> 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/two-way-sync/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://2867423571-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfJjIdV9cuW6K8asJjTPJ%2Fuploads%2FuzAJL1Zb5sHTEm3Q56r5%2FScreenshot%202023-02-12%20215720.png?alt=media&amp;token=c9a683e7-c139-43b3-bfe5-63545d4d4084" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://2867423571-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfJjIdV9cuW6K8asJjTPJ%2Fuploads%2FsKcKeg1OGfOA90pWUh4l%2FScreenshot%202023-02-12%20215735.png?alt=media&amp;token=f036be88-72ce-42b9-9f0c-acc043b150dc" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://2867423571-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfJjIdV9cuW6K8asJjTPJ%2Fuploads%2FdrT0lfm7vqMvDYHzIi4O%2FScreenshot%202023-02-12%20220102.png?alt=media&amp;token=78a41ccd-6651-485e-8e10-8b483d8ee40d" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://2867423571-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfJjIdV9cuW6K8asJjTPJ%2Fuploads%2FS4VnyMtAnTvBBrilIEYI%2FScreenshot%202023-02-12%20215809.png?alt=media&amp;token=ca764be1-b87e-4747-ac0b-f44566150b99" alt=""><figcaption></figcaption></figure>

#### 5. Click "Authorize App"

<figure><img src="https://2867423571-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfJjIdV9cuW6K8asJjTPJ%2Fuploads%2FgF9zyF2DqzwlSaZ9jZAJ%2FScreenshot%202023-02-12%20215822.png?alt=media&amp;token=00c78a9d-70c5-4bc3-9f1e-f57fad369c9b" alt=""><figcaption><p>Click "Authorize App"</p></figcaption></figure>