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
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
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
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
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: