Copy a database.

От:

Manik Surtani <manik@post1.com>

Дата:

23 февраля 1999 г. в 04:52:16

Hi, how do I copy a database?

I currently have a whole bunch of records in a database on one machine.
I want to copy it all to an identical postgres setup on another
machine.  I have already created all the necessary tables, with
identical structures.  i just want to copy the records across.


Help much appreciated,

Thanx in advance!

MANIK

Re: [GENERAL] Copy a database.

От:

Tom Ivar Helbekkmo <tih@nhh.no>

Дата:

23 февраля 1999 г. в 05:07:27

Manik Surtani  writes:

> I currently have a whole bunch of records in a database on one machine.
> I want to copy it all to an identical postgres setup on another
> machine.  I have already created all the necessary tables, with
> identical structures.  i just want to copy the records across.

On the "old" machine:

% pg_dump -a -D -f mydb.dump mydb

Then move mydb.dump to the new machine, and do:

% psql mydb
mydb=> \i mydb.dump

For more information, see 'man pg_dump'.

-tih
-- 
Popularity is the hallmark of mediocrity.  --Niles Crane, "Frasier"