PostgreSQL

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 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
Scaling Ruby on Rails: Setting Up A Dedicated PostgreSQL Server (Part 3) — step-by-step Linux tutorial on Progressive Robot

Scaling Ruby on Rails: Setting Up A Dedicated PostgreSQL Server (Part 3)

In this installation of our the cloud provider Scaling-Rails series, we are going to find out how to build a PostgreSQL server from scratch to use as the database persistence layer for Ruby-on-Rails web-applications. Continuing, we are going to see how to connect our Rails application servers with the database by making the necessary configuration changes.

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
CHAT