Postgres HA with REpmgr SSL
thoven87
PROOP

a year ago

Hello, It looks like the Postgres HA with Repmgr template does not offer SSL by default and somehow it's still on Postgres 16. It there anyway this template could be updated to provide SSL and or be upgraded to Postgres 17? This Postgres template does come with SSL, but it does not come with HA 😦

13 Replies

thoven87
PROOP

a year ago

Project ID 90b250a0-d964-46d1-9dab-8ea9d25584e5


a year ago

we are likely going to be keeping that template on 16 for the time being, as for SSL, it is not needed as long as you connect over the private network


thoven87
PROOP

a year ago

hmm, I think TLS termination should happen at least at pgpool wether or not connection is done via the private or public network.


a year ago

there is no benefit to that since the private network is an encrypted wireguard tunnel


thoven87
PROOP

a year ago

hmm, I still see the use case for the public connection.


a year ago

what's the usecase for connecting publicly?


thoven87
PROOP

a year ago

The connection is not encrypted.


a year ago

hmmm not sure how that answers my question


thoven87
PROOP

a year ago

One use case for connecting publicly is that I have batch jobs that run outside of railway.


a year ago

why can't those be ran within railway?


thoven87
PROOP

a year ago

The jobs will need to move off Google Dataflow first before they can be run within railway.


thoven87
PROOP

a year ago

Is there any specific reason why a self signed certificate is not generated for PGPool?


a year ago

because pgpool does not generate a certificate


Loading...