Re: user question about log - Mailing list pgsql-general

From Marin Dimitrov
Subject Re: user question about log
Date
Msg-id 001501c1e575$c9258c20$9b0e32d4@sirma.bg
Whole thread Raw
In response to user question about log  (<sp8925@sohu.com>)
List pgsql-general
----- 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. "





pgsql-general by date:

Previous
From: Hans-Juergen Schoenig
Date:
Subject: Re: Triggers and System Tables
Next
From: Stephan Szabo
Date:
Subject: Re: ON DELETE CASCADE doesn't work