Re: [GENERAL] db replication
On Fri, Jun 29, 2007 at 03:42:32PM +0100, andrew quaresma wrote: hi.. i developing an aplication with a postgresql+postgis... i need to replicate the database to various pda, as well as insure the synchronization between all repliques... can someone with experience tell me what is the best free solution to my problem?... AFAIK there isn't one. PDA replication requires disconnected multimaster asynchronous replication, and I don't know of a project that has delivered that yet. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] db replication
andrew quaresma wrote: i developing an aplication with a postgresql+postgis... i need to replicate the database to various pda, as well as insure the synchronization between all repliques... can someone with experience tell me what is the best free solution to my problem?... There is hardly experience with this out, as it does not exist :) You might abuse dblink or slony to hack that. -- Best regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL] DB replication
Hi, We have an application which has databases in 2 different machines. The databases are small (25 MB). Every 15 minutes we want DB of one machine to be synced with another machine. Are there ready made utilities in postgres to do this. One way is to take a pgdump, tar it, ftp it and then restore it into the other machine. This has a problem if I want to sync selected tables. Also this means the entire data gets reloaded, whereas only the incremental changes should get dumped. Any help is appreciated. Murali Differentiated Software Solutions Pvt. Ltd., 176, Gr. Floor, 6th Main 2nd Block RT Nagar Bangalore - 560 032 India Ph: 91 80 3431470 email : diffs+AEA-vsnl.com http://www.diffs-india.com
Re: [GENERAL] DB replication
I've had the same question, I believe the best it gets will be something like running rsync over an encrypted (if needed for security) tunnel (ssh). But you'll have to user some dump utility as far as I know. Cheers Wim. - Oorspronkelijk bericht - Van: Differentiated Software Solutions Pvt. Ltd. +ADw-diffs+AEA-vsnl.com+AD4- Aan: +ADw-pgsql-general+AEA-postgresql.org+AD4- Verzonden: Friday, March 24, 2000 9:19 AM Onderwerp: +AFs-GENERAL+AF0- DB replication +AD4- Hi, +AD4- +AD4- We have an application which has databases in 2 different machines. +AD4- The databases are small (25 MB). +AD4- +AD4- Every 15 minutes we want DB of one machine to be synced with another +AD4- machine. Are there ready made utilities in postgres to do this. +AD4- One way is to take a pgdump, tar it, ftp it and then restore it into the +AD4- other machine. +AD4- This has a problem if I want to sync selected tables. Also this means the +AD4- entire data gets reloaded, whereas only the incremental changes should get +AD4- dumped. +AD4- +AD4- Any help is appreciated. +AD4- +AD4- Murali +AD4- +AD4- Differentiated Software Solutions Pvt. Ltd., +AD4- 176, Gr. Floor, 6th Main +AD4- 2nd Block RT Nagar +AD4- Bangalore - 560 032 +AD4- India +AD4- Ph: 91 80 3431470 +AD4- email : diffs+AEA-vsnl.com +AD4- http://www.diffs-india.com +AD4-
Re: [GENERAL] DB replication
I'd recommend changing the structure of your tables, adding a record_added field, and then do a SELECT * FROM table WHERE record_added CURRENT_TIMESTAMP - '15min' ::datetime and having a PERL program pipe the results of the select into the other database using DBI with two connections. BTW: The SELECT statement above probably doesn't work, as I can never remember the time functions/macros. It should give you the general idea though. At 04:19 AM 3/24/00, Differentiated Software Solutions Pvt. Ltd. wrote: Hi, We have an application which has databases in 2 different machines. The databases are small (25 MB). Every 15 minutes we want DB of one machine to be synced with another machine. Are there ready made utilities in postgres to do this. One way is to take a pgdump, tar it, ftp it and then restore it into the other machine. This has a problem if I want to sync selected tables. Also this means the entire data gets reloaded, whereas only the incremental changes should get dumped. Any help is appreciated. Murali Differentiated Software Solutions Pvt. Ltd., 176, Gr. Floor, 6th Main 2nd Block RT Nagar Bangalore - 560 032 India Ph: 91 80 3431470 email : diffs+AEA-vsnl.com http://www.diffs-india.com