Re: [GENERAL] Dump and Restore

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: "Eduardo S(dot) Fontanetti" <dufuzzy(at)yahoo(dot)com(dot)br>
Cc: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Dump and Restore
Date: 2004-08-24 17:12:12
Message-ID: 1093367532.15248.8.camel@linda
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-admin pgsql-general

On Tue, 2004-08-24 at 17:36, Eduardo S. Fontanetti wrote:
> I am using pg_dump.
> It means that I can't restore to a different name
> database??

If you use pg_dump[all] without other options it will dump to a text
file. Just edit the database name.

Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
"I saw in the night visions, and, behold, one like the
Son of man came with the clouds of heaven, and came to
the Ancient of days, and they brought him near before
him. And there was given him dominion, and glory, and
a kingdom, that all people, nations, and languages,
should serve him; his dominion is an everlasting
dominion, which shall not pass away, and his kingdom
that which shall not be destroyed."
Daniel 7:13,14

In response to


Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2004-08-24 17:42:08 Re: PostgreSQL Migration of databases 7.2 to 7.4
Previous Message Christopher Browne 2004-08-24 17:04:38 Re: PostgreSQL Migration of databases 7.2 to 7.4

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-08-24 17:12:39 Re: SELECT to an external file
Previous Message Mário Gamito 2004-08-24 17:08:26 SELECT to an external file