Re: postgres crash - Mailing list pgsql-general

From Manfred Koizar
Subject Re: postgres crash
Date
Msg-id qd5bougtev5qfviqev4kvti070ifm7ua9v@4ax.com
Whole thread Raw
In response to Re: postgres crash  ("frank_lupo" <frank_lupo@email.it>)
List pgsql-general
On Mon, 16 Sep 2002 08:08:48 +0200, "frank_lupo" <frank_lupo@email.it>
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--    1 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 the directory pg_xlog (and everything else
under /usr/share/postgresql/data) should be owned by postgres.

HTH.
Servus
 Manfred

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: problem in select
Next
From: Justin Clift
Date:
Subject: Government approved support companies?