8000 Supabase Postgres 14.1.0 by dragarcia · Pull Request #98 · supabase/postgres · GitHub
[go: up one dir, main page]
Skip to content

Supabase Postgres 14.1.0 #98

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.

Sign up for GitHub

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

Merged
merged 33 commits into from
Dec 2, 2021
Merged

Supabase Postgres 14.1.0 #98

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
33 commits
Select commit Hold shift + click to select a range
168be1b
chore: bump postgres and pgbouncer
dragarcia Aug 17, 2021
e1611f6
chore: #65 sha-scram-256 encryption
dragarcia Aug 17, 2021
1170658
Merge branch 'develop' of github.com:supabase/postgres into feature/1…
dragarcia Nov 10, 2021
9461f36
chore: Bump to Postgres 14.0
dragarcia Nov 10, 2021
d8fae0f
chore: bump up existing extensions
dragarcia Nov 10, 2021
931e55b
Use PG 14 version of postgresql.conf
dragarcia Nov 15, 2021
6e04163
move up running of SQL files
dragarcia Nov 18, 2021
9bc3cd6
new extensions:
dragarcia Nov 18, 2021
25c93de
Cleanup build dependencies immediately after installation
dragarcia Nov 18, 2021
bd8258b
Remove hardcoded values for Postgres major
dragarcia Nov 18, 2021
8794e9f
Update variables
dragarcia Nov 18, 2021
a21dd05
Update wal-g installation process
dragarcia Nov 18, 2021
ec84a58
add build dependencies for supautils
dragarcia Nov 18, 2021
43a1a11
changes to pgbouncer config
dragarcia Nov 18, 2021
adcbfb6
Revert "Cleanup build dependencies immediately after installation"
dragarcia Nov 19, 2021
9b82e06
Minimise packages cleaned up
dragarcia Nov 19, 2021
e2aab01
link pg binaries only at the end
dragarcia Nov 19, 2021
cf0f434
remove postgres as pgbouncer stats_users
dragarcia Nov 19, 2021
60a6fdd
bump to Postgres 14.1
dragarcia Nov 19, 2021
9855e38
Merge branch 'develop' of github.com:supabase/postgres into feature/1…
dragarcia Nov 21, 2021
1cf9351
rename filename for pgsodium
dragarcia Nov 21, 2021
c98446c
update regex for session_preload_libraries
dragarcia Nov 22, 2021
9feea21
Update README
dragarcia Nov 22, 2021
33d7500
update download URLs for postgrest
dragarcia Nov 22, 2021
5bf900b
Bump versions
dragarcia Nov 22, 2021
ceae008
feat: build AMIs using Github Actions (#101)
darora Nov 22, 2021
ccd7a81
Transfer ownership of pgbouncer process to pgbouncer user
dragarcia Nov 22, 2021
1a3d08c
Merge branch 'feature/14.0.0' of github.com:supabase/postgres into fe…
dragarcia Nov 22, 2021
012c9df
Merge branch 'develop' of github.com:supabase/postgres into feature/1…
dragarcia Nov 22, 2021
6f615a1
increased timeout for get_url
dragarcia Nov 25, 2021
3c0201a
further hardening of pgbouncer
dragarcia Nov 25, 2021
8584437
bump common.vars.json
dragarcia Nov 25, 2021
fcb9727
Enhancements to docker images (#108)
dragarcia Nov 29, 2021
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
chore: #65 sha-scram-256 encryption
  • Loading branch information
@dragarcia
dragarcia committed Aug 17, 2021
commit e1611f690ab03a85a63b662f63115c396848f6cd
2 changes: 1 addition & 1 deletion ansible/files/pgbouncer_config/pgbouncer.ini.j2
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -113,7 +113,7 @@ unix_socket_dir = /tmp
;;;

;; any, trust, plain, md5, cert, hba, pam
auth_type = md5
auth_type = scram-sha-256
auth_file = /etc/pgbouncer/userlist.txt

;; Path to HBA-style auth config
Expand Down
4 changes: 2 additions & 2 deletions ansible/files/postgresql_config/pg_hba.conf.j2
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -84,11 +84,11 @@ local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 md5
host all all ::1/128 scram-sha-256
# Local root Unix user, passwordless access
local all postgres peer map=root_as_postgres
# IPv4 external connections
host all all 0.0.0.0/0 md5
host all all 0.0.0.0/0 scram-sha-256

# MD5 hashed password hosts

Expand Down
2 changes: 1 addition & 1 deletion ansible/files/postgresql_config/postgresql.conf.j2
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -92,7 +92,7 @@ listen_addresses = '*' # what IP address(es) to listen on;
# - Authentication -

authentication_timeout = 1min # 1s-600s
password_encryption = md5 # scram-sha-256 or md5
password_encryption = scram-sha-256 # scram-sha-256 or md5
db_user_namespace = off

# GSSAPI using Kerberos
Expand Down
0