Skip site navigation (1) Skip section navigation (2)

Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?

From: "libra dba" <libra(dot)dba(at)gmail(dot)com>
To: salman <salmanb(at)quietcaresystems(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
Date: 2008-02-27 20:54:07
Message-ID: 9abe84da0802271254j3a6463c8j7ccbe603bcdbf477@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(dot)dba(at)gmail(dot)com> wrote:

> thank you all!
>
>
> On Feb 19, 2008 10:56 AM, salman <salmanb(at)quietcaresystems(dot)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
> >
>
>

In response to

Responses

pgsql-admin by date

Next:From: salmanDate: 2008-02-27 21:05:47
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
Previous:From: LewDate: 2008-02-27 16:57:49
Subject: Re: how do I get table DDL from psql (not from pg_dump)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group