Re: win32: how to backup (dump does not work)

>-----Original Message-----
>From: pgsql-general-owner(at)postgresql(dot)org
>[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Gevik
>Babakhani
>Sent: Tuesday, 26 February 2008 22:30
>To: fkater(at)googlemail(dot)com; pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] win32: how to backup (dump does not work)
>
>> 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.
>>
>IIRC you have to re-assign owner and change permissions after
>you copy your data dir to the new server.

I believe something like NTBackup (or any decent windows backup tool)
can properly restore permissions. However, this will only work with
centralized authentication (with NT domain) and NO local computer
accounts used, when moving between servers (for obvious reasons). I
think even WinRAR contains an option to do so, but cannot remember for
sure and I never tried it anyways.

In cause you mean the permissions prevent you from making a backup, this
should be a smaller problem if you are infact a backup operator and use
a windows backup tool (they get more rights when requested).

- Joris