chore: add max connections to warehouse and pgnotifier

[achettyiitr]

Description

• Setting maxOpenConnections for Warehouse and PgNotifier db handle.

Notion Ticket

https://www.notion.so/rudderstacks/Max-open-connection-for-warehouse-and-postgres-91e4987ff26b41f6a7aa337fa3cb8f80?pvs=4

Security

• The code changed/added as part of this pull request won't create any security issues with how the software is being used.

[codecov]

Codecov Report

Patch coverage: 100.00% and project coverage change: -0.01 ⚠️

Comparison is base (abd9c8c) 68.01% compared to head (40587e8) 68.00%.

Additional details and impacted files

@@            Coverage Diff             @@
##           master    #3597      +/-   ##
==========================================
- Coverage   68.01%   68.00%   -0.01%     
==========================================
  Files         318      318              
  Lines       50375    50380       +5     
==========================================
+ Hits        34262    34263       +1     
- Misses      13880    13883       +3     
- Partials     2233     2234       +1     

Impacted Files	Coverage Δ
services/pgnotifier/pgnotifier.go	71.13% <100.00%> (+0.16%)	⬆️
warehouse/warehouse.go	64.69% <100.00%> (+0.05%)	⬆️

... and 7 files with indirect coverage changes

☔ View full report in Codecov by Sentry.
📢 Do you have feedback about the report comment? Let us know in this issue.

[fracasula]

Looks good, if needed moving forward we can differentiate between master and slave but for now I don't see a reason why. Let me know if you disagree of course.

[achettyiitr]

Looks good, if needed moving forward we can differentiate between master and slave but for now I don't see a reason why. Let me know if you disagree of course.

I am not sure how much benefit it can provide. If we need separate configs for master and slave we can always set them as ENVs since both of these have separate deployments.
warehouse-master-deployment
warehouse-slave-deployment