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

2015-05-23 Thread Tom Lane
Adrian Klaver 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 documentation Ad

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 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 scrip

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

2015-05-23 Thread Tom Lane
twoflower 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, the server would

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 /etc/p

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

[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 */etc/p