Re: postgresql fails to start after symlinking pgdata dir

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gene(at)sotech(dot)us
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql fails to start after symlinking pgdata dir
Date: 2007-02-05 21:26:24
Message-ID: 20195.1170710784@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gene <genekhart(at)gmail(dot)com> writes:
> In the past I've always done the following with success (this is under
> fedora core 6 x86_64):

> mv /var/lib/pgsql/data /data/pg/
> ln -s /data/pg/data /var/lib/pgsql/data
> /etc/init.d/postgresql start

> I just installed 8.2.2 on a new FC6 machine and when I do that it fails to
> start. The logs reveal nothing.

Smells like a SELinux problem --- you probably need to set the
appropriate security context on /data/pg. It might even take an update
to the policy ... not sure if the /var/lib/pgsql path is wired into the
policy or if it's just driven off file context markers. Look for avc
denied messages in the kernel log to get a hint.

Or you could just do "setenforce 0" but I don't recommend that ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gene 2007-02-05 21:31:53 Re: postgresql fails to start after symlinking pgdata dir
Previous Message Devrim GUNDUZ 2007-02-05 20:29:53 New RPM Sets for Fedora Core / Red Hat Enterprise Linux