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