postgresql

Fix firewall rule issue

Azure PostgreSQL Action enables you to automate workflows to deploy updates to Azure Database for PostgreSQL server. You can run a single PL/SQL file or multiple files from a single parent folder against your Azure Database for PostgreSQL server.

The action uses Connection String for authentication and PL/SQL scripts to deploy to your PostgreSQL database.

Sample workflow to deploy to an Azure database for PostgreSQL server using Azure Login

on: [push]

jobs:
  build:
    runs-on: ubuntu-latest
    
    steps:
     - uses: actions/[email protected]
     - uses: Azure/login@v1
       with:
         creds: ${{secrets.AZURE_CREDENTIALS}}
     - uses: azure/postgresql@v1
      with:
        connection-string: ${{ secrets.AZURE_POSTGRESQL_CONNECTION_STRING }}
        server-name: REPLACE_THIS_WITH_YOUR_POSTGRESQL_SERVER_NAME
        plsql-file: "sql_files/*.sql"