Allowing a Microservice to Access the BSS Database PostgreSQL Server
On-premise
To allow a microservice to access an on-premise BSS Database PostgreSQL server:
- Allow the micro-service application hosted on Kubernetes nodes to access the BSS Database PostgreSQL server:
For a single-node Kubernetes cluster, add its IP to the
pg_hba.conf
file:host all all <IP_address_of_application_node_node>/32 md5
For a multiple-node Kubernetes cluster (AKS cluser), add a nodes sub-net, for example:
host all all 10.240.0.0/24 md5
- Reload the PostgreSQL service:
For PostgreSQL 9.6, reload the service as follows:
systemctl reload postgresql-9.6
For PostgreSQL 11, reload the service as follows:
systemctl reload postgresql-11
Cloud
To allow a microservice to access a cloud BSS Database PostgreSQL server, follow the corresponding cloud vendor documentation. For example, for Azure Database for PostgreSQL, follow https://docs.microsoft.com/en-us/azure/postgresql/howto-manage-vnet-using-portal.