user question about log
does postgreSQL have any mechanism like Oracle's Redo-log or the 'logupdate' option of MySQL which log only those queries that cause really happened changes to databases? In postgreSQL, how to do things like MySQL's "flush logs" and Oracle's "alter database archivelog"? what's the information in $PGDATA/pg_log? how to browse it? how to delete rows having 'invalid' timestamp value? i use "delete from tablename where timestampColName = 'invalid';",but can't delete them.(My postgreSQL is version 6.5)
----- Original Message -----
From:
To: <pgsql-general@postgresql.org>
Sent: Monday, April 15, 2002 04:58
Subject: [GENERAL] user question about log
does postgreSQL have any mechanism like Oracle's Redo-log or the
'logupdate' option of MySQL which log only those queries that cause really
happened changes to databases? In postgreSQL, how to do things like MySQL's
"flush logs" and Oracle's "alter database archivelog"? what's the
information in $PGDATA/pg_log? how to browse it?
take a look in chapter 11 from the Administrator's Guide - "Write-Ahead
Logging (WAL)"
hth,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "