From: | Sanjib Mohanty <sanjib(dot)technical(at)gmail(dot)com> |
---|---|
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 |
Date: | 2020-02-09 07:15:30 |
Message-ID: | CAAUegEL8eKEUzHqQ=YrHZt03LHcjB9ae5fg8+CE30jsBwLDWMg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 | Mohammed Afsar | 2020-02-09 11:54:31 | Hunger for database administrator work part-time |
Previous Message | Wells Oliver | 2020-02-08 20:41:13 | Re: plpgsql, dynamic variable lengths.. |