From: Edward J. Sabol <edwardjsabol@gmail.com>
To: Daulat <daulat.dba@gmail.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Upgrade postgres 14.6 to minor version using source code
Date: Wed, 27 Sep 2023 12:02:16 -0400
Message-ID: <CA6CAB3A-9EF5-44BF-B3D6-B64753BD1D73@gmail.com> (raw)
In-Reply-To: <CALfOM6+C3uvWpRCbUir_a0UwVNCgdXadTO+f0RmqFKNfEckwKA@mail.gmail.com>
References: <CALfOM6+C3uvWpRCbUir_a0UwVNCgdXadTO+f0RmqFKNfEckwKA@mail.gmail.com>
--Apple-Mail-5761B00B-889D-4667-8888-1A1451FDDA81
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=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"></div><div dir=3D"ltr">It d=
epends on what user you are executing these commands as and whether they own=
the /opt/PostgreSQL-14/ and related directories. Using "sudo" for the confi=
gure command seems very odd. One usually needs to use "sudo" on the "make in=
stall" command unless the user you are running these commands owns /opt/....=
But I presume you know what your system needs here.</div><div dir=3D"ltr"><=
br></div><div dir=3D"ltr">Anyway, you are missing some steps. I think it wou=
ld be more like this:</div><div dir=3D"ltr"><br></div><div dir=3D"ltr">wget &=
lt;URL_of_tarball></div><div dir=3D"ltr">tar zxvf <tarball></div><d=
iv dir=3D"ltr">cd postgresql-<version>/</div><div dir=3D"ltr">./c=
onfigure <as you like></div><div dir=3D"ltr">make</div><div dir=3D"ltr=
">pg_ctl stop</div><div dir=3D"ltr">make install</div><div dir=3D"ltr">pg_ct=
l start</div><div dir=3D"ltr"><br></div><div dir=3D"ltr">Personally, I insta=
ll my source builds to separate directories for each version number. That wa=
y, I can "make install" without affecting the currently running server. Then=
, I use a script to change the symbolic links in the appropriate bin directo=
ry to point to the new version. This allows me to move the "make install" co=
mmand to before the "pg_ctl stop" command. This results in even less downtim=
e when switching to the new version, but that may not be necessary depending=
on your usage level. It also allows me to quickly revert to the previous ve=
rsion if there's a problem. I also don't use "pg_ctl" directly. I have a mor=
e sophisticated service script for stopping, starting, and restarting my Pos=
tgreSQL server which sets the environment variables appropriately and then e=
xecutes the appropriate "pg_ctl" commands for me. If you do as well, substit=
ute as appropriate.</div><div dir=3D"ltr"><br></div><div dir=3D"ltr">Hope th=
is helps,</div><div dir=3D"ltr">Ed</div><div dir=3D"ltr"><br><blockquote typ=
e=3D"cite">On Sep 27, 2023, at 7:21 AM, Daulat <daulat.dba@gmail.com> w=
rote:<br></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr"><div d=
ir=3D"ltr">You mean, just we have to perform the below steps<div>download so=
ftware , wget <a href=3D"https://ftp.postgresql.org/pub/source/v14=
.9/postgresql-14.9.tar.gz">https://ftp.postgresql.org/pub/source/v14.9/postg=
resql-14.9.tar.gz</a></div><div><div>sudo ./configure --prefix=3D/opt/Postgr=
eSQL-14/ --with-openssl --exec-prefix=3D/opt/PostgreSQL-14/ --bindir=3D<b>/o=
pt/PostgreSQL-14/bin</b> --with-ldap<br></div><div>make<br>make install<br><=
/div></div></div><br><div class=3D"gmail_quote"><blockquote type=3D"cite" __=
apple_fixed_attribute=3D"true"><div dir=3D"ltr" class=3D"gmail_attr"><span>O=
n Wed, Sep 27, 2023 at 1:46=E2=80=AFPM</span> Laurenz Albe <<a href=3D"ma=
ilto:laurenz.albe@cybertec.at">laurenz.albe@cybertec.at</a>> wrote:<br></=
div></blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Wed, 20=
23-09-27 at 13:40 +0530, Daulat wrote:<br>
> We are using the postgres 14.6 on Ubuntu that was installed via so=
urce code (./configure) .<br>
> Now we want to upgrade it to minor version 14.9. Please suggest, w=
hat is the process<br>
> for upgrading the minor releases if postgres was installed using source=
code.<br></blockquote></div></div></blockquote></body></html>=
--Apple-Mail-5761B00B-889D-4667-8888-1A1451FDDA81--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: edwardjsabol@gmail.com, daulat.dba@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Upgrade postgres 14.6 to minor version using source code
In-Reply-To: <CA6CAB3A-9EF5-44BF-B3D6-B64753BD1D73@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox