---
id: pulumi-postgresql
version: "3.18.0"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# pulumi-postgresql — A Pulumi package for creating and managing postgresql cloud resources.

License: permissive · Maintenance: active · Downloads: 492.0K/mo

## What it is and what it does

pulumi-postgresql is a Pulumi resource provider that lets you define PostgreSQL infrastructure—databases, users, roles, permissions, and other objects—using Python code instead of manual SQL or imperative scripts. It integrates with Pulumi's state management and deployment workflow, so you can version-control your database schema and apply changes consistently across environments.

The provider connects to a PostgreSQL server using standard connection parameters (host, port, username, password) supplied via environment variables or Pulumi configuration. It supports SSL connections, connection pooling, and superuser-level operations. You write Python code to declare the resources you want, and Pulumi handles creating, updating, and destroying them on your PostgreSQL instance.

Use it for:

- Define and version-control database schemas and user permissions as part of your infrastructure-as-code stack.
- Automate PostgreSQL setup in CI/CD pipelines without writing raw SQL scripts.
- Manage multiple PostgreSQL environments (dev, staging, production) with consistent, reproducible configurations.
- Provision database users and roles with specific permissions as part of application deployment.
- Coordinate PostgreSQL resource creation with application infrastructure defined in the same Pulumi program.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Pulumi resource provider for declaring and managing PostgreSQL databases, users, roles, and other database objects as infrastructure code.

Yes, if you are already using Pulumi and need to manage PostgreSQL resources as code. The provider is actively maintained, has no known vulnerabilities, and integrates cleanly with Pulumi's workflow. Install only if you have Pulumi CLI set up and a PostgreSQL server you can connect to.

## Install

pip install pulumi-postgresql
uv add pulumi-postgresql
poetry add pulumi-postgresql

## Installing pulumi-postgresql

Before you install: Low install friction; a pure Python wheel with four lightweight runtime dependencies. Actively maintained as of 2026-08-14 with recent releases.

License in practice: Apache-2.0 permissive license allows commercial and private use with minimal restrictions.

Quickstart:

pip install pulumi_postgresql

import pulumi
import pulumi_postgresql as postgresql

db = postgresql.Database("my_db", name="mydb")

Requires Pulumi CLI to be installed first and a running PostgreSQL server with network access configured via environment variables or Pulumi config (PGHOST, PGUSER, PGPASSWORD, etc.).

Verify before relying:

- Whether all PostgreSQL resource types (tables, schemas, extensions, etc.) are fully supported or if some are limited.
- Performance characteristics when managing large numbers of PostgreSQL objects.
- Compatibility with PostgreSQL versions older than 9.0.0 mentioned in the configuration docs.

## Package facts

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 492.0K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

pulumi postgresql provider, infrastructure as code postgresql, manage postgresql with pulumi, postgresql resource provider, database infrastructure automation, pulumi database management, postgresql iac, infrastructure-as-code, postgresql, pulumi-plugin

[View on SkillFed](https://skillfed.io/packages/pulumi-postgresql) · [View on PyPI](https://pypi.org/project/pulumi-postgresql/)