Message-ID: <50d43222-8249-f7a8-ecca-7c696c4f5539@jakobs.com>
Date: Sat, 21 May 2022 20:53:41 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.9.0
Subject: Re: Steps to Install archived Postgres 9.3 and 9.6
Content-Language: de-DE
To: pgsql-admin@lists.postgresql.org
References: 
 <CAN0SRDFydu12pW+XV9KanakZwd9psbg9jA+7fMJuUDiB7iENQA@mail.gmail.com>
 <D98D51ED-1786-4D12-AB46-D16F459AD6F4@gmail.com>
 <CAN0SRDGP5itL1N7hy3n8pSXxeP5Gjuou-dM1SqAZ_08_3K+2bg@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: 
 <CAN0SRDGP5itL1N7hy3n8pSXxeP5Gjuou-dM1SqAZ_08_3K+2bg@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------kMZ9k6bOXXtjlJV0lXLWIVXk"
Archived-At: 
 <https://www.postgresql.org/message-id/50d43222-8249-f7a8-ecca-7c696c4f5539%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------kMZ9k6bOXXtjlJV0lXLWIVXk
Content-Type: multipart/mixed; boundary="------------D6elMX0FcHHZsxEavQIK5fLt";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <50d43222-8249-f7a8-ecca-7c696c4f5539@jakobs.com>
Subject: Re: Steps to Install archived Postgres 9.3 and 9.6
References: <CAN0SRDFydu12pW+XV9KanakZwd9psbg9jA+7fMJuUDiB7iENQA@mail.gmail.com>
 <D98D51ED-1786-4D12-AB46-D16F459AD6F4@gmail.com>
 <CAN0SRDGP5itL1N7hy3n8pSXxeP5Gjuou-dM1SqAZ_08_3K+2bg@mail.gmail.com>
In-Reply-To: <CAN0SRDGP5itL1N7hy3n8pSXxeP5Gjuou-dM1SqAZ_08_3K+2bg@mail.gmail.com>

--------------D6elMX0FcHHZsxEavQIK5fLt
Content-Type: multipart/alternative;
 boundary="------------klI53j0yPjWxEqd8P0zN5gt6"

--------------klI53j0yPjWxEqd8P0zN5gt6
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64

QXJlIHlvdSByZWFsbHkgc3VyZSB0aGF0IHlvdXIgYXBwbGljYXRpb24gc29mdHdhcmUgKEpp
cmEpIGlzIA0KaW5jb21wYXRpYmxlIHdpdGggY3VycmVudCBQb3N0Z3JlU1FMIHZlcnNpb25z
Pw0KDQpQbGVhc2UgbWFrZSBhIHRlc3Qgd2hldGhlciBpdCB3b3Jrcy4gSXQgbWlnaHQgdmVy
eSB3ZWxsIGRvLg0KDQpJbiBtb3N0IGNhc2VzLCBub3Qgb25seSB0aGUgYXBwcm92ZWQgUG9z
dGdyZVNRTCB2ZXJzaW9ucyB3b3JrIGZpbmUgd2l0aCANCmFwcGxpY2F0aW9uIHNvZnR3YXJl
LCBidXQgYWxzbyBhbGwgeW91bmdlciB2ZXJzaW9ucy4NCg0KQmFja3dhcmQgY29tcGF0aWJp
bGl0eSBpcyB2ZXJ5IGhpZ2guDQoNClJlZ2FyZHMsDQoNCkhvbGdlcg0KDQpBbSAyMS4wNS4y
MiB1bSAwNToyNSBzY2hyaWViIGFkaXR5YSBkZXNhaToNCj4gVGhhbmtzIGFsbC4gVGhpcyBy
ZWFsbHkgaGVscHMuIFdpbGwgbGV0IHlvdSBrbm93IGlmIGFueSBpc3N1ZXMuDQo+DQo+IE9u
IFNhdCwgTWF5IDIxLCAyMDIyIGF0IDQ6MDYgQU0gUyBIb2ZmbWFuIDxob2ZmbWFuNzA0M0Bn
bWFpbC5jb20+IHdyb3RlOg0KPg0KPiAgICAgSGVsbG8gQWRpdHlhLA0KPg0KPiAgICAgQSBs
aW5rIHRvIHRoZSBhcmNoaXZlIG1hbnVhbHMgaXMgYmVsb3cuIEVhY2ggbWFudWFsIGNvbnRh
aW5zIHRoZQ0KPiAgICAgaW5zdHJ1Y3Rpb25zIGZvciB0aGUgYXJjaGl2ZWQgdmVyc2lvbi4g
VmVyc2lvbiA5LjMgaXMgYXZhaWxhYmxlLg0KPg0KPiAgICAgaHR0cHM6Ly93d3cucG9zdGdy
ZXNxbC5vcmcvZG9jcy9tYW51YWxzL2FyY2hpdmUvDQo+DQo+ICAgICBJIGhvcGUgdGhpcyBo
ZWxwcyENCj4NCj4gICAgIFRoYW5rIHlvdSwNCj4gICAgIFNvbmRyYQ0KPg0KPiAgICAgU2Vu
dCBmcm9tIG15IGlQaG9uZQ0KPg0KPj4gICAgIE9uIE1heSAyMCwgMjAyMiwgYXQgODo0NSBB
TSwgYWRpdHlhIGRlc2FpIDxhZG1hZDEyM0BnbWFpbC5jb20+IHdyb3RlOg0KPj4NCj4+ICAg
ICDvu78NCj4+ICAgICBIaSwNCj4+ICAgICBXZSBoYXZlIGEgcmVxdWlyZW1lbnQgd2hlcmUg
d2UgbmVlZCB0byBtaWdyYXRlIE9yYWNsZSB0bw0KPj4gICAgIFBvc3RncmVzLiBIb3dldmVy
IHRoZSBjdXJyZW50IHZlcnNpb24gb2YgQXBwbGljYXRpb24gSklSQSBpcyA2DQo+PiAgICAg
YW5kIGl0IGlzIG5vdCBjb21wYXRpYmxlwqB3aXRoIFBvc3RncmVzIDExLiBXZSBuZWVkIHRv
IGRvIGFuDQo+PiAgICAgaW5jcmVtZW50YWwgdXBncmFkZSBsaWtlIGJlbG93Lg0KPj4gICAg
IDEuIE1pZ3JhdGUgT3JhY2xlIDExZyB0byBQb3N0Z3JlcyA5LjMuDQo+PiAgICAgMi4gVXBn
cmFkZSBKSVJBIDYgdG8gNy4NCj4+ICAgICAzLiBVcGdyYWRlIFBvc3RncmVzIDkuMyB0byA5
LjYuDQo+PiAgICAgNC4gVXBncmFkZSBKSVJBIDcgdG8gNy54DQo+PiAgICAgNS4gVXBnYXJk
ZcKgUG9zdGdyZXMgOS42IHRvIDExLg0KPj4gICAgIDYuIFVwZ3JhZGUgSklSQSA3LnggdG8g
OC54DQo+Pg0KPj4gICAgIERvZXMgYW55b25lIGhhdmUgc3RlcHMgdG8gaW5zdGFsbCBQRyA5
LjMgYW5kIDkuNi7CoEkga25vdyBpdCBpcw0KPj4gICAgIG5vdCBzdXBwb3J0ZWQgYW55bW9y
ZSBidXQgd2UgYXJlIHN0dWNrIHdpdGggdGhpcyBhcHByb2FjaC4gUGxlYXNlDQo+PiAgICAg
aGVscCA6KA0KPj4NCj4+ICAgICBSZWdhcmRzLA0KPj4gICAgIEFkaXR5YS4NCj4NCi0tIA0K
SG9sZ2VyIEpha29icywgQmVyZ2lzY2ggR2xhZGJhY2gsIFRlbC4gKzQ5LTE3OC05NzU5MDEy
DQoNCg==
--------------klI53j0yPjWxEqd8P0zN5gt6
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <p>Are you really sure that your application software (Jira) is
      incompatible with current PostgreSQL versions?</p>
    <p>Please make a test whether it works. It might very well do. <br>
    </p>
    <p>In most cases, not only the approved PostgreSQL versions work
      fine with application software, but also all younger versions.</p>
    <p>Backward compatibility is very high.</p>
    <p>Regards,</p>
    <p>Holger<br>
    </p>
    <div class=3D"moz-cite-prefix">Am 21.05.22 um 05:25 schrieb aditya
      desai:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CAN0SRDGP5itL1N7hy3n8pSXxeP5Gjuou-dM1SqAZ_08_3K+2bg@mail.gmai=
l.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr">Thanks all. This really helps. Will let you know i=
f
        any issues.</div>
      <br>
      <div class=3D"gmail_quote">
        <div dir=3D"ltr" class=3D"gmail_attr">On Sat, May 21, 2022 at 4:0=
6
          AM S Hoffman &lt;<a href=3D"mailto:hoffman7043@gmail.com"
            moz-do-not-send=3D"true" class=3D"moz-txt-link-freetext">hoff=
man7043@gmail.com</a>&gt;
          wrote:<br>
        </div>
        <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px
          0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=

          <div dir=3D"auto">Hello Aditya,
            <div><br>
            </div>
            <div>A link to the archive manuals is below. Each manual
              contains the instructions for the archived version.
              Version 9.3 is available.</div>
            <div><br>
            </div>
            <div><a
                href=3D"https://www.postgresql.org/docs/manuals/archive/"=

                target=3D"_blank" moz-do-not-send=3D"true"
                class=3D"moz-txt-link-freetext">https://www.postgresql.or=
g/docs/manuals/archive/</a></div>
            <div><br>
            </div>
            <div>I hope this helps!</div>
            <div><br>
            </div>
            <div>Thank you,</div>
            <div>Sondra</div>
            <div><br>
              <div dir=3D"ltr">Sent from my iPhone</div>
              <div dir=3D"ltr"><br>
                <blockquote type=3D"cite">On May 20, 2022, at 8:45 AM,
                  aditya desai &lt;<a href=3D"mailto:admad123@gmail.com"
                    target=3D"_blank" moz-do-not-send=3D"true"
                    class=3D"moz-txt-link-freetext">admad123@gmail.com</a=
>&gt;
                  wrote:<br>
                  <br>
                </blockquote>
              </div>
              <blockquote type=3D"cite">
                <div dir=3D"ltr">=EF=BB=BF
                  <div dir=3D"ltr">Hi,
                    <div>We have a requirement where we need to migrate
                      Oracle to Postgres. However the current version of
                      Application JIRA is 6 and it is not
                      compatible=C2=A0with Postgres 11. We need to do an
                      incremental upgrade like below.</div>
                    <div>1. Migrate Oracle 11g to Postgres 9.3.</div>
                    <div>2. Upgrade JIRA 6 to 7.</div>
                    <div>3. Upgrade Postgres 9.3 to 9.6.</div>
                    <div>4. Upgrade JIRA 7 to 7.x</div>
                    <div>5. Upgarde=C2=A0Postgres 9.6 to 11.</div>
                    <div>6. Upgrade JIRA 7.x to 8.x</div>
                    <div><br>
                    </div>
                    <div>Does anyone have steps to install PG 9.3 and
                      9.6.=C2=A0I know it is not supported anymore but we=
 are
                      stuck with this approach. Please help :(</div>
                    <div><br>
                    </div>
                    <div>Regards,</div>
                    <div>Aditya.=C2=A0</div>
                  </div>
                </div>
              </blockquote>
            </div>
          </div>
        </blockquote>
      </div>
    </blockquote>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------klI53j0yPjWxEqd8P0zN5gt6--

--------------D6elMX0FcHHZsxEavQIK5fLt--

--------------kMZ9k6bOXXtjlJV0lXLWIVXk
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYok1NQUDAAAAAAAKCRCKV5yTsxlhut5S
AJ4wjmfsCLI0S3HJmF3/xfB4gNq9/wCfTopX1GMcWwXcakjlB+8z6cbRqjA=
=WSCi
-----END PGP SIGNATURE-----

--------------kMZ9k6bOXXtjlJV0lXLWIVXk--