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@wicourts.gov]
Sent: segunda-feira, 19 de julho de 2010 13:07
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:
> 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
formatfor your dump, though -- I've had better luck with custom if I want a "structured" dump from which I can
selectivelyrestore. If you want the whole thing, and don't need an intermediate copy (two big "ifs", I know), you
coulddo something like this on the target machine:
pg_dump -h sourcemachine -U sourceuser dbname | psql dbname
-Kevin