Обсуждение: Cleaning up vacuums
Hello, Can't see an answer to this in the archives either.... I'm automating the vacuum of each database I have every night using a cron job on a perl script. To tidy things up I want to put all of the messages received when performing the vacuum into a log file, but cannot get this to work. Each time I vacuum (from either the script or the command line), I see things like: DEBUG: --Relation pg_indexes-- DEBUG: Pages 0: Changed 0, Reapped 0, Empty 0, New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec. Redirecting STDERR or STDOUT somewhere doesn't seem to have any effect on these messages. Any ideas anyone? Regards, Mark. -- Mark Jewiss Knowledge Matters Limited http://www.knowledge.com
On Wed, Nov 24, 1999 at 02:25:11PM +0000, Mark Jewiss wrote:
> Each time I vacuum (from either the script or the command line), I see
> things like:
>
> DEBUG: --Relation pg_indexes--
> DEBUG: Pages 0: Changed 0, Reapped 0, Empty 0, New 0; Tup 0: Vac 0,
> Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail.
> Space 0/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec.
>
> Redirecting STDERR or STDOUT somewhere doesn't seem to have any effect on
> these messages.
>
> Any ideas anyone?
must be something in your perl script.
i do similar things using /bin/sh scripts as:
psql -h host -d database -c "vacuum verbose;" > errors 2>&1
if [ $? -ne 0 ] ; then
Mail -s "vacuum errors" someone < errors
fi
rm -f errors
works fine.
also, if you enable syslog (include/config.h) and set up a pg_options file,
i've noticed that verbose level 2 will put the output of vacuum into
the syslog file.
--
[ Jim Mercer jim@reptiles.org +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
On 1999-11-24 at 14:25:11, Mark Jewiss wrote: > Each time I vacuum (from either the script or the command line), I see > things like: > > DEBUG: --Relation pg_indexes-- I think you see the output from the *backend* itself (on the console/tty it has been started), which is a child of the postmaster; try redirecting postmaster when starting it... Janos
Hello, On Wed, 24 Nov 1999, Janos Farkas wrote: > I think you see the output from the *backend* itself (on the console/tty > it has been started), which is a child of the postmaster; try > redirecting postmaster when starting it... Spot on, thanks for that! ;-) Regards, Mark. -- Mark Jewiss Knowledge Matters Limited http://www.knowledge.com