PostgreSQL Database directory appears to contain a database; Skipping initialization
aronmgv opened this issue · 1 comments
aronmgv commented
Support guidelines
- I've read the support guidelines
I've found a bug and checked that ...
- ... the documentation does not mention anything about my problem
- ... there are no open or closed issues that are related to my problem
Description
Moved my docker-compose stack to new server and started having this error when trying to run it:
PostgreSQL Database directory appears to contain a database; Skipping initialization
Is there a "hack" to overcome this error/check? Thanks a lot!
Expected behaviour
24.0
Actual behaviour
start db
Steps to reproduce
use following docker-compose config
Docker info
24.0
Docker Compose config
postgres:
container_name: nextcloud.postgres
image: postgres:12
restart: always
expose:
- 5432
volumes:
- $PWD/postgres:/var/lib/postgresql/data
environment:
- TZ
- PUID
- PGID
- POSTGRES_DB=${DB_NAME}
- POSTGRES_USER=${DB_USER}
- POSTGRES_PASSWORD=${DB_PASSWORD}
Logs
PostgreSQL Database directory appears to contain a database; Skipping initialization
2023-09-07 17:37:11.279 UTC [1] LOG: starting PostgreSQL 12.16 (Debian 12.16-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2023-09-07 17:37:11.279 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2023-09-07 17:37:11.279 UTC [1] LOG: listening on IPv6 address "::", port 5432
2023-09-07 17:37:11.281 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-09-07 17:37:11.288 UTC [27] LOG: database system was interrupted; last known up at 2023-09-05 15:06:25 UTC
2023-09-07 17:37:11.524 UTC [27] PANIC: replication checkpoint has wrong magic 4177909209 instead of 307747550
2023-09-07 17:37:11.760 UTC [1] LOG: startup process (PID 27) was terminated by signal 6: Aborted
2023-09-07 17:37:11.760 UTC [1] LOG: aborting startup due to startup process failure
2023-09-07 17:37:11.760 UTC [1] LOG: database system is shut down
aronmgv commented
Deleting pg_logical/replorigin_checkpoint
solved the problem! Thanks