Google Cloud SQL
If you are not using Logical Replication (CDC), you can skip this section. Instead, follow the standard PostgreSQL setup guide.
PostgreSQL (version 9.4 and above) supports logical replication by writing additional information to its Write Ahead Logs (WALs).
The configuration process consists of two stages:
- Enable write ahead logs (WAL) - Configure database flags to enable logical replication.
- Allowlist Renta IP addresses - Grant network access to Renta to connect to your database.
Allowlist Renta IP addresses
Add Renta IP addresses to the authorized networks to allow connections to your database.
- Log in to Google Cloud SQL console.
- In the Instances list, find your PostgreSQL instance.
- Click the three dots menu (⋮) next to your instance.
- Select Edit from the dropdown menu.

- On the Edit instance page, scroll down to the Connections section.
- Ensure Public IP is enabled (it should be checked).
- Under Authorized networks, you'll see existing IP ranges if any are configured.

- Click Add a network button.
- In the Name field, enter a descriptive name (for example, "Renta / EU").
- In the IP range field, enter one of the Renta IP addresses in CIDR notation (for example,
34.91.34.151). - Use CIDR notation example:
199.27.28.0/24. - Repeat steps 1-3 for each Renta IP address you need to add.
- Click Done to close the network dialog.

- Scroll down to the bottom of the Edit instance page.
- Click Save to apply the changes.
- The instance will update its configuration without requiring a restart.
- Once saved, Renta will be able to connect to your database using the allowlisted IP addresses.
Network access is now configured! Next, you'll need to enable write ahead logs (WAL) to allow logical replication.

Configure Google Cloud SQL
Perform the following steps to configure your Google Cloud PostgreSQL Source.
- Log in to Google Cloud SQL to access your database instance.
- Click the More (three dots) icon next to the PostgreSQL instance and click Edit.

- Scroll down to the Flags and parameters section.
- Click Add a database flag.
- Search for and add the following flags with the specified values:
| Flag name | Value | Description |
|---|---|---|
| cloudsql.enable_pglogical | On | Enables the pglogical extension. Default: On. |
| cloudsql.logical_decoding | On | Enables logical replication. Default: On. |
| max_replication_slots | 10 | The number of clients that can connect to the server. |
| max_wal_senders | 10 | The number of processes that can simultaneously transmit the WAL log. |
| wal_sender_timeout | 0 | The time in seconds to terminate replication connections due to inactivity. Set to 0 to prevent termination. |

- Click Save.
- In the confirmation dialog, click Save and restart.
- Once the instance restarts, you can view the configured settings under the Flags and parameters section.

Next steps
Now that you have configured your Google Cloud SQL instance, you can proceed to create a pipeline in Renta.
Ready to get started?
Build your data pipeline today or get a personalized demo. Start free!
Need help?
Get expert support to ensure your project succeeds. We're here to help!
Feature requests?
Help shape our product! Share your ideas for new features and integrations.