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

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 t

[GENERAL] db replication

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?... thanks... andy...

Re: [GENERAL] db replication and errors

Benjamin wrote: Thanx for the pointers, Richard. If the async feature is used on the primary, shud we copy on the xlog and clog files onto the backup as well? What is the "async feature"? I meant fsync. I meant to ask, if FSYNC is enabled, is all pending data written onto the disk? Yes. Turn it

Re: [GENERAL] db replication and errors

Thanx for the pointers, Richard. If the async feature is used on the primary, shud we copy on the xlog and clog files onto the backup as well? What is the "async feature"? I meant fsync. I meant to ask, if FSYNC is enabled, is all pending data written onto the disk? As of now, we shut down pos

Re: [GENERAL] db replication and errors

Benjamin wrote: Hello everyone, The scene : Currently, we r using, Postgresql v 7.3, on RedHat 9 machines. We provide a hot standby at all times for the Primary server. So, we have to maintain a duplicate of the entire database. The problem arises, when the standby boots. I wanted to know, whenev

[GENERAL] db replication and errors

Hello everyone, The scene : Currently, we r using, Postgresql v 7.3, on RedHat 9 machines. We provide a hot standby at all times for the Primary server. So, we have to maintain a duplicate of the entire database. The problem arises, when the standby boots. I wanted to know, whenever the standby b

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:

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

[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 resto