Written by James McDonald

November 7, 2016

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 -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


Submit a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.

You May Also Like…

Network speed test host to host

On Ubuntu / Debian apt-get install iperf3 On Windows download it from https://iperf.fr/iperf-download.php#windows Make...

Clear HSTS Settings in CHrome

Open chrome://net-internals/#hsts enter the domain in the query field and click Query to confirm it has HSTS settings...