Technology Blog Posts by SAP
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

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

SilviaPedroso
Product and Topic Expert
Product and Topic Expert
‎2024 Sep 17 6:34 PM
1,526

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

SilviaPedroso_0-1726577280367.png

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.

SilviaPedroso_1-1726577351639.png

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

SilviaPedroso_2-1726577374763.png

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:

Thank you for reading!

SAP BTP Backing Services – Product Management

1 Comment