On Mon, 2005-03-14 at 17:12 -0500, [EMAIL PROTECTED] wrote: > 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.
You can run the query vacuum verbose. Sincerely, Joshua D. Drake > > Jack Orenstein > > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564 Custom programming, 24x7 support, managed services, and hosting Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG Reliable replication, Mammoth Replicator - http://www.commandprompt.com/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
