=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Hi Everybody,=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I feel that I need to reword my questi=
on.
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Testing environment:=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Windows 2008 server, 64bit<=
/span>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I am testing postgres 8.4 beta to see =
what
is different and why, in case my application that resides on postgers will =
need
to change.
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I ran into a difference, a very minor
difference for which I could not establish a logical reason and so I though=
I
would ask if anyone has ran into it (eliminating a local problem on my
machine), and perhaps an explanation why difference in behavior exists:
>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>In 8.3.0, 8.3.4 and 8.3.7 (only versio=
ns I
have tested), if the postgres installation wizard is executed the following
folder structure is laid down, all files under the PostgreSQL folder have t=
he
same privileges, allowing the admin user to delete the folder structure aft=
er
the postgres application had been uninstalled.
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Testing 8.4 I found a difference in
privileges being inherited by some data files under the Data folder:=
o:p>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>C:\Program Files (x86)\PostgreSQL\8.4,
under it are:
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Bin
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Data
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>…
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>The Data directory contains the follow=
ing:
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Base…=
p>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Pg_tblspc
:l0 level1 lfo1'>
size=3D2 color=3Dnavy face=3DArial>
ily:Arial;
color:navy'>
-
ew Roman">
style=3D'font:7.0pt "Times New Roman"'> =
face=3DArial>
=
tablespace
indicated by an integer
t:l0 level2 lfo1'>
size=3D2 color=3Dnavy face=3D"Courier New">
font-family:
"Courier New";color:navy'>
o
face=3D"Times New Roman"> =
;
face=3DArial>
=
table
indicated by an integer
t:l0 level3 lfo1'>
size=3D2 color=3Dnavy face=3DWingdings>
-family:
Wingdings;color:navy'>
§
face=3D"Times New Roman"> =
;
face=3DArial>
=
individual
files indicated by integers
y
face=3DArial>=
QUESTION:
all of these files make up the single logical object of the table – i=
n this
case there were over a thousand, in testing 8.4 beta I found that several o=
f
these files had different privileges from the other ones in this directory.=
y
face=3DArial>=
This
difference in file permissions, prevented me from deleting the C:\Program F=
iles
(x86)\PostgreSQL folder, after I uninstalled postgres and wanted to clean u=
p
the machine
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Follow up questions:=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>-Could this be a postgres installer is=
sue?
Or a windows issue?
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>-How can files that make up the same
object and supposedly inherit privileges from a parent directory end up wit=
h
different privs? Unless they are created under different security context, =
is
that the case with the installer?
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>-I know that the workaround for this i=
s to
either delete the PostgreSQL folder as the owner i.e. the postgres user, or=
for
the admin user to take ownership and delete it than, I am interested in a
reason why as opposed to a workaround.
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I apologize if the admin forum is
inappropriate for 8.4 beta questions.
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Thank you,
>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Sincerely,
>
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Kasia
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>
e=3D3
color=3Dblack face=3D"Times New Roman">
r:windowtext'>
style=3D'font-size:10.0pt;font-family:Tahoma;color:windowtex t;font-weight:b=
old'>From:
size=3D2 color=3Dblack face=3DTahoma>
amily:Tahoma;
color:windowtext'> Justin [mailto:justin@emproshunts.com]
Sent: Friday, May 08, 2009 7=
:51 PM
To: Kasia Tuszynska
Cc:
on">pgsql-admin@postgresql.org
Subject: Re: [ADMIN] testing=
8.4
color=3Dblack>
>
=
style=3D'font-size:12.0pt'>
=3D'font-size:
13.5pt;font-family:Arial'>the install sets the file permissions to account =
for
postgresql service. The only account that should have access to those
files is the postgresql service, and the postgresql account should only hav=
e
access to directories that it needs access to.
If you took ownership of the directory and then add full control for admin
replacing permissions on all child objects it would have saved time
instead of doing it by file.
Kasia Tuszynska wrote:
=3D'font-size:
10.0pt;font-family:Arial'>Hi Everybody,
p>
=3D'font-size:
10.0pt;font-family:Arial'>Is anyone testing 8.4 beta?=
font>
=3D'font-size:
10.0pt;font-family:Arial'>
=3D'font-size:
10.0pt;font-family:Arial'>I installed it on win2008 64bit machine, testing =
and
uninstalling I found no problems, but I ran into an issue with trying to de=
lete
the C:\Program Files (x86)\PostgreSQL folder after uninstalling. File
permissions on some of the data files under the Data folder seemed to have
missing admin privileges, I had to delete each file one by one and than add
full privs to admin on the files that were missing it.<=
/font>
=3D'font-size:
10.0pt;font-family:Arial'>
=3D'font-size:
10.0pt;font-family:Arial'>Has anyone else ran into this?
>
=3D'font-size:
10.0pt;font-family:Arial'>Sincerely,<=
/p>
=3D'font-size:
10.0pt;font-family:Arial'>Kasia