Re: How to move a database from HP server to Linux Server that had already one database.

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(dot)Grittner(at)wicourts(dot)gov]
Sent: segunda-feira, 19 de julho de 2010 13:07
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:

> 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