PostgreSQL

How to install PostgreSQL on Ubuntu

How to install PostgreSQL on Ubuntu

The object-relational database management system PostgreSQL is one of the most popular open source solutions for servers. You can also install PostgreSQL on Ubuntu 20.04. This is very simple to do. Read on to find out how to install PostgreSQL on Ubuntu and create a new database.…

Read more
PostgreSQL vs. MySQL

PostgreSQL vs. MySQL

Many web developers will already be familiar with MySQL as a relational database management system (RDBMS). Those managing more professional projects may be aware of its powerful competitor PostgreSQL. But did you know the latter is an object-relational database management system…

Read more
Use PostgreSQL with Ruby on Rails on Ubuntu

Use PostgreSQL with Ruby on Rails on Ubuntu

Learn how to use PostgreSQL with your Ruby on Rails application, instead of the default SQLite database. SQLite is an easy-to-configure, lightweight product which ships with Ruby on Rails by default. However, PostgreSQL is a more robust solution which provides more advanced…

Read more
PostgreSQL ‘Could not connect to server’ Error: How to troubleshoot

PostgreSQL ‘Could not connect to server’ Error: How to troubleshoot

One of the most common errors that occur when using PostgreSQL is the ‘Could not connect to server’ error that results in a refused connection. Usually, the error can be fixed by taking just a few simple steps. In this article, we will show you how to fix a PostgreSQL that cannot…

Read more
PostgreSQL backup with pg_dump and pg_restore

PostgreSQL backup with pg_dump and pg_restore

Creating database backups is one of the standard tasks of web and system admins. Each database management system comes with its own tools for creating backups. PostgreSQL has the command line programs pg_dump and pg_restore. The command line interface psql is also used. We’ll…

Read more
Page top