Postgres Pro
Downloads
Home   >   mailing lists

Thread: Cron /usr/lib/postgresql/bin/do.maintenance

Cron /usr/lib/postgresql/bin/do.maintenance

From
will trillich
Date:
got this in my logcheck email the other day
from the standard cron do.maintenance script
and thought it was cute:

----- Forwarded message from Cron Daemon <root@serensoft.com> -----

From: root@serensoft.com (Cron Daemon)
Sender: CronDaemon <postgres@serensoft.com>
Date: Sat, 19 Jan 2002 04:02:29 -0600
To: postgres@serensoft.com
Subject: Cron <postgres@server> [ -x /usr/lib/postgresql/bin/do.maintenance ] && /usr/lib/postgresql/bin/do.maintenance
-a

NOTICE:  Rel pg_attribute: Uninitialized page 30 - fixing
NOTICE:  Rel pg_toast_17058: Uninitialized page 13 - fixing

----- End forwarded message -----

toast? :)

--
DEBIAN NEWBIE TIP #28 from Will Trillich <will@serensoft.com>
:
Would you like to have rxvt show you useful information in the
TITLE BAR of its X window? For example, to see your "present
working directory" in the title bar, include this in your bash
command prompt string:
    export PS1="\e]0;\w^G\u@\h$ "
Anything between the "\e]0;" and the control-G will be displayed
as the title of the rxvt window. (For data entry, you may need to
precede the ^G with ^V.)

Also see http://newbieDoc.sourceForge.net/ ...

Re: Cron /usr/lib/postgresql/bin/do.maintenance

From
Michael Meskes
Date:
On Mon, Jan 21, 2002 at 12:36:30AM -0600, will trillich wrote:
> got this in my logcheck email the other day
> from the standard cron do.maintenance script
> and thought it was cute:
>
> ----- Forwarded message from Cron Daemon <root@serensoft.com> -----
>
> From: root@serensoft.com (Cron Daemon)
> Sender: CronDaemon <postgres@serensoft.com>
> Date: Sat, 19 Jan 2002 04:02:29 -0600
> To: postgres@serensoft.com
> Subject: Cron <postgres@server> [ -x /usr/lib/postgresql/bin/do.maintenance ] &&
/usr/lib/postgresql/bin/do.maintenance-a 
>
> NOTICE:  Rel pg_attribute: Uninitialized page 30 - fixing
> NOTICE:  Rel pg_toast_17058: Uninitialized page 13 - fixing
>
> ----- End forwarded message -----
>
> toast? :)

For those of you not using Debian, do.maintainance calls vacuum.

Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!