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

WAL archiving question

From: Debanjan Bhattacharyya <b(dot)debanjan(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: WAL archiving question
Date: 2012-03-22 12:28:35
Message-ID: CAGaAm6AhGFD1sZCwcna_ssQ9mXGP9A0v89VAxqEnQHaft11GCw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi
I have two queries on WAL archiving.
I am using Postgres 8.2 and I have successfully setup a primary
hot-standy (with continuous recovery from WAL files) db pair.

I want to find the time stamp and name of last WAL archive applied by
the HOT standby db in continuous recovery mode.
I also need to find out if currently the recovery is held up because
the standby db is missing a archive

I have gone through the documentations and could not find the
information on how to find the above information from the standby db.
Can you please guide me as to where I can find this information or
post this question?

Thanks
Regards
Debanjan Bhattacharyya

Responses

pgsql-admin by date

Next:From: Paul WoutersDate: 2012-03-22 13:54:36
Subject: pg_dump: schema with OID 145167 does not exist
Previous:From: Reinhard AsmusDate: 2012-03-22 10:24:30
Subject: Re: german sort is wrong

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