Hello, Trying to run "vacuum full analyze" on a ~200MB UTF8 database fails with:
fs=> vacuum full analyze; WARNING: skipping "pg_authid" --- only table or database owner can vacuum it WARNING: skipping "pg_database" --- only table or database owner can vacuum it WARNING: skipping "pg_shdepend" --- only table or database owner can vacuum it WARNING: skipping "pg_shdescription" --- only table or database owner can vacuum it WARNING: skipping "pg_auth_members" --- only table or database owner can vacuum it ERROR: invalid memory alloc request size 4294965504 But not always, sometimes it goes through w/o a problem: fs=> vacuum full analyze; WARNING: skipping "pg_authid" --- only table or database owner can vacuum it WARNING: skipping "pg_database" --- only table or database owner can vacuum it WARNING: skipping "pg_shdepend" --- only table or database owner can vacuum it WARNING: skipping "pg_shdescription" --- only table or database owner can vacuum it WARNING: skipping "pg_auth_members" --- only table or database owner can vacuum it WARNING: skipping "pg_tablespace" --- only table or database owner can vacuum it WARNING: skipping "pg_pltemplate" --- only table or database owner can vacuum it VACUUM This is on x86 Linux. 8.2.6 does not exhibit the problem, or at least I haven't run into it. What info do I need to submit so that this can be tracked down? Best regards, -- Tomas Szepe <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
