In this episode of Scaling Postgres, we discuss the PG15 changes to public schema permissions, experiences with kubernetes for Postgres management, using dump manifests for restores and a fork of PgBouncer.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

• https://andreas.scherbaum.la/blog/archives/1120-Changes-to-the-public-schema-in-PostgreSQL-15-and-how-to-handle-upgrades.html
• https://proopensource.it/blog/postgresql-on-k8s-experiences
• https://pganalyze.com/blog/5mins-postgres-kubernetes-operator-handling-major-version-upgrades
• https://www.percona.com/blog/working-with-postgresql-dump-manifests/
• https://blog.cloudflare.com/open-sourcing-our-fork-of-pgbouncer/
• https://www.postgresql.fastware.com/blog/how-postgresql-15-improved-communication-in-logical-replication
• https://www.depesz.com/2022/09/02/sql-json-is-postponed/
• https://www.cybertec-postgresql.com/en/postgresql-alter-table-add-column-done-right/
• https://www.crunchydata.com/blog/postgres-migration-pitstop-collations
• https://www.timescale.com/blog/timescale-cloud-tips/
• https://sqlfordevs.com/statistical-results-fill-gaps
• https://www.depesz.com/2022/08/31/new-sql-pretty-printer-based-on-parsing-and-not-regexps/
• https://postgres.fm/episodes/intro-to-query-optimization
• https://postgresql.life/post/douglas_hunley/
• https://www.rubberduckdevshow.com/episodes/57-going-off-the-rails-with-drew-bragg/