Обсуждение: Restore to a database with another name?
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? Thanks in advance, Phil
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
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
On Wed, 30 Mar 2005 15:58:02 -0500, phil campaigne <pcampaigne@charter.net> 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 netllama@gmail.com LlamaLand http://netllama.linux-sxs.org
Lonni J Friedman wrote: >On Wed, 30 Mar 2005 15:58:02 -0500, phil campaigne ><pcampaigne@charter.net> 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. > > > > Lonni, Before I try that, I should tell you that I used pg_dump to create the backup. I read in the manual that psql client restores text files from pg_dump. Should I still try pg_restore? thanks, Phil
On Wed, 30 Mar 2005 16:24:54 -0500, phil campaigne <pcampaigne@charter.net> wrote: > Lonni J Friedman wrote: > > >On Wed, 30 Mar 2005 15:58:02 -0500, phil campaigne > ><pcampaigne@charter.net> 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. > > > > > > > > > Lonni, > Before I try that, I should tell you that I used pg_dump to create the > backup. I read in the manual that psql client restores text files from > pg_dump. Should I still try pg_restore? I believe that either will work for text file dumps. I've just always used pg_restore. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@gmail.com LlamaLand http://netllama.linux-sxs.org