Collation Issues, Fast Loading, Recovery, SCRAM Authentication | Scaling Postgres 72
In this episode of Scaling Postgres, we discuss collation issues, how to load data quickly, recovery changes in Postgres 12 and moving to SCRAM authentication.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.cybertec-postgresql.com/en/icu-collations-against-glibc-2-28-data-corruption/
https://postgresql.verite.pro/blog/2018/08/27/glibc-upgrade.html
https://hakibenita.com/fast-load-data-python-postgresql
https://www.scalingpostgres.com/tutorials/fast-postgresql-data-loading-using-ruby/
https://winand.at/newsletter/2019-07/sql-standard-extensions-and-cloud-war
https://fluca1978.github.io/2019/07/08/PostgreSQL12Recovery.html
https://info.crunchydata.com/blog/how-to-upgrade-postgresql-passwords-to-scram
https://www.youtube.com/channel/UCAJ1P67u3qQyLpLm5bvPNPw/videos
https://www.cybertec-postgresql.com/en/implementing-autonomous-transactions-in-postgres/
https://www.postgresql.org/docs/current/libpq-notify.html
https://medium.com/engineered-publicis-sapient/the-database-deficit-how-full-stack-developers-blind-spot-harms-agile-teams-7a1647ac10ea
https://www.percona.com/blog/2019/07/10/wal-retention-and-clean-up-pg_archivecleanup/
https://fluca1978.github.io/2019/07/09/GeneratePrimaryKeys.html
https://info.crunchydata.com/blog/dynamic-vector-tiles-from-postgis
Create your
podcast in
minutes
It is Free