Thread: 8.4 restore parallel
Hi all,
I made an backup of database 8.3
test.dmp
and tested restore in (8.4.5) using parallel
pg_restore -d xxx -n yyy -t kkkk -j 3 < test.dmp
And give error:
pg_restore: [custom archiver] cannot reopen stdin
pg_restore: [archiver] worker process failed: exit code 1
Why not working?
Regards
Paulo
I made an backup of database 8.3
test.dmp
and tested restore in (8.4.5) using parallel
pg_restore -d xxx -n yyy -t kkkk -j 3 < test.dmp
And give error:
pg_restore: [custom archiver] cannot reopen stdin
pg_restore: [archiver] worker process failed: exit code 1
Why not working?
Regards
Le 13/12/2010 21:42, paulo matadr a écrit : > [...] > I made an backup of database 8.3 > test.dmp > and tested restore in (8.4.5) using parallel > pg_restore -d xxx -n yyy -t kkkk -j 3 < test.dmp > > And give error: > pg_restore: [custom archiver] cannot reopen stdin > pg_restore: [archiver] worker process failed: exit code 1 > > > Why not working? > Don't use the "<". You should have: pg_restore -d xxx -n yyy -t kkkk -j 3 test.dmp BTW, if you only restore one table, the -j option won't be of any use. -- Guillaume http://www.postgresql.fr http://dalibo.com