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