"Keith Fiske" <ke...@omniti.com> 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 specifically so we can improve it. > After testing > several times, I can assure you it is not. Please show your test case. It looks to me like it works as expected: regression=# create user foo superuser; CREATE ROLE regression=# create user foo2 superuser noreplication; CREATE ROLE regression=# select rolname,rolsuper,rolreplication from pg_authid ; rolname | rolsuper | rolreplication ----------+----------+---------------- postgres | t | t foo | t | t foo2 | t | f (3 rows) > 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 user until you explicitly > grant that permission. That doesn't sound to me like a bug. These flags are independent, we just provide a certain default at role creation time. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs