Re: Streaming replication as a separate permissions

Magnus Hagander <magnus@hagander.net> writes:
> Updated patch, still pending docs, but otherwise updated: allow
> start/stop backup, make sure only superuser can turn on/off the flag,
> include in system views, show properly in psql.

I'd suggest avoiding creating the static cache variable
AuthenticatedUserIsReplicationRole.  This can't possibly be sufficiently
interesting from a performance point of view to justify the risks
associated with stale cache values.  Just look up the pg_authid syscache
entry when needed, ie, treat it more like rolcreaterole than rolsuper.

BTW, you forgot pg_dumpall support.
        regards, tom lane