Re: Restore to a database with another name?

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: phil campaigne <pcampaigne(at)charter(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restore to a database with another name?
Date: 2005-03-30 20:49:46
Message-ID: 1112215786.31277.62.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2005-03-30 20:53:01 Re: [ODBC] delphi access question?
Previous Message phil campaigne 2005-03-30 20:28:47 Restore to a database with another name?