POSTGRESQL INSTALLATION ON LINUX SERVER

PostgreSQL is a powerful, open-source object-relational database system known for its robustness, extensibility, and standards compliance.
For one to install postgreSQL on linux ,one must

• You must have a Linux server (like Ubuntu).

• You must have admin rights (called sudo).

• You must know how to use the terminal/command line.

INSTALLATION PROCESS

1. One must update the system first using commands on the terminal

sudo apt update
sudo apt upgrade -y

1. Installing postgres, main database and its tools are installed.
   sudo apt install postgresql postgresql-contrib -y


2. Checking if postgres is running after installation
   sudo systemctl status postgresql

   Ensure that postgress is running and if not start postgress
   sudo systemctl start postgresql


3. After installing, postgress creates a user called postgress and we should switch to that user.

sudo -i -u postgres


5.Getting into the database
psql

You should set a password for postgress while still in the database
ALTER USER postgres PASSWORD 'mypassword';


Your postgress has been installed on the linux server. If you want you can create your own database.