PgBouncer to PostgreSQL?
log_connections as stated in the documentation http://www.pgbouncer.org/config.html
Thank you.
[root@lsp-oratl01 software]# cd DBD-Pg-3.18.0 [root@lsp-oratl01 DBD-Pg-3.18.0]# perl Makefile.PL Configuring DBD::Pg 3.18.0 Path to pg_config? /usr/pgsql-16/bin sh: /usr/pgsql...
Hi folks, what is the general consensus on the soft delete approach? Option one is to go with the 'deletedAt' and filter "where deletedAt is NULL", option two would be to go w...
Hi all, is there any provision in Postgresql to know the number of transactions in all tables in a database for a particular time. Means can we check how many insert/update/de...
Hello, I have a cluster of pg (using patroni) at the moment PG14 we wish to upgrade to 16. The main usage is mostly writing data (metadata and states0, and even some of selec...
Hello, Im encountering an issue with postgreSQL version 15 setup. The pg_wal directory on the secondary server is getting full, retaining WAL files from the past four months. ...
May I know the steps to install pg_repack in edb postgres ?
hai i am facing error as INSERT INTO fulfillments ("storeId","orderId","entityId","integrationType","lineItemId","fulfillmentStatus","returnExpiryAt","processedAt","status","...
I have a cluster running on PostgreSQL v13 (1 primary 2 standby). I am trying to migrate a database (has 12 schemas) in this cluster to another PostgreSQL v16 Patroni Cluster ...
Hello, How can I create FTS index for OID data types in postgres?
Hello everyone, I have 3 users in my database: A_User, B_User. And postgres user by default. The authorizations I give are as follows: GRANT SELECT ON ALL TABLES IN SCHEMA p...
Обсуждают сегодня