pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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