Skip to content

Latest commit

 

History

History
39 lines (27 loc) · 1.16 KB

blueprint.md

File metadata and controls

39 lines (27 loc) · 1.16 KB

db-syncer 🚀

db-syncer is a shell script that automates the synchronization of PostgreSQL databases using Docker Compose. It dynamically generates a docker-compose.yml file based on environment-specific configurations and syncs remote PostgreSQL databases into local instances.

Prerequisites 🛠️

  • Docker: Ensure Docker is installed.
  • Docker Compose: Ensure Docker Compose is installed.

Quick Start ⚡

  1. Clone the Repository 📥:

    git clone https://github.com/pinkynrg/db-syncer.git
cd db-syncer

  2. Set Up Environment Files 📝:

    Create a .env-* file in the envs directory for each environment. For example .env-test-1:

     LOCAL_POSTGRES_USER=local_user
 LOCAL_POSTGRES_PASSWORD=local_password
 LOCAL_POSTGRES_DB=local_db
 REMOTE_POSTGRES_HOST=remote.host.com
 REMOTE_POSTGRES_USER=remote_user
 REMOTE_POSTGRES_PASSWORD=remote_password
 REMOTE_POSTGRES_DB=remote_db

  3. Run the Script ▶️:

    sh ./sync.sh

  4. Monitor and Access 👀: The synchronization process will run in the foreground. Access the synced data in your local PostgreSQL database.