Invalid pg_hba.conf => Postgres crash - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Invalid pg_hba.conf => Postgres crash
Date
Msg-id 408A4DCF.2000204@bigfoot.com
Whole thread Raw
Responses Re: Invalid pg_hba.conf => Postgres crash  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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
beforeor 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







pgsql-hackers by date:

Previous
From: Shachar Shemesh
Date:
Subject: Re: Do we prefer software that works or software that looks good?
Next
From: Robert Treat
Date:
Subject: Re: Do we prefer software that works or software that looks good?