project-phanpy

Set up PostgreSQL server and pgAdmin

Quickstart

1. run the db server and pgAdmin instances.

   make up
   

2. copy the database .tar file to docker volume.

   docker cp dvdrental.tar project-phanpy_db_1:/var/lib/postgresql/data
   

   docker exec project-phanpy_db_1 ls /var/lib/postgresql/data
   

3. restore databse from .tar file.

   docker exec project-phanpy_db_1 pg_restore -c -U admin -d dvdrental -v '/var/lib/postgresql/data/dvdrental.tar'
   

4. go to localhost:8080 and use pgAdmin to manage db.

Use vscode to connect and query (Optional)

Quickstart

1. install PostgreSQL extension.

2. connect to db server.

3. send query.

Upgrade PostgreSQL

• How to quickly upgrade PostgreSQL version using Docker
• PostgreSQL Restore Database
• Removing Volumes

1. with the old PostgreSQL service running, make a backup of the current data

   docker exec project-phanpy_db_1 pg_dumpall -U admin > dump.sql
   

2. stop the running container and delete mapped volume

   docker volume rm project-phanpy_db-data
   

3. update docker-compose configuration, start the services and restore from backup

   docker exec project-phanpy_db_1 psql -U admin -d dvdrental -f /var/lib/postgresql/data/dump.sql