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

# 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)

* [clear-continuous-writes](https://charmhub.io/postgresql-test-app/actions#clear-continuous-writes)
* [run-sql](https://charmhub.io/postgresql-test-app/actions#run-sql)
* [show-continuous-writes](https://charmhub.io/postgresql-test-app/actions#show-continuous-writes)
* [start-continuous-writes](https://charmhub.io/postgresql-test-app/actions#start-continuous-writes)
* [stop-continuous-writes](https://charmhub.io/postgresql-test-app/actions#stop-continuous-writes)
* [test-tls](https://charmhub.io/postgresql-test-app/actions#test-tls)

[Learn about actions >](https://juju.is/docs/juju/action)

* clear-continuous-writes

  Clear the written data.
* run-sql

  Runs a given sql command on the backend database.

  Params

  + dbname
    string

    database on which to run the command
  + query
    string

    query to run
  + readonly
    boolean

    whether or not to use the readonly endpoint
  + relation-name
    string

    name of the relation under test

  Required

  dbname,
  query,
  relation-name
* show-continuous-writes

  Show continuous writes.
* start-continuous-writes

  Start continuous writes.
* stop-continuous-writes

  Stop continuous writes.
* test-tls

  Checks if TLS is enabled on the backend database.

  Params

  + dbname
    string

    database on which to run the command
  + readonly
    boolean

    whether or not to use the readonly endpoint
  + relation-name
    string

    name of the relation under test

  Required

  dbname,
  relation-name