Postgres Pro
Downloads
Home   >   mailing lists

Re: Pulling data from Postgres DB table for every 5 seconds. - Mailing list pgsql-general

From Mark Fletcher
Subject Re: Pulling data from Postgres DB table for every 5 seconds.
Date
Msg-id CAEO096r6WPTVkHPujM7p1qQTO0=cic534=JD7D33AT+0kEydMg@mail.gmail.com
Whole thread Raw
In response to Re: Pulling data from Postgres DB table for every 5 seconds.  (github kran <githubkran@gmail.com>)
Responses Re: Pulling data from Postgres DB table for every 5 seconds.
List pgsql-general
Tree view
On Wed, Jan 9, 2019 at 10:10 AM github kran <githubkran@gmail.com> wrote:
Mark - We are currently on 9.6 version of postgres and cant use this feature of logical replication.Answering to your question we are looking for any changes in the data related to a specific table ( changes like any update on a timestamp field
OR any new inserts happened in the last 5 seconds for a specific product entity). 
Any other alternatives ?.

The feature was added in 9.4 (I think). We are on 9.6 and it works great. Not sure about RDS Aurora, however.

Mark 

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Pulling data from Postgres DB table for every 5 seconds.
Next
From: Ron
Date:
Subject: Re: postgres operational