How To Install postgresql-upgrade.x86_64 on Amazon Linux 2

In this tutorial we learn how to install postgresql-upgrade.x86_64 in Amazon Linux 2. postgresql-upgrade.x86_64 is Support for upgrading from the previous major release of

Introduction

In this tutorial we learn how to install postgresql-upgrade.x86_64 on Amazon Linux 2.

What is `postgresql-upgrade.x86_64`

The postgresql-upgrade package contains the pg_upgrade utility and supporting files needed for upgrading a PostgreSQL database from the previous major version of PostgreSQL.

We can use yum to install postgresql-upgrade.x86_64 on Amazon Linux 2. In this tutorial we discuss both methods but you only need to choose one of method to install postgresql-upgrade.x86_64.

Install postgresql-upgrade.x86_64 on Amazon Linux 2 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

After updating yum database, We can install postgresql-upgrade.x86_64 using yum by running the following command:

sudo yum -y install postgresql-upgrade.x86_64

How To Uninstall postgresql-upgrade.x86_64 on Amazon Linux 2

To uninstall only the postgresql-upgrade.x86_64 package we can use the following command:

sudo yum remove postgresql-upgrade.x86_64

postgresql-upgrade.x86_64 Package Contents on Amazon Linux 2

/usr/bin/pg_upgrade
/usr/lib64/pgsql/pg_upgrade_support.so
/usr/lib64/pgsql/postgresql-8.4
/usr/lib64/pgsql/postgresql-8.4/bin
/usr/lib64/pgsql/postgresql-8.4/bin/pg_controldata
/usr/lib64/pgsql/postgresql-8.4/bin/pg_ctl
/usr/lib64/pgsql/postgresql-8.4/bin/pg_resetxlog
/usr/lib64/pgsql/postgresql-8.4/bin/postgres
/usr/lib64/pgsql/postgresql-8.4/bin/postmaster
/usr/lib64/pgsql/postgresql-8.4/lib
/usr/lib64/pgsql/postgresql-8.4/lib/ascii_and_mic.so
/usr/lib64/pgsql/postgresql-8.4/lib/cyrillic_and_mic.so
/usr/lib64/pgsql/postgresql-8.4/lib/euc_cn_and_mic.so
/usr/lib64/pgsql/postgresql-8.4/lib/euc_jis_2004_and_shift_jis_2004.so
/usr/lib64/pgsql/postgresql-8.4/lib/euc_jp_and_sjis.so
/usr/lib64/pgsql/postgresql-8.4/lib/euc_kr_and_mic.so
/usr/lib64/pgsql/postgresql-8.4/lib/euc_tw_and_big5.so
/usr/lib64/pgsql/postgresql-8.4/lib/latin2_and_win1250.so
/usr/lib64/pgsql/postgresql-8.4/lib/latin_and_mic.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_ascii.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_big5.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_cyrillic.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_euc_cn.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_euc_jis_2004.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_euc_jp.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_euc_kr.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_euc_tw.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_gb18030.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_gbk.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_iso8859.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_iso8859_1.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_johab.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_shift_jis_2004.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_sjis.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_uhc.so
/usr/lib64/pgsql/postgresql-8.4/lib/utf8_and_win.so
/usr/lib64/pgsql/postgresql-8.4/share
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Africa.txt
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/America.txt
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Antarctica.txt
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Asia.txt
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Atlantic.txt
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Australia
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Australia.txt
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Default
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Etc.txt
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Europe.txt
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/India
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Indian.txt
/usr/lib64/pgsql/postgresql-8.4/share/timezonesets/Pacific.txt
/usr/share/man/man1/pg_upgrade.1.gz

References

postgresql-upgrade.x86_64 website

Summary

In this tutorial we learn how to install postgresql-upgrade.x86_64 on Amazon Linux 2 using yum.