Relational database

# PostgreSQL database template

The PostgreSQL catalog includes database variants with persistent storage. Provisioning, backup, scaling, and network behavior depend on the selected service and configuration.

[Get started](https://panel.deplomo.com/signup)[View in marketplace](/marketplace)

## PostgreSQL template and catalog options

The catalog includes PostgreSQL variants and extensions. Review the selected version, storage, network access, and backup requirements.

### Ollama and Open WebUI template

The PostgreSQL template provides an option to deploy a database with persistent storage. Provisioning is currently unavailable in the international sandbox.

### Object-relational database management system (ORDBMS)

PostgreSQL supports transactions, relational constraints, and JSONB data types. Suitability depends on schema design, configuration, and workload.

### Extensions such as PostGIS and pgvector

The catalog includes PostgreSQL variants with extensions such as PostGIS or pgvector. Check the current catalog and version documentation before selecting a variant.

### Private networking and backup planning

Network access and firewall rules depend on your configuration. Arrange and verify backups separately; persistent storage alone is not a backup.

## Frequently asked questions about PostgreSQL

Answers to common questions about PostgreSQL variants, connection requirements, and data storage:

What is PostgreSQL, and when is it useful?

What does the Deplomo PostgreSQL template include?

How can I connect to PostgreSQL?

Which PostgreSQL extensions are available?

What happens to data when a PostgreSQL container restarts?

## PostgreSQL: features and deployment considerations

PostgreSQL is an open-source relational database used in a range of workloads. The Deplomo catalog includes PostgreSQL variants; review their versions and resource requirements. Service provisioning is currently unavailable in the international sandbox.

### What is PostgreSQL, and what features does it provide?

PostgreSQL is an open-source object-relational database. It supports indexes, transactions, and JSONB, with behavior and performance depending on schema, extensions, configuration, and workload.

You can manage PostgreSQL with a database client such as  [pgadmin](/marketplace/apps/pgadmin) . Connection details and access depend on the service and network configuration. The marketplace includes other database options, such as  [MySQL database hosting](/marketplace/apps/mysql)  and  [Cloud database](/products/databases) . Compare the available database services and their requirements before choosing.

### Challenges of manually setting up postgres hosting compared to cloud hosting Deplomo

Maintaining a Postgres database on a raw virtual server is associated with many technical challenges. In order to achieve the highest efficiency, Postgres requires precise tuning of values ​​such as shared_buffers, work_mem and max_connections based on server hardware resources. In addition, setting up Autovacuum to avoid unnecessarily bulking up tables and writing backup scripts takes up valuable time from technical teams.

On the other hand, by selecting the postgres host in Deplomo, the database will be automatically and optimized. Utilizing ultra-fast enterprise NVMe hard drives, read and write throughput (IOPS) is maximized, and regular cloud backup operations prevent data destruction.

### Comparison table of postgresql hosting in Deplomo with shared hosting and raw virtual server

The competitive advantages of cloud deployment are summarized in the following table:

<table class="w-full text-start text-sm"><thead class="border-b border-border/80 bg-muted/60 text-xs font-bold text-foreground"><tr><th class="p-4">Feature</th><th class="p-4 text-deplomo-600 dark:text-deplomo-400 font-extrabold">Postgresql host at Deplomo</th><th class="p-4">Conventional shared hosting (cPanel)</th><th class="p-4">Manual setup on a VPS</th></tr></thead><tbody class="divide-y divide-border/60 text-muted-foreground"><tr class="hover:bg-muted/30"><td class="p-4 font-semibold text-foreground">Setup and deployment time</td><td class="p-4 font-medium text-foreground">Deploy from a marketplace template</td><td class="p-4">Poor support or very old versions of Postgres</td><td class="p-4">Hours of installing packages, creating users, and setting permissions</td></tr><tr class="hover:bg-muted/30"><td class="p-4 font-semibold text-foreground">Disk type and read/write speed</td><td class="p-4 font-medium text-foreground">Persistent volume; capacity depends on the package</td><td class="p-4">Storage performance depends on the selected service, disk, and workload</td><td class="p-4">Performance also depends on configuration and query patterns</td></tr><tr class="hover:bg-muted/30"><td class="p-4 font-semibold text-foreground">Extensions such as PostGIS</td><td class="p-4 font-medium text-foreground">PostGIS and pgvector variants are available in the catalog; check the current versions</td><td class="p-4">Extension availability depends on the selected image and version</td><td class="p-4">A custom image may require system packages and extension binaries</td></tr><tr class="hover:bg-muted/30"><td class="p-4 font-semibold text-foreground">Persistent storage and backup planning</td><td class="p-4 font-medium text-foreground">Database variants use persistent storage; backup availability depends on the service and must be verified separately</td><td class="p-4">Backup and recovery practices depend on the service and operator</td><td class="p-4">Self-managed installations require a backup process and separate storage</td></tr><tr class="hover:bg-muted/30"><td class="p-4 font-semibold text-foreground">Pricing and package limits</td><td class="p-4 font-medium text-foreground">Deplomo packages have fixed monthly EUR prices by zone and hard resource limits</td><td class="p-4">Other providers set billing terms and resource options by plan</td><td class="p-4">Self-hosted infrastructure has ongoing resource and operations costs</td></tr></tbody></table>

Compare PostgreSQL services by version, resource limits, network access, backup options, and operating requirements.

### PostgreSQL catalog and template options

When available, use these steps to deploy Ghost:

- **Choose a database service** Review the available PostgreSQL variants in the catalog. Service provisioning is currently unavailable in the international sandbox.

- **Review resource and storage limits** Choose a service within the hard limits of the selected monthly EUR zone package. Available storage and resource options depend on the selected product.

- **Provisioning availability** Service provisioning is currently unavailable in the international sandbox; no deployment time or connection details are promised.

- **Configure database access** When service provisioning is available, configure connection details and network access according to the selected product. Test your application’s queries and performance.

### PostgreSQL template overview

The Deplomo catalog lists PostgreSQL database options with persistent storage. Review resource limits, network access, and backup requirements. Provisioning is currently unavailable in the international sandbox.

Review the PostgreSQL catalog and package requirements.

## Run PostgreSQL in seconds

Automatic installation, instant setup and custom domain support with a free security certificate.

[PostgreSQL template overview](https://panel.deplomo.com/signup)