Postgres installtion

postgress installtion
Install PostgreSQL manually (WORKING)

🔧 Step 1: Install required tools

yum install -y wget tar gcc readline-devel zlib-devel

🔧 Step 2: Download PostgreSQL source

cd /tmp

wget https://ftp.postgresql.org/pub/source/v13.11/postgresql-13.11.tar.gz
🔧 Step 3: Extract

tar -xvf postgresql-13.11.tar.gz

cd postgresql-13.11

🔧 Step 4: Install

./configure --prefix=/usr/local/pgsql

make

make install

🔧 Step 5:

Create postgres user

useradd postgres
mkdir -p /usr/local/pgsql/data
chown -R postgres:postgres /usr/local/pgsql

🔧 Step 6: Initialize DB

su - postgres

/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

🔧 Step 7: Start DB

/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

🔧 Step 8: Connect
/usr/local/pgsql/bin/psql

Видео Postgres installtion канала DBA Engine