From: | David <dlbarron28(at)gmail(dot)com> |
---|---|
To: | robjsargent(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 19:39:20 |
Message-ID: | CAPK0jFz+nxMmu11i7A3mggdcHvBie7JRs5jiQg4LAuz1GVPW1w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm not following your question. The pre-data and post-data sections each
go to an individual file, but the data section goes to a directory. I can
restore the files using psql, but it is the restore of the directory that
is hanging.
On Mon, Nov 12, 2018 at 2:28 PM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
> On 11/12/18 11:44 AM, Tom Lane wrote:
> > 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 this case, does the "General options" -f make sense? restoring to a
> file?
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2018-11-12 21:00:49 | Re: Is pg_restore in 10.6 working? |
Previous Message | Rob Sargent | 2018-11-12 19:25:36 | Re: Is pg_restore in 10.6 working? |