473,386 Members | 1,799 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

How to synchronize data from Postgre to cache

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
5 4051
rski
700 Expert 512MB
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
prajiv
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
rski
700 Expert 512MB
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
prajiv
3
Thanx for the reply if u cm 2 knw any such trigger or DB link let me asap
Jan 30 '08 #5
rski
700 Expert 512MB
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

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

Similar topics

4
by: projecktzero | last post by:
Well, I've managed to get an image into a postgre database, but now I'm having trouble getting it out. #! /usr/bin/env python from pyPgSQL import PgSQL def main(): connectdb =...
4
by: gene.ellis | last post by:
Using a web interface, I am placing text into a SQL database. From time to time, I would like to synchronize one of my other tables in the database with the table that I am inserting content into....
0
by: Cláudia Morgado | last post by:
Hello! We working currently with the Oracle and we would like to know if postgresql has some similar components as the concept of instance, buffer database cache, Redo log buffer, datafiles,...
1
by: Hewit | last post by:
DataTable Class documentation says. Thread Safety "This type is safe for multithreaded read operations. You must synchronize any write operations." In my web based application (ASP.Net)...
9
by: Leslie Coover | last post by:
http://finance.yahoo.com/ offers a wide range of financial data. Would anyone have (or know where I can get) a sample of code that
14
Sakalicek
by: Sakalicek | last post by:
Hi all, could you please help me with my big problem? I have WebService on IIS. This WebService has methods to control database stored on server. I am using Postgre database and to access to...
1
by: nilart | last post by:
Hi, I have an installer application (Installshield) which installs postgre DB programmatically on windows: I have a requirement where postgre DB is expected work after upgrading OS from windows XP...
1
by: baishali | last post by:
Hi i want to transfer the data's from SQL server to Postgre or Oracle or Cache
1
by: lion cave | last post by:
hi, I'm using postgreSQL and php. I am assigned for migration of data of database. I would like to ask a help if how to migrate the data from the Postgre 8.0 to the Postgre 8.3. Is there...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.