Command Line xTuple DB restore on mac

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

Submit a Comment

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

You May Also Like…

Toggen builds a new website

So I have built and hosted a new website for Roger Clark Pest Management they are a family owned and operated Pest...

WizTree

Just downloaded WizTree (not a sponsor) from https://wiztreefree.com/ It seems to do what it says on the tin which is...

Scam call from “Telstra”

Just had a call from a man with a sub-continental accent from caller ID 0734946596 Told me there was problem with my...