> For the complete documentation index, see [llms.txt](https://docs.stacksync.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.stacksync.com/connectors/postgres/authorize-postgres.md).

# Authorize Postgres

Authenticate your Postgres app and sync data with Stacksync

You can also watch a quick video on how to authorize Postgres

{% embed url="<https://youtu.be/J4Q09Vt57h8>" %}

## Adding Credentials to Stacksync

#### 1. Select Postgres in the Create Sync page in Stacksync.

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-3ab88a0793c4ca8914b403a6ed1959a9111fc022%2FScreenshot%202023-02-12%20215720.png?alt=media" alt=""><figcaption></figcaption></figure>

#### 2. Add your Postgres credentials as Connection String or as Parameters.

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-ced55d95266c93bc6330b89c7b7e414b587293a3%2FScreenshot%202023-02-12%20215735.png?alt=media" alt=""><figcaption></figcaption></figure>

#### 3. (Optional) Upload your SSL Root Certificate file

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-9f5900970125d00a04935a3cbb7eda306bb349c1%2FScreenshot%202023-02-12%20220102.png?alt=media" alt=""><figcaption></figcaption></figure>

#### 4. (Optional) Add SSH user and SSH host

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-9c24e1afac1161bc8e38e8e23c72bac75684c943%2FScreenshot%202023-02-12%20215809.png?alt=media" alt=""><figcaption></figcaption></figure>

#### 5. Click "Authorize App"

<figure><img src="https://3057949906-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDSqHwwR8lD3JUWz3E9NH%2Fuploads%2Fgit-blob-2167b5eb5d9915e01f8e4c45d255fd3991d0f879%2FScreenshot%202023-02-12%20215822.png?alt=media" alt=""><figcaption><p>Click "Authorize App"</p></figcaption></figure>