PostgreSQL on SAP BTP - How-to access instances via public IPs

[SilviaPedroso]

PostgreSQL on SAP BTP instances created via BTP Cockpit or Cloud Foundry command line (CLI) are provisioned by default with private endpoints that are only accessible from BTP applications. In certain scenarios where PostgreSQL instances needs to be accessible from other landscapes and environments (e.g. from external sources), customers may now leverage access via public IPs feature. Check official product documentation regarding the supported regions.

Check below how to create an instance accessible via public IPs

To make your instance accessible publicly you must enable two additional parameters in your instances on SAP BTP Cockpit or via Cloud Foundry CLI operations at the time of instance creation.

Prerequisites/considerations:

• Please consider that only new instances can be made publicly available.
• Always confirm if the feature is already available in your setup region, check product official documentation.
• Public access can only be activated for the service plans premium and standard.
• Public access cannot be disabled after setup.
• You cannot restore a backup of a non-public instances into a public instance, please leverage pg_copy and pg_restore for this purpose.

How to create a new publicly accessible instance

Access BTP Cockpit > select your Global Account > Create a new instance

In the parameter tab within the allow access section add the IP addresses that should have access to your PostgreSQL, if you have multiple IP addresses use comma to separate these. Please consider that each time you provide a new IP/domain, it will overwrite the existing settings, so always provide the complete list of IPs if you update 'allow_access' parameter.

Additionally tick the ‘Public Access’ checkbox, which ensures your instance is now accessible publicly to the allow listed IP addresses you entered above.

Your PostgreSQL instance is now accessible externally via Public IP.

Please refer to our official product documentation at SAP Help Portal for more information on PostgreSQL.

Check out other interesting blogs on PostgreSQL:

• PostgreSQL on SAP BTP - Are you looking for official blog posts? Blog INDEX

Thank you for reading!

SAP BTP Backing Services – Product Management

[Sidharthavadla16]

Hi,

I was able to create a public access, however Im only able to connect to it if I specify just 1 ip in allow IP space, when add just 2 ip address both doesnt work. 


works fine with below IP

But when I do 

Only the access from first IP works and not from second.

When I just do the second IP the connection from the Second IP as well works.