Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Patches > Re: Improve shu...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 3 Topic 3625 of 4088
Post > Topic >>

Re: Improve shutdown during online backup, take 4

by laurenz.albe@[EMAIL PROTECTED] ("Albe Laurenz") Apr 23, 2008 at 04:12 PM

Alvaro Herrera wrote:
> I think the messages should not have a newline in the middle.
>=20
> 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
right thing.

Yours,
Laurenz Albe

--=20
Sent via pgsql-patches mailing list (pgsql-patches@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches
 




 3 Posts in Topic:
Re: Improve shutdown during online backup, take 4
magnus@[EMAIL PROTECTED]   2008-04-23 15:45:40 
Re: Improve shutdown during online backup, take 4
alvherre@[EMAIL PROTECTED  2008-04-23 10:02:54 
Re: Improve shutdown during online backup, take 4
laurenz.albe@[EMAIL PROTE  2008-04-23 16:12:45 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Oct 12 14:34:51 CDT 2008.