On Tue, Oct 24, 2017 at 8:12 AM, basti 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
On Tue, Oct 24, 2017 at 6:12 AM, basti wrote:
> I have a Postgres slave (wal replication) and want no query on it, expect
>
> - SELECT pg_last_xlog_receive_location()
> - SELECT pg_last_xlog_replay_location()
>
> When I set hot_standby = off in postgres.conf nobody can query the
> replication clus
