Hi, I'm looking in my log file with today's date. I'm using VIM and
have done a search for a pattern match on "autovac", "vacuum", and
"auto" VIM returned "string not found" for each search. Am I
looking for the wrong string, or is there another log file I should
be looking at?
Carol
On Mar 30, 2007, at 10:59 AM, Thomas Pundt wrote:
Hi,
On Friday 30 March 2007 16:43, Carol Walter wrote:
| I ran the command "show autovacuum" and postgres responds with "ON."
| My colleague says that I should be able to see it running if I
run ps
| -aef. He said that he doesn't trust postgres reporting on itself.
| When I run the Unix ps command as above I don't see autovacuum.
Does
| anyone know if it's running or not? This is on a box running
Solaris.
you will only see it if it is currently processing your databases.
Look
at the PostgreSQL log file, if it has entries from autovacuum.
Ciao,
Thomas
--
Thomas Pundt <thomas.pundt@xxxxxxxxxxxx> ---- http://rp-online.de/
----