Manik Surtani <manik(at)post1(dot)com> 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"