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

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...