Search Postgresql Archives

Re: pg_dump on Linux with pg_restore on Windows?

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

 




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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[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