Postgresql on linux

By default, we will get postgresql on Linux installation

Check for the status of postgresql service as below

Before starting the postgresql service initialize the database as below

Enable the firewall for postgresql as below

Start the service and check for the status as below

Now postgresql is up and running.

Granting permissions for root user to run postgresql

Steps for creating postgresql user:

Change to postgres user and run the below command

$createuser --pwprompt

Give username and password and enter "y" and click enter

Creating postgresql database:

Now we can create postgresql database as a root user as below

Connect to the newly created database as below: