On 11/12/18 11:44 AM, Tom Lane wrote:
David <dlbarron28@xxxxxxxxx> writes:
I have some experience with different versions of Postgres, but I'm just
getting around to using pg_restore, and it's not working for me at all.
...
But a matching pg_restore command does nothing.
pg_restore -U postgres -f predata.sql -v
This command expects to read from stdin and write to predata.sql, so
it's not surprising that it's just sitting there. What you want
is something along the lines of
pg_restore -U postgres -d dbname -v <predata.sql
regards, tom lane
In this case, does the "General options" -f make sense? restoring to a file?
