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