Re: pg_restore a dump in -Fd format?

On 05/03/2018 11:28 AM, David G. Johnston wrote:
> On Thu, May 3, 2018 at 9:10 AM, Ron <ronljohnsonjr(at)gmail(dot)com
> <mailto:ronljohnsonjr(at)gmail(dot)com>>wrote:
>
> On 05/03/2018 10:59 AM, David G. Johnston wrote:
>> On Thu, May 3, 2018 at 8:21 AM, Ron <ronljohnsonjr(at)gmail(dot)com
>> <mailto:ronljohnsonjr(at)gmail(dot)com>>wrote:
>>
>> Hi,
>>
>> v9.6.6
>>
>> I created a backup using "pg_dump -Fd", but am having no luck
>> trying to restore it, and the docs are AFAICT lacking in examples
>> of how to restore -Fd dumps.
>>
>> What's the secret sauce for this method?
>>
>>
>> ​What did you try?
>
> SRC=/path/to/dump
> DB=mydatabase
> echo `date` Begin restore
> pg_restore -vcCe --if-exists --jobs=2 --file=$SRC/DB
> echo `date` Eng restore
>
> The nohup.out file looks like this:
>
> Thu May 3 11:12:19 EDT 2018 Begin restore
>
> total 49752768
> drwxr-xr-x 2 postgres postgres       20480 May 3 10:20 ./
> drwxr-xr-x 4 postgres postgres        4096 May 3 10:33 ../
> -rw-r--r-- 1 postgres postgres           5 May 3  2018 10001.dat
> -rw-r--r-- 1 postgres postgres           5 May 3  2018 10003.dat
> -rw-r--r-- 1 postgres postgres           5 May 3  2018 9022.dat
> -rw-r--r-- 1 postgres postgres           5 May 3  2018 9024.dat
> -rw-r--r-- 1 postgres postgres      487586 May 3  2018 9026.dat
> -rw-r--r-- 1 postgres postgres    10193438 May 3  2018 9028.dat
> -rw-r--r-- 1 postgres postgres           5 May 3  2018 9030.dat
> [snip]
> -rw-r--r-- 1 postgres postgres           5 May 3  2018 9993.dat
> -rw-r--r-- 1 postgres postgres           5 May 3  2018 9995.dat
> -rw-r--r-- 1 postgres postgres         483 May 3  2018 9997.dat
> -rw-r--r-- 1 postgres postgres           5 May 3  2018 9999.dat
> -rw-r--r-- 1 postgres postgres     1846130 May 3  2018 toc.dat
> pg_restore: [archiver] could not read input file: Bad file descriptor
>
> Thu May 3 11:12:19 EDT 2018 End restore
>
>
> ​--file:​
>  Specify output file for generated script, or for the listing when used
> with -l. Default is the standard output.
>
> ​You are treating the --file option like it specifies the input file.
>
> ​pg_restore [connection-option...] [option...] [filename]
>
> The "filename" argument tacked on to the end of the command is where you
> specify the location of the dump.

Since "pg_dump -Fd" needs a "--file" option to say where to put the dump
directory, it seemed reasonable that "pg_restore -Fd" would need a --file to
know where the dump directory is.

--
Angular momentum makes the world go 'round.