Обсуждение: 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