This is for a restore to a remote host running postgresql on a custom port and using the pg_restore provided by pgAdmin on a mac.
gzcat xtuple-2016-11-07_1412.dump.gz | \ /Applications/pgAdmin3.app/Contents/SharedSupport/pg_restore \ -v -p 5434 -h 10.20.20.20 -U postgres -c -d xtuple-test
The backup was done using:
pg_dump -h $HOST -p $PGPORT -U $PGUSER -Fc $DB | gzip -c - > $BKUPDIR/$TOFILE
0 Comments