Re: pg_restore a dump in -Fd format?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, May 3, 2018 at 9:10 AM, Ron <ronljohnsonjr@xxxxxxxxx> wrote:
On 05/03/2018 10:59 AM, David G. Johnston wrote:
On Thu, May 3, 2018 at 8:21 AM, Ron <ronljohnsonjr@xxxxxxxxx> 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.

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux