Postgres init setup

Install postgres

apt update
apt upgrade -y
apt install postgresql postgresql-contrib -y

Set password for postgres user

switch to postgres user

su - postgres

enter postgres shell

psql

set password for postgres user

\password postgres

Postgres config file

vim /etc/postgresql/14/main/postgresql.conf
vim /etc/postgresql/14/main/pg_hba.conf

after editing, restart postgres

systemctl restart postgresql

Cancel peer authentication for postgres user

vim /etc/postgresql/14/main/pg_hba.conf

change

local   all             postgres                                peer

to

local   all             postgres                                md5

Create new user

su - postgres
createuser --help

Create new database

su - postgres
createdb yourdbname