Restoring data to PosrgteSQL database from dump

Let's imagine that we have somedump.backup

And we need to import that dump to our docker container where we have database called mydatabase

First: copy dump to the Docker container

To see our docker container we can type

docker ps

We wil see the list with containers. Remember the name of our database container.

Later open the foder where out dump is located. And inside the folder we can type:

docker cp somedump.backup container_name_or_id:/db.backup

After this action we can see that inside our docker container appeared new item called db.backup

We can restore it using command:

pg_restore -U our_username -d mydatabase /db.backup

image:

Kenny Eliason Unsplash

SQL