Home » Articles by: Brad Morton

How to Update PostgreSQL on Linux (Ubuntu/Debian/Arch/RedHat)

How to Update PostgreSQL

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

Home » Articles by: Brad Morton

How to Upgrade the Release of PostgreSQL (Ubuntu/Debian/Red Hat)

How to Upgrade PostgreSQL

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

Home » Articles by: Brad Morton

How to Start, Stop, and Restart PostgreSQL in Linux

Start Stop Restart PostgreSQL

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

Home » Articles by: Brad Morton

PostgreSQL – Default Password/Resetting the Default Password

PostgreSQL Default User Password Reset

This post will explain how user accounts by default work in PostgreSQL, and how you can change the default password. PostgreSQL works a bit differently to other database servers like MySQL when it comes to the default behaviour of user accounts, so read on to find out how to manage access as the default PostgreSQL admin user. PostgreSQL uses the system users The default PostgreSQL configuration uses ident for authentication – this method uses the hosts operating systems usernames and compares them against the permissions stored for each database. This means … Read more

Home » Articles by: Brad Morton

How to Switch Active Cluster / Change Port in PostgreSQL in Linux

PostgreSQL Change Active Cluster Default Port

This article will demonstrate how to list the PostgreSQL clusters on your Linux system, and how to switch the active cluster. PostgreSQL is one of the most popular relation database servers. Multiple versions can be installed on the same host, so being able to switch between them is pretty useful. Read on to find out how to do it. What is a Cluster A PostgreSQL cluster is a collection of PostgreSQL databases with a shared configuration, managed. This configuration includes things like the executable that manages the … Read more

Home » Articles by: Brad Morton

How to Build a Raspberry Pi Internet Kiosk

Raspberry Pi Internet Kiosk

This tutorial will show you how to build an internet kiosk using a Raspberry Pi and FullPageOS. It can also be used as digital signage! Internet kiosks are useful when you want to allow your customers or visitors to be able to use the internet – to browse a catalogue or access services – but want to limit them to the web browser only, and make sure that they can only use the websites you deem necessary (or appropriate). FullPageOS provides this functionality for free … Read more

Home » Articles by: Brad Morton

Checking for Equality (And Inequality) in JavaScript, with Examples

Equality and Inequality JavaScript

This article will explain equality and inequality in the JavaScript Programming language, and provide code examples showing how to check if values are equal in value and type. Checking whether two values are equal can get a bit confusing in JavaScript – there is loose equality and strict equality involving types to consider. Read on to find out how testing for equality and inequality works in JavaScript. What are equality and inequality? In programming, equality is the process of checking whether two values are equal … Read more

Home » Articles by: Brad Morton

How to Export and Back Up PostgreSQL Databases

PostgreSQL Backup Import Export

This tutorial will show you how to export, import, and back up your PostgreSQL clusters and databases. You should regularly back up. It’s one of the most important things you can do as a sysadmin, developer, and even a hobbyist. Losing your data is detrimental to business, and your projects. Losing your family photos sucks too. This article demonstrates the various way to import and export PostgreSQL data so that it can be backed up. This process should be done regularly (or automated!), and performed … Read more

Home » Articles by: Brad Morton

How to Import a CSV File to PostgreSQL

PostgreSQL Import CSV File

This tutorial will show you how to import data from a CSV file into a PostgreSQL database table. What is a CSV File A CSV (Comma Separated Values) file is a text file that contains tabulated information. The rows in this data each take up a line in the text file, while the values in each column on each row are separated by a comma – hence, comma-separated. CSV files are versatile. Because the data within is stored as plain text, they can be opened … Read more

Home » Articles by: Brad Morton

Bash Split String (+ Shell Scripts)

Bash Split String

This article will show you how to split a string at a given delimiter in Bash/Shell scripts and show some examples. Splitting strings is a handy function to have available when crafting your scripts. CSV (Comma Separated Values) is a common format in which data is made available online, where data fields in a table are separated by (surprise) commas. You may also simply be looking to split a sentence into words at the spaces, or split paragraphs into sentences at the period, and so … Read more