Обсуждение: Newbie - Pointers on moving.

Hi

I have to move a pgsql database which is running on a linux box to a Windows
2003 server, so just started to find out about pgsql
Not sure what version of pgsql is running on the linux box.  This a library
application written in php?.

I have just installed php v5.0.0 and postgresql v 8.0.1 on the Windows 2003
server and it is working.
I can use phppgadmin v 3.5.2  to login to the gpsql on the windows box.

I am also trying to use the PostgreSQL ODBC connector  to connect.

I am a MS SQL DBA, so know more on ms products.

Any recommendations on how to do this migration/upgrade ?

TIA

RajiA

Envbop wrote:
> I have to move a pgsql database which is running on a linux box to a Windows
> 2003 server, so just started to find out about pgsql
> Not sure what version of pgsql is running on the linux box.  This a library
> application written in php?.

> Any recommendations on how to do this migration/upgrade ?

Run the new (v8.0) pg_dump on the Windows box and use it to dump the
database on the linux box (with the -h host parameter). The latest
version will probably be smarter than older versions of pg_dump.

Then use pg_restore to restore the data. If your linux database is only
a couple of years old there shouldn't be any problems. If you do have
problems, try restoring the schema then the data - that way it's easier
to identify where the problems are.

Details on the various options for these tools are in the "client
applications" section of the manuals.

--
   Richard Huxton
   Archonet Ltd