Connecting to Neon

Open your project in the Neon console.

From the Neon Dashboard, navigate to the Project settings section.

Within Project Settings, locate the Beta section.

Click on the Enable button to activate logical replication.

In the Sequin Console, click on the Connect Database button and enter the following details for your Neon database:

You can find these connection details in your Neon project dashboard under the “Connection details” section:

• Host: Your Neon host (e.g., ep-cool-snow-123456.us-east-2.aws.neon.tech)
• Port: 5432 (default Postgres port)
• Database: Your database name
• Username: Your Neon username
• Password: Your Neon password

Make sure to enable the SSL option for secure connection.

Use the SQL Editor in your Neon project to execute the following SQL query to create a replication slot:

SELECT pg_create_logical_replication_slot('sequin_slot', 'pgoutput');

This creates a replication slot named sequin_slot.

Next, create a publication to indicate which tables will publish changes to the replication slot. Run the following SQL command:

CREATE PUBLICATION sequin_pub FOR TABLE table1, table2, table3;

If you want to publish changes from all tables, you can use:

CREATE PUBLICATION sequin_pub FOR ALL TABLES;

Back in the Sequin Console, enter the name of the replication slot (e.g. sequin_slot) and publication (e.g. sequin_pub) you just created. Then, name your database and click Create Database.