Edit: /opt/dedrads/__pycache__/cpanel_postgres_manager.cpython-313.pyc (40762B)
}jLq S r SSKrSSKJr SSKrSSKrSSKrSSKrSSK r SSK
r
SSK r SSK r SSK
Jr SSKJrJrJrJrJrJr \" S5 r\S- r\R0 rSr\" S 5 r\" S
5 r / S Qr / S Qr \" S
5 r Sr \RB " \"5 r# " S S\$5 r%S\RL 4S jr'SSSSS.S\\( S\)S\)S\)S\\\(\(4 S\ RT 4 S jjr+SUS jr,S \(S\)4S jr-S\)S\)4S jr.S\)4S jr/S\\( 4S! jr0S\\( 4S" jr1S#\\2 S\(4S$ jr3SUS% jr4SSS&.S'\(S(\)S)\)S\)4S* jjr5S\\\2\(4 4S+ jr6S,\(S\(4S- jr7S.\\\2\(4 SS4S/ jr8S\\2 4S0 jr9S#\\2 SS4S1 jr:SUS2 jr;S3\S\)SS4S4 jr
S\)SS4S8 jr?\S\)S\S 4S9 j5 r@S\)SS4S: jrAS\)S\\( 4S; jrBS\)SS4S< jrCS=\\( S\)4S> jrDS?\(S\\(\\( 4 4S@ jrE\S\)S\S 4SA j5 rFS\)S)\)SS4SB jrGS\)S)\)SS4SC jrHS\)SS4SD jrIS#\\2 S\)S)\)SS4SE jrJS\)SS4SF jrKSG\(S\)S\\ 4SH jrLS\)SS4SI jrMS\)SS4SJ jrNSK\S\)SS4SL jrOSM\RL SG\(SS4SN jrPSM\RL SK\SS4SO jrQSM\RL S\\ 4SP jrRSM\RL S#\\2 SS4SQ jrSSM\RL S#\\2 SS4SR jrTS\24SS jrU\"ST:X a \ R " \U" 5 5 gg)Va
Install, reset, or logically upgrade PostgreSQL for cPanel on AlmaLinux 8/9.
When a PostgreSQL version is passed, the script resets/enables that dnf module
stream before running /scripts/installpostgres. When no version is passed, it
prompts for one before continuing.
N)contextmanager)Path)DictIteratorListOptionalSequenceTuplez/var/lib/pgsql/dataz pg_hba.conf
postgresqlz/scripts/installpostgresz/root/postgresql-backups)runuserz-upostgresz--)r postgresql-serverpostgresql-libszpostgresql-private-libszpostgresql[0-9]*z/etc/yum.repos.d)pgdgzpostgresql.orgzyum.postgresql.orgzftp.postgresql.orgc \ rS rSrSrg)Fatal0 N)__name__
__module__ __qualname____firstlineno____static_attributes__r '/opt/dedrads/cpanel_postgres_manager.pyr r 0 s r r returnc [ R " SS9n U R SS[ SS9 U R SSS S
9 U R S SS S
9 U R S
SSS
9 U R S[ [
5 S[
3S9 U R SSSS
9 U R SSSS
9 U R SSSS
9 U R SSSS
9 U R
5 $ )Nz;Install, reset, or logically upgrade PostgreSQL for cPanel.) descriptionversion?znPostgreSQL module stream to enable before install. Omit to display available streams and choose interactively.)nargstypehelpz --upgrade
store_truezLBackup the current cluster, reinstall/init the target version, then restore.)actionr# z--allow-logical-downgradezAllow --upgrade to attempt a pg_dumpall restore into an older major version. This is best-effort and may fail if the dump uses newer PostgreSQL features.z --reset-datazDDestroy /var/lib/pgsql/data contents and initialize a fresh cluster.z --backup-dirz+Directory for pg_dumpall backups. Default: )defaultr# z
--skip-backupz=Allow destructive reset without creating a pg_dumpall backup.--yesz[Answer yes to required prompts. Destructive prompts still require --i-understand-data-loss.z--i-understand-data-lossz9Required with --yes for destructive data directory reset.z --dry-runz"Log commands without running them.)argparseArgumentParser add_argumentintstr
BACKUP_DIR
parse_args)parsers r r. r. 4 sF
$
$QF
:
[
#
#
S
J::,
G
L
j
"
H
1
r FT)dry_runcheckcaptureenvcommandr0 r1 r2 r3 c D SR S U 5 5 n[ R SU5 U( a [ R " U SSS5 $ [ R
" [
U 5 USU( a [ R OS U( a [ R US9$ S US9$ )N c 3 8 # U H n[ U5 v M g 7fNr, ).0parts r run..x s 7wtTw z+ %sr T)r1 textstdoutstderrr3 )joinLOGGERinfo
subprocessCompletedProcessrunlistPIPE)r4 r0 r1 r2 r3 printables r rH rH p s 7w77I
KK "**7Ar2>> >> W
")zt")z
04
r c L [ R " 5 S:w a [ S5 eg )Nr zRun this script as root.)osgeteuidr r r r require_rootrO s! zz|q.// r namec 2 [ R " U 5 S L$ r8 )shutilwhichrP s r command_existsrU s << T ))r c T U ( a g[ SSS[ /SS9nUR S:H $ )NF systemctlz is-activez--quiet)r1 r )rH POSTGRES_SERVICE
returncode)r0 results r service_is_activer[ s0
+{I7GHPU
VF !!r c 0 [ S- R 5 $ )N
PG_VERSION)DATA_DIRexistsr r r existing_data_dir_has_clusterr` s | # + + --r c : [ S- n U R 5 ( a U R 5 R 5 $ [ S5 ( aO [ SS/SSS9n[ R " SUR =( d S5 nU( a UR S 5 $ g )
Nr] r
--versionFTr1 r2 (\d+)(?:\.\d+)?r? )
r^ r_ read_textstriprU rH researchrA group)
pg_versionrZ matchs r existing_cluster_versionrm s L(J##%++--j!!j+.eTJ ,fmm.ArB ;;q> ! r c [ S5 ( d g [ SS/SSS9n [ R " SU R =( d S5 nU( a UR S5 $ g ) Nr
rb FTrc rd r? re )rU rH rh ri rA rj )rZ rl s r !installed_postgres_server_versionro sQ * % %
*k*%
FF II(&--*=2 >E {{1~ r r c ~ [ 5 nUc [ S5 eU b! U[ U 5 :w a [ SU SU S35 eU$ )Nz=postgres executable was not found after package installation.z'Installed PostgreSQL server is version , but target module stream is z. Refusing to initialize, start, restore, or run cPanel setup against the data directory. Check the enabled DNF module stream and repository state.)ro r r, )r installeds r 'require_installed_server_matches_targetrs s^ 13ISTTyCL 85i[ A "+
+
r c [ 5 ( d g [ 5 n [ 5 nUb U c g X:w a [ SU SU S[ S35 eg )N.Existing PostgreSQL data directory is version z1, but the installed PostgreSQL server is version z(. Refusing to run cPanel setup or start zl with an incompatible cluster. Use --upgrade for a logical dump/restore or --reset-data for a fresh cluster.)r` rm ro r rX )clusterrr s r )require_data_dir_matches_installed_serverrw sk ( * *&(G13IGO yyes)rD rE inputrg lower)rz rx ry suffixanswers r promptr sT Hg&%Z:F
7#
$
*
*
,
2
2
4F ~ \ !!r c [ / SQSSS9n / n[ 5 nU R =( d SR 5 H nUR 5 n[ U5 S: d US S:w a M- US R
5 ( d MG [ US 5 nXR; a M\ UR U5 [ U5 S: a US R S
5 ( a US OSnUR XV45 M U$ ) N)dnfmodulerI r FTrc r? r r re [) rH setrA
splitlinessplitlenisdigitr+ add
startswithappend)rZ versionsseenlinepartsr flagss r available_postgresql_versionsr s
8t
TF&(H 5D $"002
u:>U1X 5 Qx !! eAh- ? JNuQx/B/B3/G/GaR() 3 Or r c / nSU ; a UR S5 SU ; a UR S5 SU ; a UR S5 SU ; a UR S5 S R U5 $ )
Neenableddr& irr xdisabled, )r rC )r labelss r version_flag_labelsr sb
F
e|
i
e|
i
e|
k"
e|
j! 99V r r c U ( d [ R S5 g [ R S5 U H5 u p[ U5 nU( a SU S3OSn[ R SX5 M7 g )Nz6No PostgreSQL module streams were found in DNF output.z$Available PostgreSQL module streams:z ()r? z %s%s)rD rE r )r r r r r s r !log_available_postgresql_versionsr sW LM
KK67"$U+#)2fXQ r Hg. #r c [ 5 n [ U 5 [ S5 R 5 nU( d g UR 5 ( d [ SU 35 e[
U5 nU VVs1 s H u p4UiM nnnU( a7 X%; a2 SR S [ U5 5 5 n[ SU SU 35 eU$ s snnf )NzDPostgreSQL version to install [press Enter for repository default]: z Invalid PostgreSQL version: r c 3 8 # U H n[ U5 v M g 7fr8 r9 r: available_versions r r< %prompt_for_version.. "eSd>O3'8#9#9Sdr> PostgreSQL version ) is not in the available module streams: ) r r r~ rg r r r+ rC sorted)r r r r _ availableavailable_lists r prompt_for_versionr s ,.H%h/
N eg >> 26(;<<&kG?GHx';'8"xIHW- "eSYZcSd"ee!'*S
N Is *B;c U c g [ 5 nU VVs1 s H u p#UiM nnnU( a8 X; a2 SR S [ U5 5 5 n[ SU SU 35 eg g s snnf )Nr c 3 8 # U H n[ U5 v M g 7fr8 r9 r s r r< ,validate_selected_version.. r r> r r )r rC r r )r r r r r r s r validate_selected_versionr s} ,.H?GHx';'8"xIHW- "eSYZcSd"ee!'*S
.y Is A%c Z [ R 5 ( d [ [ S35 eg )Nz/ was not found. This does not look like cPanel.)CPANEL_INSTALLPOSTGRESr_ r r r r require_cpanelr ' s+ ! ( ( * *-..]^__ +r pathc b U( a [ R SU 5 g U R SSSS9 g )N
+ mkdir -p %s Tmodeparentsexist_ok)rD rE mkdir)r r0 s r ensure_backup_directoryr , s( OT*JJE4$J7r
backup_dirc
[ X5 [ R R 5 R S5 nU SU S3- n[ S5 ( d [
S5 e[ U5 ( d [ SS[ /US9 [ R S U5 [ U5 U( d UR S
5 O[ [ R S
5 n[ R S 5 U( d [ R " / [" QSPS S
US S9 S S S 5 S S S 5 U$ ! , ( d f N= f! , ( d f U$ = f)N
%Y%m%d-%H%M%Szpostgresql-all-z.sql
pg_dumpallz:+:\: ! M
+ M
L
+ * s$ 3D2=D!D2!
D/ +D22
Ec ( [ SS[ /U SS9 g )NrW stopFr0 r1 rH rX r s r stop_postgresqlr L s f ./Nr c ( [ SS[ /U SS9 g )NrW reloadFr r r s r reload_postgresqlr P s h 017%Pr c # # SnU ( a_ [ R S[ UR 5 5 [ U 5 S v [ R S[ 5 [ U 5 g [ R 5 ( d S v g [ R
5 nUR U5 ( a S v g [ R X- 5 [ U 5 S v [ R U5 [ U 5 g ! [ R S[ 5 [ U 5 f = f! [ R U5 [ U 5 f = f7f)Nzlocal all postgres peer
z + temporarily prepend to %s: %sz+ restore original %s) rD rE PG_HBArg r r_ rf r
write_text)r0 ruleoriginals r r r T s &D 5vtzz|L'" ' KK/ 8 g & ==??
!H4
do&g #
(#'"'
KK/ 8 g &" (#'"s6 >ED BED* !E 'D''E*"E Ec U ( aU [ R S5 [ R S5 [ R S5 [ R S5 g [ / SQSSS9nUR S :X aN UR R 5 R
5 S n[ R S
U5 [ / S Q5 [ / S QSSS9nUR =( d S
R
5 HF n[ R " SU5 ( d M! [ R SU5 [ SSSU/5 MH g )Nz+ rpm -q libpq5z-+ rpm -e --nodeps libpq5 # only if installedz + rpm -qa 'postgresql*-libs'zC+ rpm -e --nodeps postgresqlNN-libs # only for PGDG versioned libs)rpmz-qlibpq5FTrc r z4Removing installed %s; it obsoletes AlmaLinux libpq.)r -e--nodepsr )r -qazpostgresql*-libsr? z^postgresql\d+-libs-z>Removing installed %s; it is from an external PostgreSQL repo.r r r ) rD rE rH rY rA rg r rh rl )r0 rr packageversioned_libss r "remove_external_postgres_librariesr s s %& CD 23 YZ+5$GIq ""((*557: JGT /0;5RVWN"))/R;;=
88+W 5 5 KKP
j'2 3
>r c L U ( a [ R S5 / SQ$ / n[ 5 n[ Hm n[ SSU/SSS9nUR
=( d SR
5 H5 nU( d M XR; d M UR U5 UR U5 M7 Mo U$ ) Nza+ rpm -qa postgresql postgresql-server postgresql-libs postgresql-private-libs 'postgresql[0-9]*')r r r r r FTrc r? ) rD rE r !POSTGRESQL_PACKAGE_QUERY_PATTERNSrH rA r r r )r0 packagesr patternrZ r s r installed_postgresql_packagesr s
9
FE H 5D4eUG,E4H
+779Gw7.!( : 5 Or c [ U 5 nU( d [ R S5 g [ R S5 [ U 5 [ SSS/UQU S9 g )Nz5No installed PostgreSQL RPM packages found to remove.zXRemoving installed PostgreSQL RPM packages before installing the selected module stream.r r r r )r rD rE r rH )r0 r s r $remove_installed_postgresql_packagesr sP ,W5H KL
KK G j,8,g>r linesc t ^ SR U 5 R 5 m[ U4S j[ 5 5 $ )N
c 3 , ># U H oT; v M g 7fr8 r )r: r r@ s r r< 'repo_section_matches.. s N.M7$.Ms )rC r any EXTERNAL_POSTGRES_REPO_PATTERNS)r r@ s @r repo_section_matchesr s, 99U ! ! #D N.MN NNr r@ c , ^^^^ U R SS9n/ m/ m/ mS mSUUUU4S jjnU HO n[ R " SU5 nU( a U" 5 U/mUR S5 mM> TR U5 MQ U" 5 SR T5 T4$ )NT)keependsc ^ > T( d g T b [ T5 ( d TR T5 / mS m g Sn Sn[ T5 He u p#[ R " SU5 ( d M# Sn [ R " SU5 ( d$ UR S5 ( a SOSnSU- TU' Sn O U ( dO T( a) TS R
5 R S 5 ( a S
O
[ T5 nTR US 5 SnU( a TR T 5 TR T5 / mS m g ) NFz^\s*enabled\s*=Tz"^\s*enabled\s*=\s*0\s*(?:[#;].*)?$r r? z enabled=0r r re z
enabled=0
) r extend enumeraterh rl endswithlstripr r insertr )
saw_enabledchangedindexr newline insert_atchanged_sectionsr section section_names
r flush-disable_matching_repo_sections..flush s ';G'D'D MM' "G L $W-KExx*D11 " xx EtLL&*mmD&9&9drG%07%:GEN "G . $):):)<)G)G)L)LRUV]R^I NN9m 4G # #L 1
g r z^\s*\[([^\]]+)\]\s*$re r? r N)r rh rl rj r rC ) r@ r r r rl r r r r
s @@@@r disable_matching_repo_sectionsr s OOTO *EF"$G"&L @ 0$7 GfG ;;q>L NN4
G
776? , ,,r c # ^# U ( a [ R S5 S v g 0 n/ n[ [ R S5 5 HY mTR 5 n[
U5 u pEU( d M) X1T' TR U5 UR U4S jU 5 5 M[ U( a% [ R SSR U5 5 S v UR 5 H u mnTR U5 M U( a [ R S5 g g ! UR 5 H u mnTR U5 M U( a [ R S5 f f = f7f)NzE+ temporarily disable external PostgreSQL repos during cPanel installz*.repoc 3 F ># U H nTR S U 3v M g7f):NrT )r: r repo_files r r< 3external_postgres_repos_disabled.. s! QWinn -Qwi8s !z2Temporarily disabled external PostgreSQL repos: %sr z0Restored external PostgreSQL repo configuration.) rD rE r YUM_REPO_DIRglobrf r r r rC items)r0 originalsr r updatedsectionsr s @r external_postgres_repos_disabledr s% [\
!#IGL - -h 78 &&( :8 D 8#+i ) NNQQ Q
9 @$))GBT
L
#,??#4 Ix * $5 KKJ K $-??#4 Ix * $5 KKJ K s' A)E+0A E+D A E+ A
E((E+c P U ( d
[ 5 [ [ 5 /nU( a UR S5 [ X SS9nUR
S:X a U ( d
[ 5 g [
5 ( a< U ( d
[ 5 [ R " UR
UR 5 e[ S5 ( d+ [ R " UR
UR 5 e[ R S5 [ U 5 [ X S9 U ( d [ 5 g g )Nr' Fr r postgresql-setupzcPanel installpostgres failed before a PostgreSQL cluster existed; initializing the cluster and rerunning cPanel configuration.r )rw r, r r rH rY r` rF CalledProcessErrorargsrU rD rE initdb_and_start)r0 ry r4 rZ s r installpostgres_with_recoveryr s 13)*+Gw
7F
A 5 7$&& 5 7++F,=,=v{{KK , - -++F,=,=v{{KK
KK G W ! 13 r c [ R S5 [ U 5 [ X5 S S S 5 g ! , ( d f g = f)Nz.Finalizing PostgreSQL configuration for cPanel)rD rE r r )r0 ry s r finalize_cpanel_postgresqlr" s+
KK@A )' 2%g:
3 2 2s 6
Ac [ 5 ( d [ U 5 g U ( d
[ 5 [ SSS[ /U S9 [ SSS[ /U SS9 g ) NrW enable--nowr status
--no-pagerFr )r` r rw rH rX r s r ensure_cluster_runningr( % sJ ( * *! 13h)9:GLh .>?X]^r c V U b [ U5 [ / SQUS9 U b [ SSSSSU 3/US9 O[ R S5 [ U5 [ U5 [
X5 S S S 5 U( d" [ U 5 n[ R S U5 g g ! , ( d f N8= f)
N)r -yr resetr r r r* r r$ z postgresql:zCNo PostgreSQL module stream selected; using the repository default.z'Installed PostgreSQL server version: %s)r rH rD rE r r r rs )r r0 ry rr s r reset_module_and_installr, / s ,W56H UD(H G9.E FPWX YZ&w/ )' 2%g:
3 ;GD =yI
3 2s B
B(c [ R 5 ( d g [ R S[ 5 U ( a [ R S[ 5 g [ R 5 HU nUR 5 ( a- UR
5 ( d [ R " U5 ME UR 5 MW g )NzClearing %s contentsz + remove all entries under %s)
r^ r_ rD rE iterdiris_dir
is_symlinkrR rmtreeunlink)r0 childs r clear_data_dirr4 A sw ??
KK&1 3X>!!# <<>>%"2"2"4"4 MM% LLN $r reasonc P [ R 5 ( d g [ R R 5 R S5 n[ SU SU 3- n[ R SU5 U( a [ R S[ U5 U$ [ R U5 U$ )Nr zdata..z/Moving existing PostgreSQL data directory to %sz
+ mv %s %s)
r^ r_ r r r r PGSQL_BASE_DIRrD rE rename)r5 r0 r destinations r move_data_dir_asider; O s ?? LL ' ' 8E U6(!E7#;;K
KKA;O L(K8 OOK r c [ U 5 [ SS/U S9 U ( d
[ 5 [ SSS[ /U S9 [ SSS[ /U S S
9 g ) Nr z--initdbr rW r$ r% r& r' Fr )ensure_pgsql_base_dirrH rw rX r s r r r \ sN '" Z(': 13h)9:GLh .>?X]^r c 8 U ( aO [ R S[ 5 [ R S[ 5 [ R S[ 5 g [ R SSSS9 [ R
" [ SSS9 [ R
S5 g ) Nr z + chown postgres:postgres %sz+ chmod 700 %sr Tr r
)userrj )rD rE r8 r rR chownchmodr s r r= r= e sg O^4 2NC $n5eTDA
LL j
C r r c U R 5 ( d U( d [ SU 35 e[ R SU 5 [ R SU 5 [ U5 U( d8 U R 5 n[ R " / [ QSPSSUS9 S S S 5 S S S 5 g ! , ( d f N= f! , ( d f g = f)Nz Backup file does not exist: z Restoring %sz"+ runuser -u postgres -- psql < %spsqlTr )r1 r stdin) r_ r rD rE r r rF rH r )r r0
input_files r restore_backuprF p s 2;-@AA
KK ,
KK4kB !' * !!#z4+4V4 $ $
+ *##
+ *s$ "B<: B+B<+
B9 5B<<
C
r c \ U R ( a U R ( a g [ R S5 [ R SU5 [ R S[ 5 [ SSS9( d [
S5 e[ S5 R 5 nUS :w a [
S
5 eg ) NzGWARNING: This operation destroys the current PostgreSQL data directory.z
Reason: %szTarget directory: %sz'Have you created and verified a backup?Fry z-Cancelled. Create a backup before continuing.z*Type "DESTROY POSTGRES DATA" to continue: zDESTROY POSTGRES DATA
Cancelled.) r} i_understand_data_lossrD warningr^ r r r~ rg )r r5 phrases r destructive_confirmationrM s xxD//
NN\]
NN<(
NN)84 ; NCDD
?
@
F
F
HF
((L!! )r c U R ( a [ R SU5 g [ R S5 [ R SU5 [ R S[ 5 [ S5 ( d [
S5 eg )NzProceeding with logical upgrade using backup %s. The existing data directory will be moved aside before the target cluster is initialized.z@WARNING: Logical upgrade requires a clean target data directory.z Backup that will be restored: %szJThe current PostgreSQL data directory will be moved aside, not deleted: %sz!Proceed with the logical upgrade?rI )r} rD rE rK r^ r r )r r s r logical_upgrade_confirmationrO so xx
V
NNUV
NN5{C
NNT 5 6 6L!! 7r c t [ U R 5 n[ 5 nU( d g U R ( a8 [ SU R
=( a U R S9( d [ S5 eg [ SU R
S9( a [ XR 5 $ [ SSS9( d [ S5 eg )Nz=You used --skip-backup. Continue without a pg_dumpall backup?rH rI z6Create a pg_dumpall backup before changing PostgreSQL?z'Continue without creating a new backup?F)
r r r` skip_backupr r} rJ r r r0 )r r has_clusters r maybe_backup_before_destructiverS s doo&J/1K Kxx?D$?$?
% %
FSWS[S[\ j,,77 ; NL!! r c [ 5 nU( a
[ 5 OS nU( a [ R SU5 U( a8 Ub5 Ub2 U[ U5 :w a# U R
( d [
SU SU S35 eU R
( aH U( aA [ U 5 [ U S5 [ U R 5 [ U R 5 [ XR U R 5 U R
( aW U R ( d [ 5 ( d6 [ U R 5 [ U R U R 5 g g [ 5 ( d6 [ U R 5 [ U R U R 5 g U R ( d
[! 5 [# SSS[$ /U R S 9 [# SS
S [$ /U R S S
9 g )N0Detected existing PostgreSQL cluster version: %sru rq zm. Use --upgrade for a logical dump/restore or --reset-data if you intend to destroy and recreate the cluster.z1Fresh initialization requested with --reset-data.rW r$ r% r r& r' Fr )r` rm rD rE r,
reset_datar rS rM r r0 r4 r, r} r r" rw rH rX )r r rR currents r install_or_resetrX sa /1K,7&(TG FP s7| # > T\\ * &t||TXX > ? +
,
, &"4<<:|| 5 7 [(G-= > U [(L2B CT\\afgr c [ 5 ( d! [ R S5 [ X5 g [ 5 n[ R SU=( d S5 Ub [ U5 OSn[ R SU5 Ub5 Ub2 [
U5 U: a# U R ( d [ SU SU S35 eUb. Ub+ [
U5 U: a [ R S U SU S
35 [ U 5 nUc [ S 5 e[ X5 S n [ U R 5 [ S U R 5 n[ XR U R 5 [# U R 5 [ R S
5 [% X@R 5 [' SS[( /U R S9 [' SSS[( /U R SS9 [+ U R U R 5 g ! [, a` [ R/ S5 [ R/ SU5 Ub [ R/ SU5 [ R/ S[0 5 e f = f)NzFNo existing PostgreSQL data directory found; running a normal install.rU unknownzrepository defaultz Target PostgreSQL version: %sz"Logical downgrade from PostgreSQL z to z is not supported. Use --allow-logical-downgrade to attempt a best-effort pg_dumpall restore, or --reset-data with a verified backup if you need to recreate the cluster.z6WARNING: Attempting logical downgrade from PostgreSQL zF. The restore can fail if the dump contains newer PostgreSQL features.zDUpgrade requires a pg_dumpall backup so the cluster can be restored.z pre-upgradez9Restoring logical backup into the new PostgreSQL cluster.rW restartr r& r' Fr zUpgrade did not complete.zLogical backup: %szPrevious data directory: %szCurrent data directory: %s)r` rD rE rX rm r, r+ allow_logical_downgrader rK rS rO r r0 r; r, r} r( rF rH rX r" Exceptionerrorr^ )r r rW targetr moved_data_dirs r logical_upgradera s ( * * \]'&(G
KKBGDXyY $ 0S\6JF
KK/8 L7 ",,0 gY GZ
Z
w 2s7|g7MDWITRYQZ [S
S
2$7KZ[[ 3%)N %,]DLLI ,,A t||, OP{LL1 [)%5 6 M [(L2B CT\\afg"4<<: 01 );7 % LL6 G 18<
s C"G3 3A*I c [ R " [ R SS9 [ 5 n [ 5 [ 5 U R b U R O [ 5 n[ U5 U R ( a [ X5 O [ X5 [ R S[ R " 5 5 g! [ a- [ R S5 [ R S5 g[" R$ a n[ R' SUR( S R+ UR, 5 5 UR. ( a. [ R' S
UR. R1 5 5 UR2 ( a. [ R' S
UR2 R1 5 5 UR( =( d S s S nA$ S nAf[4 a n[ R' S U5 S nAg S nAff = f)
Nz %(message)s)levelformatz Done on %s.r r? rI z$Command failed with exit code %s: %sr6 z%sre z ERROR: %s)logging basicConfigINFOr. rO r r r r upgradera rX rD rE socket gethostnameKeyboardInterruptrF r r^ rY rC cmdrA rstriprB r )r r excs r mainrp
sK gll=A r} s+ %
B B % & M ! 89
,
-
; % ! &' #
8 $ L 9 H&& 9 ~ $(
c]
$sCx. !
,0
* * *"t " ".t . (3- 8C= Xc] s
" 04 "C " " "RV "tE#s(O'< &
s
s
/sCx 0I /d /HSM *
x}
`
8$ 8 8$ 8t d x~ 2OT Od OQt Q Q #d #x~ # #<4 4 404 DI & ?$ ?4 ? O
O$ O
0- 0-sDI~1F 0-f Ld Lx~ L L:44 4T 4d 4:; ;$ ;4 ; _D _T _J
c]J%)J7;J J$ D T
d
x~
_d _t _ 4 D
t
"8#5#5
"s
"t
""x'9'9 " "QU "$(*<*< $ &%h8-- %h
%h$ %hP0(,, 0x} 0 0f!c !H zHHTV r