Get help with PostgreSQL database backups, installations and troubleshooting. AGIX staff have the know-how and experience to help your organisation with PostgreSQL using best-practices, current methods, on-premise and in various Cloud environments including Amazon AWS.

This page shows examples of our work that AGIX shares freely with you. For a fully supported compute environment, contact our team to find out how we can help your organization move forward in the right way.

Contact our friendly team to get started.

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 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: http://www.davidghedini.com/pg/entry/installing_postgresql_9_on_cpanel By setting that file to your liking such as the following: local all all md5 host

Read more