only restore de database
I've never seen this. Is there a trigger function with a cursor starting with your update? And why PostgreSQL 11? This will go out of support on November 9th 2023?
Hello, I'm getting this error while connecting from test to prod. i made all necessary entries in hba file. But application did not face this issue. Any one have idea on this?...
Hi everyone, I'm using the configuration to use pg_rewind to follow the old primary to a new standby that is promoted as the new primary. However, when I finished configuring ...
hello, I'm using materialized view for reports. Each entry is calculated by date/month/quarter etc.. Maybe I'm missing something in my understanding, but every time I refres...
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...
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...
[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...
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. ...
Hi everyone, How can i send email in PostgreSQL? in other words : What is the equivalent of SQL Server's pg_send_dbmail function in PostgreSQL?
for PostgreSQL 15.7 which version of PGagent to be installed ?
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...
Обсуждают сегодня