Posgres: Permissions pg_pwd

[Karel Zak - Zakkr]

On Wed, 22 Dec 1999, Borek Lupomesky wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> On Wed, 22 Dec 1999, Karel Zak - Zakkr wrote:
> 
> > Zajimave, ale ne zas tak nebezpecne. Ten adresar v kterem to je ma prava:
> > 
> > drwx------    3 postgres postgres     1024 Dec 22 14:02 data
> 
>    Bohuzel, to je v adresari /var/lib/pgsql, kde jsou prava
> rwxr-xr-x... :-I.
> 

 Debian (potato), nijak neupravovana distribuce (PgSQL 6.5.3-4):

mravenec:/var/lib/postgres# ls -la
total 5
drwxr-xr-x    3 postgres postgres     1024 Dec 20 14:58 .
drwxr-xr-x   15 root     root         1024 Dec 22 14:16 ..
-rw-------    1 postgres postgres       17 Dec 20 14:58 .bash_history
-rw-r--r--    1 postgres postgres      175 Dec 20 14:51 .bash_profile
drwx------    3 postgres postgres     1024 Dec 22 14:02 data

mravenec:/var/lib/postgres/data# ls -la
total 66
drwx------    3 postgres postgres     1024 Dec 22 14:02 .
drwxr-xr-x    3 postgres postgres     1024 Dec 20 14:58 ..
-rw-------    1 postgres postgres        4 Dec 20 14:51 PG_VERSION
drwx------    5 postgres postgres     1024 Dec 22 14:47 base
-rw-------    1 postgres postgres     8192 Dec 22 14:47 pg_database
-rw-------    1 postgres postgres     3407 Dec 20 14:51 pg_geqo.sample
-rw-------    1 postgres postgres     8192 Dec 22 14:02 pg_group
lrwxrwxrwx    1 postgres postgres       27 Dec 20 14:51 pg_hba.conf ->
/etc/postgresql/pg_hba.conf
lrwxrwxrwx    1 postgres postgres       29 Dec 20 14:51 pg_ident.conf ->
/etc/postgresql/pg_ident.conf
-rw-------    1 postgres postgres    24576 Dec 22 14:47 pg_log
-rw-rw-rw-    1 postgres postgres      149 Dec 22 14:02 pg_pwd
-rw-------    1 postgres postgres        0 Dec 22 14:02 pg_pwd.reload
-rw-------    1 postgres postgres     8192 Dec 22 14:03 pg_shadow
-rw-------    1 postgres postgres     8192 Dec 22 14:47 pg_variable


Tedy?

							Karel