Hi Kevin, If I use the : Origim: pg_dump -Ft -b db_name > file.tar Target: pg_restore -d new_db file.tar The target server has a db, using PGDATA=/postgres, the same in the other server... There is any risk to lost any data? -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of ENGEMANN, DAYSE Sent: sexta-feira, 16 de julho de 2010 15:22 To: Kevin Grittner; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: How to move a database from HP server to Linux Server that had already one database. 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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Kevin Grittner Sent: sexta-feira, 16 de julho de 2010 15:12 To: ENGEMANN, DAYSE; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: How to move a database from HP server to Linux Server that had already one database. "ENGEMANN, DAYSE" <dayse.engemann@xxxxxx> wrote: > Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
