Обсуждение: 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.
Thanks in advance,
Cheers,
SM
Hi What is your question? Can't figure it out. Regards, Holger Am 06.02.20 um 13:59 schrieb Sanjib Mohanty: > 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. > > Thanks in advance, > > Cheers, > SM
rom: Sanjib Mohanty <sanjib.technical@gmail.com>
Sent: donderdag 6 februari 2020 14:00
To: pgsql-admin@lists.postgresql.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
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.bhattacharjee@kpn.com: > rom: Sanjib Mohanty <sanjib.technical@gmail.com> > Sent: donderdag 6 februari 2020 14:00 > To: pgsql-admin@lists.postgresql.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
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
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@incisivetechgroup.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.bhattacharjee@kpn.com:
> rom: Sanjib Mohanty <sanjib.technical@gmail.com>
> Sent: donderdag 6 februari 2020 14:00
> To: pgsql-admin@lists.postgresql.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
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@comcast.net> wrote:
You should install and configure EDB 's Enterprise Failover Manager(EFM).RegardsJohn WiencekSent via the Samsung Galaxy S9+, an AT&T 5G Evolution capable smartphone-------- Original message --------From: Sanjib Mohanty <sanjib.technical@gmail.com>Date: 2/9/20 1:15 AM (GMT-06:00)Subject: Re: pg_basebackup fails to connect from slave serverHi 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,
SMOn Thu, Feb 6, 2020 at 9:19 PM <lennam@incisivetechgroup.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.bhattacharjee@kpn.com:
> rom: Sanjib Mohanty <sanjib.technical@gmail.com>
> Sent: donderdag 6 februari 2020 14:00
> To: pgsql-admin@lists.postgresql.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
Dear Sanjib/All,
I've finished my replication cluster setup (pg10). now i have 1 primary and 1 standby and I installed pgpool.4 on both servers for load balancing and failover . I need some good documents to configure pgpool+watchdog configurations.
Please help on it.
Regards,
Ashok
On Mon, Feb 10, 2020 at 8:58 AM Sanjib Mohanty <sanjib.technical@gmail.com> wrote:
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,SanjibOn Sun, 9 Feb 2020 at 8:39 PM, jwiencek3 <jwiencek3@comcast.net> wrote:You should install and configure EDB 's Enterprise Failover Manager(EFM).RegardsJohn WiencekSent via the Samsung Galaxy S9+, an AT&T 5G Evolution capable smartphone-------- Original message --------From: Sanjib Mohanty <sanjib.technical@gmail.com>Date: 2/9/20 1:15 AM (GMT-06:00)Subject: Re: pg_basebackup fails to connect from slave serverHi 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,
SMOn Thu, Feb 6, 2020 at 9:19 PM <lennam@incisivetechgroup.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.bhattacharjee@kpn.com:
> rom: Sanjib Mohanty <sanjib.technical@gmail.com>
> Sent: donderdag 6 februari 2020 14:00
> To: pgsql-admin@lists.postgresql.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