Re: postgres crash - Mailing list pgsql-general

From frank_lupo
Subject Re: postgres crash
Date
Msg-id H2KMDH$521620BFF267D1E0F9A13D6320855E9C@email.it
Whole thread Raw
Responses Re: postgres crash  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-general
> On Mon, 16 Sep 2002 08:08:48 +0200, "frank_lupo" 
> wrote:
> >Postmaster running by postgres user.
>                        ^^^^^^^^
> >AAdministrator@pippo /usr/share/postgresql/data/pg_xlog
> >$ ll
> >total 114688
> >-rw-r--r--    1 Administ Nessuno  16777216 Sep 13 17:36 000000000000008D
> >-rw-r--r--    1 Administ Nessuno  16777216 Sep  4 14:16 000000000000008E
> >-rw-r--r--   &nb sp;1&nbs p ;Administ Nessuno  16777216 Sep  4 16:40 000000000000008F
> >-rw-r--r--    1 Administ Nessuno  16777216 Sep  5 09:40 0000000000000090
> >-rw-r--r--    1 Administ Nessuno  16777216 Sep 11 10:35 0000000000000091
> >-rw-r--r--    1 Administ Nessuno  16777216 Sep 13 10:07 0000000000000092
> >-rw-r--r--    1 Administ Nessuno  16777216 Sep 13 15:56 0000000000000093
>                  ^^^^^^^^
> Frank, these files and th e d i rectory pg_xlog (and everything else
> under /usr/share/postgresql/data) should be owned by postgres.
> HTH.  
> Servus
>  Manfred
 
Administrator@pippo  /usr/share/postgresql/data
$ ll
total 27
-rw-r--r--    1 Administ Nessuno         4 Jul 29 06:17 PG_VERSION
drwxr-xr-x    9 Administ Nessuno         0 Sep 11 06:08 base
drwxr-xr-x    2 Administ Nessuno      4096 Sep 17 06:48 global
drwxr-xr-x    2 Administ Nessuno         0 Jul 29 06:17 pg_clog
-rw-r--r- - & n bsp;  1 Administ Nessuno     10130 Jul 29 06:19 pg_hba.conf
-rw-r--r--    1 Administ Nessuno      1250 Jul 29 06:17 pg_ident.conf
drwxr-xr-x    2 Administ Nessuno      4096 Sep 16 15:28 pg_xlog
-rw-r--r--    1 Administ Nessuno      3848 Sep  4 14:27 postgresql.conf
-rw-r--r--    1 Administ Nessuno        59 Sep 16 06:02 postmaster.opts
-rw-r--r--    1 Administ Nessuno        51 Sep 16 06:02 postmaster.pid
 
I have tried the commando chown on cygwin, but I have not had no effect.  Perhaps it is from using the management of authorizations of windows ?
 
Thanks
Bye !! Frank Lupo (Wolf) !!

----
Prendi GRATIS l'email universale che... risparmia: clicca qui

Sponsor:
Professionisti per le emergenze quotidiane della casa e della famiglia?
su QXservice trovi idraulici, imbianchini, baby sitter e tanti altri.
Clicca qui

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Open Source Database article
Next
From: "Oliver Neumann"
Date:
Subject: Re: STored Procedures