PostgreSQL configuration (IP restrictions)

pavlo-seimskyiTRIAL

a year ago

Hi! I'm new to Railway. I got my Postgres database running from a PostGIS template. I am using the private network for production. However, for development, I would like to keep access over the public network but restrict it to specific IP addresses. I have tried understanding from the PostGIS image documentation how to specify the configuration for the pg_hba.conf file but I can't seem to get it. It seems like a basic security configuration to me and I hope it is possible at all? Any guidance is much appreciated! Thanks for the great tooling!

1 Replies

a year ago

As Railway doesn't provide a filebrowser interface for the container or the volume I don't think there's a very straightforward way to edit the pg_hba.conf file.

For what it's worth, the databases are deployed with a randomly generated password that is 32 characters long, but if that isn't secure enough for public access I understand.

I will look into possible ways to configure the pg_hba.conf file.


PostgreSQL configuration (IP restrictions) - Railway Help Station