Task:
Get PostgreSQL version and update.
For example, below is a version 13.14 PostgreSQL running on RHEL 8.6.x. We will upgrade PostgreSQL to the newest version (13.16 at the time of this writing), and upgrade the out-of-date OS to the lastest 8.9.x.
1. Get the PostgreSQL version:
$ ssh myid@dbappliance.mindwatering.net
$ sudo su
(or)
$ pbrun su -
# su postgres -
bash-4.4$ psql -c 'SELECT version();'
version
---------------------
PostgreSQL 13.14 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 8.x.0 202xxxxx (Red Hat 8.6.0-xx), 64-bit
(1 row)
bash-4.4$ exit
2. Upgrade:
a. Check the yum.conf and dnf.conf files. We need to make sure kernel and release files can be upgraded. For example, we comment out, with #, the exclusion of the kernel and redhat-release packages below.
# vi /etc/yum.conf
[main]
# exclude=kernel* redhat-release*
...
<esc>:wq (to save)
# vi /etc/dnf/dnf.conf
[main]
# exclude=kernel* redhat-release*
...
<esc>:wq (to save)
b. Perform the upgrade:
# dnf update
<review and accept updates>
previous page
|