>[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Gevik
>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
>> creates a zip file which is not easily portable to other
>> 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).
In response to
pgsql-general by date
|Next:||From: craigp||Date: 2008-02-27 00:27:26|
|Subject: bug in 8.3? foreign key refers to different type|
|Previous:||From: Tom Lane||Date: 2008-02-26 23:24:08|
|Subject: Re: v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8 |