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 newunicorn=# 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 <kgri...@gmail.com> To: gn...@yahoo.co.in Cc: "pgsql-b...@postgresql.org" <pgsql-b...@postgresql.org> 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, <gn...@yahoo.co.in> 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@postgresql.org -- 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
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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
