How to monitor postgresql database table for any changes via c#

Question

I have a windows service running which reads configurations from a table from PostgreSQL. These settings are read only once at the time of service startup and for any change in them, the service needs to be restarted. I am looking for a mechanism in C# to monitor any changes on database. So that I would then fetch back the settings on database change.

One approach I was looking for, is to write/modify a text file from PostgreSQL trigger and then use FileWatcher to update the settings. But no success there either.

postgresql.org/docs/9.3/static/libpq-notify.html

Mike Sherrill 'Cat Recall'
– Mike Sherrill 'Cat Recall'

2014-11-26 10:34:57 +00:00
Commented Nov 26, 2014 at 10:34 — Mike Sherrill 'Cat Recall'
– Mike Sherrill 'Cat Recall', Commented Nov 26, 2014 at 10:34
for .net check this: github.com/npgsql/npgsql/wiki/…

Frank Heikens
– Frank Heikens

2014-11-26 11:32:18 +00:00
Commented Nov 26, 2014 at 11:32 — Frank Heikens
– Frank Heikens, Commented Nov 26, 2014 at 11:32

Yogesh lele · Accepted Answer · 2014-11-27 10:08:56Z

4

First, I created a perpetual listening connection with command listen <channel_name> by referring npgsql documentation

Then I wrote a trigger that would fire command

PERFORM pg_notify('<channel_name>', format('Changed: %s ', NEW.column_name));

So any change on the particular database's table was captured by the trigger, which in turn sent the notification to the channel and the c# code listened and processed it

answered Nov 27, 2014 at 10:08

Yogesh lele

4125 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to monitor postgresql database table for any changes via c#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related