SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-12-2008, 08:39 AM
| ||||
| ||||
 pg_comparator table diff/sync Is pg_comparator the only project out there that does what it does? I tried patching it, and it seems OK, but I'm not terribly confident in my patch. I'm hoping someone will tell me there's a great table- driven rsync out there that everyone uses and I just don't know about. http://pgfoundry.org/tracker/index.p...037 &atid=232      |
|
04-12-2008, 08:41 AM
| |||
| |||
| Re: pg_comparator table diff/sync On May 11, 1:16 pm, "Erik 2.0" <e...@q32.com> wrote: > Is pg_comparator the only project out there that does what it does? I > tried patching it, and it seems OK, but I'm not terribly confident in > my patch. I'm hoping someone will tell me there's a great table- > driven rsync out there that everyone uses and I just don't know > about. Slony? But perhaps I'm not understanding what pg_comparator does. Andrew |
|
04-12-2008, 08:41 AM
| |||
| |||
| Re: pg_comparator table diff/sync hello I didn't test it, but maybe it is what you are finding http://pgfoundry.org/projects/apgdiff regards Pavel Stehule 14 May 2007 11:11:08 -0700, Andrew Hammond <andrew.george.hammond@gmail.com>: > On May 11, 1:16 pm, "Erik 2.0" <e...@q32.com> wrote: > > Is pg_comparator the only project out there that does what it does? I > > tried patching it, and it seems OK, but I'm not terribly confident in > > my patch. I'm hoping someone will tell me there's a great table- > > driven rsync out there that everyone uses and I just don't know > > about. > > Slony? But perhaps I'm not understanding what pg_comparator does. > > Andrew > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
|
04-12-2008, 08:42 AM
| |||
| |||
| Re: pg_comparator table diff/sync > On May 11, 1:16 pm, "Erik 2.0" <e...@q32.com> wrote: >> Is pg_comparator the only project out there that does what it does? I >> tried patching it, and it seems OK, but I'm not terribly confident in >> my patch. I'm hoping someone will tell me there's a great table- >> driven rsync out there that everyone uses and I just don't know >> about. > > Slony? But perhaps I'm not understanding what pg_comparator does. Erik was talking about <http://pgfoundry.org/projects/pg-comparator/> It just compares table contents (not schema), to point out differing tuples in two remote locations. Next step is to use the information to generate the appropriate insert/update/delete statements to resynchronize the tables, if they are out of sync for some reason and you do not want to dump/restore the whole stuff. -- Fabien. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |
|
04-12-2008, 08:44 AM
| ||||
| ||||
| Re: pg_comparator table diff/sync Erik Aronesty wrote: > > Is pg_comparator the only project out there that does what it does? > http://www.sqlmanager.net/en/product...sql/dbcomparer http://www.sqlmanager.net/en/product...sql/dbcomparer http://pgdiff.sourceforge.net/ http://pgdiff.sourceforge.net/ http://apgdiff.sourceforge.net/ http://apgdiff.sourceforge.net/ -- View this message in context: http://www.nabble.com/pg_comparator-...html#a10636792 Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate |
 |
« Interaction of PITR backups and Bulk operations avoiding WAL
|
Windows Vista support (Buildfarm Vaquita) »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 06:32 PM.
