Re: moving postgres data

At 09:17 31/10/01, you wrote:
>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?


Easiest way would be to dump the database to a text file:

   % pg_dump yourdatabase > /path/to/dumpfile

copy it to the new server, and read it to an empty database using psql -e:

   % psql -e yourdatabase < /newpath/to/dumpfile

This way all the schema are recreated, and the data loaded into them,
automatically -- you don't have to set anything up by hand. See the
documentation on pg_dump for more information.

best,

Mo




Mo Holkar
Digital Mind Games -- log on to take over
mo.holkar@digitalmindgames.com
http://www.digitalmindgames.com