By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,117 Members | 1,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,117 IT Pros & Developers. It's quick & easy.

How to synchronize data from Postgre to cache

P: 3
Hi,
Pls guide me in synchronizing data from PostGre to Cache. i.e if we update in one database the other database must automatically get updated.I dont want to use the Tool ,I need the code for it 2 update from Postgre or from cache.
Jan 25 '08 #1
Share this Question
Share on Google+
5 Replies


Expert 100+
P: 700
Hi,
Pls guide me in synchronizing data from PostGre to Cache. i.e if we update in one database the other database must automatically get updated.I dont want to use the Tool ,I need the code for it 2 update from Postgre or from cache.
What do you mean saying 'database update', changing data in tables or also creating, deleting, altering objects?
Jan 25 '08 #2

P: 3
What do you mean saying 'database update', changing data in tables or also creating, deleting, altering objects?
I meant if u change or update any record it must get updated automatically in other database ...this means changing or updating data in one table it must get changed or updated dynamically ,I Dont want to use TOOL, I need CODE( for linking / synchronization) ...I want this to happen from POSTGRES to CACHE or viceversa
Kindly help me out in this asap
Jan 28 '08 #3

Expert 100+
P: 700
I meant if u change or update any record it must get updated automatically in other database ...this means changing or updating data in one table it must get changed or updated dynamically ,I Dont want to use TOOL, I need CODE( for linking / synchronization) ...I want this to happen from POSTGRES to CACHE or viceversa
Kindly help me out in this asap
i'm not sure maybe some triggers and dblink module will be needed.
Jan 29 '08 #4

P: 3
Thanx for the reply if u cm 2 knw any such trigger or DB link let me asap
Jan 30 '08 #5

Expert 100+
P: 700
Thanx for the reply if u cm 2 knw any such trigger or DB link let me asap
dblink is a postgres module you can find in contrib directory (in the postgres sources ).
Trigger you must write by your self. If you would be more specific about your problem maybe i would be able to help you.
Jan 30 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.