I have a postgres cluster made using repmgr. This is the requirement of the application that they should not have to change the IP in the application when the database switchover occurs. Is there a way to use virtual IP with repmgr which outside clients can use and database switchover should not demand changing IP in application
Assigning virtual IP in repmgr
1.3k Views Asked by makhshif afiniti At
1
There are 1 best solutions below
Related Questions in POSTGRESQL
- Why does adding a JOIN completely modify the query planner behaviour?
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Aggregate and count in PostgreSQL
- Rails HABTM: Select everything a that a record 'has'
- Trigger using data from inserted row
- Select results where joined table contains records with an attribute, but without another
- DB candidate as CouchDB/Schema replacement
- How do I properly add data in SQLAlchemy?
- Postgres in Conda Environment (Ubuntu 14.04)
- How to customize the output of the Postgres Pseudo Encrypt function?
- Split a large query (2 days) into pieces to increase the speed in Postgres
- Why does pg_search prefix not work like I expect?
- extracting meta info from a table psql using information_schema
- How to query a table in the database and copy it's data into one one?
- Update a table using info from a second table and a condition from a third table in Postgresql
Related Questions in DATABASE-ADMINISTRATION
- Windows Authentication - Restrict SQL Server Backend Access
- who writes a DDL - DBA or the developer using the table
- Selecting ticketid with status history
- Oracle DB: delete all the contents
- How to create a "live" feed for two seperate Postgres Instances?
- grant to multiple db using one command
- what is the correct format of a column for store UTC date time
- how to schedule a job on Oracle SQL developer to execute shell command "Java -Jar /Home/JavaFile.jar" each one minute?
- Any ideas on why this query would run so slow?
- Attempting insertion into the row version column "SSMA_TimeStamp". Cannot insert into a row version column
- MongoDB command `compact` is not working
- Can we do table partition in SQL Server 2012 Standard Edition
- query that shows if the tables might need analyze and vacuum
- How to extractvalue of table counts using xml in DB2? (see working Oracle equivalent)
- Data Export of SQL Server table from one server to another / Data Flow task error
Related Questions in DATABASE-CLUSTER
- How to share a Neo4j HA cluster with multiple Spring application?
- Rails adapter solutions for MySQL Cluster (NDB)?
- MySQL Cluster Replication
- Is it true that MyISAM engine is more preferable than InnoDB when we are building clustered storage? Why if it is so?
- log4j logging to DB (in a cluster)
- Performance of MySQL Cluster vs MySQL
- Trying bolster mysql failover
- Multi-Node in TimeScaleDB
- ERROR: [dn3]: SSL connection has been closed unexpectedly
- TimescaleDB multinode cluster & replication factor
- How to use master & slave nodes in Laravel
- pgpool-II for Postgres - Is it what I need?
- PostgreSQL - Clustering never completes - long key?
- Apache CloudStack with MySQL Cluster (NDB Engine)
- PostgreSQL 9.3.5 'Active-Active' mode for Windows Server 2012 R2
Related Questions in VIRTUAL-IP-ADDRESS
- keepalived check which is master node
- Establishing Virtual IP failover on apache load balancer running Windows 7 OS
- IPTABLES for multiple Public IP Addresses
- Kafka setting vip address to kafka cluster
- docker service loadbalancing failed
- Virtual IP and Internal IP of Windows Azure Virtual Machines
- how to use custom ip address to browse a web page c#/.net
- How to get a Virtual IP for Keepalived with bare-metal infrastructure
- ActiveMQ Artemis - how to configure primary/backup on two VMs with replication only (no failover)
- VIP URL on SSL is logging out immediately on MVC application Form authentication
- Public IP mapping to internal shared virtual ip address in Docker
- Failed to allocate network resources
- While login with an IP Address time out error will arises every time on sql server 2018
- How to monitor virtual IP with zabbix?
- Kubernetes VIP address clarifications
Related Questions in REPMGR
- How to use repmgr with dockerized Postgresql?
- Preventing the Docker container from exiting when the main process dies
- PostgreSQL/PostDock: Auto recovery failed in master node
- Do you need watchdog on pgpool when using repmgr?
- Does repmgr replicate "CREATE TABLESPACE"?
- Repmgr and PostgreSQL data_directory permission problem
- repmgr - recover from failed primary?
- pgpool HA + repmgr for Postgresql 9.6
- bitnami/postgresql-repmgr docker containers not finding each other
- repmgr - Automate process of making primary to standby after failover
- repmgrd and supervisord on docker - losing parent?
- Error: (repmgr) server is in standby mode and cannot be registered as a primary
- error: connection to server at "10.0.30.7", port 5432 failed: No route to host
- Problem when upgrading postgres from 9.5 to 11
- Assigning virtual IP in repmgr
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You can use HAproxy, target your primary DB, use with healthcheck and in case of not responding for some time HAproxy will redirect to your standby DB for example.
But if you don't want to introduce a SPOF with a loadbalancer and just want a simple two node cluster, then you could use HA2node.
https://github.com/jfekete1/HA2node
Keep in mind that HA2node only works on Linux servers with postgres and repmgr installed.