Replicate data with Stacksync

Neon's logical replication feature allows you to replicate data from your Neon Postgres database to external destinations.

Stacksync connects databases with CRMs, ERPs, and other systems using real-time, two-way sync. In this guide, you will configure Stacksync to replicate data from your Neon Postgres database to a supported destination.

Prerequisites

• A Stacksync account
• A Neon account
• Read the important notices about logical replication in Neon before you begin

Prepare your Neon database

Enable logical replication in Neon

To enable logical replication in Neon:

1. Select your project in the Neon Console.
2. On the Neon Dashboard, select Settings.
3. Select Logical Replication.
4. Click Enable to enable logical replication.

You can verify that logical replication is enabled by running the following query from the Neon SQL Editor:

SHOW wal_level;
 wal_level
-----------
 logical

Create a Postgres role for replication

It is recommended that you create a dedicated Postgres role for replicating data. The role must have the REPLICATION privilege. The default Postgres role created with your Neon project and roles created using the Neon CLI, Console, or API are granted membership in the neon_superuser role, which has the required REPLICATION privilege.

neon roles create --name replication_user

Grant schema access to your Postgres role

If your replication role does not own the schemas and tables you are replicating from, make sure to grant access. For example, the following commands grant access to all tables in the public schema to Postgres role replication_user:

GRANT USAGE ON SCHEMA public TO replication_user;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO replication_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO replication_user;

Granting SELECT ON ALL TABLES IN SCHEMA instead of naming the specific tables avoids having to add privileges later if you add tables to your publication.

Create a publication

Create the Postgres publication. Include all tables you want to replicate as part of the publication:

CREATE PUBLICATION stacksync_pub FOR TABLE <tbl1, tbl2, tbl3>;

The publication name is customizable. Refer to the Postgres docs if you need to add or remove tables from your publication.

Create a Postgres connection in Stacksync

1. Log in to your Stacksync account.

2. On the All Resources page, click Create Resource.

3. Under Jump right in, create a resource, click Connections.

4. Select Postgres.

5. Enter your Neon database connection details. Click Connect on your Project Dashboard, select the replication role you created earlier (not the default neondb_owner role), and click Copy snippet. Use a direct connection string; the hostname must not include -pooler. Logical replication is not compatible with connection poolers.

6. If you have disabled Allow traffic via the public internet under Networking in Neon's Settings, select I confirm I have allowlisted these Stacksync IPs on my side in Stacksync, and copy the IP addresses into your trusted IP addresses in Neon's settings under Networking.

7. In Stacksync, click Next.

8. Enter a name for Connection Name.

9. Click Create.

Create a connection to your destination in Stacksync

Skip this step if you already have a destination connection configured in Stacksync.

1. Log in to your Stacksync account.

2. On the All Resources page, click Create Resource.

3. Under Jump right in, create a resource, click Connections.

4. Select the connector for your destination from one of Stacksync's connectors.

5. Follow the prompt in the Configure connection popup.

6. If you have disabled public internet access in Neon, allowlist the Stacksync IPs as described in the Create a Postgres connection in Stacksync section above.

7. In Stacksync, click Next.

8. Enter a name for Connection Name.

9. Click Create.

   tip

   There are in-depth connection setup guides on Stacksync's connector docs.

Create a sync

Skip this step if you already have a sync configured.

1. Log in to your Stacksync account.

2. On the All Resources page, click Create Resource.

3. Under Jump right in, create a resource, click Syncs.

4. Enter a Sync Name.

5. Select Postgres and choose the saved connection you created in the Create a Postgres connection in Stacksync section.

6. On the schema screen, click the Postgres connection and select Logical replication under Change Data Capture Method.

   

7. Click one of the apps you have created a connection for in the Create a connection to your destination in Stacksync section.

8. Click Link Tables.

9. Select a table you would like to sync under Postgres.

10. Select a table you would like to sync the data to under your destination.

11. Select if you would like the sync to be one-way or two-way.

12. Repeat from the previous step for any additional tables you would like to link.

13. Click Map Columns to configure which columns to sync and the sync direction for each. Stacksync auto-maps columns by default; select or deselect columns as needed. See Stacksync's two-way sync docs for details on field selection and sync direction.

14. Click Create.

15. On the next page, turn on the sync by clicking the toggle in the top right.

16. Optionally, update the Data sync frequency under Settings.

References

• Stacksync Generic PostgreSQL Setup Guide