Re: Pulling data from Postgres DB table for every 5 seconds.

I am not familiar with Aurora, but.. What something like https://github.com/subzerocloud/pg-amqp-bridge? Set up a message queue in Postgres, which calls into AMPQ (RabbitMQ) to send a message for consumption by one or more clients. This provides a function that can be called from a trigger to

Re: Pulling data from Postgres DB table for every 5 seconds.

El 9/1/19 a las 20:22, Mark Fletcher escribió: > On Wed, Jan 9, 2019 at 12:58 PM github kran > wrote: > > > Mark - just curious to know on the logical replication. Do you think > I can use it for my use case where i need to publish data to a > subscriber

Re: Pulling data from Postgres DB table for every 5 seconds.

On Wed, Jan 9, 2019 at 12:26 PM Rob Sargent wrote: > > > On Jan 9, 2019, at 11:11 AM, github kran wrote: > > Rob - It's a Java based application. We dont have triggers yet on the > table and is trigger a only option in 9.6 version ?. > > On Wed, Jan 9, 2019 at 12:01 PM Rob Sargent wrote: >

Re: Pulling data from Postgres DB table for every 5 seconds.

On Wed, Jan 9, 2019 at 10:10 AM github kran 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

Re: Pulling data from Postgres DB table for every 5 seconds.

> On Jan 9, 2019, at 11:11 AM, github kran wrote: > > Rob - It's a Java based application. We dont have triggers yet on the table > and is trigger a only option in 9.6 version ?. > > On Wed, Jan 9, 2019 at 12:01 PM Rob Sargent > wrote: > > > On 1/9/19

Re: Pulling data from Postgres DB table for every 5 seconds.

Rob - It's a Java based application. We dont have triggers yet on the table and is trigger a only option in 9.6 version ?. On Wed, Jan 9, 2019 at 12:01 PM Rob Sargent wrote: > > On 1/9/19 10:21 AM, github kran wrote: > > Thanks for your reply Rob. Reading the below documentation link says the

Re: Pulling data from Postgres DB table for every 5 seconds.

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

Re: Pulling data from Postgres DB table for every 5 seconds.

On 1/9/19 10:21 AM, github kran wrote: Thanks for your reply Rob. Reading the below documentation link says the EVENT trigger is only supported for DDL commands. Is it not correct ?. _1) https://www.postgresql.org/docs/9.6/event-trigger-definition.html _ (An event trigger fires whenever the

Re: Pulling data from Postgres DB table for every 5 seconds.

On Wed, Jan 9, 2019 at 9:02 AM github kran wrote: > >> Hi Postgres Team, >> >> I have an application using RDS Aurora Postgresql 9.6 version having 4 TB >> of DB size. In this DB we have a table PRODUCT_INFO with around 1 million >> rows and table size of 1 GB. >> We are looking for a

Re: Pulling data from Postgres DB table for every 5 seconds.

Thanks for your reply Rob. Reading the below documentation link says the EVENT trigger is only supported for DDL commands. Is it not correct ?. *1) https://www.postgresql.org/docs/9.6/event-trigger-definition.html * (An event

Re: Pulling data from Postgres DB table for every 5 seconds.

On 1/9/19 11:02 AM, github kran wrote: Hi Postgres Team, I have an application using RDS Aurora Postgresql 9.6 version having 4 TB of DB size. In this DB we have a table PRODUCT_INFO with around  1 million rows and table size of 1 GB. We are looking for a implementation

Re: Pulling data from Postgres DB table for every 5 seconds.

> On Jan 9, 2019, at 10:02 AM, github kran wrote: > > > Hi Postgres Team, > > I have an application using RDS Aurora Postgresql 9.6 version having 4 TB of > DB size. In this DB we have a table PRODUCT_INFO with around 1 million rows > and table size of 1 GB. > We are looking for a

Re: Pulling data from Postgres DB table for every 5 seconds.

> > > Hi Postgres Team, > > I have an application using RDS Aurora Postgresql 9.6 version having 4 TB > of DB size. In this DB we have a table PRODUCT_INFO with around 1 million > rows and table size of 1 GB. > We are looking for a implementation where we want to pull the data in real > time for