Postgres HA with REpmgr SSL
thoven87
PROOP

2 years 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 😦

Closed

13 Replies

thoven87
PROOP

2 years ago

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


2 years 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

2 years ago

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


2 years ago

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


thoven87
PROOP

2 years ago

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


2 years ago

what's the usecase for connecting publicly?


thoven87
PROOP

2 years ago

The connection is not encrypted.


2 years ago

hmmm not sure how that answers my question


thoven87
PROOP

2 years ago

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


2 years ago

why can't those be ran within railway?


thoven87
PROOP

2 years ago

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


thoven87
PROOP

2 years ago

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


2 years ago

because pgpool does not generate a certificate


Welcome!

Sign in to your Railway account to join the conversation.

Loading...