pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: libra dba <libra.dba@gmail.com>
To: salman <salmanb@quietcaresystems.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
Date: Wed, 27 Feb 2008 15:54:07 -0500
Message-ID: <9abe84da0802271254j3a6463c8j7ccbe603bcdbf477@mail.gmail.com> (raw)
In-Reply-To: <9abe84da0802200849w1f462558n270f4320a7465b6c@mail.gmail.com>
References: <84D57263D486374587DA0820E60A2CC601B07E23@srit_mail.renaissance-it.com>
	<1203409158.16770.821.camel@ebony.site>
	<9abe84da0802190623o2a24f2a5u9a44299fd634618e@mail.gmail.com>
	<47BAFC47.4060902@quietcaresystems.com>
	<9abe84da0802200849w1f462558n270f4320a7465b6c@mail.gmail.com>

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 NFS for the wal_files, which
will be mounted on both the servers, or we can have folders on each server
and configure DRBD between them, so that whatever happens on one is copied
automatically on to the other.

Thanks!

On Wed, Feb 20, 2008 at 11:49 AM, libra dba <libra.dba@gmail.com> wrote:

> thank you all!
>
>
> On Feb 19, 2008 10:56 AM, salman <salmanb@quietcaresystems.com> 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. In the example shown by Charles,
> > mentions
> > > 'a trigger file' as it says:
> > >
> > -------------------------------------------------------------------------------
> > > *touch ~/pg82demo/trigger*
> > > **
> > > *This should immediately cause the slave to finish processing archived
> > > segments, exit recovery mode, and come up ready for use.
> > > *
> > >
> > -------------------------------------------------------------------------------
> > > what shold be the content of the trigger file. How do we cause the
> > slave to
> > > finish the processing of the archived segments, exit the recovery mode
> > and
> > > come up ready for use???
> > >
> > > Please help in the the FAILOVER of the primary and promoting the slave
> > to
> > > the primary mode.
> > >
> >
> > It's an empty file -- doesn't have to have anything in it. The script
> > simply checks to see if the file exists, and if it does, the recovery
> > loop is stopped.
> >
> > -salman
> >
>
>

view thread (11+ messages)  latest in thread

Message-ID: <9abe84da0802271254j3a6463c8j7ccbe603bcdbf477@mail.gmail.com>
Permalink:  ../9abe84da0802271254j3a6463c8j7ccbe603bcdbf477@mail.gmail.com/
Also on:    postgresql.org/message-id/9abe84da0802271254j3a6463c8j7ccbe603bcdbf477@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: libra.dba@gmail.com, salmanb@quietcaresystems.com
  Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
  In-Reply-To: <9abe84da0802271254j3a6463c8j7ccbe603bcdbf477@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox