Re: `postgresql.conf' has wrong permissions???

From: fimbulvetr(at)lycos(dot)com (fimbulvetr)
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: `postgresql.conf' has wrong permissions???
Date: 2001-08-15 16:25:18
Message-ID: 2a872b49.0108150825.5dbf81eb@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote in message news:<25631(dot)996872872(at)sss(dot)pgh(dot)pa(dot)us>...
> <rocael(at)usa(dot)net> writes:
> > FATAL 1: configuration file `postgresql.conf' has wrong permissions
>
> > One thing to note is that before I rebooted linux I did this:
> > chmod 755 -R /usr/local/pgsql
>
> That was a bad idea. 700 is the most permission you should have on the
> /usr/local/pgsql/data directory. I am not sure why the code is so picky
> about postgresql.conf and not about the data directory as a whole ---
> but it will refuse to start up if postgresql.conf has more than 744
> permissions.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

I experienced this problem as well, I changed permissions on
/usr/local in order to get our samba share to work, and the next day
the database would not start.
744 will allow the postmaster to start again.
Dan

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bill 2001-08-16 03:14:30 Thanks
Previous Message Bruce Momjian 2001-08-15 15:47:34 Re: Temp tables being written to disk. Avoidable?