Prevent users from executing pg_dump against tables

Hello all, In our production db infrastructure, we have one read_only role which has read privileges against all tables in schema A. We are planning to grant this role to some developers for viewing the data, but also I want to limit the users from executing statements like copy or using

Re: Symbolic link breaks for postgresql.auto.conf

e is managed). > > > > I would suggest taking a look at 'includes': > > > > > https://www.postgresql.org/docs/13/config-setting.html#CONFIG-INCLUDES > > < > https://www.postgresql.org/docs/13/config-setting.html#CONFIG-INCLUDES> > > > >

Symbolic link breaks for postgresql.auto.conf

Hello all, Can someone explain how *postgresql.auto.conf *file contents gets updated, when running an alter system statement followed by pg_reload_conf? I am trying to keep a symbolic link for the *postgresql.auto.conf* outside the data directory. The link gets created but whenever I issue an

Null database entry in pg_stat_database on pg-12 version

Hello all, Today I came across this null database entry with oid as 0 in *pg_stat_database* on *postgresql-12* version. Any particular use case is there for this? It also has some column values, how it is gathering those data and which database is responsible for this? I am not seeing this in

Re: Need to place pgpool logs on separate directory

Thanks Tatsuo for the info. I will contact pgpool forum regarding this. Also I tried restarting and reloading the pgpool service after each of the above parameter changes, still it's not working. item | value

Need to place pgpool logs on separate directory

Hello all, I want to place pgpool logs on a separate directory rather than in a syslog file. So I changed the below parameters, but still logging information are being written to the syslog file. Any idea or suggestion why this behaviour? *pgpool-II version 4.1.4 (karasukiboshi)* Tried all

Steps required for increasing disk size in EC2 instance with minimal downtime

Hello all, We have configured RAID 0 setup, with 8 EBS volumes of size 700G. We combined those volumes under a single mount point for the data directory. Archives are configured to be stored on different EC2 instances.Currently disk utilisation of data directory crossed 90%. We need to increase

ERROR: canceling statement due to conflict with recovery

Hello all, Your expertise is needed on this. I was going through previous mails regarding the same topic and was able to setup the slave with hot_standby_feedback enabled. Queries are running fine with bloat occuring on master. I tried the below scenario, where i disabled hot_standby_feedback

Pgpool is crashing when terminating user session

Hello all, We are having master-slave setup with pgpool pointing, only to master server. Whenever i tried to terminate the long running session on db end using SELECT pg_terminate_backend(pid), pgpool is getting crashed. Many blogs are saying this is the expected behaviour of pgpool, but my