On Apr 25, 2007, at 7:01 PM, Simon Riggs wrote:
(this is for a DELETE FROM table without any WHERE clause). I see
the XID, but can you also display date and time in the ouput ?
Original date/time is available only on COMMIT/ABORT records, so
you'll
need to search ahead/behind.
Additionall
On Wednesday 25 April 2007 11:28, Pascal Robert wrote:
> 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 erro
On Wed, 2007-04-25 at 14:49 -0400, Pascal Robert wrote:
> >> BTW, the statements look like this :
> >>
> >>0/15FFE470: prv 0/15FFE440; xid 2332; HEAP info 10 len 18
> >> tot_len 46
> >>DELETE FROM 16612 WHERE ...delete: ts 1663 db 16384 rel 16612 block
> >> 1413 off 5
> >>
> >> (this is
Le 07-04-25 à 14:49, Pascal Robert a écrit :
BTW, the statements look like this :
0/15FFE470: prv 0/15FFE440; xid 2332; HEAP info 10 len 18
tot_len 46
DELETE FROM 16612 WHERE ...delete: ts 1663 db 16384 rel 16612 block
1413 off 5
(this is for a DELETE FROM table without any WHERE
BTW, the statements look like this :
0/15FFE470: prv 0/15FFE440; xid 2332; HEAP info 10 len 18
tot_len 46
DELETE FROM 16612 WHERE ...delete: ts 1663 db 16384 rel 16612 block
1413 off 5
(this is for a DELETE FROM table without any WHERE clause). I see
the XID, but can you also displ
On Wed, 2007-04-25 at 13:13 -0400, Pascal Robert wrote:
> Le 07-04-25 à 11:43, Simon Riggs a écrit :
>
> > 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
Le 07-04-25 à 11:43, Simon Riggs a écrit :
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
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 erro
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"
