Could you share your precise
procedure steps please?
> On Tue, Sep 3, 2019 at 8:43 PM Jehan-Guillaume (ioguix) de Rorthais <
> iog...@free.fr> wrote:
>
> > On Tue, 3 Sep 2019 20:27:37 +0530
> > Nagendra Bandi wrote:
> > ...
> > > *Problem Description :*
&
On Tue, 3 Sep 2019 20:27:37 +0530
Nagendra Bandi wrote:
...
> *Problem Description :*
>
> PostgreSQL database is set up for High Availability and *asynchronous
> streaming replication* with *hot standby* as described in
> https://www.postgresql.org/docs/9.4/warm-standby.html#STREAMING-REPLICATION
On Tue, 13 Aug 2019 16:38:44 +0530
Shital A wrote:
> On Tue, 13 Aug 2019, 11:50 Shital A, wrote:
>
> > On Mon, 12 Aug 2019, 18:54 Adrien Nayrat,
> > wrote:
> >
> >> On 8/12/19 2:57 PM, Shital A wrote:
> >> > Postgres version : 9.6
> >> > OS:Rhel 7.6
> >> >
> >> > We are working on HA setup
On Mon, 22 Jul 2019 12:58:47 +0200
Tiemen Ruiten wrote:
[...]
> I've attached a graph of network IO on all servers. The network config is
> identical for all three nodes: 2x bonded gigabit connection to the same
> stacked switch pair.
AFAICS, Network doesn't looks saturated.
> Currently I don't
Hi,
On Mon, 22 Jul 2019 11:05:57 +0200
Tiemen Ruiten wrote:
[...]
> > Now to my current issue: I took the advice to add more monitoring on
> > replay lag (using pg_last_xact_replay_timestamp) and things are not looking
> > good. Last night replication lagged by almost 6 hours on one of the
> > no
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
On Thu, 17 Jan 2019 13:09:18 +0200
Achilleas Mantzios wrote:
> Hello,
>
> One strong point of barman IMHO is transparently converting an incremental
> backup to a full backup for retention purposes, so retention specification is
> far more liberal than with pgbackrest, and configuring for increm
On Thu, 17 Jan 2019 08:32:48 -0500
AI Rumman wrote:
> Hi,
>
> I am planning to use Postgresql with TimescaleDb extension. I have to
> design a system similar to AWS RDS which supports automated failover,
> transparent minor version upgrades etc.
> In early days, I worked with PgPool II to enable
On Wed, 17 Oct 2018 12:29:52 +0300
Олег Самойлов wrote:
> There is not problem with systemctl, if system locale setted by localectl is
> the same as database locale. But, as I said, there is problem with pacemaker
> pgsqlms module. And I think this is incorrect behavior. Database may write in
> l
On Mon, 15 Oct 2018 09:46:47 +0200
Laurenz Albe wrote:
> Raghavendra Rao J S V wrote:
> > Is there any impact if "#wal_keep_segments = 0 " and "checkpoint_segments
> > = 128" postgresql.conf file. If yes,what is the imapct?
>
> Yes.
> - You will have fewer checkpoints requested by data modifi
On Wed, 5 Sep 2018 15:06:21 +0200
Thomas Poty wrote:
> > In fact, PAF does not support slots. So it is not a good candidate if
> > slot are a requirement.
> Effectively slots are a requirement we prefer to keep
OK, so either patch PAF yourself (not recommended) or choose something
else. Note
On Wed, 5 Sep 2018 13:23:41 +0200
Thomas Poty wrote:
> Hi Jehan-Guillaume,
Hello,
> Thanks for your opinion.
>
> At first glance, i may use for automatic failover PAF,
In fact, PAF does not support slots. So it is not a good candidate if slot are
a requirement.
> a proxy HAproxy and
> for f
Hi all,
On Tue, 4 Sep 2018 15:09:51 +
ROS Didier wrote:
> Hi
>I have made a lot of PostgreSQL High Availability tests (more
> than 20 by solution) and the two following products respond well to the need :
>
> (1)Repmgr (2ndQuadrant)
>
> (2)Pglookout (aiven)
Both so
On Tue, 17 Jul 2018 11:03:08 +0200
Fabio Pardi wrote:
> On 07/17/2018 10:21 AM, Jehan-Guillaume (ioguix) de Rorthais wrote:
> > On Tue, 17 Jul 2018 10:11:50 +0200
>
> > ...and check this one: https://github.com/OPMDG/check_pgactivity/
> >
> > It uses bloa
On Tue, 17 Jul 2018 10:11:50 +0200
Fabio Pardi wrote:
> If you monitor using nagios (or if you want to make a wrapper around it):
>
> https://bucardo.org/check_postgres/check_postgres.pl.html#bloat
...and check this one: https://github.com/OPMDG/check_pgactivity/
It uses bloat queries for tabl
On Tue, 5 Jun 2018 10:22:02 +0900
Michael Paquier wrote:
[...]
> I do so for all my stuff on github for example.
How do you backup your projects issues on github? Using the API with some
loops?
On Mon, 23 Apr 2018 18:09:43 +
Andrew Edenburn wrote:
> I am having issues with my PAF setup. I am new to Postgres and have setup
> the cluster as seen below. I am getting this error when trying to start my
> cluster resources.
> [...]
>
> cleanup and clear is not fixing any issues and I am
On Tue, 10 Apr 2018 17:02:39 +
Vikas Sharma wrote:
> Max count is one way (vague I agree), before confirming I will ask the
> application owner to have a look on data in tables as well.
Maybe you could compare your tables on both sides using a tool like
pg_comparator? See:
https://cri.ens
On Fri, 5 Jan 2018 13:07:10 -0600
Azimuddin Mohammed wrote:
> Hello,
> I am little confused with how HA works in postgres. Reading the article
> which state as below "*If the primary server fails and the standby server
> becomes the new primary, and then the old primary restarts, you must have a
19 matches
Mail list logo
