Postgres Tutorials

EDB Tutorial: Achieving High Availability Using Enterprise Failover Manager

Enterprise Failover Manager (EFM) is a tool for managing Postgres database clusters, enabling high availability of primary-standby deployment architectures using streaming replication. Failover Manager provides a Postgres primary database node...

April 18, 2023

EDB Tutorial: How to Backup Your PostgreSQL to Azure Blob Storage with Barman

This tutorial is designed to guide you through how to setup a Barman backup to Azure Blob Storage for a PostgreSQL instance and store it in the cloud, using barman-cloud-backup...

April 12, 2023

Using Foreign Data Wrappers to access remote PostgreSQL and Oracle databases

This article explains how to use Foreign Data Wrappers to access data in remote PostgreSQL and Oracle databases.

January 24, 2023

An Overview of PostgreSQL Indexes

This article describes indexes in PostgreSQL and how they can help retrieve data faster.

January 24, 2023

How to run hierarchical queries in Oracle and PostgreSQL

This article introduces hierarchical queries and shows the differences in their usage between Oracle and PostgreSQL.

January 24, 2023

How to use block structure to write anonymous blocks and divide larger blocks into logical subblocks

This article discusses block structure in PostgreSQL, how to write an anonymous block, and how to divide a larger block into logical subblocks.

January 24, 2023

Postgres AT TIME ZONE Explained

I saw AT TIME ZONE used in a query, and found it confusing. I read the Postgres documentation and was still confused, so I played with some queries and finally...

January 24, 2023

PostgreSQL and Golang Tutorial

How to use PostgreSQL with Golang: This article covers how to use PostgreSQL together with the programming language Golang (Go). After showing how to get started with Go’s Object Relational...

January 24, 2023

How to sort rows using ORDER BY and SELECT in PostgreSQL: 6 Examples

This article reviews five ways to sort table data using the ORDER BY clause together with the SELECT statement in PostgreSQL.

January 24, 2023

How to implement repmgr for PostgreSQL automatic failover

This article discusses the open source tool repmgr (Replication Manager) and how to set up and configure it for automatic failover in PostgreSQL.

January 24, 2023

Subscribe to Postgres Tutorials

Resource Feature Callout 1