From: | Sanjib Mohanty <sanjib(dot)technical(at)gmail(dot)com> |
---|---|
To: | jwiencek3 <jwiencek3(at)comcast(dot)net> |
Cc: | lennam(at)incisivetechgroup(dot)com, pgsql-admin(at)lists(dot)postgresql(dot)org, soumik(dot)bhattacharjee(at)kpn(dot)com |
Subject: | Re: pg_basebackup fails to connect from slave server |
Date: | 2020-02-10 04:58:24 |
Message-ID: | CAAUegELFs3e8fXPuZXhoJk=UeUq_LEtpuTXWXR-ppdRXHbbc3w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks for introducing this beautiful component EFM. Currently I am looking
for a solution with the existing core capacity of Postgres.
In future I may think of using this great tool.
I am just looking for safe approach to fail back even if there is some
manual work I am fine with that.
Thanks in advance for your help.
Regards,
Sanjib
On Sun, 9 Feb 2020 at 8:39 PM, jwiencek3 <jwiencek3(at)comcast(dot)net> wrote:
> You should install and configure EDB 's Enterprise Failover Manager(EFM).
>
> Regards
>
> John Wiencek
>
>
>
> Sent via the Samsung Galaxy S9+, an AT&T 5G Evolution capable smartphone
>
>
> -------- Original message --------
> From: Sanjib Mohanty <sanjib(dot)technical(at)gmail(dot)com>
> Date: 2/9/20 1:15 AM (GMT-06:00)
> To: lennam(at)incisivetechgroup(dot)com
> Cc: soumik(dot)bhattacharjee(at)kpn(dot)com, pgsql-admin(at)lists(dot)postgresql(dot)org
> Subject: Re: pg_basebackup fails to connect from slave server
>
> Hi team,
> Thanks a lot all of your help for heads up.
> I could able t o successfully replicate the data and test the fail over
> scenario by promoting the hot stand by to master.
> However, I need best precise solution for fail back scenario now. I mean,
> Switching back to to original master and slave setup.
>
>
>
> In that case, I would like to bring back my original master to master
> again and promoted master back to slave.
>
> Master is down-
> Promoted slave as master- Inserted few records- Need to demote the Slave
> and bring back the Master
>
> Do I need to follow the same process as I created the slave initially ?
>
>
> Thanks in advance, your reply will greatly help.
>
> Regards,
> SM
>
> On Thu, Feb 6, 2020 at 9:19 PM <lennam(at)incisivetechgroup(dot)com> wrote:
>
>>
>>
>> Here is link
>>
>> https://en.wikibooks.org/wiki/PostgreSQL/Replication
>>
>> this will guide you step by step.
>>
>> let me know , if still any questions.
>>
>>
>> Quoting soumik(dot)bhattacharjee(at)kpn(dot)com:
>>
>> > rom: Sanjib Mohanty <sanjib(dot)technical(at)gmail(dot)com>
>> > Sent: donderdag 6 februari 2020 14:00
>> > To: pgsql-admin(at)lists(dot)postgresql(dot)org
>> > Subject: pg_basebackup fails to connect from slave server
>> >
>> > Hi List,
>> >
>> > I am new to postgres/EnterpriseDB( 9.6). In fact, I was trying to
>> > configure one streaming replication from master to hot-standby
>> > server. I will appreciate if I need any help or document to
>> > configure and test in in RHEL server.
>> >
>> > I am using EenterpriseDB 9.6 version.
>> >
>> >
>> >
>> >
>> > * EDB has its own support and replication solutions.
>> > * You working with community version of PostgreSQL or EDB?
>> >
>> > Thanks in advance,
>> >
>> > Cheers,
>> > SM
>>
>>
>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | dbatoCloud Solution | 2020-02-10 06:20:33 | Re: pg_basebackup fails to connect from slave server |
Previous Message | David G. Johnston | 2020-02-10 00:12:03 | Re: plpgsql & string building |