[freeside] Cron output

[Scott Damron]

Thanks for the replies!!!  Is there a way to passover the pg_ tables?

Scott

-----Original Message-----
From: Randall Lucas [mailto:rlucas at tercent.net] 
Sent: Friday, October 24, 2003 11:06 AM
To: ivan-freeside at sisd.com
Subject: Re: [freeside] Cron output


Hi Scott,

These are PostgreSQL messages.  Freeside daily seems
to be vacuuming the tables, but the database username
it's using isn't the same one as the owner of the
tables.  Perhaps you used a different username when
you first set up the freeside tables from that used to
run the daily?

Randall

--- Scott Damron <sdamron at globalmtn.com> wrote:
> Hello Listers...
> 
> I am getting the following output when the
> freeside-daily runs, any
> ideas what it means?!?
> 
> TIA,
> 
> Scott
> 
> NOTICE:  Skipping "pg_type" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_attribute" --- only table
> owner can VACUUM it
> NOTICE:  Skipping "pg_proc" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_class" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_indexes" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_group" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_database" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_attrdef" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_relcheck" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_trigger" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_inherits" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_index" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_statistic" --- only table
> owner can VACUUM it
> NOTICE:  Skipping "pg_operator" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_opclass" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_am" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_amop" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_amproc" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_language" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_aggregate" --- only table
> owner can VACUUM it
> NOTICE:  Skipping "pg_ipl" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_inheritproc" --- only table
> owner can VACUUM it
> NOTICE:  Skipping "pg_rewrite" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_listener" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_description" --- only table
> owner can VACUUM it
> NOTICE:  Skipping "pg_shadow" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_user" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_rules" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_views" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_tables" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_type" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_attribute" --- only table
> owner can VACUUM it
> NOTICE:  Skipping "pg_proc" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_class" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_indexes" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_group" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_database" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_attrdef" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_relcheck" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_trigger" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_inherits" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_index" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_statistic" --- only table
> owner can VACUUM it
> NOTICE:  Skipping "pg_operator" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_opclass" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_am" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_amop" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_amproc" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_language" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_aggregate" --- only table
> owner can VACUUM it
> NOTICE:  Skipping "pg_ipl" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_inheritproc" --- only table
> owner can VACUUM it
> NOTICE:  Skipping "pg_rewrite" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_listener" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_description" --- only table
> owner can VACUUM it
> NOTICE:  Skipping "pg_shadow" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_user" --- only table owner can
> VACUUM it
> NOTICE:  Skipping "pg_rules" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_views" --- only table owner
> can VACUUM it
> NOTICE:  Skipping "pg_tables" --- only table owner
> can VACUUM it
> 
> 
>