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