Using Azure Database for PostgreSQL with DataRobot¶

はじめに¶

DataRobot supports the use of external databases, including Azure Database for PostgreSQL, to store and manage data. This documentation provides detailed instructions on configuring DataRobot to utilize Azure Database for PostgreSQL as a database solution.

Steps to Configure Azure Database for PostgreSQL with DataRobot¶

1. Create an Azure Database for PostgreSQL Instance¶

Log in to the Azure Portal.
Navigate to the Azure Database for PostgreSQL service.
Click "Add" and configure the following settings:
Subscription: Choose your Azure subscription.
Resource Group: Create a new or select an existing resource group.
Server: Enter a unique server name.
Data Source: Choose "None" for a new database.
Server Admin Login: Set postgres as master username.
Password: Set the master password.
Location: Choose the Azure region.
Version: Select the Engine Version 12.
Compute + Storage: Choose an appropriate compute size based on our database requirements.
Advanced settings: Adjust additional settings as needed.

(Optional) Configure Private IP Address¶

Under Networking, select Private endpoint to enable private access.
Choose your virtual network and subnet for private connectivity.

2. Obtain Azure Database for PostgreSQL Connection Details¶

Once the PostgreSQL instance is created, note down the Server Name. You'll need this for configuring DataRobot.

3. Configure DataRobot to Use Azure Database for PostgreSQL¶

When PostgreSQL is configured to utilize an external service, additional YAML override values must be provided.

postgresql-ha:
  postgresql:
    postgresPassword: YOUR_AZURE_DB_PASSWORD # created on step 1

then add to your values.yaml within the datarobot chart.

global:
  postgresql:
    internal: false
    hostname:  "YOUR_AZURE_DB_ENDPOINT"

core-integration-tasks:
  jobs:
    setup:
      config_env_vars:
        PGSQL_INIT_SCRIPT: /init-config/db

build-service:
  buildService:
    envApp:
      secret:
        POSTGRES_HOST: "YOUR_AZURE_DB_ENDPOINT"

Built-in Backup Service¶

Azure offers a built-in backup service that automatically performs backups of your databases according to a specified schedule. You can configure the backup retention period and frequency to meet your data retention requirements. Additionally, you can perform on-demand backups and create backups of specific instances at any time.

成果¶

By following these steps, you can seamlessly integrate Azure Database for PostgreSQL with DataRobot, providing a reliable and scalable database solution. This setup enhances data storage and retrieval, contributing to the overall efficiency of your DataRobot instance. If issues arise, refer to DataRobot documentation and Azure Database for PostgreSQL documentation for troubleshooting guidance.

Note: Always ensure that you follow best practices for security and compliance when configuring external databases with DataRobot and Azure PostgreSQL Server.

Fresh Install or Upgrade to 10.2.3¶

Azure Postgresql

Modify under settings for the instance and set password_encryption to SCRAM-SHA-256
Once modified, follow guide to delete the existing secret
Continue with upgrade as in the admin guide