Browse our PostgreSQL Database articles here. We’ve documented and provided tutorials on installing, managing, backing up, restoring and performance tuning databases.

All HowTo's Linux PostgreSQL Ubuntu, Mint & Debian Linux

Install PostgreSQL, Create a User/Role, Create a DB, Backup a DB, and Restore a DB

This article walks you through the process of installing PostgreSQL, creating a user, backing up a database and restoring a database. In this tutorial, we’re using Ubuntu, but the commands are the same for everything except the installation. Install PostgreSQL on Ubuntu: apt install postgresql postgresql-contrib systemctl start postgresql ufw

Read more
All HowTo's Cybersecurity Linux PostgreSQL Redhat, Fedora and CentOS Linux Ubuntu, Mint & Debian Linux Web Servers

Configure Metasploit with NMap and the Database – Advanced

This article walks you through the process of installing, configuring and running scans using Metasploit and Nmap. Both CentOS 7 and Ubuntu 20.04 are discussed. Our objective is to be able to run nmap scans and have the results go into a database so we can filter the results later

Read more
AGIX Discussion All HowTo's Linux MySQL & MariaDB PostgreSQL Redhat, Fedora and CentOS Linux Ubuntu, Mint & Debian Linux Web Servers

Installing Confluence & Migrating the Database to MySQL or PostgreSQL

This article explains the process of installing Confluence on your own server and then later migrating your content and settings from the “evaluation” database to something more professional such as MySQL or PostgreSQL. This article is basically an example with sensible assumptions. We’re using CentOS 7. When you first get

Read more
All HowTo's Linux PostgreSQL Redhat, Fedora and CentOS Linux

Preparing PostgreSQL for Confluence on CentOS 7

This article explains how to install and configure PostgreSQL for a Confluence on a CentOS 7 server.  Read the other Confluence articles on this blog to ensure your web server (if you’re using one) is configured correctly. yum install postgresql-server postgresql-contrib Next you’ll need to do the automatic setup: postgresql-setup

Read more
All HowTo's PostgreSQL

cPanel overwriting my pg_hba.conf file

This article describes and solves (work-around) a problems with PostgreSQL and cPanel. The issue is that cPanel modifies the file “/var/lib/pgsql/9.4/data/pg_hba.conf” setting it back to a default state. This article has more information: By setting that file to your liking such as the following: local all all md5 host

Read more