✅ Deploy Preview for authentik-storybook canceled.

❌ Deploy Preview for authentik-docs failed.

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 92.64%. Comparing base (fd66be9) to head (3208e66).
Report is 57 commits behind head on main.

@@           Coverage Diff           @@
##             main    #9727   +/-   ##
=======================================
  Coverage   92.64%   92.64%           
=======================================
  Files         710      710           
  Lines       34706    34745   +39     
=======================================
+ Hits        32152    32189   +37     
- Misses       2554     2556    +2     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

Great PR! Just several hours ago I independently upgraded to postgres 16, there were no problems and it seems like authentik is working much faster.

Great PR! Just several hours ago I independently upgraded to postgres 16, there were no problems and it seems like authentik is working much faster.

Thanks! Out of curiosity, did you update with an existing database or did you recreate it? I'm currently facing the error psycopg.errors.DuplicateTable: relation "authentik_events_event" already exists and i'm looking for ways to make the upgrade easier. From wha I saw, it's impossible (unless i only saw the errors and not the success) to restore database from upgrade_backup_12.sql without purging it first due to already existing table errors.

also for project maintainers @BeryJu / @rissson, where should I put the markdown file once completed?

We'll probably include this in the release notes, so website/docs/releases/2024/next.md, which you can create from the template.

Great PR! Just several hours ago I independently upgraded to postgres 16, there were no problems and it seems like authentik is working much faster.

Yeah we've been testing 16 in CI pretty much since in came out, no issue. Interesting that it seems to be faster though!

Ok. thanks for the quick response. Regarding my issue, do you have any other suggestions or would you do it differently?

Great PR! Just several hours ago I independently upgraded to postgres 16, there were no problems and it seems like authentik is working much faster.

Thanks! Did you update with an existing database or did you recreate it? I'm currently facing the error psycopg.errors.DuplicateTable: relation "authentik_events_event" already exists and i'm looking for ways to make the upgrade easier. From wha I saw, it's impossible (unless i only saw the errors and not the success) to restore database from upgrade_backup_12.sql without purging it first due to already existing table errors.

You shouldn't need to re-create a database, restoring your dump file should be enough. pg_dump has arguments to delete objects if they already exist (-c, -C). The tables probably got re-created because authentik was running and thus executed its migrations as if it was a new install. As such, it should be shut down during the whole operation. The best way would be to cut off connections to postgresql completely, so network: none (don't remember the exact syntax) for a docker-compose installation, and firewalling for a standard postgres install.

I'll try that soon. Thanks!

Regarding K8s, someone would have to write the documentation as I don't really have any experience with it

Regarding K8s, someone would have to write the documentation as I don't really have any experience with it

We distribute postgres 15 with the helm chart, so we won't be upgrading that one soon.

@rissson I think this is ready for first review

Great info and steps to have, thanks @4d62ext !

No problem and thanks for the quick review.

@BeryJu something like this? tried adding headers like the example you provided

I'm so sorry, I misscliked.

something like this? tried adding headers like the example you provided

Yes!

my bad, tried renaming branch on my fork

Thanks again @4d62ext !

no problem!