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@gmail.com> 写道：
>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@iol.ie> 写道：
>>
>>> 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@iol.ie
>>
>>
>>
>
>
>--
>Adrian Klaver
>adrian.klaver@gmail.com