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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
