ELF>~@@ATH5USHH=I1L1H5HH1H1 H ~HL1H5HHujHH9tHL[]A\f11H1 HtH=1H5H=1H=1ff.@AUI1ATUHtEHLIHHtELIHtLL]A\A]H=1LH=LH=1ATH5USHH=H1H1H5HIt,HH9tH=1fH=1fLH[]A\AUIATUSH.HIHHD)L.HHHtV)9t LH1H[]A\A]HcHLuLHHfDLlfAW1H=AVAUATUSH8D$DfoD$@.txtD$0HD$0$1D$HD$ HcD$H=Hi8HHpHD$H5HHD$(1HHH5HD$AH5HAH5HAAEE11jf.DDHDDHHD$DDHH$ALD$H $HHH51D9d$txHt+uHD$H5HHP1xH|$ H5$$HHu8Ht$ H=H1fD$HH|$(D$D$;]HtH<$uH8[]A\A]A^A_H51Ht$0H=1ff.fAW1H=AVAUATUSH88foxtD$Pue.tfD$TD$0foD$VD$@HD$0D$1D$HD$ fDLc|$H=Mi8L=IwL|$H5HHD$(1IHH5LD$ H5LAAƅE11LfDDDLDDLHAHH5HH1D9|$ trHt%uHD$H5HHP1DH|$ H5T$T$HHu8Ht$ H=H1@D$LH|$(D$D$;HtH|$uH8[]A\A]A^A_H51Ht$0H=1AW1H=AVAUATUSH8foxtD$@nb.tfD$DD$FD$0HD$0$1D$HD$ HcD$H=Hi8HHpHD$H5HHD$(1HHH5HD$AH5HAH5HAAEE11jf.DDHDDHHD$DDHH$ALD$H $HHH51D9d$txHt+uHD$H5HHP1xH|$ H5$$HHu8Ht$ H=H1fD$HH|$(D$D$;]HtH<$uH8[]A\A]A^A_H51Ht$0H=1ff.f=t@uH51H51DAWAVAUATUSH|$ @H=E1H=PH=1H5H=H5HH$1H5IHH5LALAŅs8tu x AD9tXDDLDDLH HH=€t8fuxuH=1DLH<$H=Y=Kbcw6= C v=tZ|$ t_H[]A\A]A^A_=awH==s:wH==u|$ uH1[]A\A]A^A_H=f.H==uc=aH5H=H=H1H1H5HIt!H=1H=LHH=1AVH=AUATUSyL-LHi8LM80~BL(HRHML0I0 L€EI0M9uH8L9uE1fDIcHi8IŋHImHi8L8fDH8I9HsHuA 9 MHLHtLHMHLHt1LHvAD;5} L- =t H=[H=]A\A]A^HpH=1 IHsLH=H1IHH=HsIHH=Hs=t'HH5111fH51ff.fHH==s:v=Kbv*1H@1H==KbwH=11H@=:ATHIv41H5Mt4LH51A\@1H5MuH51A\ff.1HH==:vNPRcwu9wcHiQHiQH%H%9u5-cwHH=1H=1H=1H=1H5H=1fDS@H=1H=H5H=t"=_wf=tf9t[H=1H=1AT1USHH=H IL=gHH51H=H5HHHHH H=H H51HHH H51HHH H51HHH H51HHHH51HH H51HHH H51HHH H51HHHH51HH H51HHH H51HHHH=:L HH LFHH51RLD$HH51HHL$1HHH5XZ=:HH5H1H H51HHHH;urLH []A\LH5H5L LiH $HH1H5B8H3H=H18H3H=H1ff.@AWHH51AVIH=AUATUSH IH$IH5LLH5HHHLg=1L$fD9~uHHcLH4ºLLLtLH51I>I>IH []A\A]A^A_@H=1I>H5HHH H=A'H1H H5'51L-Vf.HHA'IHcH5H M'1L9H=?uH =s: LcE1I~HIcLHHHi8HAJ "j''A/D1D9=XZ9aHI>ukTfHHcù/HH5H1<LH58I6H=H18I6H=H1template1nspnamerelnameattnamewcould not open file "%s": %s Database: %s %s.%s.%s fatal proname %s.%s datnamedatallowconntemplate0pg_catalog *Clusters are compatible* Checking cluster versions11--analyze-only--analyze-U sh./%sanalyze_new_cluster.%s#!/bin/sh 'echo%s "%s/vacuumdb" %s--all echo %sDone%s %sdelete_old_cluster.%srm -rf %c%s%c rm -f %s%cPG_VERSION rm -rf %c%s%c%d%c rm -rf %c%s%s%c Checking database user is the install userSELECT rolsuper, oid FROM pg_catalog.pg_roles WHERE rolname = current_user AND rolname !~ '^pg_'database user "%s" is not the install user SELECT COUNT(*) FROM pg_catalog.pg_roles WHERE rolname !~ '^pg_'could not determine the number of users Only the install user can be defined in the new cluster. failed to get the current locale failed to get system locale name for "%s" failed to restore old locale "%s" Checking for prepared transactionsSELECT * FROM pg_catalog.pg_prepared_xactsThe source cluster contains prepared transactions The target cluster contains prepared transactions Checking for reg* data types in user tablesSELECT n.nspname, c.relname, a.attname FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n, pg_catalog.pg_attribute a, pg_catalog.pg_type t WHERE c.oid = a.attrelid AND NOT a.attisdropped AND a.atttypid = t.oid AND t.typnamespace = (SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog') AND t.typname IN ( 'regconfig', 'regdictionary', 'regnamespace', 'regoper', 'regoperator', 'regproc', 'regprocedure' ) AND c.relnamespace = n.oid AND n.nspname NOT IN ('pg_catalog', 'information_schema')Your installation contains one of the reg* data types in user tables. These data types reference system OIDs that are not preserved by pg_upgrade, so this cluster cannot currently be upgraded. You can remove the problem tables and restart the upgrade. A list of the problem columns is in the file: %s Checking for contrib/isn with bigint-passing mismatchSELECT n.nspname, p.proname FROM pg_catalog.pg_proc p, pg_catalog.pg_namespace n WHERE p.pronamespace = n.oid AND p.probin = '$libdir/isn'Your installation contains "contrib/isn" functions which rely on the bigint data type. Your old and new clusters pass bigint values differently so this cluster cannot currently be upgraded. You can manually upgrade databases that use "contrib/isn" facilities and remove "contrib/isn" from the old cluster and restart the upgrade. A list of the problem functions is in the file: %s Checking for incompatible "jsonb" data typeSELECT n.nspname, c.relname, a.attname FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n, pg_catalog.pg_attribute a WHERE c.oid = a.attrelid AND NOT a.attisdropped AND a.atttypid = 'pg_catalog.jsonb'::pg_catalog.regtype AND c.relnamespace = n.oid AND n.nspname !~ '^pg_temp_' AND n.nspname NOT IN ('pg_catalog', 'information_schema')Your installation contains the "jsonb" data type in user tables. The internal format of "jsonb" changed during 9.4 beta so this cluster cannot currently be upgraded. You can remove the problem tables and restart the upgrade. A list of the problem columns is in the file: %s Performing Consistency Checks on Old Live Server ------------------------------------------------ Performing Consistency Checks ----------------------------- Checking database connection settingsSELECT datname, datallowconn FROM pg_catalog.pg_databasetemplate0 must not allow connections, i.e. its pg_database.datallowconn must be false All non-template0 databases must allow connections, i.e. their pg_database.datallowconn must be true Checking for roles starting with "pg_"SELECT * FROM pg_catalog.pg_roles WHERE rolname ~ '^pg_'The source cluster contains roles starting with "pg_" New cluster database "%s" is not empty encodings for database "%s" do not match: old "%s", new "%s" lc_collate values for database "%s" do not match: old "%s", new "%s" lc_ctype values for database "%s" do not match: old "%s", new "%s" If pg_upgrade fails after this point, you must re-initdb the new cluster before continuing. Optimizer statistics are not transferred by pg_upgrade so, once you start the new server, consider running: %s Optimizer statistics and free space information are not transferred by pg_upgrade so, once you start the new server, consider running: %s Running this script will delete the old cluster's data files: %s Could not create a script to delete the old cluster's data files because user-defined tablespaces or the new cluster's data directory exist in the old cluster directory. The old cluster's contents must be deleted manually. This utility can only upgrade from PostgreSQL version 8.4 and later. This utility can only upgrade to PostgreSQL version %s. This utility cannot be used to downgrade to older major PostgreSQL versions. Old cluster data and binary directories are from different major versions. New cluster data and binary directories are from different major versions. When checking a pre-PG 9.1 live old server, you must specify the old server's port number. When checking a live server, the old and new port numbers must be different. Creating script to analyze new clusterecho %sThis script will generate minimal optimizer statistics rapidly%s echo %sso your system is usable, and then gather statistics twice more%s echo %swith increasing accuracy. When it is done, your system will%s echo %shave the default level of optimizer statistics.%s echo %sIf you have used ALTER TABLE to modify the statistics target for%s echo %sany tables, you might want to remove them and restore them after%s echo %srunning this script because they will delay fast statistics generation.%s echo %sIf you would like default statistics as quickly as possible, cancel%s echo %sthis script and run:%s echo %s "%s/vacuumdb" %s--all %s%s "%s/vacuumdb" %s--all --analyze-in-stages could not add execute permission to file "%s": %s WARNING: new data directory should not be inside the old data directory, e.g. %s WARNING: user-defined tablespace locations should not be inside the data directory, e.g. %s Creating script to delete old clustertables_using_regcontrib_isn_and_int8_pass_by_valtables_using_jsoGCC: (Debian 10.2.1-6) 10.2.1 20210110zRx ,BHA  ABG ,LBGA L BBA (|BHA vAB8BEA C(D0_ (A ABBD LSBKB B(A0A8G 8A0A(B BBBA L4MBKB B(A0A8G 8A0A(B BBBA LcBKB B(A0A8G 8A0A(B BBBA ;dBBB B(A0A8DPz 8A0A(B BBBA T 8C0A(B BBBM <PIBIB A(A0 (H BBBE CMclDk I ouLs I hFb E xAZ A @$1BCA N@HJP@HA@m  AABD `h?BRL B(A0A8G 8A0A(B BBBE ,X]A  9Y@rSpMc  0 @#(.(4:X@FLR X^dPjBp"v$|\p ckp0(    P x t| x    @$*06<pBxHNTZ`fl0rx~ H!" phB+ Q&p,2i8?FxLRhx"*0AJQX0 ;lvp 0@Q{P ICl@`uYpx 1/E`?ltcheck.ccheck_is_install_userget_canonical_locale_namecheck_for_prepared_transactionsequivalent_locale.part.0check_for_reg_data_type_usage.constprop.0check_for_isn_and_int8_passing_mismatch.constprop.0check_for_jsonb_9_4_usage.constprop.0.LC0.LC1.LC2.LC4.LC6.LC3.LC5.LC7.LC9.LC8.LC10.LC11.LC13.LC12.LC14.LC25.LC15.LC16.LC17.LC18.LC22.LC21.LC19.LC20.LC23.LC24.LC26.LC31.LC32.LC27.LC28.LC29.LC30.LC33.LC36.LC34.LC35.LC38.LC37.LC39.LC40.LC41.LC42.LC43.LC45.LC46.LC47.LC48.LC44.LC49.LC50.LC51.LC53.LC52.LC54.LC55.LC56.LC58.LC57.LC59.LC60.LC61.LC66.LC65.LC64.LC62.LC63.LC68.LC67.LC71.LC73.LC74.LC75.LC76.LC77.LC78.LC79.LC80.LC81.LC82.LC83.LC84.LC85.LC86.LC87.LC88.LC70.LC69.LC89.LC90.LC92.LC72.LC91.LC93.LC94.LC96.LC97.LC98.LC100.LC101.LC99.LC95_GLOBAL_OFFSET_TABLE_connectToServerprep_statusexecuteQueryOrDiePQntuplesPQgetvaluestrtoulPQclearPQfinishcheck_okpg_fatalos_infosetlocalepg_strduppg_freestrrchrpg_strncasecmpstrlenPQfnumberfprintffopen__errno_locationstrerrorfclosepg_logoutput_check_banneruser_optscheck_and_dump_old_clusterget_db_and_rel_infosinit_tablespacesget_loadable_librariesold_9_3_check_for_line_data_type_usagenew_9_0_populate_pg_largeobject_metadatagenerate_old_dumpstop_postmasterstart_postmasterold_9_6_check_for_unknown_data_type_usageold_9_6_invalidate_hash_indexescheck_new_clusterstrcmppg_strcasecmpcheck_loadable_librariescheck_hard_linkpg_encoding_to_charreport_clusters_compatibleexitissue_warnings_and_set_wal_leveloutput_completion_bannercheck_cluster_versionscheck_cluster_compatibilityget_control_datacheck_control_datacreate_script_for_cluster_analyzeinitPQExpBufferpsprintffwritechmodtermPQExpBufferappendPQExpBufferStrappendShellStringappendPQExpBufferCharcreate_script_for_old_cluster_deletionstrlcpycanonicalize_pathpath_is_prefix_of_pathunlinkpfreefputcy z,1{<|T}c~t{|}~  -:GTan~yz{| $,`+z1l> xdy!{|"#$}-}C}Y%`&'( l'@)LX*_w+z]]l,-d$y+.:{E|L"Za/l}}0&' ".(8ISblu)12zl38FdTy[4j{u||"#$}} } % A &O h 'p    (    l   )  5 2 A 6[ 7      8 z   y 9 { :  ;  |B }S }b < =           # 5 : @ H x }        y > z ? { | @    ' , 2 > AE U ` f lx d BldPld 'C.3AODYnEwFGH-28FMbyIJKLMz6PNW^OelPszQRST U,V5z@FTW[XdYip'{Z[\[][^[_ `a$+[2b?F[McZa[hdu|`a[e[fgh[i`a 18j=EV`]agn[ukl m#n-29C(MeWlXzott$ $*2=KpW_gqz'Ztr$s.tAIR$_qwldl$ #5u@Vv`gq({n5M g d  XI P @8p0 p TP `( l`.symtab.strtab.shstrtab.rela.text.data.bss.rodata.str1.1.rodata.str1.8.rodata.cst16.comment.note.GNU-stack.rela.eh_frame @@@P, &,12@2O2@]02(f2{2v@| 6 x H`~