igrating database from Unix to Windows








I am new to Postgresql and I am in the process of trying to migrate 2 databases from a unix box to windows 2000. Is there an easy way to export the database across platforms? If not, what is the best way to do this task? I wasn't sure if I could take a dump of the databases on the Unix box and rerun the sql scripts in Windows to recreate the databases. Any insight or assistance that you can offer would be greatly appreciated.


Also, I am using PostgreSQL8. Would I still need to use Cygwin since this release is supposedto work on a windows platform. Thanks in advance.


Rick Hackenberg




Rick, welcome to PGSQL. there is a tutorial about how to set up PGSQL 8 on a windows box here...


http://www.geocities.com/operationsengineer1/


you don't need cygwin.


some folks with more experience will answer you in more detail, but i think you should be finerestoring a dump of the unix db and restoring it on windows.


good luck - and i hope you like PGSQL.


oe1