pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rui DeSousa <rui@crazybean.net>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: repmgr@googlegroups.com
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Investigate postgres 9.6.3 repmgr lag 4.0.4
Date: Sun, 24 Jun 2018 11:32:37 -0400
Message-ID: <A86CBFD8-B27C-409C-8332-C73B84FD3153@crazybean.net> (raw)
In-Reply-To: <CA+t6e1kS=B5G4KiRXDnZMexrMd9uH4iC6gd++82Qj6r0cE7f9g@mail.gmail.com>
References: <CA+t6e1kS=B5G4KiRXDnZMexrMd9uH4iC6gd++82Qj6r0cE7f9g@mail.gmail.com>



> On Jun 24, 2018, at 4:59 AM, Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
> 
> 
> Now, How can I further investigate it ? my wal_keep_segment is assigned to 100 but since friday 261 wals were generated so I guess I dont have another option but to sync the node again. However, I want to understand why it happened. What can you advice me to check ?
> 

What is the connectivity between the nodes, any firewalls?  What’s the settings for wal_sender_timeout and wal_receiver_timeout?  Why not use a replication slot or have it fail over to using the archived WALs instead of full database restore?

There should be other messages in Postgresql logs.

view thread (10+ messages)  latest in thread

Message-ID: <A86CBFD8-B27C-409C-8332-C73B84FD3153@crazybean.net>
Permalink:  ../A86CBFD8-B27C-409C-8332-C73B84FD3153@crazybean.net/
Also on:    postgresql.org/message-id/A86CBFD8-B27C-409C-8332-C73B84FD3153@crazybean.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: rui@crazybean.net, mariel.cherkassky@gmail.com, repmgr@googlegroups.com
  Subject: Re: Investigate postgres 9.6.3 repmgr lag 4.0.4
  In-Reply-To: <A86CBFD8-B27C-409C-8332-C73B84FD3153@crazybean.net>
  References: <CA+t6e1kS=B5G4KiRXDnZMexrMd9uH4iC6gd++82Qj6r0cE7f9g@mail.gmail.com> <A86CBFD8-B27C-409C-8332-C73B84FD3153@crazybean.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox