PostgreSQL

24 Guides Available

PostgreSQL is an open-source relational database management system known for high performance and standards compliance, which is easy to install on a Linode.


PostgreSQL Guides

Sort PostgreSQL Guides
Article thumbnail

A Comparison of High Availability PostgreSQL Solutions

This guide describes the high availability and resiliency options for PostgreSQL, with a survey of the three most common replication managers.

Article thumbnail

Manage Replication and Failover on a PostgreSQL Cluster Using repmgr

This guide explains how to configure a two-node PostgreSQL cluster using the repmgr replication manager.

Article thumbnail

What is PostgreSQL?

This guide introduces the PostgreSQL database, outlining how it is different from other SQL databases like MySQL, and describes its benefits along with possible …

Article thumbnail

Installing and Using PostgreSQL on Ubuntu 20.04

This guide provides an introduction to PostgreSQL, an open source object-relational database management system (ORDBMS).

Article thumbnail

Install and Use PostgreSQL on CentOS 8

This guide provides an introduction to installing PostgreSQL, an open source object-Relational Database Management System (RDBMS) on CentOS 8.

Article thumbnail

Back up a PostgreSQL Database with pg_dump

Learn how to back up your PostgreSQL database with this guide for single database, multiple databases, and automated backups. ✓ Click & read!

Article thumbnail

Configure PostgreSQL

This guide will show you how to tune PostgreSQL for better performance on your Linode

Article thumbnail

Create a Highly Available PostgreSQL Cluster Using Patroni and HAProxy

This guide shows you how to set up a highly available PostgreSQL cluster using Patroni and HA Proxy on your Linode.

Article thumbnail

How to Install PostgreSQL Relational Databases on CentOS 7

The PostgreSQL relational database is a powerful open source database platform. Learn how to install it on CentOS 7 in this simple tutorial.

Article thumbnail

Installing PostgreSQL on Ubuntu 16.04

A tutorial on installing and configuring the PostgreSQL relational database system on Ubuntu distributions using Ubuntu 16.04 as an example.

Deprecated
Article thumbnail

Use PostgreSQL Relational Databases on Ubuntu 12.04

Using the PostgreSQL relational database server with Ubuntu 12.04 LTS (Precise Pangolin).

Deprecated
Article thumbnail

Use PostgreSQL Relational Databases on Debian 6

Use the PostgreSQL relational database server with Debian 6 (Squeeze).

Deprecated
Article thumbnail

Use PostgreSQL Relational Databases on Fedora 14

Using the PostgreSQL relational database server with Fedora 14.

Deprecated
Article thumbnail

Use PostgreSQL Relational Databases on Ubuntu 10.10

Using the PostgreSQL relational database server with Ubuntu 10.10 (Maverick).

Deprecated
Article thumbnail

Use PostgreSQL Relational Databases on Fedora 13

Using the PostgreSQL relational database server with Fedora 13.

Deprecated
Article thumbnail

Securely Manage Remote PostgreSQL Servers with pgAdmin on Mac OS X

Use the Open-source PgAdmin Program to Securely Manage Remote PostgreSQL Databases from a Mac OS X Workstation.

Article thumbnail

Use PostgreSQL Relational Databases on Ubuntu 10.04 LTS (Lucid)

Using the PostgreSQL relational database server with Ubuntu 10.04 LTS (Lucid).

Deprecated
Article thumbnail

Access PostgreSQL Database Remotely Using pgAdmin on Windows

Use the open-source pgAdmin program to securely manage remote PostgreSQL databases from a Windows workstation.

Article thumbnail

Use PostgreSQL Relational Databases on Ubuntu 9.10 (Karmic)

Using the PostgreSQL relational database server with Ubuntu 9.10 (Karmic).

Deprecated
Article thumbnail

Use PostgreSQL Relational Databases on CentOS 5

This guide provides you with step-by-step instructions for installing and configuring the PostgreSQL relational database server, on CentOS 5.

Deprecated