I'm not the root of a linux shared server. I have installed postgres for my local profile (http://blog.endpoint.com/2013/06/installing-postgresql-without-root.html)
I'm running a python code on the same server to access that database.
What should I give my URL as in my python code: dbURL =postgres://postgres:root@localhost:5432/myDb
OR should I add export PATH=$HOME/postgres/bin/:$PATH in my .bashrc file
I checked from terminal, myDb is on localhost:5432 postgres server. Everything is working fine when I interact with my database from terminal.
Sorry, I'm not able to get why my code is not able to connect to this db. PS: Everything is fine from code side as well (was running perfectly on local machine)