user question about log

From: <sp8925(at)sohu(dot)com>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: user question about log
Date: 2002-04-15 01:58:54
Message-ID: 8026575.1018835934602.JavaMail.postfix@srv16.mail.sohu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Cheung Tin Ka 2002-04-15 03:59:45 remove warning
Previous Message Geoff Russell 2002-04-15 01:05:32 Re: plpgsql temporary table problem