From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Invalid pg_hba.conf => Postgres crash |
Date: | 2004-04-24 11:21:51 |
Message-ID: | 408A4DCF.2000204@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi all,
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2004-04-24 11:48:18 | Re: Do we prefer software that works or software that looks good? |
Previous Message | Shachar Shemesh | 2004-04-24 08:44:53 | Re: Do we prefer software that works or software that looks good? |