pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed8.4 restore parallel
2+ messages / 2 participants
[nested] [flat]
* 8.4 restore parallel
@ 2010-12-13 20:42 paulo matadr <saddoness@yahoo.com.br>
0 siblings, 1 reply; 2+ messages in thread
From: paulo matadr @ 2010-12-13 20:42 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 8.4 restore parallel
@ 2010-12-13 22:09 Guillaume Lelarge <guillaume@lelarge.info>
parent: paulo matadr <saddoness@yahoo.com.br>
0 siblings, 0 replies; 2+ messages in thread
From: Guillaume Lelarge @ 2010-12-13 22:09 UTC (permalink / raw)
To: paulo matadr <saddoness@yahoo.com.br>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-12-13 22:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-13 20:42 8.4 restore parallel paulo matadr <saddoness@yahoo.com.br>
2010-12-13 22:09 ` Guillaume Lelarge <guillaume@lelarge.info>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox