Thread: user question about log

does postgreSQL have any mechanism like Oracle's Redo-log or the 'logupdate' option of MySQL which log only those
queriesthat 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.(MypostgreSQL 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. "