| From: | Lonni J Friedman <netllama(at)gmail(dot)com> |
|---|---|
| To: | phil campaigne <pcampaigne(at)charter(dot)net> |
| Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore to a database with another name? |
| Date: | 2005-03-30 21:27:18 |
| Message-ID: | 7c1574a905033013271303e585@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 30 Mar 2005 15:58:02 -0500, phil campaigne
<pcampaigne(at)charter(dot)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(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-03-30 21:30:58 | Re: Debugging deadlocks |
| Previous Message | phil campaigne | 2005-03-30 21:24:54 | Re: Restore to a database with another name? |