Re: Moving pg_xlog problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: Jeff Frost <jeff(at)frostconsultingllc(dot)com>, "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Moving pg_xlog problem
Date: 2005-11-08 18:29:22
Message-ID: 7443.1131474562@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)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?)

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bricklen Anderson 2005-11-08 18:30:58 Re: Moving pg_xlog problem
Previous Message Joost Kraaijeveld 2005-11-08 18:21:31 Re: Moving pg_xlog problem