Heroku is a popular platform for hosting web applications and databases. Heroku takes care of the details of infrastructure management so you can focus on building your app.
postgresql-addon-name
with the name of your Heroku Postgres add on. You can find this name by running the pg:info command.sequin_user
was created by running the pg:credentials CLI command:
sequin_user
was created, you’ll need to grant the proper permissions to the user using the pg:psql
CLI command and standard postgres permission grants:
password
, host
, database
, and port
) for the sequin_user
by running the pg:credentials:url CLI command:
sequin_user
for the Credential Name and click Create. It may take a couple minutes for Heroku to create the user:
sequin_user
is created, you’ll see it appear on the credentials page. Now, grant the sequin_user
the proper permissions using the Heroku CLI (as described in Step 3 of the Heroku CLI instructions above) or by connecting to the database using another Postgres client (e.g. Postico) and running the following SQL:
user
, password
, host
, database
, and port
values for the sequin_user
credential. You’ll need these to connect Sequin to your Heroku Postgres database:
sequin_user
created, you can now connect Sequin to your Heroku Postgres database.
Step 1: Begin to create a new sync in the Sequin console (if you need more instruction, check out one of our step-by-step guides). After connecting your source and selecting the data you want to include in your sync, you’ll be prompted to connect your destination. Click Launch or Connect and choose Connect to start a new connection to your Heroku database.
Step 2: On the screen that appears, enter the host
and port
that you noted down for your Heroku Postgres database and click the Continue button.
Step 3: On the next page, click the Setup manually instead option. Since you’ve already created the Heroku user in the steps above, skip the instructions and scroll down to enter the database
, user
, and password
that you noted for thesequin_user
credential you created. Make sure you’ve checked Use SSL, then click the Verify & Setup button: