From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
Cc: | PostgreSQL Hackers ML <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Cannot *start* server because of a typo in pg_hba.conf |
Date: | 2011-02-20 18:26:48 |
Message-ID: | 7527.1298226408@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim(at)gunduz(dot)org> writes:
> On Sun, 2011-02-20 at 12:45 -0500, Tom Lane wrote:
>> No, I can't. I get something like this on stderr:
>>
>> LOG: invalid connection type "zlocal"
> Err, please try putting an extra char before the first comment line,
> like:
> w# PostgreSQL Client Authentication Configuration File
Given exactly that mistake, I get
LOG: invalid connection type "w"
CONTEXT: line 1 of configuration file "/home/postgres/testversion/data/pg_hba.conf"
FATAL: could not load pg_hba.conf
Are you sure you're looking in the right place?
One thought that comes to mind is that I've seen cases where SELinux
prevented the postmaster from writing anything at all to its stderr.
I didn't think that could still happen in any current SELinux versions,
but it might be worth checking the kernel log for avc denials.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-02-20 19:15:14 | Re: SQL/MED - file_fdw |
Previous Message | Thom Brown | 2011-02-20 18:05:39 | Re: Cannot *start* server because of a typo in pg_hba.conf |