Back to projects
Jan 01, 2024
2 min read

Psql dump database restore

A solution for restoring a PostgreSQL database from a .dump file

Technologies in this project

This project was created because I needed to restore a database from a .dump file. This type of file is provided by PostgreSQL, and when I tried to restore from TablePlus, I got some errors that I didn’t know how to solve. So, I thought: I’ll create the solution for these issues using Cursor AI.

The solution is a Dockerfile with a docker-compose file that executes a .sh file. The output is simple: the data from the .dump file and its tables with all relationships.

Check the repository for more info: database-restore