Search Postgresql Archives

Move database from Solaris to Windows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux