DEV Community

PostgreSQL 16 Installation on Ubuntu 22.04

JohnDotOwl on September 24, 2023

Overview PostgreSQL 16 is the latest major release of the popular open source relational database. It comes with many new features and improvements...

Read full post

Nux • Mar 18

I think there is a typo. It is:
sudo apt install gnupg2 wget vim
Should be:
sudo apt install gnupg2 wget nano
I mean you do use nano, thankfully 😉

JohnDotOwl • Mar 19

Updated, Thank you! HAHA Yeah , takes me minutes to exit vim , hehe

JohnDotOwl • Sep 24 '23

I enjoy installing PostgreSQL directly on bare metal servers, without any additional overhead from Docker containers, to get pure bare metal performance.

Rinx • Jan 8 • Edited

I run this to create a root role (to match with my root user on ubuntu 20.04) so I don't have to switch to postgres user to use pg_restore.

sudo -u postgres createuser --interactive
Enter name of role to add: root
Shall the new role be a superuser? (y/n) y

Evaristo Ramos • Oct 1 '23

hi sorry for the n00b question, but how do i change the default data directory? as i am looking to install a 1TB db that will exceed my boot/os drive

JohnDotOwl • Oct 2 '23 • Edited

Sorry for the late reply
Edit the postgresql.conf file: Find the data_directory parameter and set it to the new path you want to use. For example:
data_directory = '/new/data/path'

To add on, you can run commands like
df -h Show mounted filesystems along with disk usage
lsblk List all block devices along with information like mountpoints, size, type

Evaristo Ramos • Oct 3 '23

yah that didnt quite work for me. I did end up figuring it out though, from virgin install to new custom directory took 27 steps :/

JohnDotOwl • Oct 3 '23

Haha , that is one of the reason why i started blogging because i realise i'm going through the same process multiple times these years. Glad you got it figured out!

Jonas Scholz • Apr 11

nice post:)