Re: [GENERAL] Restore to a database with another name?

[phil campaigne]

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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster