pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade postgres 14.6 to minor version using source code
5+ messages / 3 participants
[nested] [flat]
* Upgrade postgres 14.6 to minor version using source code
@ 2023-09-27 08:10 Daulat <daulat.dba@gmail.com>
2023-09-27 08:16 ` Re: Upgrade postgres 14.6 to minor version using source code Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 5+ messages in thread
From: Daulat @ 2023-09-27 08:10 UTC (permalink / raw)
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Hello Team,
We are using the postgres 14.6 on Ubuntu that was installed via source code
(./configure) . Now we want to upgrade it to minor version 14.9. Please
suggest, what is the process for upgrading the minor releases if postgres
was installed using source code.
I know , pg_upgrade does not support minor version upgrades.
Thanks,
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Upgrade postgres 14.6 to minor version using source code
2023-09-27 08:10 Upgrade postgres 14.6 to minor version using source code Daulat <daulat.dba@gmail.com>
@ 2023-09-27 08:16 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 09:11 ` Re: Upgrade postgres 14.6 to minor version using source code Daulat <daulat.dba@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Laurenz Albe @ 2023-09-27 08:16 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; pgsql-admin <pgsql-admin@lists.postgresql.org>
On Wed, 2023-09-27 at 13:40 +0530, Daulat wrote:
> We are using the postgres 14.6 on Ubuntu that was installed via source code (./configure) .
> Now we want to upgrade it to minor version 14.9. Please suggest, what is the process
> for upgrading the minor releases if postgres was installed using source code.
Simple: stop the server, install 14.9, then start the server with the new software.
You should also read the release notes at
https://www.postgresql.org/docs/14/release-14-9.html#id-1.11.6.5.4
Sometimes there are additional things to consider. However, since you are
upgrading from a release after 14.3, there is nothing more to do.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Upgrade postgres 14.6 to minor version using source code
2023-09-27 08:10 Upgrade postgres 14.6 to minor version using source code Daulat <daulat.dba@gmail.com>
2023-09-27 08:16 ` Re: Upgrade postgres 14.6 to minor version using source code Laurenz Albe <laurenz.albe@cybertec.at>
@ 2023-09-27 09:11 ` Daulat <daulat.dba@gmail.com>
2023-09-27 13:44 ` Re: Upgrade postgres 14.6 to minor version using source code Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 16:02 ` Re: Upgrade postgres 14.6 to minor version using source code Edward J. Sabol <edwardjsabol@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Daulat @ 2023-09-27 09:11 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
You mean, just we have to perform the below steps
download software , wget
https://ftp.postgresql.org/pub/source/v14.9/postgresql-14.9.tar.gz
sudo ./configure --prefix=/opt/PostgreSQL-14/ --with-openssl
--exec-prefix=/opt/PostgreSQL-14/ --bindir=*/opt/PostgreSQL-14/bin*
--with-ldap
make
make install
On Wed, Sep 27, 2023 at 1:46 PM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> On Wed, 2023-09-27 at 13:40 +0530, Daulat wrote:
> > We are using the postgres 14.6 on Ubuntu that was installed via source
> code (./configure) .
> > Now we want to upgrade it to minor version 14.9. Please suggest, what is
> the process
> > for upgrading the minor releases if postgres was installed using source
> code.
>
> Simple: stop the server, install 14.9, then start the server with the new
> software.
>
> You should also read the release notes at
> https://www.postgresql.org/docs/14/release-14-9.html#id-1.11.6.5.4
> Sometimes there are additional things to consider. However, since you are
> upgrading from a release after 14.3, there is nothing more to do.
>
> Yours,
> Laurenz Albe
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Upgrade postgres 14.6 to minor version using source code
2023-09-27 08:10 Upgrade postgres 14.6 to minor version using source code Daulat <daulat.dba@gmail.com>
2023-09-27 08:16 ` Re: Upgrade postgres 14.6 to minor version using source code Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 09:11 ` Re: Upgrade postgres 14.6 to minor version using source code Daulat <daulat.dba@gmail.com>
@ 2023-09-27 13:44 ` Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 5+ messages in thread
From: Laurenz Albe @ 2023-09-27 13:44 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
On Wed, 2023-09-27 at 14:41 +0530, Daulat wrote:
> You mean, just we have to perform the below steps
> download software , wget https://ftp.postgresql.org/pub/source/v14.9/postgresql-14.9.tar.gz
> sudo ./configure --prefix=/opt/PostgreSQL-14/ --with-openssl --exec-prefix=/opt/PostgreSQL-14/ --bindir=/opt/PostgreSQL-14/bin --with-ldap
> make
> make install
Pretty much, yes.
I'd delete the old software before I run "make install", so that
no files are left behind. There should be no missing files in a
minor update, but it cannot hurt.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Upgrade postgres 14.6 to minor version using source code
2023-09-27 08:10 Upgrade postgres 14.6 to minor version using source code Daulat <daulat.dba@gmail.com>
2023-09-27 08:16 ` Re: Upgrade postgres 14.6 to minor version using source code Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 09:11 ` Re: Upgrade postgres 14.6 to minor version using source code Daulat <daulat.dba@gmail.com>
@ 2023-09-27 16:02 ` Edward J. Sabol <edwardjsabol@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Edward J. Sabol @ 2023-09-27 16:02 UTC (permalink / raw)
To: Daulat <daulat.dba@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
--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--
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-09-27 16:02 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-09-27 08:10 Upgrade postgres 14.6 to minor version using source code Daulat <daulat.dba@gmail.com>
2023-09-27 08:16 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 09:11 ` Daulat <daulat.dba@gmail.com>
2023-09-27 13:44 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-09-27 16:02 ` Edward J. Sabol <edwardjsabol@gmail.com>
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