Re: Is pg_restore in 10.6 working?

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