fkater@xxxxxxxxxxxxxx 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 majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
