Move database from Solaris to Windows

From: "Barry C Dowell" <barry(dot)c(dot)dowell(dot)1(at)gsfc(dot)nasa(dot)gov>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Move database from Solaris to Windows
Date: 2007-08-01 18:44:19
Message-ID: 000f01c7d46b$f87784c0$9d09b780@gsfc.nasa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Please forgive me if this question is being asked in the wrong area (and
please suggest the proper one so I can ask there :-) ), but I'm in search of
assistance in moving a database from a Solaris system over to a Windows
system.

Solaris 5.8, postgreSQL 8.01, to Windows Server 2003, postgreSQL 8.0.13.

Installing on the Windows Server has gone simple enough, and I've actually
experimented a little with pg_dump to dump the contents of the database that
I get by default when installing the application that I'm working with which
requires the db.

I tried using pg_dump --format=t to dump the original database, and then
tried to restore into a database with the same name on the Windows side but
that restore has not been successful.

I've been trying to follow information found here:
http://www.postgresql.org/docs/8.0/static/app-pgrestore.html but have not
been successful yet.

Any assistance that can be lent my way is greatly appreciated.

Bcd

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-08-01 18:56:54 Re: Linux distro
Previous Message Andrej Ricnik-Bay 2007-08-01 18:30:22 Re: Linux distro