Re: postgres crash

> 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 part.
>
> 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.=0
D

0
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

Bye !!
Frank Lupo (Wolf) !!

--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

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: http://adv2.email.it/cgi-bin/foclick.cgi?mid=626&d=16-9