Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-24 Thread Thom Brown
On 19 October 2011 05:20, Tom Lane wrote: > Peter Eisentraut 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, so I don't find that examp

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-19 Thread Thom Brown
On 19 October 2011 05:50, Peter Eisentraut 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 the sam

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-18 Thread Magnus Hagander
On Oct 19, 2011 6:21 AM, "Tom Lane" wrote: > > Peter Eisentraut 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 postm

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-18 Thread Tom Lane
Peter Eisentraut 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. Should we

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 w

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-18 Thread Thom Brown
On 19 October 2011 00:38, Tom Lane wrote: > Thom Brown 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

Re: [HACKERS] Silent failure with invalid hba_file setting

2011-10-18 Thread Tom Lane
Thom Brown 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 I suspect

[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 act