How to Execute Queries from SQL files in PostgreSQL using psql
This blog is about what SQL files are and how they can be used to execute queries on PostgreSQL databases using psql...
The Beginner’s Guide to PostgreSQL Database Security Hardening
PostgreSQL offers robust security features and ensures that a user’s database is protected from all angles.
Understanding the CREATEROLE Privilege in PostgreSQL
This blog is about the CREATEROLE privilege and the new enhancements in PostgreSQL 16, part of the fine access controls for database security
PostgreSQL Physical Backups Using pg_basebackup: A Comprehensive Guide
Best practices for PostgreSQL backup & recovery, explanation of RTO & RPO, and FAQs related to physical database backups and their business case.
A look at PostgreSQL’s journey over 5 years in Stack Overflow’s Developer Survey
A look at 5 year trends of database popularity, focusing on PostgreSQL, based on Stack Overflow's annual developer survey