| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Pascal Robert" <probert(at)os(dot)ca> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Finding time in WAL logs |
| Date: | 2007-04-25 15:43:09 |
| Message-ID: | 1177515789.20637.160.camel@silverbirch.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 2007-04-25 at 11:28 -0400, Pascal Robert wrote:
> I'm writing our backup procedure for using WAL and PITR, but to be
> able to do a (mostly) perfect PITR, I need to find the time when a
> error (DELETE FROM, DROP TABLE, etc.) was made so that I can do a
> restore just before the error.
>
> Does PostgreSQL has something similar to "mysqlbinlog" so that I can
> look at the content of a WAL archive ? I tried enabling
> "log_min_messages" at "info" level, but it doesn't log the date and
> time of a executed statement, so that's not a solution.
http://pgfoundry.org/projects/xlogviewer/
I'd appreciate some feedback. I'll be looking to release a new version
within next few months.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pascal Robert | 2007-04-25 17:13:20 | Re: Finding time in WAL logs |
| Previous Message | Pascal Robert | 2007-04-25 15:28:49 | Finding time in WAL logs |