README.md

Open PostgreSQL server firewall to your IP address

Prerequisites

This example assumes you have previously completed the following examples:

1. Create an Azure Resource Group
2. Create an Azure Database for PostgreSQL
3. Install curl

Open PostgreSQL server firewall to your local IP address

To make it possible to communicate with your PostgreSQL server from your local IP address execute the following command lines:

  export LOCAL_IP=`curl -s whatismyip.akamai.com`

  az postgres server firewall-rule create \
    --resource-group $RESOURCE_GROUP \
    --server-name $POSTGRESQL_NAME \
    --name AllowMyLocalIP \
    --start-ip-address $LOCAL_IP \
    --end-ip-address $LOCAL_IP

Cleanup

Do NOT forget to remove the resources once you are done running the example.

1m