streaming replication authentication

From: Zachary Hanson-Hart <zachhh(at)temple(dot)edu>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: streaming replication authentication
Date: 2019-02-22 16:46:27
Message-ID: CAF-2CQGv7r01Kx19CNTJM2MArD3jHcUbW7t2Wu6KzpUwX+cRoQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi pgsql-general,

I know that the requirement for replication is that a user be allowed to
connect to the "replication" database. My question is how to configure the
streaming replication client to use a particular authentication method. I
haven't been able to find examples of streaming replication using any
authentication other than trust or md5.

Specifically, I'm interested in using kerberos (via gssapi) with a keytab.
I'm able to authenticate from the command line with gss after doing kinit,
but that's not practical for replication. Can gss authentication be used
in replication?

FWIW, I'm using RedHat 7's version of Postgresql 9.2.

Thanks for any hints or advice,

Zach

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Fernández 2019-02-22 16:52:58 Re: PG Upgrade with hardlinks, when to start/stop master and replicas
Previous Message Adrian Klaver 2019-02-22 15:18:59 Re: How many billion rows of data I can store in PostgreSQL RDS.