Postgres Pro
Downloads
Home   >   mailing lists

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

From basti
Subject [GENERAL] Allow only certain query on replication slave
Date
Msg-id d00936e3-6607-6848-a9c7-6765a99882a2@unix-solution.de
Whole thread Raw
Responses Re: [GENERAL] Allow only certain query on replication slave  (Michael Paquier <michael.paquier@gmail.com>)
Re: [GENERAL] Allow only certain query on replication slave  (Don Seiler <don@seiler.us>)
List pgsql-general
Tree view 
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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Rhhh Lin
Date:
Subject: Re: [GENERAL] Backup strategy using 'wal_keep_segments'
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] Allow only certain query on replication slave