See Stacksync in action with a solution architect. Book a demo ↗

Postgres Authorize Postgres

Heroku

Find your Postgres Heroku connection string

For Heroku, use the "Postgres Heroku" connector.

1. Go to https://dashboard.heroku.com/apps

2. Open one of your apps

Heroku dashboard apps list with the app "postgres112345" highlighted.

3. Open your database add-on

Heroku app Overview tab with the installed "Heroku Postgres" Mini add-on highlighted.

4. Go to settings and view Database credentials

Heroku Postgres datastore with the "Settings" tab (1) and the "View Credentials..." button (2) highlighted.

5. Copy Connection URI

Heroku Postgres Database Credentials showing host, database, user, port and password, with the masked postgres:// URI highlighted.

6. Paste the connection URI into Stacksync to connect your database

Stacksync Postgres Heroku connection dialog with the "Connection String" field and "Authorize App" button highlighted. — Paste your connection URL to connect your database

For the Heroku connector, the user is required to have the Create privilege on the database.

This privilege can be enabled for the user using the following SQL query:

GRANT CREATE ON DATABASE database_name TO user_name;

Finally, click "Authorize App" to connect!

That's it, your Postgres Heroku instance is connected! 🎉

Digital Ocean

Connect a Postgres hosted on Digital Ocean

Amazon Lightsail

Find the connection credentials for your Amazon Lightsail Database.

On this page

1. Go to https://dashboard.heroku.com/apps 2. Open one of your apps 3. Open your database add-on 4. Go to settings and view Database credentials 5. Copy Connection URI 6. Paste the connection URI into Stacksync to connect your database