Migrating database from Unix to Windows

["Hackenberg, Rick" <Rick(dot)Hackenberg(at)primedia(dot)com>]

Title: Migrating 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 supposed to work on a windows platform. Thanks in advance.

Rick Hackenberg
Business Systems Analyst
PRIMEDIA
Enthusiast Media
6405 Flank Drive
Harrisburg, PA 17112
717-540-6643(Office)
717-657-9552 (FAX)
717-215-0450(Cell)