Re: 8.4 restore parallel

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux