Logging VACUUM activity

From: jao(at)geophile(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Logging VACUUM activity
Date: 2005-03-14 22:12:26
Message-ID: 1110838346.42360c4a79a07@geophile.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using postgresql 7.4.6 on RH9. My application includes a
long-running Java process responsible for database access. I'd like to
have this Java process initiate a daily VACUUM and, one way or
another, log VACUUM output.

- Is there some way to get VACUUM output via JDBC?

- If not, how can I get VACUUM output in the postgres logs? Setting
log_min_error_statement to INFO doesn't seem to have any effect.

Jack Orenstein

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Gagnon 2005-03-14 22:32:48 Re: Problem with special character � on
Previous Message Ragnar Hafstað 2005-03-14 22:03:18 Re: Problem with special character