Re: Moving pg_xlog problem - Mailing list pgsql-admin

From Joost Kraaijeveld
Subject Re: Moving pg_xlog problem
Date
Msg-id 1131475982.6025.28.camel@Panoramix
Whole thread Raw
In response to Re: Moving pg_xlog problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Tue, 2005-11-08 at 13:29 -0500, Tom Lane wrote:
> Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl> writes:
> > Panoramix:/var/lib/postgresql/8.0/main# ls /opt/ -al
> > total 56
> > drwxrwxrw-  14 root     staff    .
>            ^
> > drwxr-xr-x  22 root     root     ..
> > drwx------   3 postgres postgres pg_xlog
>
> There's your problem --- postgres can't do lookups in /opt.
>
> (Surely it's not a good idea for /opt to be world writable, either?)
Oh yes. You really helped me here. Whenever uyou are in the Netherlands,
don't book a hotel, but stay with me. Free meals and all the beer you
can manage. Whisky. Whatever.

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl



pgsql-admin by date:

Previous
From: Jeff Frost
Date:
Subject: Re: Moving pg_xlog problem
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Semi OT - Anyone monitoring PostgreSQL with nagios