postgres:alpine: error column datlastsysoid does not exist

[MrWildanMD]

i got this strange error on macOS but its running fine in my linux..whats wrong? here my compose:

postgresdb:
    image: postgres:alpine
    container_name: postgres_container
    environment:
      - POSTGRES_USER=${DB_USERNAME}
      - POSTGRES_PASSWORD=${DB_PASSWORD}
      - POSTGRES_DB=${DB_NAME}
      - DATABASE_HOST=${DB_HOST}
    ports:
      - 5432:5432
    volumes:
      - ./pg_data:/var/lib/postgresql/data

volumes:
  pg_data:

[LaurentGoderre]

It seems that field doesn't exist anymore in Postgres 15.

[LaurentGoderre]

Is the volume data that was created in Postgres prior to version 15?

https://www.postgresql.org/docs/15/release-15.html#id-1.11.6.9.4

[MrWildanMD]

i'm not sure because my initial setup yaml is like what i post...i only specify postgres:alpine and i don't know why it works fine on my linux but not on mac, that put me to confuse

[LaurentGoderre]

Maybe one uses a local tag of Postgres latest pinned to version 14 and using a new machine uses the new version.

[MrWildanMD]

ah, that sound make sense...alright updated my docker-compose to use latest version instead of alpine one

image: postgres:latest