Re: streaming replication authentication - Mailing list pgsql-general

From Stephen Frost
Subject Re: streaming replication authentication
Date
Msg-id 20190222230953.GC6197@tamriel.snowman.net
Whole thread Raw
In response to streaming replication authentication  (Zachary Hanson-Hart <zachhh@temple.edu>)
List pgsql-general
Greetings,

* Zachary Hanson-Hart (zachhh@temple.edu) wrote:
>    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?

Yes, GSS auth can be used in replication.  Why do you think it's not
practical...?

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

PG 9.2 is no longer supported by this community, I strongly encourage
you to upgrade to a supported version.

Thanks!

Stephen

Attachment

pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2
Next
From: Lukáš Sobotka
Date:
Subject: Foreign table & Connection reset by peer