Postgres Pro
Downloads
Home   >   mailing lists

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

From phil campaigne
Subject Re: Restore to a database with another name?
Date
Msg-id 424B12DA.3050309@charter.net
Whole thread Raw
In response to Restore to a database with another name?  (phil campaigne <pcampaigne@charter.net>)
Responses Re: Restore to a database with another name?  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
Tree view 
Scott Marlowe wrote:

>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
>
>
>
Hi Scott,
Unfortunately my production machine is remote and I must transfer it via
FTP.  How would that change your suggestion?
Thanks,
Phil

pgsql-general by date:

Previous
From: frank@joerdens.de
Date:
Subject: Re: Debugging deadlocks
Next
From: Lonni J Friedman
Date:
Subject: Re: Restore to a database with another name?