Re: [GENERAL] Allow only certain query on replication slave

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

[GENERAL] Create database from template and include comment

Hi all If when creating a database I use another user-defined database as a template I would like the option for the comment on the template database to also exist for the new database. Am I correct in thinking there is no feature for this, perhaps because the global nature of pg_shdescription?

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

On 23/10/2017, 17:17, "George Neuner" wrote: >Doesn't GCloud provide a way to export drive images? [He asks naively, never having used it.] Nope – just the dd method (although this doesn’t work on VMWare, so you need to use a VWM utility on a Win pc to get it). I’m

Re: [GENERAL] using conda environment for plpython3u?

I am the server user. How do I make my conda environment available? It seems as though plpython is using python 3.5.2, whereas my conda environment is using python 3.6, and I don't have the modules loaded that I need. On Mon, Oct 23, 2017 at 5:42 PM, John R Pierce wrote: >

Re: [GENERAL] Allow only certain query on replication slave

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

[GENERAL] Allow only certain query on replication slave

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