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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend