Re: Restore to a database with another name?

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