Re: postgres crash

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