Discussion:
8.4 restore parallel
(too old to reply)
paulo matadr
2010-12-13 20:42:09 UTC
Permalink
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
Guillaume Lelarge
2010-12-13 22:09:57 UTC
Permalink
Post by paulo matadr
[...]
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
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
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...