On Tue, Sep 3, 2019 at 6:08 PM Nagendra Bandi wrote:
> Standby is built from the primary using pg_basebackup. i.e. Initial copy of
> the primary database is taken with pg_basebackup command and then restarted
> the server.
This puzzles me:
< 2019-09-01 15:43:56.440 UTC >LOG: trigger file foun
On Tue, 3 Sep 2019 21:31:23 +0530
Nagendra Bandi wrote:
> Hi Jehan,
> Thanks for your quick response.
> Standby is built from the primary using pg_basebackup. i.e. Initial copy of
> the primary database is taken with pg_basebackup command
pg_basebackup is supposed to make an non-exclusive backup
Hi Jehan,
Thanks for your quick response.
Standby is built from the primary using pg_basebackup. i.e. Initial copy of
the primary database is taken with pg_basebackup command and then restarted
the server.
Regards,
Nagendra
On Tue, Sep 3, 2019 at 8:43 PM Jehan-Guillaume (ioguix) de Rorthais <
iog.
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 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:
>> >
>> >
>> > Hello,
>> >
>> > Postgres version : 9.6
>> > OS:Rhel 7.6
>> >
>> > We are working on HA setup for postgres cluster of two nodes in
>> activ
On Mon, 12 Aug 2019, 18:54 Adrien Nayrat,
wrote:
> On 8/12/19 2:57 PM, Shital A wrote:
> >
> >
> > Hello,
> >
> > Postgres version : 9.6
> > OS:Rhel 7.6
> >
> > We are working on HA setup for postgres cluster of two nodes in
> active-passive
> > mode.
> >
> > Installed:
> > Pacemaker 1.1.19
> > C
On 8/12/19 2:57 PM, Shital A wrote:
>
>
> Hello,
>
> Postgres version : 9.6
> OS:Rhel 7.6
>
> We are working on HA setup for postgres cluster of two nodes in active-passive
> mode.
>
> Installed:
> Pacemaker 1.1.19
> Corosync 2.4.3
>
> The pacemaker agent with this installation doesn't supp
Hello,
Postgres version : 9.6
OS:Rhel 7.6
We are working on HA setup for postgres cluster of two nodes in
active-passive mode.
Installed:
Pacemaker 1.1.19
Corosync 2.4.3
The pacemaker agent with this installation doesn't support automatic
failback. What I mean by that is explained below:
1. Clu
Thank you..I have subscribed to the list..
On Jan 5, 2018 8:09 PM, "Tatsuo Ishii" wrote:
> Hi,
>
> Yes, definitely I am hanging out here.
>
> If you have more specific questions to Pgpool-II, you are encouraged
> to be subscribed to the Pgpool-II mailing list.
> https://www.pgpool.net/mailman/l
Hi,
Yes, definitely I am hanging out here.
If you have more specific questions to Pgpool-II, you are encouraged
to be subscribed to the Pgpool-II mailing list.
https://www.pgpool.net/mailman/listinfo/pgpool-general
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.j
What he said, and you also may want to look at pgpool-II. I’ve had fairly good
luck with that and Tatsuo (the author) hangs out here occasionally too.
—
Jay
Sent from my iPad
> On Jan 5, 2018, at 4:00 PM, Jehan-Guillaume (ioguix) de Rorthais
> wrote:
>
> On Fri, 5 Jan 2018 13:07:10 -0600
> Az
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
There are many different solutions; but I would recommend and use a least a
three node cluster using synchronous replication where one of the nodes is
acting as the witness — at a minimum (actual have more replicas). The witness
node need not be a full Postgres instance; it can also be achieved
On Fri, Jan 5, 2018 at 12:07 PM, 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
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
mechanism for informing the old primary that it is no longer the prima
16 matches
Mail list logo
