Search Postgresql Archives

Re: Sync 2 tables in 2 databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> > Hi,
> > I have 2 postgres databases with similar structure. I
> want to keep some tables in sync in these 2 databases(They
> can be synced just once a day). Is there a way to archive
> this using function ?
> > Something like....
> >
> >  Select syncTable('foo')
> >
> > where syncTable is a function that compares table
> 'foo' in db1 with table 'foo' in db2 and make
> changes(update/insert/delete) to 'foo' in db1
> 
> You can either truncate it on the destination db every so
> often, then
> dump / restore the data back into it, drop it and restore
> it, write a
> simple replication script that looks for missing  /
> updated rows, or
> my suggestion, set up replication with slony and be done
> with it.  Of
> course, you don't mention if you need one or two way
> synchronization,
> which makes a big difference in how you choose to do
> things.
> 

Also, Is there a way to archive this using dbi_link? In Oracle I do this using db_link..is it possible to get this done using postgres' dbi_link?


      

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux