Skip site navigation (1) Skip section navigation (2)

Re: postmaster dies on EOF?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Denis A(dot) Doroshenko" <d(dot)doroshenko(at)omnitel(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: postmaster dies on EOF?
Date: 2000-10-18 15:35:45
Message-ID: 4878.971883345@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Denis A. Doroshenko" <d(dot)doroshenko(at)omnitel(dot)net> writes:
> one day i decided to switch password authetntication in pg_hba.conf
> for local tcp/unix connection as well, ran psql and saw 'Password:' for
> the first time :-) But, when i pressed ^D in answer it showed many
> lines with 'Password:' at the begining and then postmaster died.

This is a previously reported bug in psql.  It gets into a loop wherein
it keeps opening new connections to the postmaster and then leaving them
hanging at the postmaster's demand for password.  That part is fixed in
current sources; also the postmaster doesn't elog(FATAL) on running out
of open file slots anymore.

But there's still a potential for denial of service by a broken client,
because the postmaster will just sit there waiting for password
responses on all these open connections, and there'll be no way for
other clients to get in.  There's been some talk of instituting a
timeout on the connection request protocol to fix that, but nothing's
been done about it yet AFAIK.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Karel ZakDate: 2000-10-18 15:37:10
Subject: Re: Re: 7.0.3 to_char() (was: [BUGS] Bugs in to_char function)
Previous:From: Tom LaneDate: 2000-10-18 15:21:05
Subject: Re: 7.0.3 to_char() (was: [BUGS] Bugs in to_char function)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group