| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | paulo matadr <saddoness(at)yahoo(dot)com(dot)br> |
| Cc: | admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: 8.4 restore parallel |
| Date: | 2010-12-13 22:09:57 |
| Message-ID: | 4D0699B5.7050701@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2010-12-13 22:12:12 | Re: adminpack installed? |
| Previous Message | Guillaume Lelarge | 2010-12-13 22:07:39 | Re: log_file_mode |