On 05/03/2018 10:59 AM, David G. Johnston wrote:
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--
Angular momentum makes the world go 'round.