pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Newbie - Pointers on moving. 2+ messages / 2 participants [nested] [flat]
* Newbie - Pointers on moving. @ 2005-02-24 05:18 Envbop <rajib@envbopdotgovtdot.nz> 0 siblings, 1 reply; 2+ messages in thread From: Envbop @ 2005-02-24 05:18 UTC (permalink / raw) To: " <pgsql-admin@postgresql.org.pgsql-general> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [GENERAL] Newbie - Pointers on moving. @ 2005-02-28 18:08 Richard Huxton <dev@archonet.com> parent: Envbop <rajib@envbopdotgovtdot.nz> 0 siblings, 0 replies; 2+ messages in thread From: Richard Huxton @ 2005-02-28 18:08 UTC (permalink / raw) To: Envbop <rajib@envbopdotgovtdot.nz>; +Cc: pgsql-admin; pgsql-general@postgresql.org 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-02-28 18:08 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-02-24 05:18 Newbie - Pointers on moving. Envbop <rajib@envbopdotgovtdot.nz> 2005-02-28 18:08 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox