Search Postgresql Archives

Re: pg_restore stalled ???

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

 



Gauthier, Dave <dave.gauthier@xxxxxxxxx> schrieb:

> Hi:
> 
>  
> 
> I did a pg_dump of a v8,2,5 db using...
> 
>  
> 
> pg_dump –C –file=thedb.pgdump thedb

This create a plain text dump.



> 
>  
> 
> I’m attempting to restore in v8.3.4 using pg_restore running under v8.3.4
> using...
> 
>  
> 
> pg_restore –f mydb.pgdump –i –C

pg_restore expect a dump in the custom format.

Please, read the docu about pg_dump and pg_restore. To restore a plain
text dump use psql instead.



Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux