You will get PostgreSQL cluster setup using repmgr
Project details
Following Objectives will be covered
Objective:
1) Install postgresql and repmgr & create postgresql cluster
2) Register primary server with repmgr and clone standby server.
3) Verify streaming replication.
4) Register standby server with server and verify both primary and secondary.
5) Demonstration of switchover (Controlled manual failover for mainteanance activities)
6) Demonstration of standby promote to primary in case of abrupt primary node failure.
7) Demonstration of removing primary and standby node in cluster & repmgr Unistallation
Objective:
1) Install postgresql and repmgr & create postgresql cluster
2) Register primary server with repmgr and clone standby server.
3) Verify streaming replication.
4) Register standby server with server and verify both primary and secondary.
5) Demonstration of switchover (Controlled manual failover for mainteanance activities)
6) Demonstration of standby promote to primary in case of abrupt primary node failure.
7) Demonstration of removing primary and standby node in cluster & repmgr Unistallation
Database Type
PostgreSQLWhat's included $300
These options are included with the project scope.
$300
- Delivery Time 3 days
- Number of Revisions 2
- Permissions Setup
- Import/Export Data
Frequently asked questions
91 reviews
(80)
(10)
(1)
(0)
(0)
This project doesn't have any reviews.
AR
Anurag R.
Jun 16, 2025
Normalize database, create schema files and er daigram, create prod copy of db
AR
Anurag R.
May 28, 2025
Normalize database, create schema files and er daigram, create prod copy of db
JG
JT G.
Mar 17, 2025
RDS optimization
AR
Anurag R.
Jan 21, 2025
Design database
Rohit did a great job, delivered as outlined. He understood the requirements without any challenges. Good communicator.
KR
Kumar R.
Dec 11, 2024
MySQL Query Optimization Specialist Needed
Delivered an optimized, clean, and efficient solution that exceeded expectations. Highly professional and easy to work with. Would absolutely hire again and recommend to others without hesitation!
About Rohit
DB Developer, DBA, SQL Expert, Performance Tuning, Data Visualisation
100%
Job Success
Jaipur, India - 3:05 pm local time
I help my clients build systems that are scalable, efficient, and high performant and make the right decisions on technology/implementations so that they achieve a better user experience and save on resource/hardware/development costs.
I'm Microsoft Certified Azure Database Associate
I'm an IBM Certified DBA For Linux, Unix & Windows on versions 9.7, 10,1, 10.5.
I offer wide range of Data Analytics and Visualisation using PowerBI, Tableau & AWS QuickSight (Samples Attached in my Portfolio)
✅ Sales Reports and Dashboard
✅ Finance Reports and Dashboard
✅Drug Dosage & Integration Reports & Dashboards
✅ Healthcare Report and Dashboards Over Patient De-identified Data
✅ Other Reports and Dashboards
My Key Skillsets
Sql Server 2017/2018/2019, SQL Coding / Tuning on IBM DB2 / Tuning on MySQL / Oracle / SQL Server / MySQL / Aurora / MariaDB / PostgreSQL SQL / PLSQL / Database Performance Tuning / SQL Optimisation / Data Warehousing / Snowflake / ETL Pipeline / Database Setup, Migration & Upgrade / Database Sizing / Core Java / Shell scripting / Encryption / Compression / Partitioning / Database Sizing / Shell scripting / Compression / Partitioning / AWS QuickSight / MongoDB / Knack / Tableau
Steps for completing your project
After purchasing the project, send requirements so Rohit can start the project.
Delivery time starts when Rohit receives requirements from you.
Rohit works on your project following the steps below.
Revisions may occur after the delivery date.
Linux PostgreSQL Cluster Setup
Objective: 1) Install postgresql and repmgr & create postgresql cluster 2) Register primary server with repmgr and clone standby server. 4) Register standby server with server and verify both primary and secondary.