Databases

This article will instruct you how to install the PostgreSQL database server on Linux – Red Hat/Fedora, Ubuntu, Debian, and Arch Linux. Installing PostgreSQL on Debian Linux Here’s now to install PostgreSQL on the Debian Linux distribution (and distributions based on it): From the Default apt Repository You can install PostgreSQL server straight by the apt software repository on Debian Linux by running: Note the use of the sudo command to run the package installation as the root (administrative) user. Installing More Recent Versions From the PostgreSQL apt … Read more

This article will explain the differences between PostgreSQL and Oracle Database, and help you to decide which you should use in your project (The answer is PostgreSQL). Choosing the right database for your application, whether it’s a webapp, mobile app, or desktop application is vital. Changing database backend mid-development could be a costly (in both your time or money) and frustrating experience. Trying to decide between other databases like MySQL, MariaDB, MongoDB, SQLite and MSSQL? Check out our other guide here. Oracle Database Oracle Database, otherwise … Read more

This article will show you how to check the version (or versions) of PostgreSQL running on your Linux system. As it is possible to install multiple versions of PostgreSQL on the same machine, there are a few ways to check the running version, which are detailed below. Checking PostgreSQL Server Version To check the running PostgreSQL server version, use the following pg_config command: Check PostgreSQL Client Version To check which version of the PostgreSQL client you are running, run the following psql command: Finding the PostgreSQL Executables If you … Read more

This short tutorial will demonstrate how to test the connection to a PostgreSQL database locally and remotely from Linux. This article is part of our series on getting started with PostgreSQL, head back to our index that lists our full PostgreSQL guide. Testing PostgreSQL Database Connection on Ubuntu/Debian To test connectivity to a PostgreSQL server, you’ll need the PostgreSQL client installed if it is not already. Do this by running: Then, you can use the pg_isready command to test the connection to a database: One of the following … Read more

A common question is whether PostgreSQL is an SQL or NoSQL database (it’s not) – this article explains why. What is SQL SQL (pronounced sequel or S-Q-L) is the Structured Query Language – a language used by many relational database systems for querying data. It is also increasingly being used for defining data schemas in data analytics applications where the data is not stored in a database but is arriving as a data stream. Data defined and queried by SQL is structured tables that can have relationships between records – for example … Read more

PostgreSQL is one of the most popular database systems in use today. GUIs make working with data in PostgreSQL simpler for beginners – here are the best free GUIs you can use on Linux in 2022. What is PostgreSQL PostgreSQL is an object-relational database management system (ORDBMS) for storing structured data. It provides a networked database server that can be used as the backend for your mobile apps, APIs, and webapps. It is also used for storing data for processing in analytics and data science. It’s free to … Read more

This tutorial will show you how to check that the PostgreSQL Server service is running on your Linux system. To install PostgreSQL follow our tutorial here. Checking PostgreSQL is Running on Ubuntu/Debian To check whether the PostgreSQL server service is running successfully on your Debian or Ubuntu system, run: Checking the Firewall By default PostgreSQL runs on port 5432 and is not restricted by host name. When installing PostgreSQL on Ubuntu, usually a firewall rule will be created automatically allowing access to the database server. You can confirm … Read more

This article will instruct you how to update the PostgreSQL database server on Linux – Redhat, Ubuntu, Debian, and Arch Linux. If you’re looking to install PostgreSQL server on your Linux system, follow our instructions here. Take Care, and Back Up! Note that this article is about updating the PostgreSQL package from your software repository. This will not upgrade to the next major release. Before you do update, however check which version will be installed and ensure it is compatible with the software you are connecting to the database. … Read more

This article will show you how to safely upgrade the PostgreSQL database server to the latest version on your Linux system. First, Back Up Your Databases! Before making any changes to your system, you should perform a full backup – that way if something goes wrong, you can roll back to a working version quickly. At the very least, make sure that you’ve backed up your PostgreSQL Databases to protect from data loss. What is a Major/Minor Release? A major release is an update that greatly changes the functionality or … Read more

This short tutorial will show you how to start, stop, and restart PostgreSQL servers on your Linux system. PostgreSQL is a flexible database system that allows you to run multiple versions of the server software on the same host. This can get a bit confusing, but thankfully PostgreSQL includes all of the tools you need to make sense of things and control each server individually. How to Start PostgreSQL Service/Server To start the default or primary PostgreSQL server on your system, simply run the following … Read more