uri-postgresql-docker-provisioning

• Date: 02/11/2020

• Author: @augustoliks | carlos.santos110@fatec.sp.gov.br

• Description: Docker environment with PostrgreSQL and Pgadmin, created for tests SQL of URI Judge Online Plataform.

• Objective: Provides Facility on tests URI's execercicies and familiarity on real PostgreSQL environment.

• Actual Features:

  • PgAdmin and PostgreSQL Dockerized;
  • SQL scripts run automatically on compose boot or running update.sh script.

Project Structure

├── db-config                               # Provisioning database and visualization
│   ├── pgadmin 
│   │   ├── passfile                        # Provisioning direct access on database "uri"
│   │   └── servers.json                    # Provisioning conection and visualization on database "uri"
│   └── postgres
│       └── docker-entrypoint-initdb.d      # Directory bind docker volume. Provisioning databases;
│           └── init-db.sh                  # Script for execute sql's inside "sql" in this project directory. Execute on "uri-db" container boot and "update.sh" script
├── docker-compose.yaml                     # Compose postgres and pgadmin 
├── README.md                           
├── sql                                     # SQL's scripts, donwloaded on URI Judge Online Plataform.
│   ├── 2602.sql                            
│   └── 2605.sql
└── update.sh

How to Run

docker-compose up -d

Update Databases

./update.sh

Access

• Download SQL on URI Judge Online Plataform.

---

• Save in sql directory.

• Access http://127.0.0.1:16543. Credentials definited on docker-compose.yml

• username: root@root.com
• password: root

---

• Auth on database;

---

• Verify databases;