From: Guillaume Lelarge <guillaume@lelarge.info>
To: paulo matadr <saddoness@yahoo.com.br>
Cc: admin <pgsql-admin@postgresql.org>
Subject: Re: 8.4 restore parallel
Date: Mon, 13 Dec 2010 23:09:57 +0100
Message-ID: <4D0699B5.7050701@lelarge.info> (raw)
In-Reply-To: <336291.2324.qm@web114714.mail.gq1.yahoo.com>
References: <336291.2324.qm@web114714.mail.gq1.yahoo.com>
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.frhttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, saddoness@yahoo.com.br
Subject: Re: 8.4 restore parallel
In-Reply-To: <4D0699B5.7050701@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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