---
title: Charmhub | Deploy PostgreSQL Test App using Charmhub - The Open Operator Collection
description: Deploy the latest version of PostgreSQL Test App on any cloud. PostgreSQL
  Test App
url: https://charmhub.io/postgresql-test-app
---

# PostgreSQL Test App

[Canonical](https://charmhub.io/publisher/data-platform "View all packages from Canonical")

* [Canonical](https://charmhub.io/publisher/data-platform "View all packages from Canonical")

Platform:

24.04

22.04

stable 591

```
juju deploy postgresql-test-app
```

[Learn to deploy on juju >](https://juju.is/docs/juju/manage-applications)

---

#### Relevant links

* [Homepage](https://ubuntu.com/data/postgresql)
* [Contact](mailto:Canonical Data Platform <data-platform@lists.launchpad.net>)

---

#### Contacts

##### Maintainers

+ [Canonical Data Platform](mailto:data-platform@lists.launchpad.net)

* [Submit a bug](https://github.com/canonical/postgresql-test-app/issues)

---

Share your thoughts on this charm with the community on discourse.

[Join the discussion](https://discourse.charmhub.io/)

# PostgreSQL Test App

The PostgreSQL Test App is an internal tool used in various test scenarios for Charmed PostgreSQL installations. It is a workload-less charm and can be deployed and used in both K8s and VM installations.

## [Usage](https://charmhub.io/postgresql-test-app#p-27420-usage)

Deploy and integrate Charmed PostgreSQL with PostgreSQL Test App

```
juju deploy postgresql db
juju deploy postgresql-test-app app
juju integrate db app:database
```

Configure the write load rate

```
juju config app sleep_interval=1000 # (optional, sleep 1000ms second between inserts)
```

Run an endless load test

```
juju run app/leader start-continuous-writes # (optional, to start endless write test)
juju run app/leader show-continuous-writes  # (optional, to show amount of records in DB)
juju run app/leader stop-continuous-writes  # (optional, to stop endless write test)
```

Clean up your deployment

```
juju remove-application app db
```

---

[Help improve this document in the forum](https://discourse.charmhub.io/t/postgresql-test-app/11730) ([guidelines](https://discourse.charmhub.io/t/how-to-write-docs-our-documentation-guidelines-for-contributors/1245)). Last updated 1 year, 8 months ago.