Managed Postgres FAQ

[Edit this page](https://github.com/ClickHouse/clickhouse-docs/blob/main/docs/cloud/managed-postgres/faq.md)

[Private preview](https://clickhouse.com/cloud/postgres)

## Monitoring and metrics[​](#monitoring-and-metrics "Direct link to Monitoring and metrics")

### How can I access metrics for my Managed Postgres instance?[​](#metrics-access "Direct link to How can I access metrics for my Managed Postgres instance?")

You can monitor CPU, memory, IOPS, and storage usage directly from the ClickHouse Cloud console in the **Monitoring** tab of your Managed Postgres instance.

Note

Query Performance Insights for detailed query analysis is coming soon.

## Backup and recovery[​](#backup-and-recovery "Direct link to Backup and recovery")

### What backup options are available?[​](#backup-options "Direct link to What backup options are available?")

Managed Postgres includes automatic daily backups with continuous WAL archiving, enabling point-in-time recovery to any moment within a 7-day retention window. Backups are stored in S3.

For complete details on backup frequency, retention, and how to perform point-in-time recovery, see the [Backup and restore](/docs/cloud/managed-postgres/backup-and-restore) documentation.

## Infrastructure and automation[​](#infrastructure-and-automation "Direct link to Infrastructure and automation")

### Is Terraform support available for Managed Postgres?[​](#terraform-support "Direct link to Is Terraform support available for Managed Postgres?")

Terraform support for Managed Postgres isn't currently available. We recommend using the ClickHouse Cloud console to create and manage your instances.

## Extensions and configuration[​](#extensions-and-configuration "Direct link to Extensions and configuration")

### What extensions are supported?[​](#extensions-supported "Direct link to What extensions are supported?")

Managed Postgres includes 100+ PostgreSQL extensions, including popular ones like PostGIS, pgvector, pg\_cron, and many more. For the complete list of available extensions and installation instructions, see the [Extensions](/docs/cloud/managed-postgres/extensions) documentation.

### Can I customize PostgreSQL configuration parameters?[​](#config-customization "Direct link to Can I customize PostgreSQL configuration parameters?")

Yes, you can modify PostgreSQL and PgBouncer configuration parameters through the **Settings** tab in the console. For details on available parameters and how to change them, see the [Settings](/docs/cloud/managed-postgres/settings) documentation.

Tip

If you need a parameter that isn't currently available, contact [support](https://clickhouse.com/support/program) to request it.

## Database capabilities[​](#database-capabilities "Direct link to Database capabilities")

### Can I create multiple databases and schemas?[​](#multiple-databases-schemas "Direct link to Can I create multiple databases and schemas?")

Yes. Managed Postgres provides full native PostgreSQL functionality, including support for multiple databases and schemas within a single instance. You can create and manage databases and schemas using standard PostgreSQL commands.

### Is role-based access control (RBAC) supported?[​](#rbac-support "Direct link to Is role-based access control (RBAC) supported?")

You have full superuser access to your Managed Postgres instance, which allows you to create roles and manage permissions using standard PostgreSQL commands.

Note

Enhanced RBAC features with console integration are planned for this year.

## Upgrades[​](#upgrades "Direct link to Upgrades")

### How are PostgreSQL version upgrades handled?[​](#version-upgrades "Direct link to How are PostgreSQL version upgrades handled?")

Both minor and major version upgrades are performed via failover and typically result in only a few seconds of downtime. You can configure a maintenance window to control when upgrades are applied. For complete details, see the [Upgrades](/docs/cloud/managed-postgres/upgrades) documentation.

## Migration[​](#migration "Direct link to Migration")

### What tools are available for migrating to Managed Postgres?[​](#migration-tools "Direct link to What tools are available for migrating to Managed Postgres?")

Managed Postgres supports several migration approaches:

- **pg\_dump and pg\_restore**: For smaller databases or one-time migrations. See the [pg\_dump and pg\_restore](/docs/cloud/managed-postgres/migrations/pg_dump-pg_restore) guide.
- **Logical replication**: For larger databases requiring minimal downtime. See the [Logical replication](/docs/cloud/managed-postgres/migrations/logical-replication) guide.
- **PeerDB**: For CDC-based replication from other Postgres sources. See the [PeerDB migration](/docs/cloud/managed-postgres/migrations/peerdb) guide.

Note

A fully managed migration experience is coming soon.

- [Monitoring and metrics](#monitoring-and-metrics)
  - [How can I access metrics for my Managed Postgres instance?](#metrics-access)- [Backup and recovery](#backup-and-recovery)
    - [What backup options are available?](#backup-options)- [Infrastructure and automation](#infrastructure-and-automation)
      - [Is Terraform support available for Managed Postgres?](#terraform-support)- [Extensions and configuration](#extensions-and-configuration)
        - [What extensions are supported?](#extensions-supported)- [Can I customize PostgreSQL configuration parameters?](#config-customization)- [Database capabilities](#database-capabilities)
          - [Can I create multiple databases and schemas?](#multiple-databases-schemas)- [Is role-based access control (RBAC) supported?](#rbac-support)- [Upgrades](#upgrades)
            - [How are PostgreSQL version upgrades handled?](#version-upgrades)- [Migration](#migration)
              - [What tools are available for migrating to Managed Postgres?](#migration-tools)

Was this page helpful?