David Wall wrote: > 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. Yes. I regularly do dumps on Linux ( using pg_dump -Fc usually ) and restore on Windows. It largely makes no difference; it's the same as a restore on Linux. PL languages and contrib modules can be an issue, as on Linux. Just like when restoring to a Linux server you have to make sure the PL languages used by the database you're restoring are available, though on Windows this often involves installing the language runtime ( Perl/python/whatever ) rather than the Pg PL module. Similarly, contrib modules used on the original server need to be available on the target server. If those requirements are satisfied the restore is easy and smooth. If you don't use any contrib modules and don't use any PLs other than PL/PgSQL then it's as utterly fuss free as a restore on another Linux server. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
