Documentation

PostgreSQL Integration

Alooma can replicate tables from your PostgreSQL database hosted on Heroku, Amazon RDS, or self-hosted to your data destination in near real time.

This enables you to, for example, combine your PostgreSQL data with other data sources such as mobile and web user analytics to make it even more valuable.

Alooma provides three supported replication options for PostreSQL databases: full dump/load, incremental, and log replication (CDC). Learn more about choosing the right replication method for your data..

Integrate your PostgreSQL database with Alooma via these simple steps:

  1. Configure Hot Standby if you are using Postgres on RDS with incremental or full dump/load replication. See below.

  2. Verify your Heroku configuration (incremental or full dump/load replication on Postgres on Heroku only). See below.

  3. Configure your replication type if you're using CDC on RDS or CDC on self-hosted Postgres. For full dump/load or incremental replication, you can go directly to configuring the input.

  4. Configure the input. That's it!

Configure Hot Standby

You only need to configure Hot Standby if your PostgreSQL is hosted on RDS and you're using incremental or full dump/load replication:

For PostgreSQL on RDS with incremental or full dump/load replication:

  1. On the RDS dashboard under Parameter Groups, navigate to the group that's associated with your instance.

  2. Verify that hot_standby and hot_standby_feedback are set to 1.

  3. Verify that max_standby_archive_delay and max_standby_streaming_delay are greater than 0 (we recommend 30000).

  4. If any of the parameter values need to be changed, click Edit Parameters.

Verify Heroku configuration (if necessary)

For PostgreSQL on Heroku the default configuration is sufficient.

You can choose to verify the configuration with these steps:

  1. Go to https://data.heroku.com/ and choose the relevant datastore.

  2. On the datastore page, click on View Credentials... and use the credentials provided to login to your PostgreSQL instance.

  3. Make sure that all the parameters are well configured. Use the following queries: 

    <your hostname>::DATABASE=> SHOW hot_standby;

    The value should be "on"

    <your hostname>::DATABASE=> SHOW hot_standby_feedback;;

    The value should be "on"

That's it! You're ready to move on to configuring replication: for full dump/load or incremental replication, go to configuring the input.

Search results

    No results found