Postgres 12 went end of life Nov 2024

[preArcMed821]

Postgres 12, used by Simplelogin went end of life November 2024. I've seen some reports of people successfully using Postgres 13 but that even went end of life November 2025,

Specifically, the docker image for version 12.1 was released 6 years ago.

Is it possible to use version 14 or higher to stay with something supported?

https://endoflife.date/postgresql.

I have been able to change my tag to 12.22 which is the last version released and all seems to be OK. This image is approximately 1 year old.

Many thanks

[springcomp]

I have been able to upgrade to 17.7 without issue.
This seems to run successfully in a self-hosted scenario so far.

You need to:

• Stop SimpleLogin
• Run only the postgres container sl-db (no sl-app, sl-email or sl-job-runner) with version 12.22.
• Backup the database
• Stop sl-db
• Remove the ./db/ folder and re-create it empty.
• Start sl-db with version 17.7: this will create an empty database.
• Restore the database.
• Restart all containers.

[preArcMed821]

Hey @springcomp . Thank you very mush!! This worked fine for me! Time will tell if there are any issues but all seems good so far.

I wonder if there is a reason why this is not the case for new deployments?

To make it easier for others:

• Stop SimpleLogin (docker compose down)
• Run only the postgres container sl-db (no sl-app, sl-email or sl-job-runner) with version 12.22. (docker compose up -d postgres)
• Backup the database
• Stop sl-db (docker compose down)
• Move the ./db/ folder to keep the old version safe (mv db db_pre_update)
• Modify compose file to change postgres version
• Start sl-db with version 17.7: this will create an empty database. (docker compose up -d postgres)
• Move the backup file in to the new db folder cp db_pre_update/simplelogin.backup db
• Restore the database.
• Stop postgres (docker compose down)
• Start all containers (docker compose up -d)

[springcomp]

@preArcMed821 FYI, I was also able to run version 18.1 without issue for a few hours.

[preArcMed821]

Thanks again @springcomp. I just completed the upgrade without issue. I'd missed your guide and had just written up my own to share and then saw yours, and they are essentially identical 💯

Great to see you have modified the compose file on your repo 👍 Thanks for all your contributions.

For anyone else reading this, I highly recommend @springcomp 's repo and guide for setting up SimpleLogin fullly in Docker (including Postfix) with Traefik:

self-hosted-simplelogin