Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: postgres crash

Re: postgres crash

From
"frank_lupo"
Date:
> On Fri, 13 Sep 2002 18:13:43 +0200, "frank_lupo" 
> wrote:
> >DEBUG:  recycled transaction log file 000000000000008B
> >FATAL 2:  link from /usr/share/postgresql/data/pg_xlog/000000000000008B to /usr/
> >share/postgresql/data/pg_xlog/0000000000000093 (initialization of log file 0, se
> >gment 147) failed: Permission denied
>                     ^^^^^^^^^^^^^^^^^
> Frank,              this seems to be is the relevant  pa r t.
> 
> Which user is running postmaster, and to whom does the directory
> /usr/share/postgresql/data/pg_xlog belong?
> 
> Servus
>  Manfred
> 
 
I use cygwin for win2000. For star postmaster using service nt.
The service is installed using the following definition:
 
cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user postgres --shut
 
Postmaster running by postgres user.
 
Administrator@pippo /usr/share/postgresql/data/pg_xlog
$ ll
total 114688
-rw-r--r- - & n bsp;  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
 
 
Bye !! Frank Lupo (Wolf) !!

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

Sponsor:
Baby Zen riproduce i suoni della natura. Ideale per la gestante e per la
nanna del bambino. In vendita in esclusiva nel MammaShop.it
Clicca qui

Re: postgres crash

From
Manfred Koizar
Date:
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