security on user for replication
| От | PegoraroF10 |
|---|---|
| Тема | security on user for replication |
| Дата | |
| Msg-id | 1573478809636-0.post@n3.nabble.com обсуждение исходный текст |
| Ответы |
Re: security on user for replication
Re: security on user for replication |
| Список | pgsql-general |
We use replication with publication/subsctription. It´s ok, works fine.
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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.
В списке pgsql-general по дате отправления: