Allow only certain query on replication slave

From: basti <mailinglist(at)unix-solution(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Allow only certain query on replication slave
Date: 2017-10-24 13:12:02
Message-ID: d00936e3-6607-6848-a9c7-6765a99882a2@unix-solution.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

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 cluster.

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

Best Regards,
basti

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-10-24 15:37:04 Re: Allow only certain query on replication slave
Previous Message Geoff Winkless 2017-10-24 09:58:18 Re: multiple sql results to shell