Postgres 16 unexpected shutdown

Hello, We experienced something strange last weekend when all of a sudden the Postgres service was unexpectedly stopped (see logs below). No maintenance or scripts were running at the time, just our usual traffic over the network doing SELECTS/INSERTS/UPDATES on the server. The server is a

Re: ODBC Driver dsplay name

Hello, Switching from SQL Server to PostgreSQL. Installed Postgresql 11.8 successfully.  Need to install ODBC to connect from front end.   When I install ODBC using stack builder , I see the ODBC name < in ODBC data source administrator> PostgresSQL ODBC Driver(ANSI)PostgresSQL ODBC Driver(UNICOD

Vacuum Full is not returning space to OS

Hi All, I am running Azure PostgreSQL database version 11 with replication enabled. But the autovacuum is not happening. Even Vacuum full is also not reclaiming the space and returning back to OS. when, I disable to replication then only Full Vacuum is working as expected but vacuum isn't working

Query to fetch the list of tables that have cascade constraints enabled

Hi All, I am trying to fetch the list of tables that have cascade constraints enabled. Can someone help me with the query related to this? Regards, Satalabha

Re: Load balancing of write queries among health-checked nodes

Among PostgreSQL instances there is only one master. But yes, each server may be considered master by the clients because it's Pgpool-II will redirect write queries to the actual master. Maybe it's even better to avoid this unnecessary traffic between servers and decide which Pgpool-II is in fro

Load balancing of write queries among health-checked nodes

Hello. I have a PostgreSQL high availability cluster with Pgpool-II, but I don't use the virtual IP feature so my clients don't know which node to send queries to. DNS round-robin is not a solution because it can't distinguish between healthy and dead nodes. I thought about having a Pgpool-II i

synchronous_commit= remote_apply | "The transaction has already committed locally..."

Hi Team, *Context: *We have faced a network isolation and ended-up with locally committed data on the old primary database server as one of the tools that is in-place for HA decided to promote one of the SYNC standby servers. As the PostgreSQL won't provide a HA solution as in-built, I would like

Re: synchronous_commit= remote_apply | "The transaction has already committed locally..."

Hi Laurenz, Thank you for the quick response. Could you please point me to the link where the "two-phase commit" approach is being discussed. I can track it for my reference. On Fri, Jun 23, 2023 at 3:26 PM Laurenz Albe wrote: > On Fri, 2023-06-23 at 15:05 +0530, Postgres all-