On Mittwoch, 27. Februar 2008 salman wrote:
> archive_command = 'gzip %p; rsync -av %p.gz -e \"ssh -p portNum -i
> /home/postgres/.ssh/id_dsa\"
> [EMAIL PROTECTED]:/usr/local/postgresql/archives/recovery/%f.gz &&
> rm -f %p.gz'
This works as long as there are no transmission errors. What can be do
libra dba wrote:
Hey Salman,
Thanks a lot for all your guidance and help. It has really been a great
help. I appreciate your quick replies.
Which replication in postgres is better ?
SLONY or WARM STANDBY (usning wal).
I use both. Between our two production machines, we replicate data with
Hey Salman,
Thanks a lot for all your guidance and help. It has really been a great
help. I appreciate your quick replies.
Which replication in postgres is better ?
SLONY or WARM STANDBY (usning wal).
Another thing which haunts me is that, if we have a warm standby, the
recovery process on the
continuing with the postgres replication using WARM STANDBY, what happens to
the wal_files which keeps on generating on the primary?
Do we have to manually remove them or they are removed automatically, once
they have been recovered on the warm standby?
Also a quick question, do we have to have a
libra dba wrote:
continuing with the postgres replication using WARM STANDBY, what happens to
the wal_files which keeps on generating on the primary?
Do we have to manually remove them or they are removed automatically, once
they have been recovered on the warm standby?
Also a quick question,
thank you all!
On Feb 19, 2008 10:56 AM, salman <[EMAIL PROTECTED]> wrote:
>
>
> libra dba wrote:
> > Hello all,
> >
> > Thanks for your response. The example shown by Charles Duffy, is quite
> > impressive. Actually i built my replication based on this.
> >
> > But, i want to test the failover.
libra dba wrote:
Hello all,
Thanks for your response. The example shown by Charles Duffy, is quite
impressive. Actually i built my replication based on this.
But, i want to test the failover. In the example shown by Charles, mentions
'a trigger file' as it says:
--
Hello all,
Thanks for your response. The example shown by Charles Duffy, is quite
impressive. Actually i built my replication based on this.
But, i want to test the failover. In the example shown by Charles, mentions
'a trigger file' as it says:
---
On Tue, 2008-02-19 at 09:53 +0530, Praveen Kumar (TUV) wrote:
> Go through this below mentioned link
>
>
>
> http://archives.postgresql.org/sydpug/2006-10/msg1.php
I think people should be reading the manual, rather than reading an old
email. We have improved and corrected the manual, but
the Primary database and starting the
standby database in Postgresql in PITR configuraiton?
Hello all,
I am new to postgresql. i am working on the PITR replication system. I
have successfully implemented the standby database. I have tested the
log shipment and the recovery process on the
Hello all,
I am new to postgresql. i am working on the PITR replication system. I have
successfully implemented the standby database. I have tested the log
shipment and the recovery process on the standby. everything is workign
fine.
Please guide me how to bring the standby database in open mode
11 matches
Mail list logo