PostgreSQL Wal Shipping & Stream Replication on Windows 2008 R2

[@oscarguardiola84]

Hello very usefull tuto, on windows ;) Just one thing wal_level doesn't use "hot_standby" now ( v14) use "replica" and "wal_keep_segments = 10" is deprecated from v12, if present the server (master or slave) doesn't start. Even, now recovery.conf file is deprecated. The restore command and primary conninfo are in the postgresql.conf. The "standby_mode" switch is replace by a file to create (near conf files) with this name : "standby.signal". The archive folder can be on master with shareover network with postgres user.

[@emudhradelhi6261]

hi, can you please help me

[@pragyeshgupta7157]

I've followed the same steps which are provided in the video. Problem is service is not being started on slave side. Can you please help me?

[@jitugosavi]

I have same issue with my setup. Could anyone please help ?

[@sasikanthpenumadula8829]

configuration and setup worked fine. thanks. how do you do a failover from master to slave? role reversal possible ?

[@prasdepe944]

"select pg_start_backup('name') -> ('base')" where are "base" taken from?

[@sunghsinlei1168]

Is there a way to do this from a Windows OS to a Linux OS? Preferably without slony or pgpool or similar tools.

[@mamathaammu1042]

Thanks for the video. We are using Postgres 14 and unfortunately, data is not populating in the slave could you please help us out.

[@talgimani9468]

Yes, of course you can put the Archive folder directly on the Slave, but I wanted to show a situation where the Archive is not on the master or the slave

[@plikken]

Did you use 32 bit systems or 64 bit? or 1 of each

[@leon6295]

Can you make a video on postgres 12/windows 10

[@deFreijtas]

Will this also work if one of the machines is on another subnet or external address?

[@akilan1154]

Ivannick de Freijtas yes

[@ChristopherMuscatMaskit89]

Thanks for the video... really helpful =]

[@aliasgarlokhandwala4948]

Does any one know the music in the background?

[@pragmatictechsoftpvtltd567]

Very Helpful Video. Can you create a video that is like Master is on Ubuntu and Slave is on Windows machine?

[@iamphuong]

Service is not being started on slave machine. Can you please help me?

[@jurekintergeo5548]

Hi, I have the same problem - slave don't start. Did you fix that problem?

[@ngotuanhien]

I got the same problem when started the slave service. I checked the system log and found that the login account password to run the service on the slave server was not correct. I fixed it and it run smoothly. Another possibility to error might be of the difference between login account of the slave server and the credential to read the share "archive" folder on network shared drive (Linux like account). If the service on slave server could not access the shared folder on start, it would stop the service. Hope this help!

[@ivannruiz9946]

Hey guys do any of you know how to setup automatic failover on Windows?

[@MaMiinT]

Now can you find solution to setup automatic failover on Windows? I wanna setup on failover cluster too.

[@kallkleneju]

Thanks for this... Can you show in other video how to promove the slave to master?

[@j3n660t]

what is 192.168.13.12? another computer?

[@Mikie227]

Yes, it's a another computer because worked virtual machines.

[@fxeconomist]

what is 192.168.13.12 ?

[@AntonioAlaniz715]

It's the internal IP address.

[@akilan1154]

it is a remote server machine to archive folder .... shared folder ip address

[@samnert1971]

what if the archive folder is down when the master need to write a log file on it?

[@cegfb1]

Excelent!!!

[@jitugosavi]

I've followed the same steps which are provided in the video. Problem is service is not being started on slave side. Can you please help me?