Repository navigation
SQL files under docker-entrypoint-initdb.d are not executed even if data directory is not initialized #1226
Description
According to the documentation running docker compose on this yaml file:
services:
masterdb:
image: postgres:15.6-alpine
container_name: primary-server
ports:
- 5432:5432
environment:
POSTGRES_USER: admin
POSTGRES_PASSWORD: psw
volumes:
- ./init.sql:/docker-entrypoint-initdb.d/init.sql
readonlydb:
image: postgres:15.6-alpine
container_name: hot-standby
ports:
- 5430:5432
environment:
POSTGRES_USER: admin
POSTGRES_PASSWORD: pswshould initialise:
primary-server with init.sql.
However it does not happen even if the file is correctly mounted:
Ii tried, to delete/re build the images, delete all the volumes but nothing. The init.sql script is not executed.
Activity
tianon commentedon Apr 15, 2024
Compose works really hard to keep and re-use volumes between runs (including and especially "anonymous" volumes that aren't specified in the file, but are specified in the images in use), which is probably what you're running into.
Have you tried
docker-compose down --volumesand/ordocker-compose up --renew-anon-volumes?