pg_restore in postgres docker container

Here is a way to restore from a file located on the host machine:

docker exec -i container_name pg_restore -U postgres_user -v -d database_name < /dir_backup_outside_container/file_name.tar

postgresql docker dockerfile

I don't think the backup restore can be done during the initialization phase. Start your container and then upload the db.

docker run -d --name mydb mypgimagedocker exec mydb sh -c "pg_restore -C -d DB /var/lib/postgresql/backup/DB.backup"

CodeHunter