Postgres Pro
Downloads
Home   >   mailing lists

Re: How to move a database from HP server to Linux Server that had already one database. - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: How to move a database from HP server to Linux Server that had already one database.
Date
Msg-id 4C405A9B020000250003375C@gw.wicourts.gov
Whole thread Raw
In response to Re: How to move a database from HP server to Linux Server that had already one database.  ("ENGEMANN, DAYSE" <dayse.engemann@hp.com>)
Responses Re: How to move a database from HP server to Linux Server that had already one database.  ("ENGEMANN, DAYSE" <dayse.engemann@hp.com>)
List pgsql-admin
Tree view 
"ENGEMANN, DAYSE" <dayse.engemann@hp.com> wrote:
> Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:

>> pg_dump | psql

> And to restore it.. Can I use pg_restore -d new_db_name ??

I usually pipe the output of pg_dump to psql, and thereby avoid
making a copy of the dump output entirely.  If you want to dump in
custom format, yeah, you would use pg_restore instead.

-Kevin

pgsql-admin by date:

Previous
From: "ENGEMANN, DAYSE"
Date:
Subject: Re: How to move a database from HP server to Linux Server that had already one database.
Next
From: "ENGEMANN, DAYSE"
Date:
Subject: Re: How to move a database from HP server to Linux Server that had already one database.