Manage

Manage all aspects of your Lakebase Postgres projects. You can create, configure, and maintain projects, branches, computes, roles, and databases.

Management topics

• • Manage projects
  • Create, configure, and manage Lakebase Postgres projects. Control project settings, resources, and lifecycle.
• • Manage project permissions
  • Grant project permissions to control who can manage infrastructure.
• • Manage branches
  • Create and manage branches for development, testing, and production environments.
• • Manage computes
  • Configure and manage compute resources for your projects, including sizing and scaling options.
• • Manage roles
  • Create, manage, and configure database roles and permissions for secure access control.
• • Manage databases
  • Create and manage databases within your projects for different applications and workloads.
• • Manage updates
  • Manage compute and Postgres version updates for your projects.

Backup and restore

• • Backup and restore methods
  • Overview of backup and restore options for Lakebase Postgres.
• • Point-in-time restore
  • Create a branch from any point in time within your restore window.
• • Snapshots
  • Create and manage manual snapshots of your database.
• • Postgres pg_dump & pg_restore
  • Export and import databases using standard Postgres pg_dump and pg_restore tools.

Monitor

• • Metrics dashboard
  • View CPU, memory, connection, and database metrics in the Lakebase dashboard.
• • Monitor active queries
  • View and manage currently running queries on your database.
• • Monitor query performance
  • Analyze slow queries and optimize database performance.
• • System operations
  • Monitor system operations and database activity.

Data protection

• • Data protection
  • Overview of data protection features for Lakebase Postgres.
• • Protected branches
  • Prevent accidental deletion or modification of production branches.
• • Customer-managed keys for Lakebase
  • Encrypt your data using your own encryption keys.

Management tools

• • Get started with the Databricks CLI for Lakebase
  • Manage projects, branches, and computes from the command line or in scripts and CI/CD pipelines.
• • Lakebase Autoscaling API guide
  • Use the REST API and SDKs to manage infrastructure programmatically.
• • Get started with Terraform for Lakebase
  • Use Terraform to create and manage Lakebase projects, branches, and endpoints as code.

Limits

See Project limits for maximum projects, branches, history retention, and other resource limits.