Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Allow only certain query on replication slave - Mailing list pgsql-general

From Don Seiler
Subject Re: [GENERAL] Allow only certain query on replication slave
Date
Msg-id CAHJZqBAxD4Uabg8XXK8dxuPVAvbmjH3YGDkcrpO84uVKK32Znw@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Allow only certain query on replication slave  (basti <mailinglist@unix-solution.de>)
List pgsql-general
Tree view
On Tue, Oct 24, 2017 at 8:12 AM, basti <mailinglist@unix-solution.de> wrote:

Is there a way to allow only the above query and deny all other?

Probably easiest to just configure your HBA to restrict all connections/uses except the one that does your xlog query checks.

Don. 
--
Don Seiler
www.seiler.us

pgsql-general by date:

Previous
From: Peter Devoy
Date:
Subject: [GENERAL] Create database from template and include comment
Next
From: Geoff Winkless
Date:
Subject: [GENERAL] libpq: PQreset not reconnecting connection, even though server is running