Re: postgres crash - Mailing list pgsql-general

From frank_lupo
Subject Re: postgres crash
Date
Msg-id H2IP2O$ACFEC6602E3799A936AED38D8C68C99B@email.it
Whole thread Raw
Responses Re: postgres crash  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Looking for more "big name" places that use PostgreSQL
Next
From: "frank_lupo"
Date:
Subject: Re: problem in select