[EMAIL PROTECTED] wrote:
Hi,

I urgently need a way to simply backup the database's data on win32
(e.g. the 'data' directory).

As discussed earlier I can't use dump/dumpall since my data needs
persistent tableoids which, however, are not the same after a restore.

AFAIK stopping the server, zipping data dir, and restarting the server
creates a zip file which is not easily portable to other computers due
to some ntfs file system permission problems.

What exactly would those problems be? If you can shut your server down like this, that's absolutely the easiest way to get it done. It should be portable across all win32 machines at least - and if that's not enough, pg_dump really is your only option.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to