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