Re: 8.4 restore parallel - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: 8.4 restore parallel
Date
Msg-id 4D0699B5.7050701@lelarge.info
Whole thread Raw
In response to 8.4 restore parallel  (paulo matadr <saddoness@yahoo.com.br>)
List 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

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: log_file_mode
Next
From: Guillaume Lelarge
Date:
Subject: Re: adminpack installed?