posgresSQL 설치시 에러 내용

5 asked

1

안녕하세요. 5432 포트가 이미 사용중인것 같습니다.

linux, mac의 경우 lsof -i :5432 명령어로 사용중인지 여부를 알수 있습니다.

혹은, docker ps 실행해보시면 PORTS 열에서, 이미 postgres를 설치했거나 다른 container가 5432 포트를 사용중인지 알수 있습니다.

docker container 를 지우고 싶다면 docker rm -f 컨데이너ID 로 삭제하실 수 있고,

lsof 명령어에서 PID를 확인하셨다면 kill -9 프로세스ID 로 종료가능합니다.

0

안녕하세요. docker -down -v 해서 다시 설치하면 포트번호는 맞게 들어가는데. 포트가 개방이 안돼는것 같습니다. ; CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

fae5488c6056 postgres:latest "docker-entrypoint.s…" 5 seconds ago Restarting (1) 1 second ago postgres_db '

ports:
  - "5433:5432"

0

안녕하세요. 5432포트를 변경해서 5433으로 변경을하면 ,docker 에서 실행은돼는데. 또다른 에러메세지가 나오네요.. ㅜㅜ

"in 18+, these Docker images are configured to store database data in a

format which is compatible with "pg_ctlcluster" (specifically, using

major-version-specific directory names). This better reflects how

PostgreSQL itself works, and how upgrades are to be performed.

See also https://github.com/docker-library/postgres/pull/1259⁠

Counter to that, there appears to be PostgreSQL data in:

/var/lib/postgresql/data (unused mount/volume)

This is usually the result of upgrading the Docker image without

upgrading the underlying database using "pg_upgrade" (which requires both

versions).

The suggested container configuration for 18+ is to place a single mount

at /var/lib/postgresql which will then place PostgreSQL data in a

subdirectory, allowing usage of "pg_upgrade --link" without mount point

boundary issues.

See https://github.com/docker-library/postgres/issues/37⁠ for a (long)

discussion around this process, and suggestions for how to do so. "

DB 설치하는부분이 힘드네요..

docker-compose down -v
docker-compose up -d