INSTALLATION DOCUMENTS BY RAVI

Wednesday, July 4, 2018

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:









No comments:

Post a Comment

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...