Re: "Time of latest checkpoint" stays too old on both master and slave

Damn. Sorry, and please disregard my post. The master server had the wrong time. Not wrong TZ, simply wrong time. $ date Sun Jun 30 08:34:52 +04 2019 while it's currently 10:58

"Time of latest checkpoint" stays too old on both master and slave

Current time is 10:44. pg_controldata shows on both on master & slave server which uses streaming replication: Time of latest checkpoint:    Sun Jun 30 07:49:18 2019 So it was almost 3 hours ago. There are always some heavy writes and a new WAL file in the pg_wal/ directory is created

Re: Memory settings

Try run postgresqltuner.pl as suggested on https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and also look at the other info there. After running a few days with live data run cache_hit_ratio.sql by Melvin Davidson: SELECT pg_stat_database.datname, pg_stat_database.blks_read,

Memory settings

Hi team, Can you please suggest what will be the suitable memory settings for Postgresql11 if we have 80gb RAM, 16 CPU's and OS Linux. If we set 25 % of total RAM then shared_buffers value will be 20GB. Will it be useful or we can set it any random vale like 8g or 12gb. According to https://

Memory settings

Can you please suggest what will be the suitable memory settings for Postgresql11 if we have 80gb RAM, 16 CPU's and OS Linux. If we set 25 % of total RAM then shared_buffers value will be 20GB. Will it be useful or we can set it any random vale like 8g or 12gb. According to https://pgtune.leo

Re: Azure Database for PostgreSQL - how to add pgbouncer or similar?

On 6/29/19 8:33 AM, Alexander Farber wrote: Thank you Adrian - On Sat, Jun 29, 2019 at 3:59 PM Adrian Klaver > wrote: On 6/29/19 12:34 AM, Alexander Farber wrote: Not from within. Supported extensions: https://docs.microsoft.com/en-us/azure/postg

Re: How to get non-existant values as NULL or 0?

On 6/29/19 9:20 AM, Pól Ua Laoínecháin wrote: I'm in a bit of a quandary. I'm trying to figure out how to have non-existent values appear as NULL (or using COALESCE, as 0). I have several tables (DDL and DML shown at the bottom of this post - and there is a fiddle available here: https://dbfiddl

Re: How to get non-existant values as NULL or 0?

Le sam. 29 juin 2019 à 17:20, Pól Ua Laoínecháin a écrit : > I'm in a bit of a quandary. I'm trying to figure out how to have > non-existent values appear as NULL (or using COALESCE, as 0). Please ignore this question here - I have reposted it to pg-novice where I think it better belongs. TIA a

How to get non-existant values as NULL or 0?

I'm in a bit of a quandary. I'm trying to figure out how to have non-existent values appear as NULL (or using COALESCE, as 0). I have several tables (DDL and DML shown at the bottom of this post - and there is a fiddle available here: https://dbfiddle.uk/?rdbms=postgres_11&fiddle=171d207d25981e0db

Re: Azure Database for PostgreSQL - how to add pgbouncer or similar?

Thank you Adrian - On Sat, Jun 29, 2019 at 3:59 PM Adrian Klaver wrote: > On 6/29/19 12:34 AM, Alexander Farber wrote: > > Not from within. Supported extensions: > > https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions > > Using search term 'azure postgresql connection pooler',

Re: Azure Database for PostgreSQL - how to add pgbouncer or similar?

On 6/29/19 12:34 AM, Alexander Farber wrote: Good morning, in Microsoft Azure how to add pgbouncer or a similar software enabling multiple simultaneous connections? Not from within. Supported extensions: https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions Using search term

Re: Automatic Failover in PostgreSQL using PAF/repmgr

On Sat, 29 Jun 2019 00:34:13 +0530 Devendra Y wrote: > Dear Experts, > > I have configured Wal replication (standby) in PostgreSQL as Master and > slave. And I have also configured Logical replication (standby) in > PostgreSQL as Master and slave for different application's. > > Now I am trying

Automatic Failover in PostgreSQL using PAF/repmgr

Dear Experts, I have configured Wal replication (standby) in PostgreSQL as Master and slave. And I have also configured Logical replication (standby) in PostgreSQL as Master and slave for different application's. Now I am trying to integrate the Failover part to Automatic Failover using PAF (Post

Azure Database for PostgreSQL - how to add pgbouncer or similar?

Good morning, in Microsoft Azure how to add pgbouncer or a similar software enabling multiple simultaneous connections? After reading https://docs.microsoft.com/en-us/azure/postgresql/overview I could not find such options... Thank you Alex