2385 Commits

Author SHA1 Message Date
68f0cfe480 Clarify that the sponsor table for PGCA only shows "Friend" and above. 2025-07-18 11:44:40 +01:00
47d332bd23 PostgreSQL 18 Beta 2 release 2025-07-17 08:11:10 -04:00
faaf2fe339 Update bio for Floor Drees 2025-07-15 12:38:02 +02:00
e2ba7ed105 Update info on financial sponsors page
This updates the dates of the sponsorships, and moves to a
different date format based on discussion from PGCA board.
2025-07-10 21:28:35 -04:00
e594541fe3 Remove activity examples, per PGCA board discussion. 2025-07-10 10:39:12 +01:00
336324ebbd Remove Xata as a PGCA financial sponsor. 2025-07-10 10:38:23 +01:00
7d33e398a6 Do full email validation in oauth signup form
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-07-02 22:28:30 +02:00
0c8f2d7bca Add new book: PostgreSQL Mistakes and How to Avoid Them
Author: Jimmy Angelakos <vyruss@hellug.gr>
Reviewed-by: Daniel Gustafsson <daniel@yesql.se>
Discussion: https://postgr.es/m/8e2b0fbcb7f5ce0b061506f95b211729@hellug.gr
2025-06-23 17:06:47 +02:00
84bf556fce Show cauth version field in django overview page 2025-06-16 15:47:45 +02:00
4bc540b6a0 Make oauthexceptions be http status 400 on signup as well
This was already done for the majority on signin, but for new accounts
we should do the same.
2025-06-12 10:21:50 +02:00
7959b229ee Set status 400 on oauth exceptions
It's not always entirely correct, but it's less wrong than 200.
2025-06-11 20:47:16 +02:00
252c238e69 Ensure oauth secure cookie expires
If login isn't completed in 10 minutes, expire the cookie and require a
start-over.
2025-06-11 20:40:20 +02:00
eb629db583 Use encrypted cookie instead of session for oauth state data
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-11 20:34:09 +02:00
e001690d4d Use POST when sending to third party oauth
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-11 20:34:09 +02:00
e48157dac3 Use base64.urlsafe_b64encode() instead of manual specification of chars
This makes for better readability, and is exactly the same
functionality...

Pointed out by Jacob Champion
2025-06-11 20:26:21 +02:00
de76f82f62 Implement authenticated encryption in community auth
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-11 20:26:21 +02:00
7a42e2a5f5 Remove suburl support in test_auth.py
This was removed from actual community auth a very long time ago (in
2013, in commit 78de94d1).
2025-06-11 20:26:21 +02:00
6fbb64be01 Remove more RHEL 7 stuff, also remove Oracle Linux support. We don't test it 2025-06-02 19:49:05 +03:00
f24954666c RHEL 10 is available, RHEL 7 is EOL, Fedora 40 is EOL, Fedora 42 is already out. 2025-06-02 19:46:42 +03:00
06120780ba 2025-05-08 update release and PostgreSQL 18 Beta 1 2025-05-07 23:49:46 -04:00
89f8a7d553 List Fastly as CDN sponsor.
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-23 10:27:58 +01:00
827a06e256 Move book to right place in the list
This moves the book added in eb46390e since I only remembered to put
in chronological order after pushing.
2025-04-23 10:49:11 +02:00
eb46390e71 Add PostgreSQL For Jobseekers to the books page
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-23 10:46:19 +02:00
76ad604105 Add Fastly logo 2025-04-23 09:32:58 +01:00
e1d0305d6e Add Prairie Postgres 2025-04-15 12:58:16 +01:00
d7211e72e4 Update committers list 2025-04-11 13:23:43 -07:00
c661a1d41b Upgrade Debian/Ubuntu installation instructions
* 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-09 14:06:03 +02:00
02d4fa24cc Update to latest version of auth plugin
For some reason, downstream repos had a newer version but we forgot it
in the upstream repo.
2025-04-01 13:01:31 +02:00
2d764dbc08 Correct note on naming to match reality.
Per discussion on -core and -hackers.
2025-03-04 10:07:33 +00:00
55d5c107d4 Remove "Schemaverse" from the "Online resources" page
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-22 15:01:25 -05:00
898dbf6a08 2025-02-20 update release 2025-02-19 22:57:14 -05:00
45af503ca8 Update Code of Conduct
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-19 10:58:05 -05:00
f679398efa Remove 32-bit Windows column in Windows Download table
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-18 22:52:12 +01:00
ec7b5ae1f5 Fix typo
Spotted by Daniel Gustafsson
2025-02-18 16:19:36 +01:00
a97bc8ea1d Add a how to get involved section to developer frontpage
Much more can be done to help this page, but it's a start.

Reviewed-by: Daniel Gustafsson and Jonathan Katz
2025-02-18 16:18:37 +01:00
aebddbe97f 2025-02-13 update release 2025-02-12 21:23:03 -08:00
403be5a387 Prepare for social link updates
The full work will be handled in a subsequent patch, but for now
prepare for the update while finalizing the design.
2025-02-12 21:12:49 -08:00
aab6824999 Add PgBouncer to list of projects covered by CNA scope 2025-02-06 16:29:30 -05:00
a1ddfdd8bd List 3rd party support/help resources on the website.
As discussed at the dev meeting in Brussels in January 2025.
2025-02-06 11:17:25 +00:00
272af05a83 RHEL/Rocky/AlmaLinux supports PostgreSQL 16 as well via modules. 2025-01-30 11:00:55 +01:00
ef76cab252 Add additional Contributor Committee links
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-30 09:29:51 +01:00
a48d202a8a Add EDB as a PGCA sponsor. 2025-01-27 10:05:38 +00:00
af10fea8be Make more use of postgres as it's one of our marks. 2025-01-22 11:27:14 +00:00
7182b96342 Use correct org name. 2025-01-21 09:23:34 +00:00
44dbbc162a Add a help text indicating where the "contributions" field is used
Per discussion among moderators
2025-01-15 13:20:41 +01:00
83493b5da6 Add a page listing recognised NPOs. 2025-01-07 09:28:07 +00:00
3743bdb5d9 Update supported versions 2025-01-02 09:53:36 +00:00
8c256f890b Retire Scientific Linux 2024-12-27 20:12:03 +03:00
4e3fce6bb9 Make recent RHEL releases more prominent and remove remaining RHEL 6 stuff 2024-12-27 20:11:06 +03:00
d59ef65c63 Retire RHEL/CentOS 6 2024-12-27 20:08:12 +03:00