PostgreSQL

How To Connect to a Managed Database on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Connect to a Managed Database on Ubuntu 18.04

If you’re new to working with managed databases, the best way to perform certain tasks, like connecting to the database, may not be self-evident. In this guide, we will go over how to install client programs for a variety of database management systems, including PostgreSQL, MySQL, and Redis, on an Ubuntu 18.04 server. We’ll also explain how to use these programs to connect to a managed database instance.

Read more
How To Install and Use PostgreSQL on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use PostgreSQL on Ubuntu 16.04

Relational database management systems are a key component of many web sites and applications. They provide a structured way to store, organize, and access information. PostgreSQL, or Postgres, is a relational database management system that provides an implementation…

Read more
How To Set Up Continuous Archiving and Perform Point-In-Time-Recovery with PostgreSQL 12 on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Set Up Continuous Archiving and Perform Point-In-Time-Recovery with PostgreSQL 12 on Ubuntu 20.04

One method PostgreSQL uses to maintain ACID properties is Write-Ahead Logging (WAL). For example, a secondary database cluster can use the archived WAL file for replication purposes, but you can also use the files to perform point-in-time-recovery (PITR). In this tutorial, you will set up continuous archiving with a PostgreSQL 12 cluster on Ubuntu 20.04 and perform PITR on the cluster.

Read more
How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 18.04

A PostgreSQL database is a robust and flexible choice for your Ruby on Rails application. In this tutorial, you will set up a Ruby on Rails development environment connected to a PostgreSQL database on an Ubuntu 18.04 server. You will install and configure PostgreSQL, and then test your setup by creating a Rails application that uses PostgreSQL as its database server.

Read more
CHAT