There are many of cheap NAT OpenVZ VPSes on market. However, OpenVZ virtualization has certain limitations and comes with old 2.6 kernel. Hosting provider can decide to disable tun/tap, nfs or another core feautures, which makes VPS very limited in usage. At this article we will break the rules and run latest Alpine Linux inside …
Running QEMU VM with the latest kernel inside 2.6 OpenVZ container. Read More »
Part 1. Introduction.Part 2. Replication. Repmgr.Part 3. Auto-failover. Repmgr daemons.Part 4. HA. Backup. Repmgr daemons. Barman.Part 5. Testing. Ansible. Final thoughts. Manual switchover On backup server run. su – postgres repmgr standby switchover -f /etc/repmgrd_db2.conf –log-to-file Auto-failover db2 is a new master now. Gracefully shutdown db2 server. shutdown -h now Wait for db1 server promotion. …
Fault tolerant PostgreSQL cluster. Part 5. Testing. Ansible. Final thoughts. Read More »
Part 1. Introduction.Part 2. Replication. Repmgr.Part 3. Auto-failover. Repmgr daemons.Part 4. HA. Backup. Repmgr daemons. Barman.Part 5. Testing. Ansible. Final thoughts. At this part, we will: make PostgreSQL high available using repmgr daemons use barman for streaming backup combine HA feature and barman to store master and standby backups in the same barman place and …
Part 1. Introduction.Part 2. Replication. Repmgr.Part 3. Auto-failover. Repmgr daemons.Part 4. HA. Backup. Repmgr daemons. Barman.Part 5. Testing. Ansible. Final thoughts. At this part, we will create two repmgr daemons on backup server and setup auto-failover. Why not place daemons on db servers? Because in this case we don’t have voting majority, which dispose to …
Fault tolerant PostgreSQL cluster. Part 3. Auto-failover. Repmgr daemon. Read More »
Part 1. Introduction.Part 2. Replication. Repmgr.Part 3. Auto-failover. Repmgr daemons.Part 4. HA. Backup. Repmgr daemons. Barman.Part 5. Testing. Ansible. Final thoughts. At this part, we will setup master (db1) and standby (db2) replication servers using repmgr. First, create repmgr user and database on db1 server. su – postgres createuser -s repmgr psql -c “alter user …
Fault tolerant PostgreSQL cluster. Part 2. Replication. Repmgr. Read More »