My logs are constantly filling up with these messages for hundreds of tables:
WARNING: skipping "some_table_name" --- only table or database owner can analyze it
How do I perform any the following and/or resolve this?
- Determine in which database(s) these tables reside? Would be nice if the warning included that information.
- Grant the PostgreSQL superuser access to vacuum these tables
- Disable these warnings in the log file
Side note: none of the log file rotation, truncation, size/date limits settings are working either but I'll save that for a separate post.