running postgres 7.4.1
2 different behavior:
- Inserting the following invalid line on pg_hba.conf
host all all 127.0.0.1 trust sameuser # HANG
the future connections will hang leaving a postgres process running
- Inserting the following line instead will crash postgres
host all 127.0.0.1 trust sameuser # CRASH
#psql kalman psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
and in the log:
LOG: server process (PID 17656) was terminated by signal 11
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2004-04-24 12:27:37 CEST
LOG: checkpoint record is at 0/4877FD38
LOG: redo record is at 0/4877FD38; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 195700; next OID: 5718523
LOG: database system was not properly shut down; automatic recovery in progress
LOG: record with zero length at 0/4877FD78
LOG: redo is not required
LOG: database system is ready
Regards Gaetano Mendola
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
