On 11/12/18 10:37 AM, David wrote:
I can connect with psql either of these two ways: psql -U postgres or psql -h ip-172-31-62-127.ec2.internal -p 5432 -U postgres -W postgres (Yes, it's an AWS server) This pg_dump command works: pg_dump -U postgres -f predata.sql -F p -v -d prod_data But a matching pg_restore command does nothing. pg_restore -U postgres -f predata.sql -v
pg_restore -U postgres -v predata.sql -f is used to output data from a backup file into predata.sql. Usage: pg_restore [OPTION]... [FILE] General options: -d, --dbname=NAME connect to database name -f, --file=FILENAME output file name -F, --format=c|d|t backup file format (should be automatic) -l, --list print summarized TOC of the archive -v, --verbose verbose mode -V, --version output version information, then exit -?, --help show this help, then exit
I'm running 10.6. thank you
-- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc *** A fault and talent of mine is to tell it exactly how it is. *** PostgreSQL centered full stack support, consulting and development. Advocate: @amplifypostgres || Learn: https://postgresconf.org ***** Unless otherwise stated, opinions are my own. *****
