In this episode of Scaling Postgres, we discuss tips for using psql, stories from a Postgres 13 upgrade, exploring the role hierarchy and replica scaling considerations.

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

Links for this episode:

https://mydbanotebook.org/psql_tips_all.html

https://blog.discourse.org/2021/04/standing-on-the-shoulders-of-a-giant-elephant/

https://www.cybertec-postgresql.com/en/postgresql-get-member-roles-and-permissions/

https://momjian.us/main/blogs/pgblog/2021.html#April_9_2021

https://www.migops.com/blog/2021/04/09/pgbackrest-the-best-postgres-backup-tool-with-a-very-active-community/

https://blog.crunchydata.com/blog/announcing-google-cloud-storage-gcs-support-for-pgbackrest

https://blog.crunchydata.com/blog/introducing-pgbackrest-multiple-repository-support

https://digitalis.io/blog/postgresql/part1-postgresql-ha-patroni-etcd-haproxy/

https://digitalis.io/blog/postgresql/deploying-postgresql-for-high-availability-with-patroni-etcd-and-haproxy-part-2/

https://www.highgo.ca/2021/04/09/how-to-run-hierarchical-queries-with-postgresql/

https://www.cybertec-postgresql.com/en/getting-started-qgis-postgresql-postgis/