Skip to main content
Solved

POSTGRESQL AWS config

  • Dec 6, 2024 11:45 AM UTC
  • 4 replies
  • 121 views

Yuggyuy
Apprentice
Forum|alt.badge.img+8

Hi all.

Can anyone give me details of their config please.

I have opened port 5432 between the CV proxies and the RDS instance but do I also need to allow ports 8400-8403 as well?

 

I get this error (just edited out the names and ips)

Error Code: [94:13]
Description: PostgreSQL Database: [~Connection to Database Failed: connection to server at "x.x.x.x", port 5432 failed: Connection timed out (0x0000274C/10060) Is the server running on that host and accepting TCP/IP connections? ~] Data Backup Failed.
Source: myCVproxy, Process: PostGresIfind

Best answer by Yuggyuy

I may have found the issues.  We have explicit outbound rules on the SG.  I will have this changed and update.

View original

4 replies

Meera
Vaulter
Forum|alt.badge.img+9
  • Vaulter
  • Dec 9, 2024 4:39 AM UTC

Hi Yuggyuy,

No, that is not needed. From the proxy machines, connection to postgres will use port 5432 only. Are you able to connect to the postgres server from proxy machine? 

 

For example, if it is a linux proxy, are you able to connect to postgres like this -
 

[root@client ~]# cd /opt/commvault/CVCloudAddOns/PostgreSQL/15/bin/
[root@client bin]# ./psql -U username -p 5432 -h x.x.x.x -d databasename

 

For windows proxy, for default commvault install location, psql will be under C:\Program Files\Commvault\ContentStore\CVCloudAddOns\PostgreSQL\15\bin\

 

Regards,

Meera


Yuggyuy
Apprentice
Forum|alt.badge.img+8
  • Author
  • Apprentice
  • Dec 11, 2024 2:40 PM UTC

Hello.  Thank you for the information.  This is postgreql hosted on RDS so I am accessing it via the endpoint, and it’s the endpoint that’s returning the error message.  I’m not sure yet if it is even getting through the endpoint


Yuggyuy
Apprentice
Forum|alt.badge.img+8
  • Author
  • Apprentice
  • Answer
  • Dec 11, 2024 2:54 PM UTC

I may have found the issues.  We have explicit outbound rules on the SG.  I will have this changed and update.


Yuggyuy
Apprentice
Forum|alt.badge.img+8
  • Author
  • Apprentice
  • Dec 13, 2024 9:32 AM UTC

Rules were added at both service account and target account and backups  worked.