[freeside] Cron output

[Randall Lucas]

Oh, yes.  A good point.  I hadn't examined the table
names.

Those tables are the internal tables that store
information about relations in PostgreSQL.  They are
created not when you set up the freeside tables, but
when you CREATE DATABASE, I believe, so the username
under which you created the db is the one that
matters.

You could probably eliminate those messages if you
created a new database with freeside's username, moved
things over to it with a database dump, and changed
over to that new database.  Also, you could probably
change it even more easily by hacking the pg internal
tables and changing the ownership; that's probably a
more pg-wizard type of operation.  If this system is
in production, you may just want to ignore these
messages and perhaps occasionally vacuum the system
tables separately.

Randall

--- ivan at 420.am wrote:
> On Fri, Oct 24, 2003 at 11:06:10AM -0700, Randall
> Lucas wrote:
> > 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.
> 
> As the owner of some Pg-internal tables.  It appears
> the regular
> database tables used by Freeside were vacuumed
> fine...
> 
> -- 
> _ivan
> 
> 
> > 
> > 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
> 
=== message truncated ===