Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-24 Thread Thom Brown
On 19 October 2011 05:20, Tom Lane t...@sss.pgh.pa.us wrote: Peter Eisentraut pete...@gmx.net writes: I wouldn't add extra special checks for that.  It might not be completely unreasonable to have a standby that no one can connect to, for example. Well, you couldn't monitor its state then,

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-19 Thread Thom Brown
On 19 October 2011 05:50, Peter Eisentraut pete...@gmx.net wrote: On tis, 2011-10-18 at 18:38 -0400, Tom Lane wrote: The problem with this is you cannot get into the database as it acts as if it did find the hba file but found it empty. Well, an actually empty pg_hba.conf file would have

[HACKERS] Silent failure with invalid hba_file setting

2011-10-18 Thread Thom Brown
Hi, I noticed that if the hba_file setting in the config is uncommented and set to a directory instead of the full path to the file, no error occurs when the service starts. For example: hba_file = '/home/thom/Development/data' The problem with this is you cannot get into the database as it

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-18 Thread Tom Lane
Thom Brown t...@linux.com writes: I noticed that if the hba_file setting in the config is uncommented and set to a directory instead of the full path to the file, no error occurs when the service starts. When I try that, I get a boatload of errors ending with FATAL: could not load pg_hba.conf

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-18 Thread Thom Brown
On 19 October 2011 00:38, Tom Lane t...@sss.pgh.pa.us wrote: Thom Brown t...@linux.com writes: I noticed that if the hba_file setting in the config is uncommented and set to a directory instead of the full path to the file, no error occurs when the service starts. When I try that, I get a

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-18 Thread Peter Eisentraut
On tis, 2011-10-18 at 18:38 -0400, Tom Lane wrote: The problem with this is you cannot get into the database as it acts as if it did find the hba file but found it empty. Well, an actually empty pg_hba.conf file would have the same problem, and it's pretty hard to see any situation where

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-18 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On tis, 2011-10-18 at 18:38 -0400, Tom Lane wrote: Well, an actually empty pg_hba.conf file would have the same problem, and it's pretty hard to see any situation where it would be useful to start the postmaster and not let it accept any connections.

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-18 Thread Magnus Hagander
On Oct 19, 2011 6:21 AM, Tom Lane t...@sss.pgh.pa.us wrote: Peter Eisentraut pete...@gmx.net writes: On tis, 2011-10-18 at 18:38 -0400, Tom Lane wrote: Well, an actually empty pg_hba.conf file would have the same problem, and it's pretty hard to see any situation where it would be useful