[HACKERS] include_dir catch-22

2014-06-18 Thread Craig Ringer
There is, IMO, a significant oversight with the include_dir feature.

If a distributor wants to enable it by default at initdb time, they
can't just turn it on in postgresql.conf.sample, because initdb will die
when the postgres backend refuses to start because the configdir is missing.

Yet the configdir cannot exist, or initdb will refuse to run.

IMO we should just treat the configdir as implicitly if_exists, but
otherwise, there needs to be a separate if_exists option.

I'll gladly submit a patch to fix this for 9.4, I just want an opinion
on which way to go first.

(initdb then 'sed' the config file afterwards is not an answer)

-- 
 Craig Ringer   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training  Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] include_dir catch-22

2014-06-18 Thread Craig Ringer
On 06/18/2014 03:30 PM, Craig Ringer wrote:
 There is, IMO, a significant oversight with the include_dir feature.
 
 If a distributor wants to enable it by default at initdb time, they
 can't just turn it on in postgresql.conf.sample, because initdb will die
 when the postgres backend refuses to start because the configdir is missing.
 
 Yet the configdir cannot exist, or initdb will refuse to run.
 
 IMO we should just treat the configdir as implicitly if_exists, but
 otherwise, there needs to be a separate if_exists option.
 
 I'll gladly submit a patch to fix this for 9.4, I just want an opinion
 on which way to go first.

Oh, and while it's possible for include_if_exists, you get a spammy
initdb like:

creating template1 database in testdb/base/1 ... LOG:  skipping missing
configuration file /home/ec2-user/testdb/some.conf
 2014-06-18 04:05:15.194 EDT LOG:  skipping missing configuration file
/home/ec2-user/testdb/some.conf
ok
initializing pg_authid ... LOG:  skipping missing configuration file
/home/ec2-user/testdb/some.conf
 2014-06-18 04:05:15.894 EDT LOG:  skipping missing configuration file
/home/ec2-user/testdb/some.conf
ok
initializing dependencies ... LOG:  skipping missing configuration file
/home/ec2-user/testdb/some.conf
 2014-06-18 04:05:15.927 EDT LOG:  skipping missing configuration file
/home/ec2-user/testdb/some.conf
ok





-- 
 Craig Ringer   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training  Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers