Postgres Pro
Downloads
Home   >   mailing lists

Re: Restore to a database with another name? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Restore to a database with another name?
Date
Msg-id 1112215786.31277.62.camel@state.g2switchworks.com
Whole thread Raw
In response to Restore to a database with another name?  (phil campaigne <pcampaigne@charter.net>)
List pgsql-general
Tree view 
On Wed, 2005-03-30 at 14:28, phil campaigne wrote:
> Hi All,
> I want to move my development database (7.2.3) to my production server
> but the production server database has a different name.
> What is the procedure for restoring a database pg_dump to another
> machine with a different database name?

pg_dump -h source_host source_dbname |psql -h dest_host dest_dbname

pgsql-general by date:

Previous
From: phil campaigne
Date:
Subject: Restore to a database with another name?
Next
From: "Raymond O'Donnell"
Date:
Subject: Re: [ODBC] delphi access question?