From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | David <dlbarron28(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Is pg_restore in 10.6 working? |
Date: | 2018-11-12 21:14:28 |
Message-ID: | dd80d4b8-6baa-cb56-ced9-e5762ff40aa3@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/12/18 2:06 PM, Tom Lane wrote:
> Rob Sargent <robjsargent(at)gmail(dot)com> writes:
>> On 11/12/18 12:39 PM, David wrote:
>>> 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.
> The other bit that I think David is missing is that pg_dump's default
> output format is a plain-text SQL script, which is meant to be fed to
> psql not pg_restore. To get something that pg_restore can work with,
> you need to specify one of the non-text dump formats (typically, you'd
> use -Fc or -Fd).
>
> The situation in which you'd want to use "pg_restore -f" is if you
> want to reconstruct a plain-text SQL script from one of the non-text
> dump formats, rather than just restoring directly into a database.
>
> regards, tom lane
Roger that. Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2018-11-12 21:39:18 | Re: Is pg_restore in 10.6 working? |
Previous Message | Tom Lane | 2018-11-12 21:06:26 | Re: Is pg_restore in 10.6 working? |