A deep dive look at Azure Database for PostgreSQL. What it is and how it works!
๐ Looking for content on a particular topic? Search the channel. If I have something it will be there!
๐ค Due to the channel growth and number of people wanting help I no longer can answer or even read questions and they will just stay in the moderation queue never to be seen so please post questions to other sites like Reddit, Microsoft Community Hub etc.
โฌโฌโฌโฌโฌโฌ C H A P T E R S โฐ โฌโฌโฌโฌโฌโฌ
00:00 – Introduction
00:21 – What is PostgreSQL
03:32 – Why PostgreSQL
03:51 – Azure offerings for PostgreSQL
05:42 – Primary instance
07:27 – Parameters to tweak
08:56 – VM SKU
13:02 – Disk configuration
15:02 – AZ configuration
15:24 – PostgreSQL version
15:59 – Authentication options
17:52 – Networking
19:28 – Encryption
21:37 – High availability
25:50 – DNS name for connections
28:34 – PGBouncer and connection pooling
30:42 – Read replicas
37:08 – Virtual endpoints
39:20 – Maintenance
39:34 – Auto minor version upgrade
40:27 – Maintenance window
44:12 – Major version upgrades
46:45 – Backups
49:43 – Azure Backup
50:50 – Pricing
52:25 – Citus and elastic cluster
53:18 – Summary
54:55 – Close
โฌโฌโฌโฌโฌโฌ K E Y L I N K S ๐ โฌโฌโฌโฌโฌโฌ
โบ Whiteboard:
๐ https://github.com/johnthebrit/RandomStuff/raw/master/Whiteboards/PostgreSQLDeepDive.png
โบ MS PostgreSQL blog:
๐ https://techcommunity.microsoft.com/category/azuredatabases/blog/adforpostgresql
โบ MS Docs:
๐ https://learn.microsoft.com/azure/postgresql/
โฌโฌโฌโฌโฌโฌ Want to learn more? ๐ โฌโฌโฌโฌโฌโฌ
๐ Recommended Learning Path for Azure
๐ https://learn.onboardtoazure.com
๐ฅ Certification Content Repository
๐ https://github.com/johnthebrit/CertificationMaterials
๐
Weekly Azure Update
๐ https://youtube.com/playlist?list=PLlVtbbG169nEv7jSfOVmQGRp9wAoAM0Ks
โ Azure Master Class
๐ https://youtube.com/playlist?list=PLlVtbbG169nGccbp8VSpAozu3w9xSQJoY
โ DevOps Master Class
๐ https://youtube.com/playlist?list=PLlVtbbG169nFr8RzQ4GIxUEznpNR53ERq
๐ป PowerShell Master Class
๐ https://youtube.com/playlist?list=PLlVtbbG169nFq_hR7FcMYg32xsSAObuq8
๐ Certification Cram Videos
๐ https://youtube.com/playlist?list=PLlVtbbG169nHz2qfLvPsAz9CnnXofhmcA
๐ง Mentoring Content
๐ https://youtube.com/playlist?list=PLlVtbbG169nGHxNkSWB0PjzZHwZ0BkXZZ
โ Questions? Maybe I answered it in my FAQ
๐ https://savilltech.com/faq
๐ Cure Childhood Cancer Charity T-Shirt Channel Store
๐ https://johns-t-shirts-store.creator-spring.com/
๐ Enable the subtitles and from there you can translate to your native language via the auto-translate feature in settings! https://youtu.be/v5b53-PgEmI for a demo of using this feature.
SUBSCRIBE โ https://www.youtube.com/channel/UCpIn7ox7j7bH_OFj7tYouOQ?sub_confirmation=1
#microsoft #azure #postgresql #johnsavillstechnicaltraining #onboardtoazure
