Обсуждение: PostgreSQL Automatic Failover Windows Server
HI,
I am Heljeeve from India working as a DB Administratror. We are a company doing projects on solutions for lottery system worldwide, and been in the industry for the past 20 years. Currently we are doing projects in Windows environments ( MS SQL SERVER DATABASE ), as we required high availability system we are mirroring the DATABASES using in built technology of MS SQL SERVER MIRRORING and it's running smoothly.
Now we are wth a plan to migrate the databases to PostgresSQL. Database development has been started.
I want to know in detail about PostgreSQL Automatic Failover solutions without third party tools.
I believe it will work fine as mirroring in MS SQL SERVER
Can someone help me how to configure PostgreSQL Automatic Failover Windows Server.
Installation procedures step by step on WINDOWS SERVER.
Help very much appreciated.
Thanks & Regareds
Heljeeve
I want to know in detail about PostgreSQL Automatic Failover solutions without third party tools.
There is no automatic failover solution provided with core postgresql. (maybe EDB provides in windows but ...)
there are third party OSS solutions,
These are a few solutions for HA.
There are detailed docs for each and/or blogs, you will have to read them to figure out which one suits you best.
Thanks,
Vijay
Mumbai, India
On Wed, Aug 18, 2021 at 11:57:24PM +0530, Vijaykumar Jain wrote: > > I want to know in detail about PostgreSQL Automatic Failover solutions > without third party tools. > > There is no automatic failover solution provided with core postgresql. (maybe > EDB provides in windows but ...) > there are third party OSS solutions, > dhamaniasad/awesome-postgres: A curated list of awesome PostgreSQL software, > libraries, tools and resources, inspired by awesome-mysql (github.com) > These are a few solutions for HA. > There are detailed docs for each and/or blogs, you will have to read them to > figure out which one suits you best. Yes, I think the reason there are only third-party failover tools is that failover is very tied to the operating system/network details, and the database usually doesn't focus on those. -- Bruce Momjian <bruce@momjian.us> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
On Wed, 2021-08-18 at 21:18 +0530, Heljeeve C Unni wrote: > I want to know in detail about PostgreSQL Automatic Failover solutions without third party tools. > > Installation procedures step by step on WINDOWS SERVER. You could have a look at this: https://github.com/cybertec-postgresql/patroni-windows-packaging Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com