Search Postgresql Archives

Re: How to modify dump files created by pg_dump

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

 



Hmm...It seem like a wonderful solution.
But, i can't change the way to restore.
For some reason, the way to restore as follows.
pg_restore -C -h xxx -p xxx -U xxx -d template1 -e -v xxx.pgdump 

Does any one can give a clarification about whether the dump file support modify?
By the way, dump with these options..-b -o -Fc -Z 0...that i can't chage.

在 2013-06-06 08:30:44,"Adrian Klaver" <adrian.klaver@xxxxxxxxx> 写道: >On 06/05/2013 05:20 AM, 私人邮箱 wrote: >> no,I can't... >>  >> Actually the dump file comes from another site... > >So use the -f option to pg_restore to save the custom format file to  a >text file.  Edit the text file and then run using psql. > >Ex: > >pg_restore -C -f  whatever_name.sql  /root/horen/rnwdump/DBRNWHSB.pgdump > >Open whatever_name.sql > Change the database name wherever needed. > >psql -h CFPU-0 -p 5433 -U_qnrnwdbman -d template1 -f whatever_name.sql > >>  >>  >> 在 2013-6-5,19:28,Raymond O'Donnell <rod@xxxxxx> 写道: >>  >>> On 05/06/2013 03:02, 任洪彩 wrote: >>>> Hi, >>>> Yes, you are right. >>>> But -d option not suitable for me. Because our flatform use -C option >>>> and -d template1 option to create the database described in the dump >>>> file to restore the dump file. >>>> >>>> The whole command like this: >>>> # /opt/nokiasiemens/SS_Postgres/bin/pg_restore -C -h CFPU-0 -p 5433 -U >>>> _qnrnwdbman -d template1 -e -v >>> >>> Hmmmm, OK. Could you rename the original database before dumping it, so >>> that its name matches the new one? >>> >>> Ray. >>> >>> >>> >>> --  >>> Raymond O'Donnell :: Galway :: Ireland >>> rod@xxxxxx >>  >>  >>  > > >--  >Adrian Klaver >adrian.klaver@xxxxxxxxx



[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