PostgreSQL

Containerizing a Ruby on Rails Application for Development with Docker Compose — step-by-step Docker tutorial on Progressive Robot

Containerizing a Ruby on Rails Application for Development with Docker Compose

If you are actively developing an application, using Docker can simplify your workflow and the process of deploying your application to production. This tutorial will show you how to set up a development environment for a Ruby on Rails application using Docker. You will create multiple containers – for the application itself, the PostgreSQL database, Redis, and a Sidekiq service – with Docker Compose.

Read more
How To Choose a Redundancy Plan To Ensure High Availability — step-by-step Databases tutorial on Progressive Robot

How To Choose a Redundancy Plan To Ensure High Availability

Redundancy is a way of reducing the impact of system failures by configuring multiple avenues to achieve the objective. If a disk, a computer, or an entire portion of the network becomes unavailable for some reason, various forms of redundancy can help mitigate the impact on your currently running systems. This will allow you to address the issue without experiencing downtime.

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

How To Install and Use PostgreSQL on Ubuntu 22.04

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. This guide demonstrates how to install Postgres on an Ubuntu 22.04 server. It also provides instructions for general database administration.

Read more
How To Migrate a MySQL Database to PostgreSQL Using pgLoader — step-by-step Linux tutorial on Progressive Robot

How To Migrate a MySQL Database to PostgreSQL Using pgLoader

The prospect of migrating a database can be intimidating, especially when migrating from one database management system to another. This tutorial provides instructions on how to install pgLoader, an open-source database migration tool, and use it to migrate a remote MySQL database to PostgreSQL over an SSL connection.

Read more
How To Set Up Master Slave Replication on PostgreSQL on an Ubuntu 12.04 VPS — step-by-step Linux tutorial on Progressive Robot

How To Set Up Master Slave Replication on PostgreSQL on an Ubuntu 12.04 VPS

PostgreSQL, or postgres, is a popular database management system often used to manage the information from websites and applications. In this guide, we will configure a master server postgres replication set up, which will allow us to replicate the changes from the master server onto the slave. This can be used to distribute reads to multiple machines.

Read more
How To Use PostgreSQL with Your Ruby on Rails Application on macOS — step-by-step Databases tutorial on Progressive Robot

How To Use PostgreSQL with Your Ruby on Rails Application on macOS

When using the Ruby on Rails web framework, the PostgreSQL database could be a robust and flexible choice for your application. In this tutorial, you will set up a Ruby on Rails development environment connected to a PostgreSQL database on a local macOS machine. 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