summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
11 hoursUpdate bio for Floor DreesHEADmasterMagnus Hagander
5 daysUpdate info on financial sponsors pageJonathan S. Katz
This updates the dates of the sponsorships, and moves to a different date format based on discussion from PGCA board.
6 daysRemove activity examples, per PGCA board discussion.Dave Page
6 daysRemove Xata as a PGCA financial sponsor.Dave Page
13 daysDo full email validation in oauth signup formMagnus Hagander
These fields aren't editable anyway, but if we don't do the full validation we will instead crash if for example the same account creation form is submitted twice (happens surprisingly often). Now we will instead show a validation error message.
2025-06-23Add new book: PostgreSQL Mistakes and How to Avoid ThemJimmy Angelakos
Author: Jimmy Angelakos <vyruss@hellug.gr> Reviewed-by: Daniel Gustafsson <daniel@yesql.se> Discussion: https://postgr.es/m/8e2b0fbcb7f5ce0b061506f95b211729@hellug.gr
2025-06-16Show cauth version field in django overview pageMagnus Hagander
2025-06-12Make oauthexceptions be http status 400 on signup as wellMagnus Hagander
This was already done for the majority on signin, but for new accounts we should do the same.
2025-06-11Set status 400 on oauth exceptionsMagnus Hagander
It's not always entirely correct, but it's less wrong than 200.
2025-06-11Ensure oauth secure cookie expiresMagnus Hagander
If login isn't completed in 10 minutes, expire the cookie and require a start-over.
2025-06-11Use encrypted cookie instead of session for oauth state dataMagnus Hagander
During oauth logins we need to store some temporary data related to the users session. Previously we did this in the django session, but thanks to AI bots trying millions of logins every day (and never completing the process) we end up with many abandoned sessions in the db. To work around this, instead store the temporary data in an encrypted cookie passed to the browser. Since this cookie can be limited in scope to just the auth part of the site, the slightly larger cookie size doesn't matter, and we don't need to store any data at all server-side.
2025-06-11Use POST when sending to third party oauthMagnus Hagander
Instead of prepopulating a GET request that could generate a session, createa a form with different submit buttons and use that. In the brave new world of AI bots, nobody cares about robots.txt anymore, so we'd get hit by a lot of requests specifically for these logins that were then thrown away because they couldn't log in on the third party site.
2025-06-11Use base64.urlsafe_b64encode() instead of manual specification of charsMagnus Hagander
This makes for better readability, and is exactly the same functionality... Pointed out by Jacob Champion
2025-06-11Implement authenticated encryption in community authMagnus Hagander
This creates a community auth version 3 (previous one being 2, and 1 is long gone) trhat uses AES_SIV as the encryption method instead of regular AES_CBC, and validates the digests on all accounts. As this gets deployed on servers incrementall, the version has to be specified in the database record for the site. We could have the site indicate this itself, but doing it this way seems safer as it will then just break for any app that accidentally reverts the plugin. Reviewed by Jacob Champion
2025-06-11Remove suburl support in test_auth.pyMagnus Hagander
This was removed from actual community auth a very long time ago (in 2013, in commit 78de94d1).
2025-06-02Remove more RHEL 7 stuff, also remove Oracle Linux support. We don't test itDevrim Gunduz
2025-06-02RHEL 10 is available, RHEL 7 is EOL, Fedora 40 is EOL, Fedora 42 is already out.Devrim Gunduz
2025-05-082025-05-08 update release and PostgreSQL 18 Beta 1Jonathan S. Katz
2025-04-23List Fastly as CDN sponsor.Dave Page
This is not the prettiest at the moment as the server sponsor page doesn't include logos, but we are obliged to display the Fastly one in return for the services they provide. We may want to redesign this page at some point in the future to group by sponsor and work more cleanly with non-server hosting sponsors.
2025-04-23Move book to right place in the listDaniel Gustafsson
This moves the book added in eb46390e since I only remembered to put in chronological order after pushing.
2025-04-23Add PostgreSQL For Jobseekers to the books pageDaniel Gustafsson
Per request by the author on pgsql-www@. Reported-by: Sonia Valeja <soniavaleja@gmail.com> Discussion: https://postgr.es/m/CAJz4NYk03KyOVfw8GXif_2c3f2nmOACbNWBNUy9q5R9kd4mWFA@mail.gmail.com
2025-04-23Add Fastly logoDave Page
2025-04-15Add Prairie PostgresDave Page
2025-04-11Update committers listJonathan S. Katz
2025-04-09Upgrade Debian/Ubuntu installation instructionsChristoph Berg
* Use /etc/os-release instead of lsb_release * Update list of distribution releases covere * Drop i386 and s390x architectures * Use PG 17 in package name examples
2025-04-01Update to latest version of auth pluginMagnus Hagander
For some reason, downstream repos had a newer version but we forgot it in the upstream repo.
2025-03-04Correct note on naming to match reality.Dave Page
Per discussion on -core and -hackers.
2025-02-22Remove "Schemaverse" from the "Online resources" pageJonathan S. Katz
The Schemaverse website no longer responds, so we don't need to link to it. Reported-by: Greg Sabino Mullane <htamfids@gmail.com>
2025-02-202025-02-20 update releaseJonathan S. Katz
2025-02-19Update Code of ConductJonathan S. Katz
The CoC had superfluous language on when a CoCC member could be removed. Given the language didn't provide additional context on the process of removal, the language itself is removed. Signed-off-by: Jonathan S. Katz <jonathan.katz@excoventures.com>
2025-02-18Remove 32-bit Windows column in Windows Download tableDaniel Gustafsson
The table describing platform support for Windows downloads still had a column for 32-bit Windows platforms which was all empty. Reviewed-by: Magnus Hagander <magnus@hagander.net> Discussion: https://postgr.es/m/3F3210DF-1A5B-4E6A-B7E1-50B2D9F4D8AD@yesql.se
2025-02-18Fix typoMagnus Hagander
Spotted by Daniel Gustafsson
2025-02-18Add a how to get involved section to developer frontpageMagnus Hagander
Much more can be done to help this page, but it's a start. Reviewed-by: Daniel Gustafsson and Jonathan Katz
2025-02-132025-02-13 update releaseJonathan S. Katz
2025-02-13Prepare for social link updatesJonathan S. Katz
The full work will be handled in a subsequent patch, but for now prepare for the update while finalizing the design.
2025-02-06Add PgBouncer to list of projects covered by CNA scopeJonathan S. Katz
2025-02-06List 3rd party support/help resources on the website.Dave Page
As discussed at the dev meeting in Brussels in January 2025.
2025-01-30RHEL/Rocky/AlmaLinux supports PostgreSQL 16 as well via modules.Devrim Gunduz
2025-01-30Add additional Contributor Committee linksMelanie Plageman
The Contributors Committee wants to add our contact email to our governance page and also link to the release notes from the Contributor profile page. It should make it easier to know how to contact us.
2025-01-27Add EDB as a PGCA sponsor.Dave Page
2025-01-22Make more use of postgres as it's one of our marks.Dave Page
2025-01-21Use correct org name.Dave Page
2025-01-15Add a help text indicating where the "contributions" field is usedMagnus Hagander
Per discussion among moderators
2025-01-07Add a page listing recognised NPOs.Dave Page
2025-01-02Update supported versionsDave Page
2024-12-27Retire Scientific LinuxDevrim Gunduz
2024-12-27Make recent RHEL releases more prominent and remove remaining RHEL 6 stuffDevrim Gunduz
2024-12-27Retire RHEL/CentOS 6Devrim Gunduz
2024-12-27Update Fedora infoDevrim Gunduz
2024-12-19PGCA sponsorship cost update.Dave Page