Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Finding time in WAL logs
- From: Pascal Robert <probert(at)os(dot)ca>
- To: pgsql-admin(at)postgresql(dot)org
- Subject: Finding time in WAL logs
- Date: Wed, 25 Apr 2007 11:28:49 -0400
Hi,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.
pgsql 8.2.4 on RedHat Linux ES 4
- Follow-Ups:
- Re: Finding time in WAL logs
- From: Robert Treat
- Re: Finding time in WAL logs
- From: Simon Riggs
- Re: Finding time in WAL logs
- Prev by Date: Re: [HACKERS] Kill a Long Running Query
- Next by Date: Re: [GENERAL] Regarding WAL
- Previous by thread: Kill a Long Running Query
- Next by thread: Re: Finding time in WAL logs
- Indexes: