Re: Re: Server tries to read a different config file than it is supposed to - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Re: Server tries to read a different config file than it is supposed to
Date
Msg-id 5560FDD0.3040904@aklaver.com
Whole thread Raw
In response to Re: Re: Server tries to read a different config file than it is supposed to  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 05/23/2015 02:42 PM, Tom Lane wrote:
> Adrian Klaver <adrian.klaver@aklaver.com> writes:
>> So on my Ubuntu installs it does not set up the postgres user to allow login, so how are you getting to:
>> su postgres -c ...
>
>From root, presumably ...

Aargh, so used to the little voice telling me not to do things as root I
forgot that possibility.

>
> I thought of a different theory: maybe the server's complaint is not due
> to trying to read that file as a config file, but it's just because there
> is an unreadable/unwritable file in the data directory.  See Christoph
> Berg's complaint at
> http://www.postgresql.org/message-id/20150523172627.GA24277@msg.df7cb.de
>
> This would only apply if the OP was trying to use this week's releases
> though.  Also, I thought the fsync-everything code would only run if
> the server had been shut down uncleanly.  Which maybe it was, but that
> bit of info wasn't provided either.
>
>             regards, tom lane
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Daniel Begin
Date:
Subject: Re: FW: Constraint exclusion in partitions
Next
From: Marcos Ortiz
Date:
Subject: Trying to solve a SocketError [Errno 13] Permission with PL/Python in PostgreSQL 9.3