Re: user question about log

From: "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg>
To: <sp8925(at)sohu(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: user question about log
Date: 2002-04-16 18:37:38
Message-ID: 001501c1e575$c9258c20$9b0e32d4@sirma.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


----- Original Message -----
From:
To: <pgsql-general(at)postgresql(dot)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. "

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-04-16 18:53:39 Re: ON DELETE CASCADE doesn't work
Previous Message Masaru Sugawara 2002-04-16 18:25:44 Fw: views