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:
No comments:
Post a Comment