Re: [BUGS] BUG #13847: WARNING: skipping "pg_toast_" --- cannot vacuum indexes, views, or special system tables VACUUM

Navaneethakrishnan Gopal <gnkna@xxxxxxxxxxx> · Wed, 6 Jan 2016 18:36:51 +0000 (UTC)

Hi Kevin,

Thanks a lot for getting back on this.

1) Customer is facing issue in our application running 8.2 version PG
linux# su postgres -s /bin/sh -c "postgres --version"
postgres (PostgreSQL) 8.2.3

unicorn=# select version();
                                version
------------------------------------------------------------------------
 PostgreSQL 8.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3
(1 row)

2) This is the current error customer is facing; which I think same as this https://wiki.postgresql.org/wiki/20110408pg_upgrade_fix#What_is_the_underlying_cause_of_this_bug.3F
700002 org.postgresql.util.PSQLException: ERROR: could not access status of transaction 192282624   Detail: Could not open file "pg_clog/00B7": No such file or directory.  org.postgresql.util.PSQLException: ERROR: could not access status of transaction 192282624   Detail: Could not open file "pg_clog/00B7": No such file or directory. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) ~[postgresql-8.2-504.jdbc3.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) ~[postgresql-8.2-504.jdbc3.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) ~[postgresql-8.2-504.jdbc3.jar:na]   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) ~[postgresql-8.2-504.jdbc3.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) ~[postgresql-8.2-504.jdbc3.jar:na]

3) We tried applying the fix in two ways
 https://wiki.postgresql.org/wiki/20110408pg_upgrade_fix#What_is_the_underlying_cause_of_this_bug.3F 
    3.i) Just copy and past the text from this page in the psql windown
    3.ii) By running like this  "psql -U postgres -a -f pg_upgrade_fix.sql unicorn >> error.txt 2>&1"
       Have attached both "pg_upgrade_fix.sql" and error.txt with this mail

Please help us on solving these errors.

4) As this issue is already fixed in 9.4 version, we have our newer application which uses 9.4 PG. But customer currently can't migrate to this new
unicorn=# select version();
                                                                version
----------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.4.1 on x86_64-mv-linux-gnu, compiled by i686-montavista-linux-gnu-gcc (MontaVista Linux G++ 4.4-1311130628) 4.4.1, 64-bit
(1 row)
    4.i) May be not applicable here, just to ensure the above script is working fine, we tried here in the 9.4 PG version. As expected we didn't see any error. Please check  "no_error*.txt"

Could you please help us on solving the warning message seen (error.txt)  in 8.2 PG version. 

Please let us know if you require more info.

Thanks,
Navanee

 From: Kevin Grittner <kgrittn@xxxxxxxxx>
 To: gnkna@xxxxxxxxxxx 
Cc: "pgsql-bugs@xxxxxxxxxxxxxx" <pgsql-bugs@xxxxxxxxxxxxxx>
 Sent: Wednesday, January 6, 2016 8:39 PM
 Subject: Re: [BUGS] BUG #13847: WARNING: skipping "pg_toast_" --- cannot vacuum indexes, views, or special system tables VACUUM

On Tue, Jan 5, 2016 at 9:15 AM,  <gnkna@xxxxxxxxxxx> wrote:

> Postgres Version:8.2

Do you really mean 8.2, not 9.2?  For a running instance, please
connect with psql (or similar) and give the output of:

  SELECT version();

If you have installed software for an upgrade and don't have a
cluster running yet, please run the following at a command line and
show the results:

  <path to executables>/postgres --version

Always use copy/paste for such things, rather than retyping or
showing what you think are the relevant parts.

> One of our customer is hitting this issue 20110408pg_upgrade_fix.

Rather than a diagnosis, please show exactly what you are doing and
what the results are.  You certainly can't be hitting this bug if
you are upgrading from 8.2.

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

> Customer currently cannot upgrade to our new software (which is
> running with 9.x PG DB).

Again, 9.x doesn't even tell us what the major release is.  Copy
paste a full version, as described above.

> Sorry if this is an wrong alias? Could you please guide us to the
> correct mailing list.

This would be more appropriate on the pgsql-general list.

http://www.postgresql.org/list/

Please start a new thread there with the information suggested by
the "Guide to reporting problems" page referenced above.  You can
do that by just sending an email to: pgsql-general@xxxxxxxxxxxxxx

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

SET vacuum_cost_delay = 40;
SET
SET vacuum_cost_limit = 200;
SET
CREATE TEMPORARY TABLE pg_upgrade_fix AS SELECT 'VACUUM FREEZE pg_toast.' || c.relname || ';' 	FROM    pg_class c, pg_namespace n WHERE   c.relnamespace = n.oid AND n.nspname = 'pg_toast' AND c.relkind = 't' ORDER by c.oid;
SELECT
\copy pg_upgrade_fix TO '/local/local1/pg_upgrade_tmp.sql';
psql:pg_upgrade_fix.sql:4: \copy: parse error at ";"
\i /local/local1/pg_upgrade_tmp.sql;
VACUUM FREEZE pg_toast.pg_toast_2604;
psql:/local/local1/pg_upgrade_tmp.sql:1: WARNING:  skipping "pg_toast_2604" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2606;
psql:/local/local1/pg_upgrade_tmp.sql:2: WARNING:  skipping "pg_toast_2606" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2609;
psql:/local/local1/pg_upgrade_tmp.sql:3: WARNING:  skipping "pg_toast_2609" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_1255;
psql:/local/local1/pg_upgrade_tmp.sql:4: WARNING:  skipping "pg_toast_1255" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2618;
psql:/local/local1/pg_upgrade_tmp.sql:5: WARNING:  skipping "pg_toast_2618" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2619;
psql:/local/local1/pg_upgrade_tmp.sql:6: WARNING:  skipping "pg_toast_2619" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_1260;
psql:/local/local1/pg_upgrade_tmp.sql:7: WARNING:  skipping "pg_toast_1260" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_1262;
psql:/local/local1/pg_upgrade_tmp.sql:8: WARNING:  skipping "pg_toast_1262" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2396;
psql:/local/local1/pg_upgrade_tmp.sql:9: WARNING:  skipping "pg_toast_2396" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_10737;
psql:/local/local1/pg_upgrade_tmp.sql:10: WARNING:  skipping "pg_toast_10737" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_10742;
psql:/local/local1/pg_upgrade_tmp.sql:11: WARNING:  skipping "pg_toast_10742" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_10747;
psql:/local/local1/pg_upgrade_tmp.sql:12: WARNING:  skipping "pg_toast_10747" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_10752;
psql:/local/local1/pg_upgrade_tmp.sql:13: WARNING:  skipping "pg_toast_10752" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_10757;
psql:/local/local1/pg_upgrade_tmp.sql:14: WARNING:  skipping "pg_toast_10757" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_10762;
psql:/local/local1/pg_upgrade_tmp.sql:15: WARNING:  skipping "pg_toast_10762" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_10767;
psql:/local/local1/pg_upgrade_tmp.sql:16: WARNING:  skipping "pg_toast_10767" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19316;
psql:/local/local1/pg_upgrade_tmp.sql:17: WARNING:  skipping "pg_toast_19316" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19323;
psql:/local/local1/pg_upgrade_tmp.sql:18: WARNING:  skipping "pg_toast_19323" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19330;
psql:/local/local1/pg_upgrade_tmp.sql:19: WARNING:  skipping "pg_toast_19330" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19335;
psql:/local/local1/pg_upgrade_tmp.sql:20: WARNING:  skipping "pg_toast_19335" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19340;
psql:/local/local1/pg_upgrade_tmp.sql:21: WARNING:  skipping "pg_toast_19340" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19345;
psql:/local/local1/pg_upgrade_tmp.sql:22: WARNING:  skipping "pg_toast_19345" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19350;
psql:/local/local1/pg_upgrade_tmp.sql:23: WARNING:  skipping "pg_toast_19350" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19355;
psql:/local/local1/pg_upgrade_tmp.sql:24: WARNING:  skipping "pg_toast_19355" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19360;
psql:/local/local1/pg_upgrade_tmp.sql:25: WARNING:  skipping "pg_toast_19360" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19371;
psql:/local/local1/pg_upgrade_tmp.sql:26: WARNING:  skipping "pg_toast_19371" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19384;
psql:/local/local1/pg_upgrade_tmp.sql:27: WARNING:  skipping "pg_toast_19384" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19389;
psql:/local/local1/pg_upgrade_tmp.sql:28: WARNING:  skipping "pg_toast_19389" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19394;
psql:/local/local1/pg_upgrade_tmp.sql:29: WARNING:  skipping "pg_toast_19394" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19399;
psql:/local/local1/pg_upgrade_tmp.sql:30: WARNING:  skipping "pg_toast_19399" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19404;
psql:/local/local1/pg_upgrade_tmp.sql:31: WARNING:  skipping "pg_toast_19404" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19409;
psql:/local/local1/pg_upgrade_tmp.sql:32: WARNING:  skipping "pg_toast_19409" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19414;
psql:/local/local1/pg_upgrade_tmp.sql:33: WARNING:  skipping "pg_toast_19414" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19421;
psql:/local/local1/pg_upgrade_tmp.sql:34: WARNING:  skipping "pg_toast_19421" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19426;
psql:/local/local1/pg_upgrade_tmp.sql:35: WARNING:  skipping "pg_toast_19426" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19431;
psql:/local/local1/pg_upgrade_tmp.sql:36: WARNING:  skipping "pg_toast_19431" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19436;
psql:/local/local1/pg_upgrade_tmp.sql:37: WARNING:  skipping "pg_toast_19436" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19441;
psql:/local/local1/pg_upgrade_tmp.sql:38: WARNING:  skipping "pg_toast_19441" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19446;
psql:/local/local1/pg_upgrade_tmp.sql:39: WARNING:  skipping "pg_toast_19446" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19451;
psql:/local/local1/pg_upgrade_tmp.sql:40: WARNING:  skipping "pg_toast_19451" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19456;
psql:/local/local1/pg_upgrade_tmp.sql:41: WARNING:  skipping "pg_toast_19456" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19461;
psql:/local/local1/pg_upgrade_tmp.sql:42: WARNING:  skipping "pg_toast_19461" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19466;
psql:/local/local1/pg_upgrade_tmp.sql:43: WARNING:  skipping "pg_toast_19466" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19471;
psql:/local/local1/pg_upgrade_tmp.sql:44: WARNING:  skipping "pg_toast_19471" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19476;
psql:/local/local1/pg_upgrade_tmp.sql:45: WARNING:  skipping "pg_toast_19476" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19481;
psql:/local/local1/pg_upgrade_tmp.sql:46: WARNING:  skipping "pg_toast_19481" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19486;
psql:/local/local1/pg_upgrade_tmp.sql:47: WARNING:  skipping "pg_toast_19486" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19493;
psql:/local/local1/pg_upgrade_tmp.sql:48: WARNING:  skipping "pg_toast_19493" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19500;
psql:/local/local1/pg_upgrade_tmp.sql:49: WARNING:  skipping "pg_toast_19500" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19505;
psql:/local/local1/pg_upgrade_tmp.sql:50: WARNING:  skipping "pg_toast_19505" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19510;
psql:/local/local1/pg_upgrade_tmp.sql:51: WARNING:  skipping "pg_toast_19510" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19515;
psql:/local/local1/pg_upgrade_tmp.sql:52: WARNING:  skipping "pg_toast_19515" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19520;
psql:/local/local1/pg_upgrade_tmp.sql:53: WARNING:  skipping "pg_toast_19520" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19525;
psql:/local/local1/pg_upgrade_tmp.sql:54: WARNING:  skipping "pg_toast_19525" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19534;
psql:/local/local1/pg_upgrade_tmp.sql:55: WARNING:  skipping "pg_toast_19534" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19545;
psql:/local/local1/pg_upgrade_tmp.sql:56: WARNING:  skipping "pg_toast_19545" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19550;
psql:/local/local1/pg_upgrade_tmp.sql:57: WARNING:  skipping "pg_toast_19550" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19557;
psql:/local/local1/pg_upgrade_tmp.sql:58: WARNING:  skipping "pg_toast_19557" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19562;
psql:/local/local1/pg_upgrade_tmp.sql:59: WARNING:  skipping "pg_toast_19562" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19569;
psql:/local/local1/pg_upgrade_tmp.sql:60: WARNING:  skipping "pg_toast_19569" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19578;
psql:/local/local1/pg_upgrade_tmp.sql:61: WARNING:  skipping "pg_toast_19578" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19595;
psql:/local/local1/pg_upgrade_tmp.sql:62: WARNING:  skipping "pg_toast_19595" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19600;
psql:/local/local1/pg_upgrade_tmp.sql:63: WARNING:  skipping "pg_toast_19600" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19605;
psql:/local/local1/pg_upgrade_tmp.sql:64: WARNING:  skipping "pg_toast_19605" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19614;
psql:/local/local1/pg_upgrade_tmp.sql:65: WARNING:  skipping "pg_toast_19614" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19619;
psql:/local/local1/pg_upgrade_tmp.sql:66: WARNING:  skipping "pg_toast_19619" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19624;
psql:/local/local1/pg_upgrade_tmp.sql:67: WARNING:  skipping "pg_toast_19624" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19629;
psql:/local/local1/pg_upgrade_tmp.sql:68: WARNING:  skipping "pg_toast_19629" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19636;
psql:/local/local1/pg_upgrade_tmp.sql:69: WARNING:  skipping "pg_toast_19636" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19643;
psql:/local/local1/pg_upgrade_tmp.sql:70: WARNING:  skipping "pg_toast_19643" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19648;
psql:/local/local1/pg_upgrade_tmp.sql:71: WARNING:  skipping "pg_toast_19648" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19653;
psql:/local/local1/pg_upgrade_tmp.sql:72: WARNING:  skipping "pg_toast_19653" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19658;
psql:/local/local1/pg_upgrade_tmp.sql:73: WARNING:  skipping "pg_toast_19658" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19663;
psql:/local/local1/pg_upgrade_tmp.sql:74: WARNING:  skipping "pg_toast_19663" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19672;
psql:/local/local1/pg_upgrade_tmp.sql:75: WARNING:  skipping "pg_toast_19672" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19677;
psql:/local/local1/pg_upgrade_tmp.sql:76: WARNING:  skipping "pg_toast_19677" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19686;
psql:/local/local1/pg_upgrade_tmp.sql:77: WARNING:  skipping "pg_toast_19686" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19691;
psql:/local/local1/pg_upgrade_tmp.sql:78: WARNING:  skipping "pg_toast_19691" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19696;
psql:/local/local1/pg_upgrade_tmp.sql:79: WARNING:  skipping "pg_toast_19696" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19701;
psql:/local/local1/pg_upgrade_tmp.sql:80: WARNING:  skipping "pg_toast_19701" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19706;
psql:/local/local1/pg_upgrade_tmp.sql:81: WARNING:  skipping "pg_toast_19706" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19715;
psql:/local/local1/pg_upgrade_tmp.sql:82: WARNING:  skipping "pg_toast_19715" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19726;
psql:/local/local1/pg_upgrade_tmp.sql:83: WARNING:  skipping "pg_toast_19726" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19731;
psql:/local/local1/pg_upgrade_tmp.sql:84: WARNING:  skipping "pg_toast_19731" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19736;
psql:/local/local1/pg_upgrade_tmp.sql:85: WARNING:  skipping "pg_toast_19736" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19741;
psql:/local/local1/pg_upgrade_tmp.sql:86: WARNING:  skipping "pg_toast_19741" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19746;
psql:/local/local1/pg_upgrade_tmp.sql:87: WARNING:  skipping "pg_toast_19746" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19753;
psql:/local/local1/pg_upgrade_tmp.sql:88: WARNING:  skipping "pg_toast_19753" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19758;
psql:/local/local1/pg_upgrade_tmp.sql:89: WARNING:  skipping "pg_toast_19758" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19763;
psql:/local/local1/pg_upgrade_tmp.sql:90: WARNING:  skipping "pg_toast_19763" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19768;
psql:/local/local1/pg_upgrade_tmp.sql:91: WARNING:  skipping "pg_toast_19768" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19773;
psql:/local/local1/pg_upgrade_tmp.sql:92: WARNING:  skipping "pg_toast_19773" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19778;
psql:/local/local1/pg_upgrade_tmp.sql:93: WARNING:  skipping "pg_toast_19778" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19783;
psql:/local/local1/pg_upgrade_tmp.sql:94: WARNING:  skipping "pg_toast_19783" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19788;
psql:/local/local1/pg_upgrade_tmp.sql:95: WARNING:  skipping "pg_toast_19788" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19793;
psql:/local/local1/pg_upgrade_tmp.sql:96: WARNING:  skipping "pg_toast_19793" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19798;
psql:/local/local1/pg_upgrade_tmp.sql:97: WARNING:  skipping "pg_toast_19798" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19803;
psql:/local/local1/pg_upgrade_tmp.sql:98: WARNING:  skipping "pg_toast_19803" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19808;
psql:/local/local1/pg_upgrade_tmp.sql:99: WARNING:  skipping "pg_toast_19808" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19813;
psql:/local/local1/pg_upgrade_tmp.sql:100: WARNING:  skipping "pg_toast_19813" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19818;
psql:/local/local1/pg_upgrade_tmp.sql:101: WARNING:  skipping "pg_toast_19818" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19823;
psql:/local/local1/pg_upgrade_tmp.sql:102: WARNING:  skipping "pg_toast_19823" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19828;
psql:/local/local1/pg_upgrade_tmp.sql:103: WARNING:  skipping "pg_toast_19828" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19833;
psql:/local/local1/pg_upgrade_tmp.sql:104: WARNING:  skipping "pg_toast_19833" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19838;
psql:/local/local1/pg_upgrade_tmp.sql:105: WARNING:  skipping "pg_toast_19838" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19843;
psql:/local/local1/pg_upgrade_tmp.sql:106: WARNING:  skipping "pg_toast_19843" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19852;
psql:/local/local1/pg_upgrade_tmp.sql:107: WARNING:  skipping "pg_toast_19852" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19857;
psql:/local/local1/pg_upgrade_tmp.sql:108: WARNING:  skipping "pg_toast_19857" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19862;
psql:/local/local1/pg_upgrade_tmp.sql:109: WARNING:  skipping "pg_toast_19862" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19867;
psql:/local/local1/pg_upgrade_tmp.sql:110: WARNING:  skipping "pg_toast_19867" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19872;
psql:/local/local1/pg_upgrade_tmp.sql:111: WARNING:  skipping "pg_toast_19872" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19877;
psql:/local/local1/pg_upgrade_tmp.sql:112: WARNING:  skipping "pg_toast_19877" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19882;
psql:/local/local1/pg_upgrade_tmp.sql:113: WARNING:  skipping "pg_toast_19882" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19889;
psql:/local/local1/pg_upgrade_tmp.sql:114: WARNING:  skipping "pg_toast_19889" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19894;
psql:/local/local1/pg_upgrade_tmp.sql:115: WARNING:  skipping "pg_toast_19894" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19899;
psql:/local/local1/pg_upgrade_tmp.sql:116: WARNING:  skipping "pg_toast_19899" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19910;
psql:/local/local1/pg_upgrade_tmp.sql:117: WARNING:  skipping "pg_toast_19910" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19915;
psql:/local/local1/pg_upgrade_tmp.sql:118: WARNING:  skipping "pg_toast_19915" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19922;
psql:/local/local1/pg_upgrade_tmp.sql:119: WARNING:  skipping "pg_toast_19922" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19927;
psql:/local/local1/pg_upgrade_tmp.sql:120: WARNING:  skipping "pg_toast_19927" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19936;
psql:/local/local1/pg_upgrade_tmp.sql:121: WARNING:  skipping "pg_toast_19936" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19941;
psql:/local/local1/pg_upgrade_tmp.sql:122: WARNING:  skipping "pg_toast_19941" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19946;
psql:/local/local1/pg_upgrade_tmp.sql:123: WARNING:  skipping "pg_toast_19946" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19951;
psql:/local/local1/pg_upgrade_tmp.sql:124: WARNING:  skipping "pg_toast_19951" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19956;
psql:/local/local1/pg_upgrade_tmp.sql:125: WARNING:  skipping "pg_toast_19956" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19961;
psql:/local/local1/pg_upgrade_tmp.sql:126: WARNING:  skipping "pg_toast_19961" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19966;
psql:/local/local1/pg_upgrade_tmp.sql:127: WARNING:  skipping "pg_toast_19966" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19971;
psql:/local/local1/pg_upgrade_tmp.sql:128: WARNING:  skipping "pg_toast_19971" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19976;
psql:/local/local1/pg_upgrade_tmp.sql:129: WARNING:  skipping "pg_toast_19976" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19981;
psql:/local/local1/pg_upgrade_tmp.sql:130: WARNING:  skipping "pg_toast_19981" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19986;
psql:/local/local1/pg_upgrade_tmp.sql:131: WARNING:  skipping "pg_toast_19986" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19991;
psql:/local/local1/pg_upgrade_tmp.sql:132: WARNING:  skipping "pg_toast_19991" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_19996;
psql:/local/local1/pg_upgrade_tmp.sql:133: WARNING:  skipping "pg_toast_19996" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20001;
psql:/local/local1/pg_upgrade_tmp.sql:134: WARNING:  skipping "pg_toast_20001" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20006;
psql:/local/local1/pg_upgrade_tmp.sql:135: WARNING:  skipping "pg_toast_20006" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20011;
psql:/local/local1/pg_upgrade_tmp.sql:136: WARNING:  skipping "pg_toast_20011" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20016;
psql:/local/local1/pg_upgrade_tmp.sql:137: WARNING:  skipping "pg_toast_20016" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20021;
psql:/local/local1/pg_upgrade_tmp.sql:138: WARNING:  skipping "pg_toast_20021" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20026;
psql:/local/local1/pg_upgrade_tmp.sql:139: WARNING:  skipping "pg_toast_20026" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20031;
psql:/local/local1/pg_upgrade_tmp.sql:140: WARNING:  skipping "pg_toast_20031" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20036;
psql:/local/local1/pg_upgrade_tmp.sql:141: WARNING:  skipping "pg_toast_20036" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20041;
psql:/local/local1/pg_upgrade_tmp.sql:142: WARNING:  skipping "pg_toast_20041" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20046;
psql:/local/local1/pg_upgrade_tmp.sql:143: WARNING:  skipping "pg_toast_20046" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20051;
psql:/local/local1/pg_upgrade_tmp.sql:144: WARNING:  skipping "pg_toast_20051" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20056;
psql:/local/local1/pg_upgrade_tmp.sql:145: WARNING:  skipping "pg_toast_20056" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20061;
psql:/local/local1/pg_upgrade_tmp.sql:146: WARNING:  skipping "pg_toast_20061" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20068;
psql:/local/local1/pg_upgrade_tmp.sql:147: WARNING:  skipping "pg_toast_20068" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20075;
psql:/local/local1/pg_upgrade_tmp.sql:148: WARNING:  skipping "pg_toast_20075" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20080;
psql:/local/local1/pg_upgrade_tmp.sql:149: WARNING:  skipping "pg_toast_20080" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20085;
psql:/local/local1/pg_upgrade_tmp.sql:150: WARNING:  skipping "pg_toast_20085" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20090;
psql:/local/local1/pg_upgrade_tmp.sql:151: WARNING:  skipping "pg_toast_20090" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20095;
psql:/local/local1/pg_upgrade_tmp.sql:152: WARNING:  skipping "pg_toast_20095" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20102;
psql:/local/local1/pg_upgrade_tmp.sql:153: WARNING:  skipping "pg_toast_20102" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20107;
psql:/local/local1/pg_upgrade_tmp.sql:154: WARNING:  skipping "pg_toast_20107" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20112;
psql:/local/local1/pg_upgrade_tmp.sql:155: WARNING:  skipping "pg_toast_20112" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20117;
psql:/local/local1/pg_upgrade_tmp.sql:156: WARNING:  skipping "pg_toast_20117" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20122;
psql:/local/local1/pg_upgrade_tmp.sql:157: WARNING:  skipping "pg_toast_20122" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20127;
psql:/local/local1/pg_upgrade_tmp.sql:158: WARNING:  skipping "pg_toast_20127" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20134;
psql:/local/local1/pg_upgrade_tmp.sql:159: WARNING:  skipping "pg_toast_20134" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20139;
psql:/local/local1/pg_upgrade_tmp.sql:160: WARNING:  skipping "pg_toast_20139" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20144;
psql:/local/local1/pg_upgrade_tmp.sql:161: WARNING:  skipping "pg_toast_20144" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20151;
psql:/local/local1/pg_upgrade_tmp.sql:162: WARNING:  skipping "pg_toast_20151" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20166;
psql:/local/local1/pg_upgrade_tmp.sql:163: WARNING:  skipping "pg_toast_20166" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20171;
psql:/local/local1/pg_upgrade_tmp.sql:164: WARNING:  skipping "pg_toast_20171" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20178;
psql:/local/local1/pg_upgrade_tmp.sql:165: WARNING:  skipping "pg_toast_20178" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20189;
psql:/local/local1/pg_upgrade_tmp.sql:166: WARNING:  skipping "pg_toast_20189" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20194;
psql:/local/local1/pg_upgrade_tmp.sql:167: WARNING:  skipping "pg_toast_20194" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20199;
psql:/local/local1/pg_upgrade_tmp.sql:168: WARNING:  skipping "pg_toast_20199" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20204;
psql:/local/local1/pg_upgrade_tmp.sql:169: WARNING:  skipping "pg_toast_20204" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20209;
psql:/local/local1/pg_upgrade_tmp.sql:170: WARNING:  skipping "pg_toast_20209" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20222;
psql:/local/local1/pg_upgrade_tmp.sql:171: WARNING:  skipping "pg_toast_20222" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20227;
psql:/local/local1/pg_upgrade_tmp.sql:172: WARNING:  skipping "pg_toast_20227" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20232;
psql:/local/local1/pg_upgrade_tmp.sql:173: WARNING:  skipping "pg_toast_20232" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20237;
psql:/local/local1/pg_upgrade_tmp.sql:174: WARNING:  skipping "pg_toast_20237" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20242;
psql:/local/local1/pg_upgrade_tmp.sql:175: WARNING:  skipping "pg_toast_20242" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20247;
psql:/local/local1/pg_upgrade_tmp.sql:176: WARNING:  skipping "pg_toast_20247" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20256;
psql:/local/local1/pg_upgrade_tmp.sql:177: WARNING:  skipping "pg_toast_20256" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20261;
psql:/local/local1/pg_upgrade_tmp.sql:178: WARNING:  skipping "pg_toast_20261" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20266;
psql:/local/local1/pg_upgrade_tmp.sql:179: WARNING:  skipping "pg_toast_20266" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20271;
psql:/local/local1/pg_upgrade_tmp.sql:180: WARNING:  skipping "pg_toast_20271" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20278;
psql:/local/local1/pg_upgrade_tmp.sql:181: WARNING:  skipping "pg_toast_20278" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20283;
psql:/local/local1/pg_upgrade_tmp.sql:182: WARNING:  skipping "pg_toast_20283" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20288;
psql:/local/local1/pg_upgrade_tmp.sql:183: WARNING:  skipping "pg_toast_20288" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20293;
psql:/local/local1/pg_upgrade_tmp.sql:184: WARNING:  skipping "pg_toast_20293" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20298;
psql:/local/local1/pg_upgrade_tmp.sql:185: WARNING:  skipping "pg_toast_20298" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20303;
psql:/local/local1/pg_upgrade_tmp.sql:186: WARNING:  skipping "pg_toast_20303" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20308;
psql:/local/local1/pg_upgrade_tmp.sql:187: WARNING:  skipping "pg_toast_20308" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20313;
psql:/local/local1/pg_upgrade_tmp.sql:188: WARNING:  skipping "pg_toast_20313" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20318;
psql:/local/local1/pg_upgrade_tmp.sql:189: WARNING:  skipping "pg_toast_20318" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20323;
psql:/local/local1/pg_upgrade_tmp.sql:190: WARNING:  skipping "pg_toast_20323" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20330;
psql:/local/local1/pg_upgrade_tmp.sql:191: WARNING:  skipping "pg_toast_20330" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20335;
psql:/local/local1/pg_upgrade_tmp.sql:192: WARNING:  skipping "pg_toast_20335" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20340;
psql:/local/local1/pg_upgrade_tmp.sql:193: WARNING:  skipping "pg_toast_20340" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20347;
psql:/local/local1/pg_upgrade_tmp.sql:194: WARNING:  skipping "pg_toast_20347" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20352;
psql:/local/local1/pg_upgrade_tmp.sql:195: WARNING:  skipping "pg_toast_20352" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20357;
psql:/local/local1/pg_upgrade_tmp.sql:196: WARNING:  skipping "pg_toast_20357" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20362;
psql:/local/local1/pg_upgrade_tmp.sql:197: WARNING:  skipping "pg_toast_20362" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20369;
psql:/local/local1/pg_upgrade_tmp.sql:198: WARNING:  skipping "pg_toast_20369" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20374;
psql:/local/local1/pg_upgrade_tmp.sql:199: WARNING:  skipping "pg_toast_20374" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20379;
psql:/local/local1/pg_upgrade_tmp.sql:200: WARNING:  skipping "pg_toast_20379" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20384;
psql:/local/local1/pg_upgrade_tmp.sql:201: WARNING:  skipping "pg_toast_20384" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20389;
psql:/local/local1/pg_upgrade_tmp.sql:202: WARNING:  skipping "pg_toast_20389" --- cannot vacuum indexes, views, or special system tables
VACUUM
VACUUM FREEZE pg_toast.pg_toast_20394;
psql:/local/local1/pg_upgrade_tmp.sql:203: WARNING:  skipping "pg_toast_20394" --- cannot vacuum indexes, views, or special system tables
VACUUM
Attachment:
pg_upgrade_fix.sql

Description: Binary data
SET vacuum_cost_delay = 40;
SET
SET vacuum_cost_limit = 200;
SET
CREATE TEMPORARY TABLE pg_upgrade_fix AS SELECT 'VACUUM FREEZE pg_toast.' || c.relname || ';' 	FROM    pg_class c, pg_namespace n WHERE   c.relnamespace = n.oid AND n.nspname = 'pg_toast' AND c.relkind = 't' ORDER by c.oid;
SELECT 209
\copy pg_upgrade_fix TO '/local/local1/pg_upgrade_tmp.sql'
COPY 209
\i /local/local1/pg_upgrade_tmp.sql;
VACUUM FREEZE pg_toast.pg_toast_2620;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2604;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2606;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2609;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_1255;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2618;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2619;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2396;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_2964;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_3596;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_11711;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_11716;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_11721;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_11726;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_11731;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_11736;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_11741;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16385;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16394;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16403;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16409;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16415;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16421;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16427;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16433;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16439;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16454;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16472;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16478;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16484;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16490;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16496;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16502;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16508;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16517;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16523;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16529;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16535;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16541;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16547;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16553;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16559;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16565;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16571;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16577;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16583;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16589;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16595;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16604;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16613;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16619;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16625;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16631;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16637;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16643;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16655;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16670;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16676;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16685;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16691;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16700;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16712;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16736;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16742;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16748;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16760;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16766;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16772;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16778;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16787;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16796;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16802;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16808;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16814;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16820;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16832;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16838;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16850;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16856;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16862;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16868;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16874;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16886;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16901;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16907;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16913;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16919;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16925;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16934;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16940;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16946;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16952;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16958;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16964;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16970;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16976;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16982;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16988;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_16994;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17000;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17006;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17012;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17018;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17024;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17030;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17036;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17042;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17054;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17060;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17066;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17072;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17078;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17084;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17090;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17099;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17105;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17111;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17126;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17132;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17141;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17147;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17159;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17165;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17171;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17177;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17183;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17189;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17195;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17201;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17207;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17213;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17219;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17225;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17231;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17237;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17243;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17249;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17255;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17261;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17267;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17273;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17279;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17285;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17291;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17297;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17303;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17309;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17318;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17327;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17333;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17339;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17345;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17351;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17360;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17366;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17372;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17378;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17384;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17390;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17399;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17405;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17411;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17420;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17441;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17447;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17456;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17471;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17477;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17483;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17489;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17495;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17513;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17519;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17525;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17531;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17537;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17543;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17555;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17561;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17567;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17573;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17582;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17588;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17594;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17600;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17606;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17612;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17618;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17624;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17630;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17636;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17645;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17651;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17657;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17666;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17672;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17678;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17684;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17693;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17699;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17705;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17711;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17717;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_17723;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_18181;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_18189;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_18197;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_18205;
VACUUM
VACUUM FREEZE pg_toast.pg_toast_18213;
VACUUM
-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general