I know this used to be a problem, but I don't have a Windows server to test it on again.

Can I do a pg_dump on Linux and then pg_restore it on Windows? We're using PG 8.3 now, but could certainly upgrade if that made the difference.

Okay, maybe I answered my own question, though if anybody has experience one way or another, I'd love to hear it. It looks like the pg_dump option -Fp (or perhaps just no -F option at all) on Linux would write the backup in script format, so it may allow it to be processed by psql on the Windows.

If anybody has done this, let me know since I'd hate to have someone order a new server only to find out we can't get it to work.

Thanks again,
David

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to