Re: Is pg_restore in 10.6 working?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David <dlbarron28(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Is pg_restore in 10.6 working?
Date: 2018-11-12 18:44:57
Message-ID: 28066.1542048297@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David <dlbarron28(at)gmail(dot)com> 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 response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scot Kreienkamp 2018-11-12 19:25:15 RE: help with aggregation query across a second text array column
Previous Message Joshua D. Drake 2018-11-12 18:40:27 Re: Is pg_restore in 10.6 working?