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 ENGEMANN, DAYSE
Subject Re: How to move a database from HP server to Linux Server that had already one database.
Date
Msg-id 5FCE2C21B63D86478DBA823B3A27B40149CF10498D@GVW1341EXA.americas.hpqcorp.net
Whole thread Raw
In response to Re: How to move a database from HP server to Linux Server that had already one database.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: How to move a database from HP server to Linux Server that had already one database.  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view 
And to restore it.. Can I use pg_restore -d new_db_name ??

-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]
Sent: sexta-feira, 16 de julho de 2010 14:47
To: ENGEMANN, DAYSE; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How to move a database from HP server to Linux Server that had already one database.

"ENGEMANN, DAYSE" <dayse.engemann@hp.com> wrote:

> I have a HP Server with a postgres database, and I need to transfer it
> to another server

> What is the easy way to do it?

pg_dump | psql

-Kevin

pgsql-admin by date:

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