Hi Srikanth --
I'm guessing you're trying this locally, on the Tableau Server itself? PostgreSQL trusts any local connection to the machine (unless something has been specifically setup to force a password in the pg_hba.conf file, which controls this behavior)
The setting (dbpass) that you're working with is to enable/disable remote connections to the data source.
Hope this helps!
Tableau Desktop is installed on a different machine though not on Tableau Server itself.
After executing this command on Tableau Server, i can still access the db from my Tableau Desktop which is remotely connected.
But we had explicitly defined my IP in the pg_hba.conf file as a trusted connection, will this have to do anything here?
In general, you won’t want to edit pg_hba.conf directly because it can be overwritten with contents in a template file.
See this (old) information about editing the template file itself. There should be no need to explicitly deny the IP, either – if it’s remote and NOT in the conf file, it shouldn’t be able to connect:
I must clarify here, the file is template file and not the original one.
And the IP is included to allow remote access and not explicitly deny .
Ah, I thought you said it was added to “deny”.
Just remove it. That entry will explicitly allow the user entry to the box. Restart the server and see what happens.