Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP

Pega-as-a-Service
,
1

Please tell how to resolve this error

pega error.txt (17.9 KB)

PEGA ERROR.png
PEGA ERROR.png801×656 30 KB

2

@MrunalD5 During the install, did you test port 5432? Looks like this when I test port availability, installation success:

Port Availability .jpg
Port Availability .jpg759×604 22.2 KB

Port Availability result.jpg
Port Availability result.jpg585×177 9.43 KB

3

@shanp yes port is available

4

@MrunalD5

Can you please try reinstalling the Personal Edition, it may resolve the issue. Change the port from 5432 to other and reinstall it once.

5

@MS91781 okay will try

6

Any update on the issue

7

@JeevanthaPerera @MrunalD5 these issues are caused by external factors to PE:

See Unable to install Pega 8.5.1 PE for the identical error and the causes of this error:

  • attempting to install PE on a system where directories from previous PE installs/ PostGres DB still exist and are causing caching issues

  • missing installation of Microsoft Visual C++ 2015 Redistributable Update 3 RC program.

  • check firewall is not blocking port 5432.

Try

Solution 1 : install the latest version of pgadmin then proceed to install.

Also please check if the postgres db starts up correctly first.

You need to make sure you are starting the DB server using below command and then starting the tomcat instance-

D:\PRPCPersonalEdition\pgsql\bin>pg_ctl -D D:\PRPCPersonalEdition\pgsql\data start

Above highlighted could change based on the personal edition installation.

Solution 2: installing the Microsoft Visual C++ 2015 Redistributable Update 3 RC program.

The issue may be that the pg_ctl executable is not able to run due to the VCRUNTIME140.dll being missing in the Windows System. This error is not exclusive of the pg_ctl command but it seems to be common for other programs that need that DLL to run correctly.

Check this links for more details about this error:

https://softwarekeep.com/help-center/how-to-fix-the-vcruntime140dll-is-missing-error-on-windows-10

You can download the executable from this site:

https://www.microsoft.com/en-us/download/details.aspx?id=52685

Solution 3: Check that there is not an older version of pega files already existing in your PC.

Remove those files first.

Solution 4: try completely deleting the contents of following directory

C:\PRPCPersonalEdition\tomcat\kafka-data , if you are using a VPN or dynamic IP, the IP address of you machine is cached by Kafka which creates this problem.

Clean restart of Pega PE after clearing off this folder

https://www.pgadmin.org/download/pgadmin-4-windows/

During the installation be sure to test the ports:

Port Availability result.jpg
Port Availability result.jpg585×177 9.43 KB

After it’s installed and running you could use TCPView (or similar utility) to confirm that postgres is running at port 5432:

2.jpg
2.jpg893×320 77 KB

Solution 5: Check your jvm parameters like heapspace and permgen. Incase of tomcat it would present in setenv.bat/.sh file.

8

Hi,

There is a chance the firewall might be blocking the DB ports i.e. 5432.
Work Around: Can try Opening Ports in Windows Firewall.
Also, if you are trying to install the same in your office laptop you might not have the full access.
So instead of installing the PRPC in C:\ Drive (System level install) try installing in other local folders like Pictures, Videos etc which will be a User level install.

Thanks
Udyog

9

@MrunalD5 we notice that you have not logged into the Pega Support Center for over a year. We will close this thread for now. Feel free to log a new question if you need any further help.