Re: postgres crash

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: "frank_lupo" <frank_lupo(at)email(dot)it>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres crash
Date: 2002-09-16 08:31:40
Message-ID: qd5bougtev5qfviqev4kvti070ifm7ua9v@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 16 Sep 2002 08:08:48 +0200, "frank_lupo" <frank_lupo(at)email(dot)it>
wrote:
>Postmaster running by postgres user.
^^^^^^^^
>AAdministrator(at)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2002-09-16 08:41:44 Government approved support companies?
Previous Message Martijn van Oosterhout 2002-09-16 07:36:21 Re: problem in select