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?
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