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 在 2013-06-04 23:40:50，"Raymond O'Donnell" <r...@iol.ie> 写道： >On 04/06/2013 09:44, 任洪彩 wrote: >> Hi, guys >> >> I have met a problem that do confused me. >> >> I created a dump file by pg_dump from database named "DBRNWHSB" with >> parameters -b -o -Fc -Z 0. >> As you know, at the beginning of the dump file contains some SQL >> statements for create the database "DBRNWHSB". >> >> So here comes the question, I want let these SQL statements to create >> another database, e.g. named "myDB". In that case, when restore the dump >> i can restore the modified dump file with "-C" that "myDB" can be founded. >> >> I have tried to modify the dump file manually. But the dump file may >> caused invalid. >> >> # /opt/nokiasiemens/SS_Postgres/bin/pg_restore -C -h CFPU-0 -p 5433 -U >> _qnrnwdbman -d template1 -e -v /root/horen/rnwdump/DBRNWHSB.pgdump >> pg_restore: connecting to database for restore >> pg_restore: implied data-only restore >> >> I wonder is there any way to modify the dump file after create or i can >> specify the database name when dump? > >I think you're asking for trouble trying to modify the dump file manually. > >If I understand, you want to restore into a database with a different >name to the original one, is that correct? If so, then simply create the >database manually, then restore into it with the -d option: > > pg_restore -d <my-other-database> <dump-file> > >HTH, > >Ray. > >-- >Raymond O'Donnell :: Galway :: Ireland >r...@iol.ie
