testing 8.4

testing 8.4

am 08.05.2009 22:25:06 von Kasia Tuszynska

--_000_232B5217AD58584C87019E8933556D110125F10FC3redmx2esric om_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Everybody,
Is anyone testing 8.4 beta?

I installed it on win2008 64bit machine, testing and uninstalling I found n=
o problems, but I ran into an issue with trying to delete the C:\Program Fi=
les (x86)\PostgreSQL folder after uninstalling. File permissions on some of=
the data files under the Data folder seemed to have missing admin privileg=
es, I had to delete each file one by one and than add full privs to admin o=
n the files that were missing it.

Has anyone else ran into this?
Sincerely,
Kasia

--_000_232B5217AD58584C87019E8933556D110125F10FC3redmx2esric om_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html40">












0.0pt;
font-family:Arial'>Hi Everybody,



0.0pt;
font-family:Arial'>Is anyone testing 8.4 beta?



0.0pt;
font-family:Arial'> 



0.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 permi=
ssions
on some of the data files under the Data folder seemed to have missing admi=
n
privileges, I had to delete each file one by one and than add full privs to
admin on the files that were missing it.



0.0pt;
font-family:Arial'> 



0.0pt;
font-family:Arial'>Has anyone else ran into this?
<=
/p>

0.0pt;
font-family:Arial'>Sincerely,



0.0pt;
font-family:Arial'>Kasia









--_000_232B5217AD58584C87019E8933556D110125F10FC3redmx2esric om_--

Re: testing 8.4

am 09.05.2009 04:50:49 von Justin







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 have access to directories that it needs
access to. 



If you took ownership of the directory and then
size="+1"> add face="Arial">full control face="Arial"> for admin face="Arial"> replacing face="Arial">permissions on face="Arial">all child objects  it would have saved time instead of
doing it by file.




Kasia Tuszynska wrote:
cite="mid:232B5217AD58584C87019E8933556D110125F10FC3@redmx2. esri.com"
type="cite">




style="font-size: 10pt; font-family: Arial;">Hi Everybody,


style="font-size: 10pt; font-family: Arial;">Is anyone testing 8.4
beta?


style="font-size: 10pt; font-family: Arial;"> 


style="font-size: 10pt; 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 delete
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.


style="font-size: 10pt; font-family: Arial;"> 


style="font-size: 10pt; font-family: Arial;">Has anyone else ran into
this?


style="font-size: 10pt; font-family: Arial;">Sincerely,


style="font-size: 10pt; font-family: Arial;">Kasia





Re: testing 8.4

am 11.05.2009 20:57:35 von Kasia Tuszynska

--_000_232B5217AD58584C87019E8933556D110125F11A68redmx2esric om_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Everybody,
I feel that I need to reword my question.
Testing environment:
Windows 2008 server, 64bit

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.
I ran into a difference, a very minor difference for which I could not esta=
blish a logical reason and so I though I would ask if anyone has ran into i=
t (eliminating a local problem on my machine), and perhaps an explanation w=
hy difference in behavior exists:

In 8.3.0, 8.3.4 and 8.3.7 (only versions I have tested), if the postgres in=
stallation wizard is executed the following folder structure is laid down, =
all files under the PostgreSQL folder have the same privileges, allowing th=
e admin user to delete the folder structure after the postgres application =
had been uninstalled.

Testing 8.4 I found a difference in privileges being inherited by some data=
files under the Data folder:
C:\Program Files (x86)\PostgreSQL\8.4, under it are:
Bin
Data
....

The Data directory contains the following:
Base...
Pg_tblspc
- tablespace indicated by an integer
o table indicated by an integer
? individual files indicated by integers
QUESTION: all of these files make up the single logical object of the table=
- in this case there were over a thousand, in testing 8.4 beta I found tha=
t several of these files had different privileges from the other ones in th=
is directory.
This difference in file permissions, prevented me from deleting the C:\Prog=
ram Files (x86)\PostgreSQL folder, after I uninstalled postgres and wanted =
to clean up the machine
Follow up questions:
-Could this be a postgres installer issue? Or a windows issue?
-How can files that make up the same object and supposedly inherit privileg=
es from a parent directory end up with different privs? Unless they are cre=
ated under different security context, is that the case with the installer?
-I know that the workaround for this is to either delete the PostgreSQL fol=
der as the owner i.e. the postgres user, or for the admin user to take owne=
rship and delete it than, I am interested in a reason why as opposed to a w=
orkaround.

I apologize if the admin forum is inappropriate for 8.4 beta questions.

Thank you,
Sincerely,
Kasia

________________________________
From: Justin [mailto:justin@emproshunts.com]
Sent: Friday, May 08, 2009 7:51 PM
To: Kasia Tuszynska
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] testing 8.4

the install sets the file permissions to account for postgresql service. T=
he only account that should have access to those files is the postgresql se=
rvice, and the postgresql account should only have access to directories th=
at 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 instea=
d of doing it by file.

Kasia Tuszynska wrote:
Hi Everybody,
Is anyone testing 8.4 beta?

I installed it on win2008 64bit machine, testing and uninstalling I found n=
o problems, but I ran into an issue with trying to delete the C:\Program Fi=
les (x86)\PostgreSQL folder after uninstalling. File permissions on some of=
the data files under the Data folder seemed to have missing admin privileg=
es, I had to delete each file one by one and than add full privs to admin o=
n the files that were missing it.

Has anyone else ran into this?
Sincerely,
Kasia

--_000_232B5217AD58584C87019E8933556D110125F11A68redmx2esric om_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://ww=
w.w3.org/TR/REC-html40">




namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"Person=
Name"/>









=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









--_000_232B5217AD58584C87019E8933556D110125F11A68redmx2esric om_--