Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: Teja Jakkidi <teja.jakkidi05@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Postgres open source upgrades
Date: Tue, 28 Jun 2022 13:12:29 -0700
Message-Id: <70F022F4-4A35-4F5F-86A1-C5B571253A70@gmail.com>
References: <6E89EC2B-D3EF-456A-A020-5A17D44F3103@gmail.com>
In-Reply-To: <6E89EC2B-D3EF-456A-A020-5A17D44F3103@gmail.com>
To: pgsql-admin@lists.postgresql.org
Archived-At: 
 <https://www.postgresql.org/message-id/70F022F4-4A35-4F5F-86A1-C5B571253A70%40gmail.com>
Precedence: bulk

I also tried to test a minor upgrade with online documentation I found. I im=
plemented the below steps for upgrading from 14.1 to 14.2 and this is open s=
ource.
Before upgrade binary location is /postgres/14
1. Stop the cluster
2. Rename old binary location to /postgres/14.old
3. Create new binary location /postgres/14.2
4. Untar the software,=20
     Configure in the new directory 14.2 with new unrated software
     Make world
     Make install-world
5. Rename /postgres/14.2 to /postgres/14
6. Start the cluster
Cluster started and I was able to connect remotely with no issues. However w=
hen I tried using psql, I got below error:
         Connection to server on socket =E2=80=9C/var/run/postgresql/.s.PGSQ=
L.5432=E2=80=9D failed.
But my postgres has been using socket file in /tmp location before upgrade. I=
 am not sure why after upgrade psql is searching at a different allocation f=
or socket.=20
Can someone help me here?=20
Are the steps that I did, correct??


Thanks and Regards,
J. Teja Sri.

> On Jun 28, 2022, at 12:13 PM, Teja Jakkidi <teja.jakkidi05@gmail.com> wrot=
e:
>=20
> =EF=BB=BFHello pgsql-admin,
>=20
> I am very new to Postgres and trying to learn how upgrades work in Postgre=
s.=20
> We have open source installation and I am wondering if anyone can help me w=
ith correct documentation or steps on performing minor and major version upg=
rades.
>=20
> Thanks,
> J. Teja Sri.