On Wed, 30 Mar 2005 15:58:02 -0500, phil campaigne <[EMAIL PROTECTED]> wrote: > 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?
You break it into two separate commands at the pipe, and use pg_restore to import it back in on the target box. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman [EMAIL PROTECTED] LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
