Installing postgres (PostgreSQL) database on Ubuntu 22

Installation:

sudo apt update
sudo apt upgrade
sudo apt install postgresql postgresql-contrib postgresql-client-common

Start PostgreSQL service:

sudo systemctl start postgresql.service

Setup

Switch to postgres account; the installation of PostgreSQL automatically created a user account named “postgres”. Switch to this account for accessing the PostgreSQL database:

sudo -i -u postgres

Create new role

createuser --interactive

Create database

createdb exampledatabasename

Create a new Linux user

sudo adduser exampleusername

Switch to your user

sudo -i -u exampleusername

Connect to database

psql

Check connection information

\conninfo

Distilled from How to Install and Set up PostgreSQL Database on Ubuntu 22.04 on Linux Hint. For more details:
https://linuxhint.com/install-and-setup-postgresql-database-ubuntu-22-04/

PostgreSQL/postgres cheat-sheet: postgres-cheatsheet.md
https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546

Installing PHP extension imagick manually because it’s missing in cPanel/WHM EasyApache 4

We needed imagemagick installed on our server for nextCloud, but imagick is missing/unavailable in EasyApache 4.

Fortunately, we found the following instructions, which worked perfectly for us on our cPanel/WHM server for PHP versions 7.4, 8.0, and 8.1…

Original source:
https://help.bigscoots.com/en/articles/730428-cpanel-easyapache-4-installing-imagemagick-and-imagick-php-extension

Originally written by Justin Catello

This is fairly simple, just copy and paste the following into SSH.

1. Installing imagemagick:

yum -y install ImageMagick-devel ImageMagick-c++-devel ImageMagick-perl

2. Installing the imagemagick PHP extensions for all installed PHP versions.

for phpver in $(whmapi1 php_get_installed_versions|grep -oE '\bea-php.*') ; do
printf "\autodetect" | /opt/cpanel/$phpver/root/usr/bin/pecl install imagick
echo 'extension=imagick.so' >> /opt/cpanel/$phpver/root/etc/php.d/imagick.ini
done
/scripts/restartsrv_httpd
/scripts/restartsrv_apache_php_fpm

3.  Test to make sure imagemagick is installed:

/usr/bin/convert --version

4. Test to make sure the PHP extensions loaded:

for phpver in $(whmapi1 php_get_installed_versions|grep -oE '\bea-php.*') ; do
echo "PHP $phpver" ; /opt/cpanel/$phpver/root/usr/bin/php -m |grep imagick
done
PHP 54
imagick
PHP 55
imagick
PHP 56
imagick
PHP 70
imagick
PHP 71
imagick