Question
Cognizant
IN
Last activity: 24 Apr 2020 15:19 EDT
not able to connect to postgres db
I am not able to connect to postgresql database of pega 8 vm of the system architect essentials course. I am using host only adapter on virtualbox and so trying to connect from the host machine. I read the other thread on this forum about this issue and first found DB connection information from the installed tomcat's prweb.xml
driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/pega" username="pega" password="pega"/>
Then I modified the postgresql.conf and pg_hba.conf and placed them back in the path which was /var/lib/pgsql/9.4/data
the change to pg_hba.conf was to add the line
host all all 0.0.0.0/0 trust
the change to postgresql.conf was to uncomment
listen_addresses=*
I restarted VM
Not sure if the path is correct, but this is the only place where I found pgAdmin4 files that had current date as the last modified timestamp.
I am still getting the same error which is
I am not able to connect to postgresql database of pega 8 vm of the system architect essentials course. I am using host only adapter on virtualbox and so trying to connect from the host machine. I read the other thread on this forum about this issue and first found DB connection information from the installed tomcat's prweb.xml
driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/pega" username="pega" password="pega"/>
Then I modified the postgresql.conf and pg_hba.conf and placed them back in the path which was /var/lib/pgsql/9.4/data
the change to pg_hba.conf was to add the line
host all all 0.0.0.0/0 trust
the change to postgresql.conf was to uncomment
listen_addresses=*
I restarted VM
Not sure if the path is correct, but this is the only place where I found pgAdmin4 files that had current date as the last modified timestamp.
I am still getting the same error which is
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
I used 127.0.0.1 instead of localhost and got same error as above. Please guide how to proceed.
***Edited by Moderator Marissa to update Content Type from Discussion to Question***
Updated: 14 Jun 2021 7:38 EDT
JP Morgan Chase & Co.
IN
I think the host address will vary, did you try using the host address which you are using for Pega login.
Cognizant
IN
Thank you for the suggestion. I just tried using the host address 192.168.56.103 now and unfortunately received the same error. I am attaching the two files - pg_hba.conf and postgresql.conf that I am using. May be there is some mistake in them. Please review if possible.
Updated: 14 Jun 2021 7:38 EDT
JP Morgan Chase & Co.
IN
I tried with the below configuration and it worked. Used password as "postgres". Could you please try the same once.
Cognizant
IN
I tried with postgres as username/password following the example in the screenshot. However I still received the same error. So, the conf files could be wrong. Could you kindly share the pg_hba.conf and postgresql.conf files that you have used.
I also downloaded senior system architect course vm and tried to connect to that database. But received same error. The pgsql 9.4 folder is present in same location as the SA essentials course vm. So maybe I updated the configuration files incorrectly. Please help.