Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[bitnami/postgresql] container refuse to start after upgrade #79382

Open
jtremesay opened this issue Apr 2, 2025 · 1 comment
Open

[bitnami/postgresql] container refuse to start after upgrade #79382

jtremesay opened this issue Apr 2, 2025 · 1 comment
Assignees
Labels
postgresql tech-issues The user has a technical issue about an application triage Triage is needed

Comments

@jtremesay
Copy link

jtremesay commented Apr 2, 2025

Name and Version

bitnami/postgresql:17.4.0

What architecture are you using?

amd64

What steps will reproduce the bug?

  1. start a bitnami/postgres:16 container
  2. upgrade to bitnami/postgres:17 using the upgrade instructions https://github.com/bitnami/containers/tree/main/bitnami/postgresql#upgrade-this-image

What is the expected behavior?

The upgraded container start without error

What do you see instead?

freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.67 INFO  ==> Welcome to the Bitnami postgresql container
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.67 INFO  ==> Subscribe to project updates by watching https://github.com/bitnami/containers
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.67 INFO  ==> Did you know there are enterprise versions of the Bitnami catalog? For enhanced secure software supply chain features, unlimited pulls from Docker, LTS support, or application customization, see Bitnami Premium or Tanzu Application Catalog. See https://www.arrow.com/globalecs/na/vendors/bitnami/ for more information.
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.67 INFO  ==> 
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.68 INFO  ==> ** Starting PostgreSQL setup **
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.69 INFO  ==> Validating settings in POSTGRESQL_* env vars..
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.70 INFO  ==> Loading custom pre-init scripts...
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.70 INFO  ==> Initializing PostgreSQL database...
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.71 INFO  ==> pg_hba.conf file not detected. Generating it...
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.71 INFO  ==> Generating local authentication configuration
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.72 INFO  ==> Deploying PostgreSQL with persisted data...
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.73 INFO  ==> Configuring replication parameters
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.75 INFO  ==> Configuring fsync
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.75 INFO  ==> Configuring synchronous_replication
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.76 INFO  ==> Loading custom scripts...
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.76 INFO  ==> Enabling remote connections
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.77 INFO  ==> ** PostgreSQL setup finished! **
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | 
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | postgresql 09:43:10.78 INFO  ==> ** Starting PostgreSQL **
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | 2025-04-02 09:43:10.794 GMT [1] FATAL:  database files are incompatible with server
freshrss_postgresql.1.xkgozf959zhl@edemaruh    | 2025-04-02 09:43:10.794 GMT [1] DETAIL:  The data directory was initialized by PostgreSQL version 16, which is not compatible with this version 17.4.

Additional information

No response

@jtremesay jtremesay added the tech-issues The user has a technical issue about an application label Apr 2, 2025
@github-actions github-actions bot added the triage Triage is needed label Apr 2, 2025
@jtremesay jtremesay changed the title container refuse to start after upgrade [bitnami/postgresql] container refuse to start after upgrade Apr 4, 2025
@javsalgar
Copy link
Contributor

Hi!

In this case you are upgrading between major versions of PostgreSQL, so you may need to dump the contents of the database and then restore them in the new image.

https://www.postgresql.org/docs/current/backup-dump.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
postgresql tech-issues The user has a technical issue about an application triage Triage is needed
Projects
None yet
Development

No branches or pull requests

2 participants