How do I configure an ACI which is container group to access an Azure Postgres Server?

Question

Hi,

I'm a bit green around the ears when it comes to Azure.

I have a YMAL file that creates a container group with two Linux containers: the application and the other a sidecar for TLS. The application I am running is FlowiseAI, which can connect and leverage a Postgres database instead of a local deployment of SQLite.

I deployed an Azure Database for PostgreSQL (single server) burstable and have allowed Azure services access. I can connect to the database from my laptop using pgAdmin, which works (there is a firewall rule for my home network).

api-version: 2019-12-01
location: eastus
name: flowise-ssl
properties:
  containers:
  - name: flowise
    properties:
      image: flowiseai/flowise
      ports:
      - port: 80 
      - port: 3000
      command:
      - "/bin/sh"
      - "-c"
      - "flowise start" 
      environmentVariables:
      - name: PASSPHRASE
        value: 

Answer 1

Hello Travis Polland

It looks like you have started defining a YAML file for deploying a container group with the FlowiseAI application. To connect the application to your PostgreSQL database, you will need to add an environment variable to the container definition with the connection string for the database.

Here is an example YAML file that includes the connection string as an environment variable:

api-version: 2019-12-01
location: eastus
name: flowise-ssl
properties:
  containers:
  - name: flowise
    properties:
      image: flowiseai/flowise
      ports:
      - port: 80 
      - port: 3000
      command:
      - "/bin/sh"
      - "-c"
      - "flowise start" 
      environmentVariables:
      - name: PASSPHRASE
        value: "mysecretpassword"
      - name: DATABASE_URL
        value: "postgresql://username:password@hostname:port/database"
  - name: sidecar
    properties:
      image: myregistry.azurecr.io/sidecar
      ports:
      - port: 443
      command:
      - "/bin/sh"
      - "-c"
      - "sidecar start"

Replace mysecretpassword with the password for your PostgreSQL server. Replace username, password, hostname, port, and database with the appropriate values for your PostgreSQL server, as described in my previous message.

Note that I have added a second container definition for the sidecar, which is used for TLS. You can remove this if you don't need it.

Once you have updated the YAML file with the correct connection string, you can deploy the container group using the Azure CLI or the Azure portal.

Hope this helps.