|
|
|
|
|
|
| Author |
Message |
Jack Orenstein
*nix forums beginner
Joined: 15 Mar 2005
Posts: 27
|
 Posted: Tue Mar 15, 2005 1:37 am Post subject:
Re: Logging VACUUM activity
|
|
|
Joshua D. Drake wrote:
| Quote: | On Mon, 2005-03-14 at 17:12 -0500, jao@geophile.com 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.
|
I tried that. Whether I issue the VACUUM VERBOSE call through JDBC
or psql, I don't see anything in the postgres log file at all, even
with log_min_error_statement set to info.
In psql, I see the VACUUM VERBOSE output in the psql session itself,
but I need to log the output. I could spawn a psql session if necessary,
but ideally I'd just run VACUUM VERBOSE from JDBC and get the output
in the postgres log file.
Jack Orenstein
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings |
|
| Back to top |
|
 |
Joshua D. Drake
*nix forums Guru
Joined: 09 Mar 2005
Posts: 341
|
| Posted: Mon Mar 14, 2005 10:35 pm Post subject:
Re: Logging VACUUM activity
|
|
|
On Mon, 2005-03-14 at 17:12 -0500, jao@geophile.com wrote:
| Quote: | 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
| Quote: |
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 |
|
| Back to top |
|
|
Guest
|
| Posted: Mon Mar 14, 2005 9:12 pm Post subject:
Logging VACUUM activity
|
|
|
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 |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Jan 08, 2009 7:54 am | All times are GMT
|
|
Loans | Sudoku Software | Personal Loans | Loans and Credit Cards | Unsecured Credit Cards
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
PostgreSQL
