ta, looks like that will do it.
-----Original Message-----
From: Einar Karttunen [mailto:ekarttun@cs.Helsinki.FI]
Sent: Wednesday, October 31, 2001 11:52 AM
To: Duncan Adams (DNS)
Cc: pgsql-novice@postgresql.org
Subject: Re: moving postgres data
On Wed, Oct 31, 2001 at 11:17:01AM +0200, Duncan Adams (DNS) wrote:
> Hi all
>
> I have data in a postgres database on one server and have to move it to a
> new server that has been set up with a new version of postgres. The
> database is an exact copy. what is the best way of moving the thing
across?
> do i set up the tables on the new box and write scripts to move it across
or
> is there another way of doing this?
>
See pg_dump and restore in Reference Manual - PostgreSQL Client
Applications.
http://www.postgresql.org/idocs/index.php?app-pgdump.htmlhttp://www.postgresql.org/idocs/index.php?app-pgrestore.html
If you want to move all databases use pg_dumpall
http://www.postgresql.org/idocs/index.php?app-pg-dumpall.html
- Einar Karttunen