PostgreSQL Master-Slave DBs: Slave Table Creation
Budget: ₹1,500 – ₹12,500 INR
I currently have a PostgreSQL setup with a master-slave relation for my databases, using Logical Replication. I have a specific requirement where I need to create additional tables in the slave database only. This is intended to distribute the read load more effectively.
Key Requirements:
- Additional tables specifically for user data are to be created in the slave database.
- These tables should not be created in the master database.
- The slave database is currently in read-only mode when I try to create tables, which is causing an issue.
Ideal Skills and Experience:
- Expertise in PostgreSQL databases, particularly in the context of master-slave setups.
- Proficiency with Logical Replication in PostgreSQL.
- Previous experience with setting up additional tables in a slave database.
- Ability to troubleshoot and resolve issues related to read-only mode in PostgreSQL.
This project requires a freelancer who can not only create the necessary tables but also ensure they function correctly within the existing master-slave architecture. Prior experience with similar projects would be highly advantageous.
Key Requirements:
- Additional tables specifically for user data are to be created in the slave database.
- These tables should not be created in the master database.
- The slave database is currently in read-only mode when I try to create tables, which is causing an issue.
Ideal Skills and Experience:
- Expertise in PostgreSQL databases, particularly in the context of master-slave setups.
- Proficiency with Logical Replication in PostgreSQL.
- Previous experience with setting up additional tables in a slave database.
- Ability to troubleshoot and resolve issues related to read-only mode in PostgreSQL.
This project requires a freelancer who can not only create the necessary tables but also ensure they function correctly within the existing master-slave architecture. Prior experience with similar projects would be highly advantageous.