pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_basebackup fails to connect from slave server
7+ messages / 5 participants
[nested] [flat]
* pg_basebackup fails to connect from slave server
@ 2020-02-06 12:59 Sanjib Mohanty <sanjib.technical@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Sanjib Mohanty @ 2020-02-06 12:59 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_basebackup fails to connect from slave server
@ 2020-02-06 13:03 Holger Jakobs <holger@jakobs.com>
parent: Sanjib Mohanty <sanjib.technical@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Holger Jakobs @ 2020-02-06 13:03 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: pg_basebackup fails to connect from slave server
@ 2020-02-06 14:46 soumik.bhattacharjee@kpn.com
parent: Sanjib Mohanty <sanjib.technical@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2020-02-06 14:46 UTC (permalink / raw)
To: sanjib.technical@gmail.com; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_basebackup fails to connect from slave server
@ 2020-02-06 15:49 lennam@incisivetechgroup.com
parent: soumik.bhattacharjee@kpn.com
0 siblings, 1 reply; 7+ messages in thread
From: lennam@incisivetechgroup.com @ 2020-02-06 15:49 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: sanjib.technical@gmail.com; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_basebackup fails to connect from slave server
@ 2020-02-09 07:15 Sanjib Mohanty <sanjib.technical@gmail.com>
parent: lennam@incisivetechgroup.com
0 siblings, 1 reply; 7+ messages in thread
From: Sanjib Mohanty @ 2020-02-09 07:15 UTC (permalink / raw)
To: lennam@incisivetechgroup.com; +Cc: soumik.bhattacharjee@kpn.com; pgsql-admin@lists.postgresql.org
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@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
>
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_basebackup fails to connect from slave server
@ 2020-02-10 04:58 Sanjib Mohanty <sanjib.technical@gmail.com>
parent: Sanjib Mohanty <sanjib.technical@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Sanjib Mohanty @ 2020-02-10 04:58 UTC (permalink / raw)
To: jwiencek3 <jwiencek3@comcast.net>; +Cc: lennam@incisivetechgroup.com; pgsql-admin@lists.postgresql.org; soumik.bhattacharjee@kpn.com
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).
>
> Regards
>
> John Wiencek
>
>
>
> Sent 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)
> To: lennam@incisivetechgroup.com
> Cc: soumik.bhattacharjee@kpn.com, pgsql-admin@lists.postgresql.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@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
>>
>>
>>
>>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_basebackup fails to connect from slave server
@ 2020-02-10 06:20 dbatoCloud Solution <dbatocloud17@gmail.com>
parent: Sanjib Mohanty <sanjib.technical@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: dbatoCloud Solution @ 2020-02-10 06:20 UTC (permalink / raw)
To: Sanjib Mohanty <sanjib.technical@gmail.com>; +Cc: jwiencek3 <jwiencek3@comcast.net>; lennam@incisivetechgroup.com; pgsql-admin@lists.postgresql.org; soumik.bhattacharjee@kpn.com
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,
> 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).
>>
>> Regards
>>
>> John Wiencek
>>
>>
>>
>> Sent 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)
>> To: lennam@incisivetechgroup.com
>> Cc: soumik.bhattacharjee@kpn.com, pgsql-admin@lists.postgresql.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@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
>>>
>>>
>>>
>>>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2020-02-10 06:20 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-02-06 12:59 pg_basebackup fails to connect from slave server Sanjib Mohanty <sanjib.technical@gmail.com>
2020-02-06 13:03 ` Holger Jakobs <holger@jakobs.com>
2020-02-06 14:46 ` soumik.bhattacharjee@kpn.com
2020-02-06 15:49 ` lennam@incisivetechgroup.com
2020-02-09 07:15 ` Sanjib Mohanty <sanjib.technical@gmail.com>
2020-02-10 04:58 ` Sanjib Mohanty <sanjib.technical@gmail.com>
2020-02-10 06:20 ` dbatoCloud Solution <dbatocloud17@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox