Re: [BUGS] [ADMIN] Postgres crashed on invalid IP entry in pg_hba.conf

2005-02-20 Thread Bruce Momjian
Pallav Kalva wrote: > I am using 7.4.2 on Redhat 9 Linux 2.4. I know iam on old version, we > are actually planning to move to 8.0.1 soon, I just wanted to know if > this is bug if so if it is 7.4.2 related . You just need to stop your server, install 7.4.7 and restart. There is no reason to b

Re: [BUGS] [ADMIN] Postgres crashed on invalid IP entry in pg_hba.conf

2005-02-16 Thread Pallav Kalva
I am using 7.4.2 on Redhat 9 Linux 2.4. I know iam on old version, we are actually planning to move to 8.0.1 soon, I just wanted to know if this is bug if so if it is 7.4.2 related . Tom Lane wrote: Pallav Kalva <[EMAIL PROTECTED]> writes: do you think this problem is specific to the 7.4.2

Re: [BUGS] [ADMIN] Postgres crashed on invalid IP entry in pg_hba.conf

2005-02-16 Thread Tom Lane
Pallav Kalva <[EMAIL PROTECTED]> writes: > do you think this problem is specific to the 7.4.2 > version . You didn't say what platform this is, but it might be related to this 7.4.3 fix: 2004-04-24 16:10 tgl * src/backend/libpq/ip.c (REL7_4_STABLE): Ensure getaddrinfo_all retur

Re: [BUGS] [ADMIN] Postgres crashed on invalid IP entry in pg_hba.conf

2005-02-16 Thread Pallav Kalva
Hi Tom, Thanks! for the quick reply actually i forgot to attach the log file in my first email, the next email has the attachment, anyways here is the output from the log file. as you can see i have 5 numbers in the ip address which was a typo and postgres crashes when it reads the hba file

Re: [BUGS] [ADMIN] Postgres crashed on invalid IP entry in pg_hba.conf

2005-02-16 Thread Tom Lane
[EMAIL PROTECTED] 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 a