PostgreSQL

Which database is best? MongoDB vs. PostgreSQL

Which database is best? MongoDB vs. PostgreSQL

While more and more companies are beginning to rely on so-called NoSQL databases, there are still countless reasons why the traditional relational approach might be the better option for you. Ultimately, it always depends on what you’re using it for. We’ve looked at two of the…

Read more
What are the top 5 PostgreSQL alternatives?REDPIXEL.PLShutterstock

What are the top 5 PostgreSQL alternatives?

While PostgreSQL offers robustness and security, if you’re looking for speed or a non-relational approach, alternative solutions are worth considering. We’ll explore alternatives to PostgreSQL and outline their benefits so you can find the one that is ideal for your project and…

Read more
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
How to Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 16.04

How to Use PostgreSQL with Your Ruby on Rails Application on Ubuntu 16.04

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 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
Install PostgreSQL on Windows Server 2016sdecoretShutterstock

Install PostgreSQL on Windows Server 2016

PostgreSQL is an open source object-relational database system with over 15 years of active development and a reputation for reliability. Learn how to install PostgreSQL on Windows Server 2016.

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
We use cookies on our website to provide you with the best possible user experience. By continuing to use our website or services, you agree to their use. More Information.
Page top