From: | "ENGEMANN, DAYSE" <dayse(dot)engemann(at)hp(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How to move a database from HP server to Linux Server that had already one database. |
Date: | 2010-07-16 18:21:35 |
Message-ID: | 5FCE2C21B63D86478DBA823B3A27B40149CF1049B4@GVW1341EXA.americas.hpqcorp.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I am not sure if I can do it in this way.. As the are in diferent servers and network.
I found a paper that suggest to use pg_dump -Ft -b db_name > file.tar .... Transfer it to new server and you ther the pg_restore -d new_db file.tar
But as the servers have different SO.. I am not sure if it can be used...
And another question is that in the target server there is a database there that we can not destroy.
Thanks for your help.
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Kevin Grittner
Sent: sexta-feira, 16 de julho de 2010 15:12
To: ENGEMANN, DAYSE; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] How to move a database from HP server to Linux Server that had already one database.
"ENGEMANN, DAYSE" <dayse(dot)engemann(at)hp(dot)com> wrote:
> Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)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
--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
From | Date | Subject | |
---|---|---|---|
Next Message | Patric Michael | 2010-07-16 22:31:33 | Stumped by a version conflict. |
Previous Message | Kevin Grittner | 2010-07-16 18:11:55 | Re: How to move a database from HP server to Linux Server that had already one database. |