pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedMaster - Slave Replication Window Server
7+ messages / 3 participants
[nested] [flat]
* Master - Slave Replication Window Server
@ 2021-06-14 19:36 Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-14 19:41 ` Re: Master - Slave Replication Window Server Rory Campbell-Lange <rory@campbell-lange.net>
0 siblings, 1 reply; 7+ messages in thread
From: Haseeb Khan @ 2021-06-14 19:36 UTC (permalink / raw)
To: pgsql-performance@lists.postgresql.org
Hello Everyone !
I trust that you guys are keep doing very Well !
Does anyone have complete documentation to configure PostgreSQL V13 Master and Slave on Windows Server
and also how to test Manual Failover ?
Would highly appreciated, if someone could help in this regard.
Br,
Haseeb Ahmad
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Master - Slave Replication Window Server
2021-06-14 19:36 Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
@ 2021-06-14 19:41 ` Rory Campbell-Lange <rory@campbell-lange.net>
2021-06-15 05:42 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Rory Campbell-Lange @ 2021-06-14 19:41 UTC (permalink / raw)
To: Haseeb Khan <khanhaseeb92@gmail.com>; +Cc: pgsql-performance@lists.postgresql.org
On 15/06/21, Haseeb Khan (khanhaseeb92@gmail.com) wrote:
> Does anyone have complete documentation to configure PostgreSQL V13 Master
> and Slave on Windows Server and also how to test Manual Failover ?
I suggest having a look at https://www.postgresql.org/docs/13/high-availability.html
The server administration documentation at https://www.postgresql.org/docs/13/admin.html has some Windows-specific guides.
Rory
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Master - Slave Replication Window Server
2021-06-14 19:36 Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-14 19:41 ` Re: Master - Slave Replication Window Server Rory Campbell-Lange <rory@campbell-lange.net>
@ 2021-06-15 05:42 ` Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 06:17 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Haseeb Khan @ 2021-06-15 05:42 UTC (permalink / raw)
To: Rory Campbell-Lange <rory@campbell-lange.net>; +Cc: pgsql-performance@lists.postgresql.org
Thankyou Rory !
Br,
Haseeb Ahmad
> On 15-Jun-2021, at 12:42 AM, Rory Campbell-Lange <rory@campbell-lange.net> wrote:
>
> On 15/06/21, Haseeb Khan (khanhaseeb92@gmail.com) wrote:
>> Does anyone have complete documentation to configure PostgreSQL V13 Master
>> and Slave on Windows Server and also how to test Manual Failover ?
>
> I suggest having a look at https://www.postgresql.org/docs/13/high-availability.html
>
> The server administration documentation at https://www.postgresql.org/docs/13/admin.html has some Windows-specific guides.
>
> Rory
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Master - Slave Replication Window Server
2021-06-14 19:36 Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-14 19:41 ` Re: Master - Slave Replication Window Server Rory Campbell-Lange <rory@campbell-lange.net>
2021-06-15 05:42 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
@ 2021-06-15 06:17 ` Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 12:05 ` Re: Master - Slave Replication Window Server Rory Campbell-Lange <rory@campbell-lange.net>
0 siblings, 1 reply; 7+ messages in thread
From: Haseeb Khan @ 2021-06-15 06:17 UTC (permalink / raw)
To: Rory Campbell-Lange <rory@campbell-lange.net>; +Cc: pgsql-performance@lists.postgresql.org
Hello Rory,
Hope you're doing well !
I have confusion below, Should we create an archive path on the standby
server and then set it to recovery.conf file ?
restore_command = 'cp /path/to/archive/%f %p'
*BR,*
Haseeb Ahmad
On Tue, Jun 15, 2021 at 10:42 AM Haseeb Khan <khanhaseeb92@gmail.com> wrote:
> Thankyou Rory !
>
> Br,
> Haseeb Ahmad
>
> > On 15-Jun-2021, at 12:42 AM, Rory Campbell-Lange <
> rory@campbell-lange.net> wrote:
> >
> > On 15/06/21, Haseeb Khan (khanhaseeb92@gmail.com) wrote:
> >> Does anyone have complete documentation to configure PostgreSQL V13
> Master
> >> and Slave on Windows Server and also how to test Manual Failover ?
> >
> > I suggest having a look at
> https://www.postgresql.org/docs/13/high-availability.html
> >
> > The server administration documentation at
> https://www.postgresql.org/docs/13/admin.html has some Windows-specific
> guides.
> >
> > Rory
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Master - Slave Replication Window Server
2021-06-14 19:36 Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-14 19:41 ` Re: Master - Slave Replication Window Server Rory Campbell-Lange <rory@campbell-lange.net>
2021-06-15 05:42 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 06:17 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
@ 2021-06-15 12:05 ` Rory Campbell-Lange <rory@campbell-lange.net>
2021-06-15 12:29 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Rory Campbell-Lange @ 2021-06-15 12:05 UTC (permalink / raw)
To: Haseeb Khan <khanhaseeb92@gmail.com>; +Cc: pgsql-performance@lists.postgresql.org
On 15/06/21, Haseeb Khan (khanhaseeb92@gmail.com) wrote:
> I have confusion below, Should we create an archive path on the standby
> server and then set it to recovery.conf file ?
>
> restore_command = 'cp /path/to/archive/%f %p'
Hi Hasseb
Are you following this procedure?
https://www.postgresql.org/docs/13/continuous-archiving.html
If so please let us know what problem you are experiencing.
Also, this is the postgres performance list. Please move this conversation to postgresql general.
Cheers
Rory
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Master - Slave Replication Window Server
2021-06-14 19:36 Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-14 19:41 ` Re: Master - Slave Replication Window Server Rory Campbell-Lange <rory@campbell-lange.net>
2021-06-15 05:42 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 06:17 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 12:05 ` Re: Master - Slave Replication Window Server Rory Campbell-Lange <rory@campbell-lange.net>
@ 2021-06-15 12:29 ` Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 16:14 ` Re: Master - Slave Replication Window Server Atul Kumar <akumar14871@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Haseeb Khan @ 2021-06-15 12:29 UTC (permalink / raw)
To: Rory Campbell-Lange <rory@campbell-lange.net>; +Cc: pgsql-performance@lists.postgresql.org
Hello Rory,
Yes , I have followed the document and configured each and everything. But I can’t see archive_Wal_segments is copying to the folder which I have created. So the issue I am facing is that where should I create the archive folder should I create on master or slave server ? Might be I am missing something or doing some mistake.
Would appreciated, if you could help in this regard
Kindly send me the Postgres general email, so I can raise this issue over there as well
Thanks in advance
Br,
Haseeb Ahmad
> On 15-Jun-2021, at 5:05 PM, Rory Campbell-Lange <rory@campbell-lange.net> wrote:
>
> On 15/06/21, Haseeb Khan (khanhaseeb92@gmail.com) wrote:
>> I have confusion below, Should we create an archive path on the standby
>> server and then set it to recovery.conf file ?
>>
>> restore_command = 'cp /path/to/archive/%f %p'
>
> Hi Hasseb
>
> Are you following this procedure?
> https://www.postgresql.org/docs/13/continuous-archiving.html
>
> If so please let us know what problem you are experiencing.
>
> Also, this is the postgres performance list. Please move this conversation to postgresql general.
>
> Cheers
> Rory
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Master - Slave Replication Window Server
2021-06-14 19:36 Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-14 19:41 ` Re: Master - Slave Replication Window Server Rory Campbell-Lange <rory@campbell-lange.net>
2021-06-15 05:42 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 06:17 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 12:05 ` Re: Master - Slave Replication Window Server Rory Campbell-Lange <rory@campbell-lange.net>
2021-06-15 12:29 ` Re: Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
@ 2021-06-15 16:14 ` Atul Kumar <akumar14871@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Atul Kumar @ 2021-06-15 16:14 UTC (permalink / raw)
To: Haseeb Khan <khanhaseeb92@gmail.com>; +Cc: Rory Campbell-Lange <rory@campbell-lange.net>; pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Hi Haseeb,
I had configured replication on windows and made a document in an easy way.
I am not expert but I hope it will help you.
Regards
Atul
On Tuesday, June 15, 2021, Haseeb Khan <khanhaseeb92@gmail.com> wrote:
> Hello Rory,
>
> Yes , I have followed the document and configured each and everything. But
> I can’t see archive_Wal_segments is copying to the folder which I have
> created. So the issue I am facing is that where should I create the archive
> folder should I create on master or slave server ? Might be I am missing
> something or doing some mistake.
>
> Would appreciated, if you could help in this regard
>
> Kindly send me the Postgres general email, so I can raise this issue over
> there as well
>
> Thanks in advance
>
> *Br*,
> Haseeb Ahmad
>
> On 15-Jun-2021, at 5:05 PM, Rory Campbell-Lange <rory@campbell-lange.net>
> wrote:
>
> On 15/06/21, Haseeb Khan (khanhaseeb92@gmail.com) wrote:
>
> I have confusion below, Should we create an archive path on the standby
>
> server and then set it to recovery.conf file ?
>
>
> restore_command = 'cp /path/to/archive/%f %p'
>
>
> Hi Hasseb
>
> Are you following this procedure?
> https://www.postgresql.org/docs/13/continuous-archiving.html
>
> If so please let us know what problem you are experiencing.
>
> Also, this is the postgres performance list. Please move this conversation
> to postgresql general.
>
> Cheers
> Rory
>
>
>
Attachments:
[application/zip] streaming repliaction on windows.zip (19.1K, ../../CA+ONtZ6LN02Cx+zCae6jJ7SYYvV0=r6DmCojhRXZ6umfKf4t1Q@mail.gmail.com/3-streaming%20repliaction%20on%20windows.zip)
download
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2021-06-15 16:14 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-06-14 19:36 Master - Slave Replication Window Server Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-14 19:41 ` Rory Campbell-Lange <rory@campbell-lange.net>
2021-06-15 05:42 ` Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 06:17 ` Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 12:05 ` Rory Campbell-Lange <rory@campbell-lange.net>
2021-06-15 12:29 ` Haseeb Khan <khanhaseeb92@gmail.com>
2021-06-15 16:14 ` Atul Kumar <akumar14871@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