PostgreSQL (English)

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...

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 ...

hai i am facing error as INSERT INTO fulfillments ("storeId","orderId","entityId","integrationType","lineItemId","fulfillmentStatus","returnExpiryAt","processedAt","status","...

how did you measure a comparison in the RDS vs your tool case? comparison to ec2 instances?

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...

Hello, How can I create FTS index for OID data types in postgres?

Guys User table is in one to many relationship with Chat participants . Chats are also in one to many relationship with ChatParticipants. So chatparticipants will have a chat_...

Do we have any document which compare plan and performance between Oracle and posrgres?

Actually I am investigating this process to migrate some databases from version 13 to version 16. pg_dump is not enough for my database size because it takes too long. From P...

Hello All, I need your assistance with the following tasks: 1)How can I migrate database links from Oracle to PostgreSQL using ora2pg? 2)How can I determine the appropriate...

4000 people will connect to the Postgre server simultaneously. Is more core or faster processor important when choosing a processor?