Search Postgresql Archives

security on user for replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



We use replication with publication/subsctription. It´s ok, works fine.

But if I go to my replica server and do select * from pg_subscription

on field subconninfo I have all properties to connect. host, port, user, password and dbname, all these info are available.

Documentation says user for replication is equivalent to a superuser and must have the login attribute. If this user has all this power and using that select on replica all that info is available ...

How can I hide that info from users which are connected to my replica server or

If it´s possible to have a replication user with not superuser rights or with NoLogin


Sent from the PostgreSQL - general mailing list archive at Nabble.com.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux