On 05/03/2018 10:59 AM, David G. Johnston 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="">
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.
David J.
