> For the complete documentation index, see [llms.txt](https://learn.capstorm.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.capstorm.com/reference/main-tab/postgresql-connection.md).

# PostgreSQL Connection

## Initial Steps

Prior to running CopyStorm for the first time, create a fresh PostgreSQL database.

## Connection String

The only complicated configuration required in the CopyStorm Main tab is the PostgreSQL connection string. Clicking on the Connection String Builder button will open a form that will construct the connection string for you, given database information.

The general form of a PostgreSQL connection string is:

* `[//host[:port]][/database-name]`

Example:

* `//localhost/CopystormBackupDatabase`

By default, a PostgreSQL connection will use the public schema. This can be overridden by entering a schema name.

The following is a screen shot of a working PostgreSQL setup on one of our test computers:

![](https://4057376488-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsbSqfKw3vSfr8qwXao4j%2Fuploads%2Fgit-blob-3adf864f586e9b2ce2911b4b4fa7bea5b9bf2a2c%2F048d44c7-Postgres-Configuration.png?alt=media)