[GENERAL] Re: Server tries to read a different config file than it is supposed to

2015-05-25 Thread twoflower
> I think that that unwritable postgresql.conf file had probably been > hanging around in your data directory for some time. It was not causing > any particular problem until we decided we ought to fsync everything in > the data directory after a crash. So this is indeed the same case > Christop

Re: [GENERAL] Re: Server tries to read a different config file than it is supposed to

2015-05-24 Thread Tom Lane
twoflower writes: > I was doing this after I upgraded to 9.4.2, yes. As for the shut down: I > suspect the server was rebooted without explicitly stopping Postgres. Not > sure how this plays out in terms of cleanliness. This is everything relevant > in the log file after I ran the start script: >

[GENERAL] Re: Server tries to read a different config file than it is supposed to

2015-05-24 Thread twoflower
> From root, presumably ... Yes > 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.post

Re: [GENERAL] Re: Server tries to read a different config file than it is supposed to

2015-05-23 Thread Adrian Klaver
On 05/23/2015 02:42 PM, Tom Lane wrote: Adrian Klaver 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 for

Re: [GENERAL] Re: Server tries to read a different config file than it is supposed to

2015-05-23 Thread Tom Lane
Adrian Klaver 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 ... I thought of a different theory: maybe the server's complaint is not due to trying to read that file as a config fil

Re: [GENERAL] Re: Server tries to read a different config file than it is supposed to

2015-05-23 Thread Adrian Klaver
On 05/23/2015 08:23 AM, twoflower wrote: > Testing this, the problem appears to be that you forgot the keyword > "start", so pg_ctl didn't really do anything. > > I am sorry, that was just a mistake on my part here, it is in the script. > > I suspect this was left over from some previ

[GENERAL] Re: Server tries to read a different config file than it is supposed to

2015-05-23 Thread twoflower
> Testing this, the problem appears to be that you forgot the > keyword"start", so pg_ctl didn't really do anything. I am sorry, that was just a mistake on my part here, it is in the script. > I suspect this was left over from some previous attempt. It doesn't look like it. I tried several times