Help with restoring Postgresql data in docker from a local data.dump file

Backend Development
1

Hi, I have started learning data engineering recently and I found a free workshop on it and this is the link for its material data-engineer-handbook/bootcamp/materials/1-dimensional-data-modeling/README.md at main · DataExpert-io/data-engineer-handbook · GitHub

From what i understand , the writer is sending is the data from his database by giving us his backup config file data.dump

Through blood and sweat I was able to setup docker and create a postgresql container instance.
Also coned the repo into my local computer
I am jsut lost in the next steps. I would really appreciate if someone could please help me what am supposed to do next. I have spent two whole days trying for a fix and am losing my will to continue on this.

1 Like
2

You’re making great progress! Please see if the documentation below can be helpful:

  1. Import the data.dump file into your PostgreSQL container. You can find detailed instructions in the PostgreSQL pg_restore documentation.
  2. Verify the data by listing the tables in your database. For guidance on using the \dt command in psql, check the psql command documentation.

Keep up the great work!