From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | 任洪彩 <qdurenhongcai(at)163(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, hongcai(dot)ren(at)nsn(dot)com |
Subject: | Re: How to modify dump files created by pg_dump |
Date: | 2013-06-04 15:40:50 |
Message-ID: | 51AE0A82.7070509@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
rod(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Fiske | 2013-06-04 16:22:59 | Re: Foreign Key violated |
Previous Message | Amit Langote | 2013-06-04 13:42:59 | Re: More buffers used than a relation's relpages |