Hi Kevin, Sorry to disturb you.. But I am really new in it... Let me see if I understood... pg_dump -h sourcemachine -U sourceuser source_dbname | psql target_dbname Is that? The data will be import in the existing db? -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@xxxxxxxxxxxx] Sent: segunda-feira, 19 de julho de 2010 13:07 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: > 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? Restoring to a new database should not put the data in pre-existing databases at risk. I wouldn't recommend the tar format for your dump, though -- I've had better luck with custom if I want a "structured" dump from which I can selectively restore. If you want the whole thing, and don't need an intermediate copy (two big "ifs", I know), you could do something like this on the target machine: pg_dump -h sourcemachine -U sourceuser dbname | psql dbname -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
