Scott Marlowe wrote:
> On Fri, Jul 3, 2009 at 10:02 PM, Roseller A. Romanos<don2_907@yahoo.com> wrote:
>
> Note that this could be a permissions problem. All the files need to
> belong to whatever user postgres runs as.
>
>
If the destination PG install successfully started before there will be
no permission problems. When copying files from one computer to another
security credentials do not follow in Windows, security will be
inherited from parent directory by default.
The only time security in windows has that kind of problem is when
moving the physical hard drive to another computer. This creates
orphaned UUID describing security credentials in meta data of the NTFS
volume To clean up that kind of security mess requires first taking
ownership of the files then reseting all the permissions with replace
option.