Alvaro Herrera wrote:
> I think the messages should not have a newline in the middle.
> Also, I am wondering if in PM_WAIT_BACKUP mode we should accept new
> connections from superusers only.
I spent some thought on that.
You'd need to wait until the user is authenticated before you can determine
if he/she is a superuser and may connect (otherwise I think it would be a
security leak that enables any attacker to find out whether a given user is
a superuser without knowing the password).
By that time the server process is already forked.
I couldn't see a way to check the postmaster state at that point,
so I decided not to try and keep it simple.
If you have any ideas how I could do such a check reasonably,
I'd be happy to try it, because basically I think it would be the
In response to
pgsql-patches by date
|Next:||From: Simon Riggs||Date: 2008-04-23 14:18:41|
|Subject: Re: Concurrent psql API|
|Previous:||From: Magnus Hagander||Date: 2008-04-23 14:08:36|
|Subject: Re: Improve shutdown during online backup, take 4|