ELF> C@@8 @@@@@!@!000qq@@PPP*```888 XXXDDStd888 PtdLiLiLi,,QtdRtdPPP/lib64/ld-linux-x86-64.so.2GNUGNU" kY9:ɭkgK"GNUooqr(em9/Vrg6' <ku4+@ k^PLw}<Cr( ,dQX %Bq 2.^(Jl=7 SWCc\H "d@](libpq.so.5_ITM_deregisterTMCloneTable__gmon_start___ITM_registerTMCloneTablePQexecPQgetvaluecreatePQExpBufferPQescapeStringConnPQresultStatusPQfnumberappendPQExpBufferPQntuplesPQconnectdbresetPQExpBufferPQconninfoFreeappendPQExpBufferCharPQcleartermPQExpBufferpg_encoding_to_charPQstatusPQconndefaultsinitPQExpBufferPQfinishappendPQExpBufferStrPQerrorMessagelibc.so.6fflushstrcpy__printf_chkreaddirsetlocalefopenstrsignalstrncmpstrrchrperror__isoc99_sscanfgetpwuidclosedirstrncpyfork__stack_chk_fail__lxstatunlinkreallocabort_exitstrpbrkpopenstrspnstrdupchmodstrtolisattyfeoffgetscallocstrlenstrstrrmdir__errno_locationchdirreadunsetenv__fprintf_chkctimegetpwuid_rputenvstdoutfputc__isoc99_fscanffputsfclose__vsnprintf_chkstrtoulmallocumask__strncpy_chkopendir__ctype_b_locgetenvoptargstderrsystem__snprintf_chkreadlinkgetopt_longfilenopclosegetcwdfwriterenamegeteuidwaitpidstrerror_rstrchr__ctype_toupper_loc__ctype_tolower_loc__cxa_finalize__sprintf_chk__xstataccess__strcat_chkstrcmpstrerror__libc_start_mainsnprintffree__cxa_atexitGLIBC_2.4GLIBC_2.7GLIBC_2.2.5GLIBC_2.3.4GLIBC_2.3/usr/local/pgsql/libii yii ui ti ii PDXC I@I`IIIIII I@I`IJ J(R"(AHد 18ap o(r@qȬ Ь ج   (08@HPX`hpx !"#$%&'()ȭ*Э+ح,-./02345 6(7098:@;H<P=X>`?h@pAxBCDEFGHIJKȮLЮMخNOPQRSTUV W(X0Y8Z@[H\P]X^`_h`pbxcdefghijklȯmЯnHHHtH5R|%S|hhhhhhhhqhah Qh Ah 1h !h hhhhhhhhhhqhahQhAh1h!hhhh h!h"h#h$h%h&h'qh(ah)Qh*Ah+1h,!h-h.h/h0h1h2h3h4h5h6h7qh8ah9Qh:Ah;1h<!h=h>h?h@hAhBhChDhEhFhGqhHahIQhJAhK1hL!hMhNhOhPhQhRhShThUhVhWqhXahYQhZAh[1h\!h]h^h_h`hahbhchdhehfhgqhhahiQ%yD%uD%uD%uD%uD%}uD%uuD%muD%euD%]uD%UuD%MuD%EuD%=uD%5uD%-uD%%uD%uD%uD% uD%uD%tD%tD%tD%tD%tD%tD%tD%tD%tD%tD%tD%tD%tD%tD%tD%tD%}tD%utD%mtD%etD%]tD%UtD%MtD%EtD%=tD%5tD%-tD%%tD%tD%tD% tD%tD%sD%sD%sD%sD%sD%sD%sD%sD%sD%sD%sD%sD%sD%sD%sD%sD%}sD%usD%msD%esD%]sD%UsD%MsD%EsD%=sD%5sD%-sD%%sD%sD%sD% sD%sD%rD%rD%rD%rD%rD%rD%rD%rD%rD%rD%rD%rD%rD%rD%rD%rD%}rD%urD%mrD%erD%]rD%UrDATU?SHH dH%(HD$1D$HD$HD$nHމH-`ZH=ƔIH=r`H= f`H;Ht$Hrg|$t$H=הb1H=ɕb|$|$H=yU1H5yH51σ1H=F葅=bH=SLEuH1ATLI1H 2H=E~?詇1H=@;= AZH=HDA[@uH1SLeI1H )H=%?PH=s1{H=Fh1H=Ä[51D H 41LH=>]5Ӕ1D zH #1LŔH=X>D N115LH AQH=&_>H 膆= = z1H=H56L?L 11H pH==H=w1g1H=f虃H=bsLޓ1H uIH|H$H=U1=跅H= Si1?z=Y^H qHjH5SH=Lo1H=^H158D 1H L1H=<(1H=躂L 11LH H=<H|$H|$ 7R1H5菀1H5*|Ht$ H|$mH|$H|$ 4jXZHD$dH3%(H 1[]A\Á=͑ 1H=edH=.1ׁѐ15LH=H /PDH1;_AX4\H=pdH=yd1H=[ fh1AQLH q H=45D 9P.P1V;H }1I^HHPTLH H=8lH=nHnH9tHnlHt H=nH5nH)HH?HHHtHElHtfD=}nu+UH="lHt H=&ldUn]wATH5USHMrH=~I1L1H5pHH1H1 H ~HL1H5ĽwpHHujHPH9tHL[]A\f11H1 HetH=1ҀH5H=1轀H=n1诀ff.@AUI1ATUHtEH2LIHHtELIHtLnL]A\A]H=f17LH=(LH=n1ATH5;USHpH=H1L~H1H5oHI`uL4H[]A\sH܌H5H9tHɍH5йH9HʹHEH=}1vfDAUIATAUSH.HHHtFH)DL.HIHt1D)E19t6HD[]A\A]fH@LE19uHcLH蓩AH[D]A\A]ff.@AUIATL߸USHH(dH%(H$1Ld$LH5o LhHL$H¾HL4HtlHw LZHt1HL$ HT$LH5YuMkD$dD$ kdH$dH3%(u'H([]A\A]螂LH=H1}LH=1}@AUH=ATUSHdH%(H$1{5V~y1H$IL%fDH)HcMHHL 581\LHZYt;q8u1;ۉ|}H$dH3%(uHĨ[]A\A]HH=a1|DAWH=AVAUATUSHHdH%(H$81z D$DfoD$@.txt)D$0HD$0$1D$HD$ HcD$H=THi8HHpHD$lH5HHD$(12kHHwH5KHD$AH5=HAoH53HA]AEE11of.DDH2DDHHD$DDHH$A LL$L$HHH1D9d$tsHt.uHD$HHHH1nfDH|$ H5,$$HHuHt$ H=JH1zD$HH|$(D$D$;3]HtH<$u/5{H$8dH3%(uHH[]A\A]A^A_[H51vHt$0H=1%zDAWH=߼AVAUATUSHHdH%(H$81Pxz8twfooxtD$Pue.tfD$T)D$0fo`D$V)D$@HD$0D$1D$HD$ DLc|$H=Mi8L=IwL|$iH5QHHD$(1hIHH5LD$ H5ݳLAAƅE11QfDDDLDDLHAIؾHHH1D9|$ tmHt(uHD$H9HHH1UH|$ H5T$T$HHu9}Ht$ H=вH1CxD$LH|$(D$D$;HtHw|$u/xH$8dH3%(uHH[]A\A]A^A_H51NtHt$0H=B1wff.AWH=AVAUATUSHHdH%(H$81u fo"xtD$@nb.tfD$DD$F)D$0HD$0$1D$HD$ fDHcD$H=DHi8HHpHD$gH51HHD$(1"fHHgH5;HD$AqH5-HA_H5#HAMAEE11of.DDH"DDHHD$DDHH$ALL$L$HHH1D9d$tsHt.uHD$HHHH1nfDH|$ H5$$HHuzHt$ H=:H1uD$H H|$(D$D$;#]HtH<$u/%vH$8dH3%(uHH[]A\A]A^A_KH51qHt$0H=Ļ1uDH=t@u*H5+1wq1HH5-`qH51Mq1HH56qfDAWAVAUATUSH@H=E1aH=xC3n4H=H=ü1rH5qH=fdH5ʼHI1]cH5IHH5߮LALD$}Å}D:tu zQAD9t`DDLjT$DLHD$VHt$ H=}Ht:fuzuH=1nsfDLLHtH=|7 cw7=V C v =t[@t`H[]A\A]A^A_[ɀ=awH=z=s:wH=%x=vu'%@uH1[]A\A]A^A_gDH=dfH=Ytr@AVH=AUATUShAzH؀L +Hi8HL80~:H(H LD(H2 LUH(I9uH8L9uE1fDIcHi8HËUH-;LsHi8L8fDH8I9HuLu 9 LLLLtLLLLLLt1LLAD;%}HsfD3=}t*H=~H=~[]A\A]A^ D/ϐHpH=%1~pI I;HuLH=%H1SpHHH=Hu5pHHH=(Hup=|t+HH51|l1Ee1fDH5i1UlDHH=}b=q}s:v 1HdH=}1t1HdATHI1H5SkMtLH51A\k@H51A\kff.HH=1ZmH=#|>`H=}|,`|}:|c9H=^|H5|H=K}H5}U||HiQHiQH%H%9uK/}m}HiQHiQH%H%9uHnH=˺1$nH=1nH=1nH=)1mH5 H=Ժ1mDS@H=zi1H={[H5{H=zxv|-_cw ={ v6t"=R{_G{wf=t'f98|t[H=]1VmH=g1HmH=1:mf.AUATUSHH=lH(dH%(HD$1I`kL8=yHH5,1H=蟁H5HHHHH H=L-VQH1L@HLAH1L H!L!H1LHQLH1LHyLH1H ^HXH1LH|LH1LHLH1LcHܼLdH1H HۦGH1L&HL'H1LH'LHLHAULy1LL$HH1H YHSLD$H1H yHH1H HLMH1HdHH;?ZYu^LA,kHD$dH3%(uQI>لIH$ dH3%(H []A\A]A^A_fH=ٻ1fI>H5HHH H=A'H1Lu'HDuE1L-V裃HtHHIHcù'Lj'HM1L薄XZ9tH=u?uH l=Vus:=uLcE1I~'LHH9tA/N Icj'AHi8HtP1D9=tY^9t_HlI>uhg/HsHcþHA/H H[15LH5NwkI6H=H1f^kI6H=H1jff.AWIH=AAVAUATUSHt$`dH%(H$1UHD$HtH=?H跁HD$H=&HD$HtH=H舁HD$H=ѹHD$HtH=HYHD$H=HD$ HtH=H*HD$ H=HD$(HtH=tHHD$(H=cjHD$0HtH=MTH̀HD$0H=9;HD$8HtH=#%H蝀HD$8H= HD$@HtH=HnHD$@H=HD$HHtH=ոH?HD$H1H=ri1H=oi1H=ji1H=hri1H=edi1H=_Vi1H=VHi1H=Q:iH5-H=E'iH0rI9|$`H$IWxHHL$PRMLXPH\$`1HH=OH=PH5HY^HH A`D$Pw AGbD$PD$|E1E1H$D$tD$yD$xD$sD$rD$qD$pD$oD$nD$mD$lD$kD$XD$jD$iD$zD$hD$gD${D$fHHHHH5^114_HH5>HH:IHH+HI~XgAH$H1H\$XMHAwxLcdH=]NH=qNHH5_AXHHh E1H$L-BL5RDHHHHH5HHtо:IHH2HA|$ ID$u H8 tHL€Hƹ LAOHH5׵IHHtA:'IH`HHNI~eAGHH5HHtI:IHH;HI|$AaeAfHH5vHH:kIHHHI~eD$fD$t&fDH8Ht$H=ͳdHt$H=dzdHt$H=dHt$ H=dHt$(H=dHt$0H=dHl$8H=HdLt$@H=LzdH\$HH=HfdH|$\{H|$R{H|$H{H|$ >{H|$(4{H|$0*{H"{L{H{A`wD"d$fDd${D$zL$hD$gA |$iuA yD$X D$`|$je]T$kD$lET$mD$n-T$oD$pD$qT$r T$s|$xu A?T$yD$PH$dH3%(HĘ[]A\A]A^A_HEuHjI9H=1]|$`HWH `IWxHDHH5HHt?:IH?HH-I~+bD${D$|MHH5^HH:8IHHHILaL/AG(IHuHiHcI~aD$gAG$HiI9H=1j\HiI9H=1L\HH5PHH:gIHHHI~aD$hAG,"D$|IEL PD$|P1XZD$XH=1[H=1[H=}1[H=A1{[H=W1h[H=1U[HH5õHHt~:tIHtOHHvAI~`D$zAG07H=1Z@H=̴1Z#H=1Zf.HH5VHH:IHyHGHgI~t_D$iAG8A_Ht$PH= H1KZH='18ZH=1%Z0HIgHI9tH6hHAI9H3HD1H5`nV|$gE|$h"E|$iuA V|$jD$X D$`|$kg|$lD|$m!|$n|$o|$p|$q|$rtv|$st0|$xu A?c|$yt?|$Pt#H=ܵ1YH5֯1UH51mUH51XUH5g1CUrH5b1+USH561U0H5 1T H51TH5ή1TH51TH5w1TH571T^H51kT7H51STH51;TH51#TH5ĭ1 T8zHt$PH=H1TWH5-1S H=1)WH=1W.H=1WHH5DHHtL:"HH1HHHHHHHz[D$jAG4HH5HH:IHE1HHDHHHHLH5mmIHt|HHDHHHHv`LH5LLD$XLD$XHu.ILtD$X9H=1UKH=1UGH=1UDH=1UHH5תHHtS:HH1HHHHHHv}HzH5D$kHAGaYHH5jHHtj:HHHtE1HHHHHHv*HzYD$lAGH=1RH=׬1RHH5)HHtH:HH1HHHHHHvrHzWD$qAGPHH5CHHtj:HHtE1HHHHHHv*Hz\JH$dH3%(uH]A\LHH=1MDAWH=CAVAUATUSH҈HHxdH%(H$h1K=\LH=mZIE;L[1H IHPH=_1UMH=11RK=ZY^RL#H\$E1Hl$ LT$Ld$@Lt$`L$`IcHHi8H4Z1H5HfHsHNLHt$ LMH-HS1H5HD LL1sD LL1PHT$@H\$H=Y= [HE\$AHT$T:HT$1IH {ZIL1RHAV(LtD9==YXZD'<t]K8LH$hdH3%(uHx[]A\A]A^A_^f.@AWL=AVAUATUHSHdH%(H$1H~Lt$HD$Ll$HLd$PHH$HD$HHD$HHD$ HHD$(HHD$0HHD$8HHD$@HHGD$h%=@tHH51GM9tsIHI8IEPIRLAH1sLH޿ӾZYtNHڿH5H1?GM9uH$dH3%(uH[]A\A]A^A_мUILHdH%(H$1H$HVHǺHT$H%ZYxND$%=u~HBu\H1u:H$dH3%(u"HĠ]MHH=H1HHH=I1HHH=1HHH=1HSHHHdH%(H$1HND$H%=@u_H5HH5HH5}HfVH9tqH$dH3%(HĠ[ÐHH571JEH낐LHH5H1EHSfHH5HH5HH5Q荺ff.fAWAVAAUIATUHSHL$PL$Xt@)$`)$p)$)$)$)$)$)$dH%(H$(1Ld$ ILL$H$ LHD$H$0D$ D$ 0HD$=~HcI)LL 1HcH賷ÁCLH511BH5ުHSIH#LHߪH1޼LvL.ÅupH5H IHHH=%脼L,H$(dH3%(H[]A\A]A^A_fDH5P1BH=1i11LH5AAMtLHH51A4@HH5>1AH=1EHH=1Dff.UILHdH%(H$1HH111Hy3tu01H$dH3 %(u4H]@%IHH=H11DD9-gKH|$YA.D%JH[]A\A]A^A_H5p1:IcE1H=pJH $kAD$L4DIcLdEeEHI9tH-1JIcE}LdHtLHuLE)YH|$E1Y@1H='1<AWH5wH=JAVAUATUSH( dH%(H$ 1E-H=I1: IfoxtD$ es.tfT$$D$&)D$H$D$E11H$H$LH=€L5H4$E1 'LLLOADfCCH5HLHIHIt.MttLLLIHG1`D$L9-HHmHHcL4L=(I_Hc9fDLD$H5tuLLD$GLD$HIbL$?L$H=uH1L:DLر|$u9;H$ dH3%(uH( []A\A]A^A_L蟱踭LH5Tu17Ht$H=Q1z:f.AWAVAUATUSHH $HH $HHH5wtH|$(HLd$0dH%(H$8 1*L 7 LIHD$X`HLCLӨ1 *LL1H5|)H5HHdH5tHD$ QH5̧HD$>H5§HD$+H5HAH5HAHAܰHc|$HHi8SHD$ HXE1fT$ DH 1H肯T$DHC蠭HTT$DHHC腭 1H6DDHbHZTDDHHEH=TDDHHA$H߾HH1H8贫D9d$)H豮H|$'HD$(HL$ HHhL$HpH$8 dH3%(uHH []A\A]A^A_AWAVAUATUSHH $HH $HhdH %(H$X 1Ht$8HvHLd$PA(HL灻X`HD$@IHFH wHCA@ =2Et:HrLHCR jjP1腨H LLH51]&HH袮D$AHHqHD$oH5HD$\H5HD$0IH5HA7D$4EHD$8E1E1HD$ HHD$(L+T$DHHQT$0DHHCӪ1 H蔬C!DDCH诪1 HpHD$(HCH(D9t$ET$HADj 1H+T$HDCIC HMtLHD$谩H|$#QC HIT$4DHIHD$ HHL]uqHD$ H(HCD9t$AHxH|$@HD$8HL$HH(L$0H$X dH3%(uEHh []A\A]A^A_fDL`PC!HD$ HCfDD${薧fDAWIAVAUATUSHXHc0LD$@HL\$Ht$HT$HHL$8NL\$LT$HD$0E0A0A91E1^fDI(IcHHAD$DzA9 LH=>€A90HcHI(L$M,$E9u LH=tAT$IsH=1i3fL:LLT$L\$LHT$sHT$L\$LT$=@_w LH=ztKHJIt$LT$(L\$ HHT$Ht$HL$ HL$Ht$HT$L\$ LT$(HBHH\$08HD$8HHHCID$8HD$@HCHHCAAC AC$BC(AD$C,HHC0HBHC8E0A90wE9HD$HD0HD$0HX[]A\A]A^A_HH@HCID$8`HCH@HC`IsDH=11IMSML1H=ӨL1ML$HJIsH=1~1ff.=@ufAT1I1UH5şS-~?EI\$(HH-şMdhHKHSH1DKD1H@-L9u[H5Xl]11A\-AWAVAUATIUSHHhHED$pEE1DMcMi8J,70H(~aE1.@HLH(H{!AD;0}.IcHHH߀ tH?jLH(HfDSLADž0ID$hJ|06LE;|$pI|$hN!LID$hAD$pL1uAL$p~%@HcLHi8It$hA9\$pH<HI9tH=HiI9HiHE1H5%1,=>u'H[]A\A]A^A_H{wKH(AT$p~E1L5DIcID$h11Hi8H5iHT(1+Il$h0~;HcL1HH(HHHLHD@H1X+;0|H5j11A<+E;l$pqH[]A\A]A^A_fAWIAVIAUATIUHSHHLD$Ht;u9L茟IHtM8tHHIHEHMtLII$H]HHD8/uH[]A\A]A^A_Ht$LL1H=-ff.AVAUATA1UHSH dH%(HD$1D$ ;]:H}HD$CSH=HU:谞IMtH=藞 1HȡH=f;uIMtH=o\ 1H荡H=9f;z1H=K,Ht'H=9 IH=,HHH9A~bHUH= H- H=fH-uzVfDH5H=îmHv;HLl$ HqMH vHDH4sB48HcH>Dz?Jz@ :91H5L8TH=蘝H=茝1EH5O1(:F::H= 1ǟf 9fH=ϭ;+L58HMLH=1?LH8d7H=AFH=5H~8FHz8v7H=  1`7kH=?FH@8SH=\7FH=FH=E7HH37n/H= 1覞f8fH=Ǭ*L58HdMLH=1>LH8CH=/EH=#Hl8oEHh8H=WEHX8kH=HLd$HtMH5蔟HHLHHHH1H諛H;HuH=WH"H= BH5 H=H1=H=HH.HE1LԫH HH=z6-1L֫H HH=W7 H5C6L֫H~H HH57L׫H HH~HD$dH3%(H []A\A]A^HCH5@HCH6H5H= -zrH=辙1wH54H=1'H3H=M1'H5 H=81'H5U4H=ԩ1w'肚fAULATUSHH LdH%(H$ 1HHqH5)H2H%HqH1LL=*H5HHH3H5#~H9tH4H5`H9H`HEH=1$L$H1LLL蜗H5TLMHXZH~L$HLHtaHZ L=HtLAHCx&H$ dH3%(uH []A\A]H(*LH=*H1%AWAVAUATUSHHdH%(H$1_@LOxIL1DLmH5%L.IHIL$DLLHtr@?HHBHH$dH3%(H[]A\A]A^A_HLJH)2H5L1hNfDL? HH\HtL|fAgfD9-1YAտ1H5٥d 6LH=#ɖLH=X1#H=Y#f.fHdH%(HD$1=10~ u1HL$dH3 %(uAHfD1@Ht$ttËt$u0-舔8H=H1"H=1"fATIUHSHH$HL$PL$Xt@)$`)$p)$)$)$)$)$)$dH%(H$(1H\$ ILL$H$HHD$H$0D$D$ 0HD$^=.~uD1i<tk9.~?1Xזt~x_H$(dH3%(uGH[]A\DfDIH 7LH1}8qH=H1P!HIH L1@f=-AVIAUIATIUHSL~|@1a<tc 9-~G1P ϕ txT[]A\A]A^HILLL 1]D fD[E1]A\A]A^ 8tH=H1S ATIUHHdH%(H$18H=-7t'1H=:-u=,EH=.uRHLHN-xgHb@H7AH_;H,H$dH3%(uHH]A\1H=-t011w>$H=H1MXH=91:H=1,ff.ATUHSHH=HdH%(H$1IKH1UL -LLL4ZYt$iH$dH3%(uH[]A\LH={膑fDATUHSHdH%(H$1H"H1UL +HLhf1H,$L$L ,L3L31HH=˩21MIH ϩH= 1@kXZH$dH3%(u H[]A\蕐DAWAVAUATUSH@|$@H=1H5WH=x+ *H5.HI1i H葓{*H5lL1J HrH5eL11 H5WIH菒H5WL$}LD$QD$1d *H5L1 HLy;fu*{u$LfLH5ܤH1 Hʒ9l$$LT$LIߐ8fHu*xu$L LH5H1E HmLH=#* |$I0.)HH51 H1 @L L蘒H[]A\A]A^A_UH=1H5UH=) IKff.AWH=AVAUATUSHXdH%(H$H1 (*E1Ld$ Lt$@HL$@f.IcHAHi8H(#1H5_}H貑HsHLH4$LHzHS1H5I#D LL}1D LL}1蝋H=v(H\$ H1LAVH (II1H6LތD9='XZ^<t='`v1H='H$HdH3%(uHX[]A\A]A^A_ÿ袌fAVAUATUSHH=(dH%(H$1ҋ=(H=~HtHrfˊH{HHuH={貊H=&=&E1IH$L-{fIcMHi8L1AHa&D LDD HLI{1HD95"&H$dH3%(uH[]A\A]A^hAWIAVAUIATU1SHhdH%(H$X1Ld$PIH$P0f1H5!11HL.HAG($HLAVMAULPAG P1AwAG,H(HAVMOAULPAG$P1Aw賈H0A}tL111:ǃHˆL1H5ҫ#HL1H5/11HLHIW8Iw0IILH=ʤ1ALQL1AAAG(HMAVLAULPAG P1Aw贇AG,H(HAVMOAULKPAG$P1AwzH0蛇8uIH$XdH3%(u1Hh[]A\A]A^A_IW8Iw0IILH=1݈IW8Iw0IILH=(1fAV=O"HڢIAUHƢIATHEI1UH5HS="~sMLLLH1"~51H"HcLLHLL9"fDf<t[]A\A]A^E1LLLHf.AWAVAUATUSHHH|$Ht$HT$ HL$(dH%(HD$81GD$ M1fHD$Lcd$ Mi8L HD$M|$h9OLcMi8LMDI89)IvLBuLD$(HL$ LLHT$4tt$4HŅuIH0HL$D$ D$ 9AZHD$8dH3%(HH[]A\A]A^A_IVHAD$4= V w=!V ADž~D`IIIII@M9ZMtI>LcuH5NLH5LEtH5xLLH=61fATH5MUSHiH5:IH1H5HHSH1G 1HH[L]A\^f.@AUIATIUSHH(dH%(HD$1HHrH5tHSLH8H5PH9H5HA$1HH5/ĈH;tH5&HH3HH<$ˆHI耄HD$dH3%(uH(L[]A\A]蝄ff.fSHH=!HH= Ht7H5vHH=H= rH=1H5iH5H=SH[HHHpff.ATUHHHT$0HL$8LD$@LL$Ht7)D$P)L$`)T$p)$)$)$)$)$dH%(HD$1H$II HD$HD$ H=$D$0HD$YH11H5k H5HcHI8wHD$dH3%(uYHL]A\HHSH5H1 LHmH=arfATHHHǘHt.HIduRLH5V1_H臅LA\1JH5kH1 H=؀莅LH57H1P L訅fDAULvATUHH LOxdH%(H$1Ll$D$LD$ H5[LdHHŨIH1HH5НtT1HL$ HT$HH5hHu4LakD$dD$ kdH$dH3 %(u/H ]A\A]LH=s1 LH=:1 讀ff.AVAUATUSHH $HdH%(H$1=Hfo$Hns=0700HD$0H)$fo)D$fo)D$ HtG`H|$7HHL LŜLCHP1~XZHHHL5LH H5ڝHL$L%}HDL9LLHEʁ{z HFHFHHt$VPQRP1AT~}LH@MH Π111AĉDtMEusHHH"FHHH~H赂Et]H$dH3 %(u@H[]A\A]A^HH=y>s~HH5bH9tL9H5EHEHEH=<1- HeH5aH1HH0H5hbH9tL9H5(EH%EHELH=1 1H5H1Aff.@HHH9tHH9t@HHf@LH MH5ELHDHHQH HDE1@AH=1R1DHHfDRfAWAVAUATUSH{H H8IHH-L-̙L5ϙL=ҙ@LCMLHt H=zLucLzHtVtO HLt8 HLt!HLɀ/tu&fH8H;RHL[]A\A]A^A_zHsHH=f1H=1fAWAVAUATUSHH $HH $HH5BH=dH%(H$ 1L$L tv LHD$HÁ= X`HQLCL~1 eyLH1H5AHIHHH5uL~}Aŋ1Lt$c@ H5HHH1D$(%=@tHcH5H19K~yDLHc{HH'L<"LIH H4{tx8QHH5H13TfDL@}H|$}H$ dH3%(u.Hĸ []A\A]A^A_ÐHH< HzySHs:wH=A"H[WH1H=UH[HsH=LH=@~H5H=ztHH=.fATSHH $HH $H IIIdH%(H$ 1 LzLMt7LLxH=Pzw=vt'f.wKLH5ҙ1zH=^ zH$ dH3%(pH [A\uLH51ezH=[v_{=LMLLHMr19{H=]yH=xJvL H!%tMLz?DHJHDщ@HL)H:w7A::L1H5vyjfMLLTfH5q1=y\%vff.fHHT$0HL$8LD$@LL$Ht7)D$P)L$`)T$p)$)$)$)$)$dH%(HD$1H$H$HD$HD$ HD$D$0HD$dH3%(uHuff.ATUHH$@H$HL$PL$Xt@)$`)$p)$)$)$)$)$)$dH%(H$(1Ld$ ILL$H$LHD$H$0D$D$ 0HD$+w1LH5fXH$(dH3%(u H]A\tDATHH$8H$@H$HL$PL$Xt@)$`)$p)$)$)$)$)$)$dH%(H$(1Ld$ ILL$H$LHD$H$0D$D$ 0HD$v|$ tBL H!%tDHJHDщ@HL)| t=L<1H5H$(dH3%(u'HA\DLH513sH=J;1nff.PXHIHt$(HT$0HL$8LD$@LL$Ht7)D$P)L$`)T$p)$)$)$)$)$dH%(HD$1H$HLHD$HD$ HD$$D$0H=:quHH51uH=nHtDSHqH|Y"3HP@u%8HHH3H@13@tHJ@"u"Hf"f [fDAUI'ATUHSHtAu@tMLL%*@HHt3@t)@ t:@ t4@'uLHHcu3@uHH'[]A\A]dtH=}L1Httff.fATIUHHt$HHƒ߃Avq.<1vd'LsEu3HL']A\s<\tuLHsEt<'u\LsfHsAHrHHL]A\HtAUATIUHSH(dH%(HD$1HH1۾HHDJHt7  ȃ߃A<vփ.1vJHuH55HsILp1H5^L'sLL\H5H1 sH<$HHGsLn HRrHD$dH3%(uVH([]A\A]H5 sLHHrH=,L1HېvrLrnATSHHdH%(HD$1nHAbHt&HHHD$dH3%(uHD[A\H4$H=Ŋ1%0nHl8rHHH 1lqHHt'HH1HH=HHn qf.AWAVAUATIH=USHHt$ @t$ dH%(H$81AT$pqlfofD$@D$B)D$0H$E11DH<$Lt$LHnIuLL,$H|$LkmLAlLeH=яpL)pHpA9\$pHcLHi8IL$hHqI(H5YHH1H5HIo1Ln1 Hm{|$ AefLt$0H5T3L,oH$HLH=|H1fDH$HtH?kEtZ1H5k|$ tPH51-H$8dH3%(uDHH[]A\A]A^A_+fHT$0H51QkAWAVAUIH=ATUSHxdH%(H$h1iAMpfo}tD$pe.txfT$t)D$`HD$`E1Lt$@1D$ HD$8fLcd$ LMi8MehIt$CLHD$k1H?LH5#^nAW`H5ޒL1[Ht,HH /H=ZZH vH=KZZfDHt2Ufff.@7ATHAUHSHEHWHt:At/u*Hw!HH9sHDHHBH9w[]A\Au_ff.@7wf.AWAVAUATUSHH<$EUH=TIH-@A1I@A$HXWHtkfx.L@tfx..t D{E9}'LI\JHIcfAxtD{E9|ELLD$IcH)LD$IA<$u0IDHUuKHL[]A\A]A^A_fXH $H=;IH1XA<$XH $H=IH1VX뉋8E1XH $H=IH 1)XY@UHSHH?HtH H{HHuHH[]HtGHLHDPHWtHHH9uHHxuH)HDHDHxuH)HfDSHWSHH9s HH9r[@HH9t8/t[ff.fSHSHD/tHPH/u3H9r/u)H9r fHH9t7x/tH9t,[H9rfH9tH8/u1Ҁ8/H[1ff.PnfD;.u{.u {t~d;tvH;tHO*f.ffDO../H߃uOHø..fC[]A\~H߃OuAUATIUHHSHU1۸/L~ @8u4HcTt(AtuLHTLLqff.@SH.t H5}HRAHtFD[Ð.t".uՀ{.uπ{/AuD[fDAuD[HME1~HH=&}HtAff.?/tH>H@1ff.fATIUHSMMLHHcH,LA1EuA/ []A\ff.ATIt&H1/HDPHuHFHLELQHtA\H=sLHF|PZKf.AVAUATUSH?/IHNHHt@HH?MIHKHD0A"uBJHHbNHHuH E1H={ P2JDCPH=H8|H1O[L]A\A]A^f.OIHLg[L]A\A]A^E1HH!%tLDHSHDډHQKH)H|tMIHt0HMIHH <1OHI]HIH H=zN fHHH5tz:f.HHH5kzf.HHH5`zf.f.HHH5zf.HHH5)zf.f.HHH5zzf.HHH5 zZf.f.HHH5y*f.UHH $HH $HPdH%(H$H 1HHD$;JLD$HT$@ Ht$ HD$E1HtHp HbAH$H dH3%(u HP D]XI?tff.DAVIAUIATUSfDAEeIIA8tMPX vÄxOAD$<w&Al$ @8t@[)]A\A]A^f.DEx@@8u@u[1]A\A]A^L@HDhtLHLEHBD`tLHB,DAWL<AVAUIATIUSH@M9taA$AmIIA@8tBE<wZ C<w(Ds D8tH@E[D)]A\A]A^A_Dx\D8uEuH1[]A\A]A^A_f@yL@HHT$DPtKHT$H,vDKHDXtKHD4f.ATGDgSH<vA@xHD[A\{KAHDXtEHD$H[DA\DATGDg SH<vA@xHD[A\KAHDXtJHD$H[DA\DWGCff.@WG Cf.DHHHvHHDHAH Au#HHWFH9ufDH1f.H LLH HH9ufDAUIATIUHSHHLH߅x>Յ~HH[]A\A]f.LLՅx&HL[]A\A]fDՅxLLՅxHL[]A\A]AWHAVIAUIATUSHHHHT$HD$0HD$D$L HD$HLHD$(HD$0HD$ HHD$(Hl$0H9nL|$H\$HHMILH9BHHL)Aօ~H\$HD$HLCHLHO|LHt!LMH(wHLL|Hŋt$IEHUIUHEL9|$0H\$0Lf.H\$LHAօJL;|$s(fDIHUIHELMI9tLLAօx&uT$t̋L$HT$HLpfDD$HIHIHD$MHHT$HI9SHD$(HH+T$ L)H)H+D$HH9HGIHD$ L)H9HNHMtHt$(L$LH|$L)H9H;\$~HL$H9H1HHfDL$HT$LH7u#L$uSHL$ HHHHHL$HL$ HD$HHT$ HD$HHNHu@HH[]A\A]A^A_ËL$HT$HH|$ 릋L$HT$HLHD$011E1HD$Ht$L$LH)1H|$D$HH\$LLIT]ItHIHTIHH)LLT$HD$8LT$LLHK4J<LL$8HL\$H1H|$(LIH)LHZH9l$sH|$H1LHHLHHL$H9H1Ll$(HI)HID HD$0H\$HH9D$(Dd$Hl$Ll$HD$ HL$H9vQIIEITIUIDL9|$s0MI)LLAօ~EtDHLLNL9|$rHl$ HD$ H;D$(rHH[]A\A]A^A_HHT$DH6H?QAA?AWL=sAVIAUIATAUH-dSL)H6Ht1LLDAHH9uH[]A\A]A^A_ff.f.H1BHHtemplate1newnone"%s/pg_ctl" --version%*s %*s %d.%dnspnamerelnameattnameCould not open file "%s": %s Database: %s %s.%s.%s fatal proname %s.%s datnamedatallowconntemplate0pg_catalog *Clusters are compatible* Checking cluster versions-U sh%sanalyze_new_cluster.%s#!/bin/sh echo%s 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_userdatabase user "%s" is not the install user SELECT COUNT(*) FROM pg_catalog.pg_roles 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 %s cluster contains prepared transactions Could not get pg_ctl version data using %s: %s could not get version from %s Checking for new cluster tablespace directoriesnew cluster tablespace directory already exists: "%s" Checking for reg* system OID user data typesSELECT 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 JSONB user data typesSELECT 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 one of the JSONB data types 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 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 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. This utility can only upgrade to PostgreSQL version 9.0 after 2010-01-11 because of backend API changes made during development. 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 --analyze-only%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_jsopg_controldata"pg_resetxlog" -nLC_COLLATELC_CTYPELC_MONETARYLC_NUMERICLC_TIMELANGLANGUAGELC_ALLLC_MESSAGES"%s/pg_controldata" "%s"Database cluster state:shut down in recovery shut down "%s/%s "%s"pg_control version number:%d: pg_resetxlog problem Catalog version number:Latest checkpoint's NextXID:Latest checkpoint's NextOID:01234567890ABCDEF0123456789ABCDEFFloat8 argument passing:by valueMaximum data alignment:Database block size:WAL block size:Bytes per WAL segment:Maximum columns in an index:Size of a large-object chunk:Date/time type storage:64-bit integerschecksum%08X%08X%08X checkpoint next XID latest checkpoint next OID maximum alignment block size WAL block size WAL segment size maximum identifier length maximum TOAST chunk size large-object chunk size dates/times are integers? data checksum version %s/global/pg_control%s/global/pg_control.oldUnable to rename %s to %s. could not get control data using %s: %s %d: database cluster state problem The source cluster was shut down while in recovery mode. To upgrade, use "rsync" as documented or shut it down as a primary. The target cluster was shut down while in recovery mode. To upgrade, use "rsync" as documented or shut it down as a primary. The source cluster was not shut down cleanly. The target cluster was not shut down cleanly. The source cluster lacks cluster state information: The target cluster lacks cluster state information: Could not get control data using %s: %s %d: controldata retrieval problem Latest checkpoint's TimeLineID:First log file ID after reset:First log file segment after reset:Latest checkpoint's NextMultiXactId:Latest checkpoint's oldestMultiXid:Latest checkpoint's NextMultiOffset:First log segment after reset:Blocks per segment of large relation:Maximum length of identifiers:Maximum size of a TOAST chunk:The %s cluster lacks some required control information: latest checkpoint next MultiXactId latest checkpoint oldest MultiXactId latest checkpoint next MultiXactOffset first WAL segment after reset float8 argument passing method large relation segment size maximum number of indexed columns Cannot continue without required control information, terminating old and new pg_controldata alignments are invalid or do not match Likely one cluster is a 32-bit install, the other 64-bit old and new pg_controldata block sizes are invalid or do not match old and new pg_controldata maximum relation segment sizes are invalid or do not match old and new pg_controldata WAL block sizes are invalid or do not match old and new pg_controldata WAL segment sizes are invalid or do not match old and new pg_controldata maximum identifier lengths are invalid or do not match old and new pg_controldata maximum indexed columns are invalid or do not match old and new pg_controldata maximum TOAST chunk sizes are invalid or do not match old and new pg_controldata large-object chunk sizes are invalid or do not match old and new pg_controldata date/time storage types do not match old cluster does not use data checksums but the new one does old cluster uses data checksums but the new one does not old and new cluster pg_controldata checksum versions do not match Adding ".old" suffix to old global/pg_control If you want to start the old cluster, you will need to remove the ".old" suffix from %s/global/pg_control.old. Because "link" mode was used, the old cluster cannot be safely started once the new cluster has been started. --verbosepg_upgrade_utility.logpg_upgrade_dump_globals.sqldbname=pg_upgrade_dump_%u.custompg_upgrade_dump_%u.logCreating dump of global objects"%s/pg_dumpall" %s --globals-only --quote-all-identifiers --binary-upgrade %s -f %sCreating dump of database schemas "%s/pg_dump" %s --schema-only --quote-all-identifiers --binary-upgrade --format=custom %s --file="%s" %sglobalpg_clogpg_multixactpg_subtranspg_tblspcpg_twophasepg_xlog%s%s%scheck for "%s" failed: %s %s is not a directory %s/%spostgrespg_ctlpg_resetxlogpsqlpg_dumppg_dumpallcommand too long >> "%s" 2>&1acannot write to log file %s command: %s *failure*%s/postmaster.pidcheck for "%s" failed: not an executable file check for "%s" failed: cannot read file (permission denied) check for "%s" failed: cannot execute (permission denied) There were problems executing "%s" Consult the last few lines of "%s" or "%s" for the probable cause of the failure. Consult the last few lines of "%s" for the probable cause of the failure. could not open file "%s" for reading: %s You must have read and write access in the current directory. could not write new page to destinationcould not create destination filefound partial page in source fileCannot in-place update this cluster, page-by-page conversion is requiredCould not create hard link between old and new data directories: %s In link mode the old and new data directories must be on the same file system volume. could not open source file%s/PG_VERSION%s/PG_VERSION.linktestSELECT DISTINCT probin FROM pg_catalog.pg_proc WHERE prolang = %u AND probin IS NOT NULL AND oid >= %u;SELECT 1 FROM pg_catalog.pg_proc p JOIN pg_catalog.pg_namespace n ON pronamespace = n.oid WHERE proname = 'plpython_call_handler' AND nspname = 'public' AND prolang = %u AND probin = '$libdir/plpython' AND p.oid >= %u; The old cluster has a "plpython_call_handler" function defined in the "public" schema which is a duplicate of the one defined in the "pg_catalog" schema. You can confirm this by executing in psql: \df *.plpython_call_handler The "public" schema version of this function was created by a pre-8.1 install of plpython, and must be removed for pg_upgrade to complete because it references a now-obsolete "plpython" shared object file. You can remove the "public" schema version of this function by running the following command: DROP FUNCTION public.plpython_call_handler() in each affected database: Remove the problem functions from the old cluster to continue. Checking for presence of required librariesCould not load library "%s" %s Your installation references loadable libraries that are missing from the new installation. You can add these libraries to the new installation, or remove the functions using them from the old installation. A list of problem libraries is in the file: %s %s $libdir/plpython2$libdir/plpythonloadable_librarit.spclocationoidencodingdatcollatedatctyperelfilenodereltablespacepg_toast/basemappings for database "%s": %s.%s: %u to %u %s databases: pg_catalog.pg_tablespace_location(t.oid)SELECT d.oid, d.datname, d.encoding, d.datcollate, d.datctype, %s AS spclocation FROM pg_catalog.pg_database d LEFT OUTER JOIN pg_catalog.pg_tablespace t ON d.dattablespace = t.oid WHERE d.datallowconn = true ORDER BY 2pg_catalog.pg_tablespace_location(t.oid) AS spclocation, 'pg_largeobject_metadata', 'pg_largeobject_metadata_oid_index'WITH regular_heap (reloid) AS ( SELECT c.oid FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid LEFT OUTER JOIN pg_catalog.pg_index i ON c.oid = i.indexrelid WHERE relkind IN ('r', 'm', 'i', 'S') AND i.indisvalid IS DISTINCT FROM false AND i.indisready IS DISTINCT FROM false AND ((n.nspname !~ '^pg_temp_' AND n.nspname !~ '^pg_toast_temp_' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'binary_upgrade', 'pg_toast') AND c.oid >= %u) OR (n.nspname = 'pg_catalog' AND relname IN ('pg_largeobject', 'pg_largeobject_loid_pn_index'%s) ))), toast_heap (reloid) AS ( SELECT reltoastrelid FROM regular_heap JOIN pg_catalog.pg_class c ON regular_heap.reloid = c.oid AND c.reltoastrelid != %u), all_index (reloid) AS ( SELECT indexrelid FROM pg_index WHERE indisvalid AND indrelid IN (SELECT reltoastrelid FROM (SELECT reloid FROM regular_heap UNION ALL SELECT reloid FROM toast_heap) all_heap JOIN pg_catalog.pg_class c ON all_heap.reloid = c.oid AND c.reltoastrelid != %u)) SELECT c.oid, n.nspname, c.relname, c.relfilenode, c.reltablespace, %s FROM (SELECT reloid FROM regular_heap UNION ALL SELECT reloid FROM toast_heap UNION ALL SELECT reloid FROM all_index) all_rels JOIN pg_catalog.pg_class c ON all_rels.reloid = c.oid JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid LEFT OUTER JOIN pg_catalog.pg_tablespace t ON c.reltablespace = t.oid ORDER BY 1;old and new databases "%s" have a mismatched number of relations Extra non-TOAST relation found in database "%s": new OID %d Mismatch of relation OID in database "%s": old OID %d, new OID %d Mismatch of relation names in database "%s": old name "%s.%s", new name "%s.%s" relname: %s.%s: reloid: %u reltblspace: %s You must identify the directory where the %s. Please use the %s command-line option or the %s environment variable. pg_upgrade upgrades a PostgreSQL cluster to a different major version. Usage: pg_upgrade [OPTION]... Options: -b, --old-bindir=BINDIR old cluster executable directory -B, --new-bindir=BINDIR new cluster executable directory -c, --check check clusters only, don't change any data -d, --old-datadir=DATADIR old cluster data directory -D, --new-datadir=DATADIR new cluster data directory -j, --jobs=NUM number of simultaneous processes or threads to use -k, --link link instead of copying files to new cluster -o, --old-options=OPTIONS old cluster options to pass to the server -O, --new-options=OPTIONS new cluster options to pass to the server -p, --old-port=PORT old cluster port number (default %d) -P, --new-port=PORT new cluster port number (default %d) -r, --retain retain SQL and log files after success -U, --username=NAME cluster superuser (default "%s") -v, --verbose enable verbose internal logging -V, --version display version information, then exit -?, --help show this help, then exit Before running pg_upgrade you must: create a new database cluster (using the new version of initdb) shutdown the postmaster servicing the old cluster shutdown the postmaster servicing the new cluster When you run pg_upgrade, you must provide the following information: the data directory for the old cluster (-d DATADIR) the data directory for the new cluster (-D DATADIR) the "bin" directory for the old version (-b BINDIR) the "bin" directory for the new version (-B BINDIR) For example: pg_upgrade -d oldCluster/data -D newCluster/data -b oldCluster/bin -B newCluster/bin or $ export PGDATAOLD=oldCluster/data $ export PGDATANEW=newCluster/data $ export PGBINOLD=oldCluster/bin $ export PGBINNEW=newCluster/bin $ pg_upgrade Report bugs to .pg_upgrade (PostgreSQL) 9.5.25Try "%s --help" for more information. ----------------------------------------------------------------- pg_upgrade run on %s----------------------------------------------------------------- -c default_transaction_read_only=falseFinding the real data directory for the %s cluster"%s/postgres" -D "%s" -C data_directoryCould not get data directory using %s: %s cannot find current directory Cannot read line %d from %s: %m User-supplied old port number %hu corrected to %hu PGPORTOLDPGPORTNEWPGUSER--help%s: cannot be run as root pg_upgrade_internal.log%s %sinvalid old port number invalid new port number Running in verbose mode d:D:b:B:cj:ko:O:p:P:rU:vPGOPTIONSold cluster binaries residePGBINOLDnew cluster binaries reside-BPGBINNEWold cluster data resides-dPGDATAOLDnew cluster data resides-DPGDATANEW%s/postgresql.confCannot open file %s: %m %huold-datadirnew-datadirold-bindirnew-bindirold-optionsnew-optionsold-portnew-portusernamechecklinkretainjobs RSQSSSSSSSSSSQwQSSSS=QSSSSSSSSSSSS%QPPSSSSSQPSSSPVPSJPSSS+Pwaitpid() failed: %s child process exited abnormally: status %d could not create worker process: %s There seems to be a postmaster servicing the old cluster. Please shutdown that postmaster and try again. There seems to be a postmaster servicing the new cluster. Please shutdown that postmaster and try again. Could not get path name to pg_upgrade: %s could not delete directory "%s" Setting frozenxid and minmxid counters in new clusterUPDATE pg_catalog.pg_database SET datfrozenxid = '%u'Setting minmxid counter in new clusterUPDATE pg_catalog.pg_database SET datminmxid = '%u'ALTER DATABASE %s ALLOW_CONNECTIONS = trueUPDATE pg_catalog.pg_class SET relfrozenxid = '%u' WHERE relkind IN ('r', 'm', 't')UPDATE pg_catalog.pg_class SET relminmxid = '%u' WHERE relkind IN ('r', 'm', 't')ALTER DATABASE %s ALLOW_CONNECTIONS = falseRestoring database schemas in the new cluster "%s/pg_restore" %s --exit-on-error --verbose --dbname %s "%s"Analyzing all rows in the new cluster"%s/vacuumdb" %s --all --analyze %sFreezing all rows on the new cluster"%s/vacuumdb" %s --all --freeze %sSetting next transaction ID and epoch for new cluster"%s/pg_resetxlog" -f -x %u "%s""%s/pg_resetxlog" -f -e %u "%s""%s/pg_resetxlog" -f -c %u,%u "%s"Setting next multixact ID and offset for new cluster"%s/pg_resetxlog" -O %u -m %u,%u "%s"Setting oldest multixact ID on new cluster"%s/pg_resetxlog" -m %u,%u "%s""%s/pg_resetxlog" -l 00000001%s "%s"Restoring global objects in the new cluster"%s/psql" --echo-queries --set ON_ERROR_STOP=on --no-psqlrc --dbname=template1 %s -f "%s"Setting next OID for new clusterDeleting files from new %sCopying old %s to new servercp -Rf "%s" "%s" Performing Upgrade ------------------ pg_multixact/offsetspg_multixact/membersResetting WAL archives"%s/pg_resetxlog" -o %u "%s"Sync data directory to disk"%s/initdb" --sync-only "%s" Upgrade Complete pg_upgrade_server.log%s%s/%u/%u%s%scopying "%s" to "%s" linking "%s" to "%s" LinkingCopying%s user relation files _fsm_vmerror while checking for file existence "%s.%s" ("%s" to "%s"): %s error while copying relation "%s.%s" ("%s" to "%s"): %s error while creating link for relation "%s.%s" ("%s" to "%s"): %s old database "%s" not found in the new cluster SELECT c.relname, c.relfilenode FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n WHERE c.relnamespace = n.oid AND n.nspname = 'pg_catalog' AND c.relname = 'pg_database' ORDER BY c.relname user= port=%d host=--host --port %d --username executing: %s SQL command failed %s %s Failure, exiting%63sunix_socket_directoryunix_socket_directories -b -c %s='%s'-m fast-m smartPGHOSTPGHOSTADDRlocalhost127.0.0.1::1SELECT pg_catalog.set_config('search_path', '', false)connection to database failed: %s could not open version file "%s" could not parse version file "%s" -c synchronous_commit=off -c fsync=off -c full_page_writes=off -c vacuum_defer_cleanup_age=0 -c autovacuum=off -c autovacuum_freeze_max_age=2000000000"%s/pg_ctl" -w -l "%s" -D "%s" -o "-p %d%s%s %s%s" startcould not connect to %s postmaster started with the command: %s pg_ctl failed to start the %s server, or connection failed connection to database failed: %s "%s/pg_ctl" -w -D "%s" -o "%s" %s stoplibpq environment variable %s has a non-local server value: %s -c listen_addresses='' -c unix_socket_permissio/PG_%s_%dpg_catalog.pg_tablespace_location(oid) AS spclocationSELECT %s FROM pg_catalog.pg_tablespace WHERE spcname != 'pg_default' AND spcname != 'pg_global'tablespace directory "%s" does not exist cannot stat() tablespace directory "%s": %s tablespace path "%s" is not a directory Cannot upgrade to/from the same system catalog version when using tablespaces. ... %s%-*.*s %s%-*sok'"'"'\connect -reuse-previous=on %s=%sshell command argument contains a newline or carriage return: "%s" database name contains a newline or carriage return: "%s" Checking for large objectscountcould not open file "%s": %s warningpg_catalog.lineIn database: %s SELECT count(*) FROM pg_catalog.pg_largeobject SELECT pg_catalog.lo_create(t.loid) FROM (SELECT DISTINCT loid FROM pg_catalog.pg_largeobject) AS t; Your installation contains large objects. The new database has an additional large object permission table. After upgrading, you will be given a command to populate the pg_largeobject permission table with default permissions. Your installation contains large objects. The new database has an additional large object permission table, so default permissions must be defined for all large objects. The file %s when executed by psql by the database superuser will set the default permissions. Checking for invalid "line" user columnsWITH RECURSIVE oids AS ( SELECT '%s'::pg_catalog.regtype AS oid UNION ALL SELECT * FROM ( WITH x AS (SELECT oid FROM oids) SELECT t.oid FROM pg_catalog.pg_type t, x WHERE typbasetype = x.oid AND typtype = 'd' UNION ALL SELECT t.oid FROM pg_catalog.pg_type t, x WHERE typelem = x.oid AND typtype = 'b' UNION ALL SELECT t.oid FROM pg_catalog.pg_type t, pg_catalog.pg_class c, pg_catalog.pg_attribute a, x WHERE t.typtype = 'c' AND t.oid = c.reltype AND c.oid = a.attrelid AND NOT a.attisdropped AND a.atttypid = x.oid UNION ALL SELECT t.oid FROM pg_catalog.pg_type t, pg_catalog.pg_range r, x WHERE t.typtype = 'r' AND r.rngtypid = t.oid AND r.rngsubtype = x.oid ) foo ) SELECT 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 IN (SELECT oid FROM oids) AND c.relkind IN ('r', 'm', 'i') AND c.relnamespace = n.oid AND n.nspname !~ '^pg_temp_' AND n.nspname !~ '^pg_toast_temp_' AND n.nspname NOT IN ('pg_catalog', 'information_schema')Your installation contains the "line" data type in user tables. This data type changed its internal and input/output format between your old and new clusters 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 pg_largeobject.stables_using_lincould not identify current directory: %scould not change directory to "%s": %scould not read symbolic link "%s"could not find a "%s" to executeno data was returned by command "%s" invalid binary "%s"PATHcould not read binary "%s"pclose failed: %s/%s%s"%s" -Vpopen failurefgets failurepostgres-9.5PGSYSCONFDIRPGSYSCONFDIR=%svsnprintf failed: %s with format string "%s" could not stat file or directory "%s": %s could not remove file or directory "%s": %s user does not exist%s: %s could not look up effective user ID %ld: %schild process exited with exit code %dchild process was terminated by signal %d: %schild process exited with unrecognized status %dcommand not execcommand not founcannot duplicate null pointer (internal error) could not open directory "%s": %s could not read directory "%s": %s could not close directory "%s": %s /../usr/local/pgsql/bin/../%s: out of memory /usr/local/pgsql/share/usr/local/pgsql/etc/usr/local/pgsql/include/usr/local/pgsql/lib/usr/local/pgsql/share/locale/usr/local/pgsql/share/doc//usr/local/pgsql/share/mancould not get current working directory: %s /usr/local/pgsql/include/serverunrecognized signal;(\4DDtDdht(t t( D Td $$ T   Dd    l d    D |  "$t(+0+`-.5T689d;H4<d=> ?P$AB4DFGI $JLKK$MMN(QRRS,VTVVYYZ@d\h\|D]t]]^t_@`|daaaaDdD4ggjlTTmDoTpTqTdrtu8u\vvwwx04xLxhx|xxdytyyyy,4{xt{{$||| |$ $}8 T}L d}` ~  !8!P!4|!!d!!"Ą$"Ԅ8"L"`"$t"D"d"t""D"d#DT#D## $$4$DL$dd$ĉx$D$T<%dT%th%|%%%zRx /D$4pFJ w?:*3$"\t,BHA  ABG ,BGA L BBA ,XBHA J ABE HBED A(D0M (D ABBJ w(A DBB8h<BOH A(O (A ABBA H BIA A(G P T ] A x (A ABBA L{BIB B(A0A8G - 8A0A(B BBBA L@uBIB B(A0A8G ' 8A0A(B BBBA L$BIB B(A0A8G = 8A0A(B BBBA djHl L ^d,FBB B(A0C8DP~ 8A0A(B BBBD R 8C0A(B BBBJ <h|YFIB A(A0 (A BBBJ KQgIHc E TUFq I PD+H E XEv A H<GFBA A(NPXH`XAPe (A ABBB pvFPL B(A0A8G 8A0A(B BBBJ YZAzUOA+FLB B(A0A8GnTAA9_yB! 8A0A(B BBBA EHAH D ,8FHG ABA lBFIB B(A0A8QVJ_A0IUA} 8A0A(B BBBA \<BIB B(A0D8G  N g A A 8A0A(B BBBA 0A[ _ A ` A P AA CAJ AB LFBE E(A0D8G 8A0A(B BBBG D0 E`] AE h _HD E H FBB A(A0G L@I@ 0A(A BBBJ I_W J D(FRL ABA 4x?FAA ` ADC AGBHTFBB B(A0A8DP 8A0A(B BBBA PfFPB B(A0A8G 8A0A(B BBBA TxBBB B(A0A8G L@IAB 8A0A(B BBBA hL jBBB B(A0A8G L@IAALABAAAKAh 8A0A(B BBBG L FEB B(A0A8DY 8A0A(B BBBH , RHJ IHF`8 ,^FBB B(D0A8D@p 8A0A(B BBBA 8A0A(B BBBH (BEE B(D0D8DPd 8A0A(B BBBA @ nFBB F(D0DP 0A(A BBBH L, $FSF A(JHxAn (A ABBD L| H&FBB B(A0A8J 8A0A(B BBBA  'H y G 4 (FDD G   AABF P *MEE D(D0~ (A BBBD y (D BBBE (t *$BDJ ABA @ +BAD S_HlAc  AABA @ ,BFD G_HAZ  AABA H( ,BBB B(A0A8DP 8A0A(B BBBE \t .BIB B(A0A8GGkAW 8A0A(B BBBA D /8BBB A(A0G 0A(A BBBA FAH G@$HIP{HM@IHHPRHFPkHFP{XU`P@wHFPHA@yHMPHA@X  CABA zH[PQHB@DH[PHXG`K@P0BEB E(A0C8GiEOMEFMEPMEFIEOMEFMEPMEFIj 8A0A(B BBBA <lH2FSL J(P0u (A BBBE H2FBB B(A0A8D 8A0A(B BBBH (|4rFHA XDB8$4BED A(GP (D ABBA `t5E K (6^FAJ DBA H7FH A 07FSF J  ABBA |8FBB A(A0G L11F2H1A1g1F2F2H2F2F2H2B2L1 0A(A BBBI 4;lu_ Y;L;7FBB B(A0A8D@ 8D0A(B BBBE T<0BBB B(A0A8G L@LA 8A0A(B BBBB \x>IAc D `|>WHB A 0>SBAG L@I@ ABH AK A (A FAI  ABA $B}FG K BF @CTDEAGpD+H^DjEd8EFJA D(D0` (I ABBE 4EFDG D IBH RGB8,FyFBD D(DP (A ABBA (TpGpFAG0D DBA G HPGHPG5MXLG_FBB B(K0A8G  8A0A(B BBBI LIFBB L(A0A8G s 8A0A(B BBBD (lLBDOo DBF DMBGB A(D0GB 0D(A BBBD HNFBB B(D0I8G 8A0A(B BBBI 0,HQFAD G DBH ~DBT`QFBB D(G0JDY\A 0A(A BBBF 0\SFFK Gd  AABJ <8TFEE D(A0i (D BBBH D,TFBB D(A0G 0D(A BBBA \tUFBB B(D0A8G V L e A w 8D0A(B BBBD 8WFBA D(D0s (D ABBC WoFG q BA <4 X0EAIWG^Af AAD tY-AAU$Y(HZ A (8YeEII F AAA ,|YqFLD L ABA Y+KZ A $YjHS A @4ZT@Z h IP c ,w     7   (  @p p&, > M ` @q 0Q,    @,  ` P Pb (3H]@xBop_+ e  XG3fLPB^ fp  C/w`j k`~.`>E\l0`e `VU=@`SY#W?VI`sP v$9L`obufu_,j=rYgp y[vd`  P(1 K0hz5[@Pwp 0E3"O`m @#W00q@ Q0([@oyypg_upgrade.csetupremove_new_subdircopy_subdir_filesset_frozenxidscreate_new_objectscrtstuff.cderegister_tm_clones__do_global_dtors_auxcompleted.8060__do_global_dtors_aux_fini_array_entryframe_dummy__frame_dummy_init_array_entrycheck.ccheck_is_install_userget_canonical_locale_namecheck_for_prepared_transactionsequivalent_locale.part.0get_bin_version.isra.0check_for_new_tablespace_dir.isra.0.constprop.0check_for_reg_data_type_usage.constprop.0check_for_isn_and_int8_passing_mismatch.constprop.0check_for_jsonb_9_4_usage.constprop.0controldata.cdump.cexec.ccheck_data_dirvalidate_execcheck_bin_dirfile.cfunction.clibrary_name_compareinfo.cget_db_infosget_rel_infosoption.ccheck_required_directorylong_options.8152page.cparallel.cparallel_jobsrelfilenode.ctransfer_relfile.constprop.0server.cget_db_conn.isra.0buf.7318query.7323exit_hook_registered.7345stop_postmaster_atexittablespace.cget_tablespace_pathsset_tablespace_directory_suffixutil.cpg_log_vversion.cresolve_symlinkspsprintf.crmtree.cusername.cwait_error.cfe_memutils.cpg_malloc_internal.part.0pg_realloc.part.0restricted_token.cpgfnames.cstrlcpy.cpath.ctrim_trailing_separatortrim_directory.part.0make_relative_path.constprop.0pgstrcasecmp.cpgstrsignal.cqsort.cswapfuncmed3thread.c__FRAME_END____init_array_end_DYNAMIC__init_array_start__GNU_EH_FRAME_HDR_GLOBAL_OFFSET_TABLE___libc_csu_fini__ctype_toupper_loc@@GLIBC_2.3__strcat_chk@@GLIBC_2.3.4getenv@@GLIBC_2.2.5prep_statuspalloc0old_9_3_check_for_line_data_type_usagePQconninfoFreeappendShellString__snprintf_chk@@GLIBC_2.3.4reap_childfree@@GLIBC_2.2.5user_optsabort@@GLIBC_2.2.5__errno_location@@GLIBC_2.2.5unlink@@GLIBC_2.2.5strncpy@@GLIBC_2.2.5strncmp@@GLIBC_2.2.5_ITM_deregisterTMCloneTablestdout@@GLIBC_2.2.5pg_malloc_extendedparallel_transfer_all_new_dbspqGetpwuid_exit@@GLIBC_2.2.5strcpy@@GLIBC_2.2.5__isoc99_fscanf@@GLIBC_2.7parseCommandLinepg_tolowercheck_hard_linknew_9_0_populate_pg_largeobject_metadatapid_lock_file_existsget_restricted_tokenpg_reallocreport_clusters_compatibleisatty@@GLIBC_2.2.5PQescapeStringConnPQconndefaultsPQstatusstop_postmasterappendConnStrValreadlink@@GLIBC_2.2.5get_db_and_rel_infosPQresultStatuspg_strncasecmp_edatapsprintfcluster_conn_optsgetErrorTextfclose@@GLIBC_2.2.5opendir@@GLIBC_2.2.5getpwuid@@GLIBC_2.2.5ctime@@GLIBC_2.2.5set_pglocale_pgservicermdir@@GLIBC_2.2.5get_share_pathstrlen@@GLIBC_2.2.5termPQExpBuffer__lxstat@@GLIBC_2.2.5getpwuid_r@@GLIBC_2.2.5find_my_execchdir@@GLIBC_2.2.5pg_strdup__stack_chk_fail@@GLIBC_2.4check_okgetopt_long@@GLIBC_2.2.5report_statussystem@@GLIBC_2.2.5get_parent_directorystrchr@@GLIBC_2.2.5os_infopclose@@GLIBC_2.2.5snprintf@@GLIBC_2.2.5strrchr@@GLIBC_2.2.5make_absolute_pathexecuteQueryOrDiefputs@@GLIBC_2.2.5has_drive_prefixgeteuid@@GLIBC_2.2.5getcwd@@GLIBC_2.2.5check_cluster_versionsstrspn@@GLIBC_2.2.5closedir@@GLIBC_2.2.5get_include_pathget_major_server_versionfputc@@GLIBC_2.2.5output_check_bannerconnectToServerread@@GLIBC_2.2.5__libc_start_main@@GLIBC_2.2.5linkAndUpdateFilefgets@@GLIBC_2.2.5first_dir_separatorpg_freecalloc@@GLIBC_2.2.5putenv@@GLIBC_2.2.5pqStrerrorcheck_pghost_envvar__data_startstrcmp@@GLIBC_2.2.5optarg@@GLIBC_2.2.5initPQExpBufferget_user_infolast_dir_separatorfeof@@GLIBC_2.2.5__gmon_start__umask@@GLIBC_2.2.5start_postmastercheck_and_dump_old_clusterstrtol@@GLIBC_2.2.5__dso_handlePQexecfirst_path_var_separator_IO_stdin_usedadjust_data_dirpg_ascii_toupperget_loadable_librariesfileno@@GLIBC_2.2.5PQgetvalue__xstat@@GLIBC_2.2.5readdir@@GLIBC_2.2.5generate_old_dumpget_control_datapg_strsignalstrerror_r@@GLIBC_2.2.5__libc_csu_initmalloc@@GLIBC_2.2.5fflush@@GLIBC_2.2.5PQconnectdb__isoc99_sscanf@@GLIBC_2.7output_filescreate_script_for_cluster_analyzecheck_loadable_librariescanonicalize_pathpstrduppg_ascii_tolowerfind_other_execprint_mapsget_man_pathstrpbrk@@GLIBC_2.2.5strlcpyget_includeserver_pathPQerrorMessageget_pkginclude_path__vsnprintf_chk@@GLIBC_2.3.4__strncpy_chk@@GLIBC_2.3.4get_pkglib_pathrmtreestrsignal@@GLIBC_2.2.5pg_qsort_strcmpwait_result_to_strrealloc@@GLIBC_2.2.5pg_malloc0__bss_startoutput_completion_bannersetlocale@@GLIBC_2.2.5main__printf_chk@@GLIBC_2.3.4get_sock_dircheck_new_clusterPQfnumbercheck_cluster_compatibilityissue_warnings_and_set_wal_levelchmod@@GLIBC_2.2.5pg_strcasecmppg_encoding_to_charend_progress_outputgen_db_file_mapspvsnprintfrepallocwaitpid@@GLIBC_2.2.5copyAndUpdateFileget_etc_pathget_html_pathaccess@@GLIBC_2.2.5join_path_componentspopen@@GLIBC_2.2.5get_user_name_or_exitparallel_exec_progfopen@@GLIBC_2.2.5get_prognameperror@@GLIBC_2.2.5check_control_datarename@@GLIBC_2.2.5appendPQExpBufferCharunsetenv@@GLIBC_2.2.5PQclearverify_directoriesstrtoul@@GLIBC_2.2.5quote_identifierget_pg_database_relfilenodeget_user_namestr2uintpg_qsortget_doc_path__cxa_atexit@@GLIBC_2.2.5create_script_for_old_cluster_deletionfwrite@@GLIBC_2.2.5pg_log__TMC_END____fprintf_chk@@GLIBC_2.3.4path_contains_parent_referencepgfnames_ITM_registerTMCloneTabletransfer_all_new_tablespacesappendPQExpBufferpg_putenvPQfinishpg_fatalget_home_pathstrdup@@GLIBC_2.2.5strerror@@GLIBC_2.2.5pg_toupperget_lib_pathdisable_old_clusterget_locale_pathcreatePQExpBufferpath_is_prefix_of_path__cxa_finalize@@GLIBC_2.2.5make_native_pathpclose_checkappendPQExpBufferStrpfreelog_optsfork@@GLIBC_2.2.5strstr@@GLIBC_2.2.5pgfnames_cleanuppath_is_relative_and_below_cwdinit_tablespaces__ctype_tolower_loc@@GLIBC_2.3__ctype_b_loc@@GLIBC_2.3palloc_extendedresetPQExpBufferpg_mallocstderr@@GLIBC_2.2.5PQntuples__sprintf_chk@@GLIBC_2.3.4appendPsqlMetaConnect.symtab.strtab.shstrtab.interp.note.gnu.property.note.gnu.build-id.note.ABI-tag.gnu.hash.dynsym.dynstr.gnu.version.gnu.version_r.rela.dyn.rela.plt.init.plt.got.plt.sec.text.fini.rodata.eh_frame_hdr.eh_frame.init_array.fini_array.dynamic.data.bss.comment#88 6XX$I|| Wo4a  iqodd~oPP`BPP 00 0 06666==dd LiLiLi,xnxn PPXX``pp    " 0 *P"v