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 with this entry. do you think this problem is specific to the 7.4.2 version .
Feb 15 17:30:55 prod postgres[2322]: [702-1] LOG: invalid IP address "100.1.100.1.50" in pg_hba.conf file: Name or service not known
Feb 15 17:30:55 prod postgres[13585]: [702-1] LOG: server process (PID 2322) was terminated by signal 11
Feb 15 17:30:55 prod postgres[13585]: [703-1] LOG: terminating any other active server processes
Feb 15 17:30:55 prod postgres[13585]: [704-1] LOG: all server processes terminated; reinitializing
Feb 15 17:30:55 prod postgres[2323]: [705-1] LOG: database system was interrupted at 2005-02-15 17:30:51 EST
Feb 15 17:30:55 prod postgres[2323]: [706-1] LOG: checkpoint record is at D5/796387A8
Feb 15 17:30:55 prod postgres[2323]: [707-1] LOG: redo record is at D5/796387A8; undo record is at 0/0; shutdown TRUE
Feb 15 17:30:55 prod postgres[2323]: [708-1] LOG: next transaction ID: 146738745; next OID: 565698175
Feb 15 17:30:55 prod postgres[2323]: [709-1] LOG: database system was not properly shut down; automatic recovery in progress
Feb 15 17:30:55 prod postgres[2323]: [710-1] LOG: record with zero length at D5/796387E8
Feb 15 17:30:55 prod postgres[2323]: [711-1] LOG: redo is not required
Feb 15 17:30:55 prod postgres[2324]: [705-1] FATAL: the database system is starting up
Feb 15 17:30:57 prod postgres[2323]: [712-1] LOG: database system is ready
Feb 15 17:30:59 prod postgres[2329]: [705-1] LOG: invalid IP address "100.1.100.1.50" in pg_hba.conf file: Name or service not known
Feb 15 17:30:59 prod postgres[2329]: [706-1] LOG: invalid entry in pg_hba.conf file at line 206, token "100.1.100.1.50"
Feb 15 17:30:59 prod postgres[2329]: [707-1] FATAL: missing or erroneous pg_hba.conf file
Feb 15 17:30:59 prod postgres[2329]: [707-2] HINT: See server log for details.
Feb 15 17:30:59 prod postgres[13585]: [705-1] LOG: server process (PID 2329) was terminated by signal 11
Feb 15 17:30:59 prod postgres[13585]: [706-1] LOG: terminating any other active server processes
Tom Lane wrote:
[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 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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
