Re: Connection limit and Superuser - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Connection limit and Superuser
Date
Msg-id 44CE28A6.6000000@dunslane.net
Whole thread Raw
In response to Re: Connection limit and Superuser  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Joshua D. Drake wrote:

>
>>
>> As a protection against malice, yes. I think Rod was more interested 
>> in some protection against stupidity.
>>
>> Maybe the real answer is that Slony should connect as a non-superuser 
>> and call security definer functions for the privileged things it 
>> needs to do.
>
>
> Wouldn't that break Slony's ability to connect to older postgresql 
> versions and replicate?
>

I don't know anything of Slony's internals, but I don't see why older 
versions should matter - Postgres has had security definer functions for 
every release that Slony supports. Maybe I'm missing something ...

cheers

andrew


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Connection limit and Superuser
Next
From: Rod Taylor
Date:
Subject: Re: [PATCHES] extension for sql update