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

2015-05-23 Thread Adrian Klaver
On 05/23/2015 08:06 AM, Tom Lane wrote: twoflower standa.ku...@gmail.com writes: So I wrote a few scripts to make my life easier, e.g. *pg94start.sh*: su postgres -c /usr/lib/postgresql/9.4/bin/pg_ctl -D /storage/postgresql/9.4/data -o '-c config_file=/etc/postgresql/9.4/main/postgresql.conf'

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

2015-05-23 Thread Tom Lane
Adrian Klaver adrian.kla...@aklaver.com writes: On 05/23/2015 08:06 AM, Tom Lane wrote: I can't explain that claim, but for me, -c config_file=something seems to work as you'd expect, and a look at the server source code confirms that it should honor that (cf SelectConfigFiles()). I think the

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

2015-05-23 Thread Adrian Klaver
On 05/23/2015 07:01 AM, rob stone wrote: On Sat, 2015-05-23 at 04:23 -0700, twoflower wrote: I thought I understood how specifying a config file path for the server works, but that's apparently not the case. The cluster data is at /storage/postgresql/9.4/data. The config files are at

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

2015-05-23 Thread twoflower
I thought I understood how specifying a config file path for the server works, but that's apparently not the case. The cluster data is at */storage/postgresql/9.4/data*. The config files are at */etc/postgresql/9.4/main* (this is the default location on Ubuntu). This is how the beginning of

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

2015-05-23 Thread Adrian Klaver
On 05/23/2015 04:23 AM, twoflower wrote: I thought I understood how specifying a config file path for the server works, but that's apparently not the case. The cluster data is at */storage/postgresql/9.4/data*. The config files are at */etc/postgresql/9.4/main* (this is the default location on

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

2015-05-23 Thread rob stone
On Sat, 2015-05-23 at 04:23 -0700, twoflower wrote: I thought I understood how specifying a config file path for the server works, but that's apparently not the case. The cluster data is at /storage/postgresql/9.4/data. The config files are at /etc/postgresql/9.4/main (this is the

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

2015-05-23 Thread Tom Lane
twoflower standa.ku...@gmail.com writes: So I wrote a few scripts to make my life easier, e.g. *pg94start.sh*: su postgres -c /usr/lib/postgresql/9.4/bin/pg_ctl -D /storage/postgresql/9.4/data -o '-c config_file=/etc/postgresql/9.4/main/postgresql.conf' But running this script did not work,