Re: security on user for replication - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: security on user for replication
Date
Msg-id 20191111190007.akaitdibm22x7xzm@squirrel.exwg.net
Whole thread Raw
In response to security on user for replication  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
## PegoraroF10 (marcos@f10.com.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.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Rules documentation example
Next
From: Palle Girgensohn
Date:
Subject: Re: here does postgres take its timezone information from?