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,
dhamaniasad/awesome-postgres: A curated list of awesome PostgreSQL
software, libraries, tools and resources, inspired by awesome-mysql
(github.com)
<https://github.com/dhamaniasad/awesome-postgres#high-availability>
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