Security and compliance
Ensure data security and compliance with monitoring and change traceability
Accidental PostgreSQL DBA
Resources to help you get up to speed with PostgreSQL.
Many people managing PostgreSQL didn't plan to be managing PostgreSQL. It usually starts with one database, one project, and an assumption that someone else will handle the hard parts. Then it becomes your problem: monitoring, schema changes, migrations, version control - without a clear direction. These resources have been created as your PostgreSQL starting point.
PostgreSQL 101 Webinar Series
Join our webinar series, which follows Developer Advocates, Ryan Booz and Grant Fritchey, as they guide you through the what, how and why of the database system, breaking down key topics into easy-to-follow sessions. It’s PostgreSQL, simplified.
On-demand webinar
PostgreSQL 101: Stored Procedures / Functions
The features available within SQL Server and PostgreSQL for functions and procedures are different in some surprising ways. Join Grant Fritchey and Ryan Booz in this on-demand webinar as they uncover the secrets behind stored procedures and functions between the two database platforms and share how to most effectively use them.
On-demand webinar
PostgreSQL 101: Data Types
While there are common data types used across all database platforms, there are a few differences to be aware of to successfully operate in PostgreSQL. Join Ryan Booz for this webinar on the key differences between data types in SQL Server versus PostgreSQL, and best practices in picking PostgreSQL data types.
On-demand webinar
PostgreSQL 101: Indexing
Efficient and high-quality data retrieval is critical to saving time in your day-to-day tasks. Join our in-house expert, Ryan Booz, for a dive into the tips and tricks of indexing in this increasingly popular database platform. Ryan covers the 6 primary index types along with best practices for the most common.
Introduction to PostgreSQL Book
If you've spent years working with SQL Server, PostgreSQL can feel disorienting at first. The concepts are familiar, but the terminology shifts, the tooling is different, and the documentation assumes you're starting from scratch.
This book meets you where you are. It's written for people who already understand relational databases and data management, but need a practical guide to how PostgreSQL does things differently. From spinning up your first instance to backups, server configuration, and monitoring, it maps the fundamentals of Postgres onto knowledge you already have, so you can get productive quickly rather than starting over.
Get your free copy
Learning PostgreSQL with Grant Fritchey
Learn from Grant Fritchey’s triumphs and mistakes as he takes his vast knowledge of SQL Server and applies it to learning PostgreSQL.
How User-Defined Types work in PostgreSQL: a complete guide
Learn PostgreSQL User-Defined Types (UDTs) with clear examples of DOMAIN, COMPOSITE, ENUM, and RANGE types, plus practical SQL code for... Read more
Learning PostgreSQL with Grant: Data Storage
Learn how PostgreSQL stores data on disk, including page architecture, TOAST storage, file structure, tablespaces, and I/O performance optimization strategies... Read more
Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant
It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping... Read more
PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant
The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after... Read more
