> 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.
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-02-28 19:22:00|
|Subject: Re: maximum number of schemas per database? |
|Previous:||From: Tomaz Borstnar||Date: 2005-02-28 17:50:13|
|Subject: maximum number of schemas per database?|
pgsql-general by date
|Next:||From: Richard Huxton||Date: 2005-02-28 18:10:15|
|Subject: Re: Suggestion for parameterized queries|
|Previous:||From: Markus Wollny||Date: 2005-02-28 17:32:41|
|Subject: Problems with pgcrypto and special characters|