Skip site navigation (1) Skip section navigation (2)

Re: Postgres crashed on invalid IP entry in pg_hba.conf

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pkalva(at)deg(dot)cc
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres crashed on invalid IP entry in pg_hba.conf
Date: 2005-02-16 20:05:17
Message-ID: 26829.1108584317@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugs
pkalva(at)deg(dot)cc writes:
>    Yesterday, our production database was crashed as soon as we added an invlid
> entry in the pg_hba.conf file. Immediately, after the SIGHUP it tried to read
> the pg_hba.conf file and it couldnt validate the IP address and restarted the
> postgres server, as soon as we change the pg_hba.conf with the right entry
> everything was back to normal. Attached you will see the postgres log file at
> the time of the crash. Postgres version we are using is 7.4.2.

Works fine for me in 7.4.7 ... I get log entries like this:

LOG:  invalid IP address "1727.0.0.1" in pg_hba.conf file: Unknown server error
LOG:  invalid entry in pg_hba.conf file at line 56, token "1727.0.0.1"
FATAL:  missing or erroneous pg_hba.conf file
HINT:  See server log for details.

and after I fix the pg_hba.conf file it lets me in again.  I see no crash.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Pallav KalvaDate: 2005-02-16 20:15:03
Subject: Re: Postgres crashed on invalid IP entry in pg_hba.conf
Previous:From: Michael FuhrDate: 2005-02-16 19:14:26
Subject: Re: Access privileges

pgsql-bugs by date

Next:From: Pallav KalvaDate: 2005-02-16 20:15:03
Subject: Re: Postgres crashed on invalid IP entry in pg_hba.conf
Previous:From: Bruno Wolff IIIDate: 2005-02-16 18:48:30
Subject: Re: BUG #1483: Index problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group