Robert Haas writes:
> ... If we do decide to change the
> behavior, we'd better carefully document that if you want to make
> someone a superuser without giving them replication privileges (or
> revoke their superuser status without revoking replication
> privileges), you need to specify both ALT
On Tue, Oct 25, 2011 at 8:39 AM, Magnus Hagander wrote:
> On Mon, Oct 24, 2011 at 16:37, Keith Fiske wrote:
>> On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane wrote:
>>> "Keith Fiske" writes:
>>
If you create a user as a NONsuperuser,
then later ALTER them to be one, they will NOT have the
On Tue, Oct 25, 2011 at 1:39 PM, Magnus Hagander wrote:
> On Mon, Oct 24, 2011 at 16:37, Keith Fiske wrote:
>> On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane wrote:
>>> "Keith Fiske" writes:
>>
If you create a user as a NONsuperuser,
then later ALTER them to be one, they will NOT have the
On Mon, Oct 24, 2011 at 16:37, Keith Fiske wrote:
> On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane wrote:
>> "Keith Fiske" writes:
>
>>> If you create a user as a NONsuperuser,
>>> then later ALTER them to be one, they will NOT have the replication
>>> permission and cannot be used as a replication
On Sat, Oct 22, 2011 at 11:49 AM, Tom Lane wrote:
> "Keith Fiske" writes:
>> The documentation says replication is inherent to a superuser.
>
> What it actually says is that superusers get the replication privilege
> by default --- but you can create a superuser without that. If you
> see a plac
"Keith Fiske" writes:
> The documentation says replication is inherent to a superuser.
What it actually says is that superusers get the replication privilege
by default --- but you can create a superuser without that. If you
see a place that says something different, please point it out
specific
The following bug has been logged online:
Bug reference: 6264
Logged by: Keith Fiske
Email address: ke...@omniti.com
PostgreSQL version: 9.1.1
Operating system: Debian
Description:Superuser does not have inherent Replication permission
Details:
Was testing out an up