PostgreSQL Installation and Replication Setup on Two Servers

₹600-1500 INR

Open

Posted

about 23 hours ago

•

Ends in 6 days

₹600-1500 INR

Paid on delivery

Project Description: We are looking for an experienced system administrator or database specialist to assist with the installation and configuration of PostgreSQL on two new servers. The goal is to establish a replication setup where one server acts as the primary (master) and the other as a replica (slave), ensuring automatic synchronization and real-time backup of the primary server’s data. The setup should also allow secure connections to the PostgreSQL database from a third server, which will be used for accessing the database remotely. Key Requirements: PostgreSQL Installation: - Install the latest stable version of PostgreSQL on both servers. - Configure PostgreSQL to run as a service on both servers, ensuring automatic startup on reboot. Master-Replica Configuration: - Set up one server as the primary (master) and the other as the replica (slave). - Configure streaming replication between the two servers to ensure that the replica is always in sync with the master server. - Set up the replication process to be fully automated and error-free, ensuring the replica continuously receives updates from the primary server without manual intervention. Replication Monitoring: - Provide tools or scripts to monitor the replication status and health, ensuring there is minimal downtime or data inconsistencies. Connection Setup for a Third Server: - Ensure secure and efficient access to the PostgreSQL databases from a third server. - Configure necessary firewall rules and provide secure authentication mechanisms (e.g., SSL, SSH tunneling) for external connections. Testing & Validation: - Test replication functionality to ensure data changes on the master server are reflected on the replica in real-time. - Test access from the third server to confirm connectivity and access rights. Documentation: - Include troubleshooting steps in case of replication failures or connection issues. Deliverables: - PostgreSQL installed and configured on both servers. - Master-replica replication fully set up and functional. - Secure connection access to the PostgreSQL from the third server. Skills Required: - Proficiency with PostgreSQL setup and configuration. - Experience in setting up PostgreSQL replication (streaming replication, logical replication, etc.). - Strong understanding of server security, networking, and remote access configurations. - Knowledge of Linux server management and firewall configuration. - Ability to provide support for any issues related to replication, synchronization, or connectivity.

Linux

Database Administration

MySQL

System Admin

Ubuntu

Project ID: 38966221

About the project

12 proposals

Open for bidding

Remote project

Active 4 hours ago

Place your bid

Bid amount

₹

INR

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

12 freelancers are bidding on average ₹3,696 INR for this job

@ASSAMWEB

Greetings, I have read the project description I have been working on a similar project in recent time. I am interested in the work open a chat to discuss requirements in details.

₹20,000 INR in 2 days

5.0

(10 reviews)

4.4

@manum11

i have working experience of 2+ years on linux os like ubuntu, centos, amazon linux, oracle linux, etc. i can install postgreSQL on your server with replication turned on on second server.

₹1,500 INR in 1 day

4.6

(11 reviews)

3.7

@ToracosLabs

As a seasoned system administrator who has worked extensively with various database management systems, I assure you of my proficiency in PostgreSQL setup and configuration. Installation of the latest stable version of PostgreSQL on both your servers and ensuring it runs as a service that starts up automatically on reboot is well within my skillset. Additionally, my expertise in streaming and logical replication aligns perfectly with your requirement to establish a secure master-replica setup. My knowledge extends beyond just setting up databases; I am well-versed in server security, networking, and remote access configurations. Utilizing these skills, I will ensure the third server gets efficient and secure access to your PostgreSQL databases. Furthermore, I can provide robust monitoring tools and documentation to minimize downtime or data inconsistencies. My experience extends to Linux server management and firewall configuration which means I can guarantee not just a functional replication setup but also an airtight one that keeps your data safe from unauthorized access. Testing functionalities like real-time data reflection on the replica from the master server along with connectivity from the third server will be treated with utmost priority before finalizing anything. Expect clear communication and strong support throughout the process. Allow me to provide you with an exceptional solution aligned to your requirements.

₹600 INR in 2 days

5.0

(21 reviews)

3.5

@arpitasahasarkar

I'm a great fit because i have 13 years of experience on Database admin. i have experience on oracle and PostgreSQL ,aws RDS ,ETL. I'm ready to start working on your project and can complete it by 2 days . Looking forward to hearing from you, Please initiate a chat session so we can discuss more about it. Thank you.

₹2,050 INR in 1 day

5.0

(6 reviews)

2.9

@nvbhuvi

As a team of seasoned professionals with a rich background in system administration and database management, we are well-versed and experienced in handling exactly the kind of task you're looking to have completed. replication or logical replication, we have got it covered.

₹1,050 INR in 7 days

3.1

(2 reviews)

2.7

@EngrHamza3409

As a seasoned and highly skilled Full Stack Developer with over 3 years of experience, I have had the privilege of working on diverse projects that required manipulating, analyzing, and managing large datasets. My proficiency in PostgreSQL, coupled with my understanding of different database systems, including replication mechanisms and data consistency makes me the ideal fit for this task. Throughout my career, I have continuously demonstrated an unwavering commitment to quality output and cutting-edge solutions. I intend to employ this same dedication and expertise into your task by ensuring an optimized PostgreSQL installation on both servers, seamless master-replica configuration through efficient streaming replication and robust remote connection setup while guaranteeing secure and efficient access from the third server. Moreover, my solid understanding of Linux server management and firewall configuration perfectly complements this project's requirement. I can provide real-time monitoring tools along with comprehensive documentation that details not only the setup process but also troubleshooting steps - ensuring any replication failure or connection issue can be resolved swiftly with minimal downtime. Consider my services and let's achieve flawless PostgreSQL setup, replication and secure remote accessibility to elevate your business operations to a higher level of efficiency!

₹2,500 INR in 7 days

5.0

(1 review)

0.0

@eguerrac

As an experienced system administrator with a comprehensive understanding of PostgreSQL setup and configuration, I firmly believe that I possess the skills and expertise required to successfully install and configure PostgreSQL on your servers. My wide-ranging knowledge of server security, Linux server management, and firewall configuration will be invaluable in establishing a secure connection for remote access to the databases. Additionally, I have extensive experience in setting up various types of PostgreSQL replications. I'm well-versed in streaming replication, logical replication, and other techniques to ensure real-time synchronization between a master and replica server efficiently. My eye for detail and meticulous nature pushes me to implement fully automated and error-free replication processes that eliminate manual intervention. One aspect that distinguishes me from others is my ability to communicate effectively with both technical and non-technical stakeholders. I nicely combine my solid technical background with years of experience in customer support and commercial management. Overall, choosing me for this project guarantees trustworthy delivery of not just PostgreSQL installation and replication setup between your servers but also a secure connection with minimal downtime or data inconsistencies from the third server. Looking forward to working on your requirements!

₹1,500 INR in 2 days

0.0

(0 reviews)

0.0

@dikshaag07

I am a dba with 8+ years of experience working in Bangalore. I can help you in installation and configuration of postgres server, Please reach out to me for this

₹10,500 INR in 7 days

0.0

(0 reviews)

0.0

@amolnandivale18

Hi, this is Amol. I specialize in secure database installation and have hands-on experience with setting up database replication in master-slave configurations. I’m highly interested in this task and would love to discuss it further with you. Let’s connect! Thank you.

₹1,500 INR in 2 days

0.0

(0 reviews)

0.7

@ibrarkhann

Hello, As a certified DevOps engineer with expertise in PostgreSQL administration, Linux server management, and network security, I am confident in delivering a robust and secure PostgreSQL replication setup tailored to your requirements. Approach PostgreSQL Installation and Configuration Install and configure the latest PostgreSQL version on both servers with auto-start. Master-Replica Setup Establish automated streaming replication for real-time synchronization. Configure reliable monitoring tools/scripts to ensure replication health. Secure Third-Server Connectivity Enable secure database access using SSL or SSH tunneling. Configure firewalls and authentication mechanisms for enhanced security. Testing and Documentation Validate replication functionality and third-server connectivity. Provide comprehensive documentation with troubleshooting guidelines. Why Choose Me? Extensive experience with PostgreSQL replication and Linux servers. Proven expertise in designing secure and scalable database solutions. Commitment to delivering high-quality work with clear communication. I can complete the setup within 5 days at a competitive rate of 650 INR. Let’s collaborate to ensure a seamless and secure database environment. Best regards, Ibrar khan

₹1,050 INR in 5 days

0.0

(0 reviews)

0.0

@sivapradeepmsc

With a company name like ClutchOps Technologies LLP, I know you're expecting someone skilled in both clutch moments and technological prowess. Look no further! My team and I have a proven track record in delivering cutting-edge cloud solutions and deploying efficient data management and recovery configurations. As specialists in Database Administration, Linux, and MySQL specifically, setting up PostgreSQL on your servers for replication will be a natural fit for us. We have extensive experience with PostgreSQL setup, the ins and outs of streaming replication, and handling connection issues with secure means like SSL and SSH tunneling. What sets us apart is our deep commitment to documentation; we'll provide clear instructions to help you troubleshoot potential replication issues or connection problems moving forward. Choose ClutchOps Technologies; we don't just solve the problem at hand, we equip you with the knowledge to navigate any future challenges autonomously.

₹1,050 INR in 7 days

0.0

(0 reviews)

0.0

@smarttechbreed

With my extensive experience in DevOps and Linux-based database administration – I have set up, configured and maintained complex database infrastructures that spanned multiple servers. I have expert level command on Linux/Debian/Ubuntu - critical experience given your exacting requirements. Furthermore, my skills extend beyond the mere 'administrative' aspect; I am well-versed in mastering potent monitoring tools such as Datadog, ELK, M/Monit, Zabbix and Nagios – this means I can not only install and configure PostgreSQL for you, but also devise a monitoring mechanism that will keep track of the replication process between the two servers ensuring minimal downtime or inconsistencies. My command over SDLC ensures thorough testing and validation after setting up replication: data changes from the master reflect real-time on the replica. Lastly, my familiarity with robust security protocols like SSL and SSH means that I am adept at making sure that your PostgreSQL installation is impervious to unauthorized access whilst simultaneously facilitating efficient connectivity options to the third party server. Even problems, if they occur, won't stagnate your workflow as I document all my work including troubleshooting steps should anything malfunction unexpectedly.

₹1,050 INR in 7 days