Re: security on user for replication

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: security on user for replication
Date: 2019-11-11 19:00:07
Message-ID: 20191111190007.akaitdibm22x7xzm@squirrel.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

## PegoraroF10 (marcos(at)f10(dot)com(dot)br):

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

https://www.postgresql.org/docs/current/catalog-pg-subscription.html
Access to the column subconninfo is revoked from normal users, because
it could contain plain-text passwords.

Else: SSL certificates, pgpass file, or rig up some kerberos (that's
not that elegant in this case).

Regards,
Christoph

--
Spare Space.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Palle Girgensohn 2019-11-12 14:40:37 Re: here does postgres take its timezone information from?
Previous Message Tom Lane 2019-11-11 18:38:49 Re: Rules documentation example