Sudo apt-get install postgresql-12-repmgr Install PostgreSQL12: deb focal-pgdg main Note: The server I am using has ubuntu 20.04 instaled. Sudo rm -Rf /etc/postgresql /var/lib/postgresql Please note that in PostgreSQL replication, primary node has read and write functionality, whereas the standby node is read only.Īs a first step, remove all the postgresql leftovers from the system: sudo apt-get -purge remove postgresql-* Repmgr uses the built in streaming replication of PostgreSQL. It enhances PostgreSQL's built-in hot-standby capabilities with tools to set up standby servers, monitor replication, and perform administrative tasks such as failover or manual switchover operations. Repmgr is the tool which I used for replication. Was exported as CSV and imported into tables in PostgreSQL. Since we are using liquibase, we didn't have too many problems with migration of tables because liquibase took care of it. So we decided to switch Teckportal to PostgreSQL as well. Maintaining different databases and deploying them with replication and high availability is a big problem. We were using MySQL as database for Teckportal till now, whereas the Open-source software we use for Teckportal known as loraserver uses PostgreSQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |