How To Install postgresql on CentOS 8

postgresql is PostgreSQL client programs

Introduction

In this tutorial we learn how to install postgresql on CentOS 8.

What is `postgresql`

PostgreSQL is an advanced Object-Relational database management system (DBMS). The base postgresql package contains the client programs that you’ll need to access a PostgreSQL DBMS server, as well as HTML documentation for the whole system. These client programs can be located on the same machine as the PostgreSQL server, or on a remote machine that accesses a PostgreSQL server over a network connection. The PostgreSQL server can be found in the postgresql-server sub-package.

We can use yum or dnf to install postgresql on CentOS 8. In this tutorial we discuss both methods but you only need to choose one of method to install postgresql.

Install postgresql on CentOS 8 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

The output should look something like this:

CentOS Linux 8 - AppStream                                       43 kB/s | 4.3 kB     00:00    
CentOS Linux 8 - BaseOS                                          65 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - ContinuousRelease                               43 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - Extras                                          23 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - FastTrack                                       40 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - HighAvailability                                36 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - Plus                                            24 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - PowerTools                                      50 kB/s | 4.3 kB     00:00    
Extra Packages for Enterprise Linux Modular 8 - x86_64           13 kB/s | 9.2 kB     00:00    
Extra Packages for Enterprise Linux 8 - x86_64                   24 kB/s | 8.5 kB     00:00    
Metadata cache created.

After updating yum database, We can install postgresql using dnf by running the following command:

sudo dnf -y install postgresql

Install postgresql on CentOS 8 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

The output should look something like this:

CentOS Linux 8 - AppStream                                       43 kB/s | 4.3 kB     00:00    
CentOS Linux 8 - BaseOS                                          65 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - ContinuousRelease                               43 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - Extras                                          23 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - FastTrack                                       40 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - HighAvailability                                36 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - Plus                                            24 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - PowerTools                                      50 kB/s | 4.3 kB     00:00    
Extra Packages for Enterprise Linux Modular 8 - x86_64           13 kB/s | 9.2 kB     00:00    
Extra Packages for Enterprise Linux 8 - x86_64                   24 kB/s | 8.5 kB     00:00    
Metadata cache created.

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

sudo yum -y install postgresql

How To Uninstall postgresql on CentOS 8

To uninstall only the postgresql package we can use the following command:

sudo dnf remove postgresql

postgresql Package Contents on CentOS 8

/usr/bin/clusterdb
/usr/bin/createdb
/usr/bin/createuser
/usr/bin/dropdb
/usr/bin/dropuser
/usr/bin/pg_dump
/usr/bin/pg_dumpall
/usr/bin/pg_isready
/usr/bin/pg_restore
/usr/bin/pg_upgrade
/usr/bin/psql
/usr/bin/reindexdb
/usr/bin/vacuumdb
/usr/lib/.build-id
/usr/lib/.build-id/03
/usr/lib/.build-id/03/24334b46c11c2eafd32fec19eb88e4095f050b
/usr/lib/.build-id/07
/usr/lib/.build-id/07/2ffc26f9c7a89dce18d3d43335c73f90e16595
/usr/lib/.build-id/2a
/usr/lib/.build-id/2a/c8d5a2b06447a2100080a969305cf279f1ccd1
/usr/lib/.build-id/57
/usr/lib/.build-id/57/2aac9e7fb56917a76ec77e1d3fcd5be7ede97d
/usr/lib/.build-id/69
/usr/lib/.build-id/69/3b7bb3db5a0ec6c22b32cf739042749e024463
/usr/lib/.build-id/9d
/usr/lib/.build-id/9d/57287a835f2cbca1b5aeacb3a94dea398e8490
/usr/lib/.build-id/af
/usr/lib/.build-id/af/160fb688a37a0c527f5dfb3f2aea8e9dc4ae9f
/usr/lib/.build-id/b3
/usr/lib/.build-id/b3/b97a585e40bbf45cc14ee6badb4e05f84c4389
/usr/lib/.build-id/c6
/usr/lib/.build-id/c6/91b74e5c63a0a8960acf1c2958543c57799d38
/usr/lib/.build-id/c9
/usr/lib/.build-id/c9/83da103d5e641d62b9f27c20840ea032973fad
/usr/lib/.build-id/d5
/usr/lib/.build-id/d5/f260a37035cb7a896419be1a048874499a45af
/usr/lib/.build-id/e1
/usr/lib/.build-id/e1/31627d488dc201af82a5ee0ea3dedf8db61192
/usr/lib/.build-id/f5
/usr/lib/.build-id/f5/4c53fcde4934599a3c575cda927b15a672dfb9
/usr/share/doc/postgresql
/usr/share/doc/postgresql/COPYRIGHT
/usr/share/doc/postgresql/HISTORY
/usr/share/doc/postgresql/KNOWN_BUGS
/usr/share/doc/postgresql/MISSING_FEATURES
/usr/share/doc/postgresql/README
/usr/share/doc/postgresql/README.rpm-dist
/usr/share/doc/postgresql/TODO
/usr/share/doc/postgresql/bug.template
/usr/share/locale/cs/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/cs/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/cs/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/cs/LC_MESSAGES/psql-10.mo
/usr/share/locale/de/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/de/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/de/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/de/LC_MESSAGES/psql-10.mo
/usr/share/locale/es/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/es/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/es/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/es/LC_MESSAGES/psql-10.mo
/usr/share/locale/fr/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/fr/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/fr/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/fr/LC_MESSAGES/psql-10.mo
/usr/share/locale/he/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/he/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/he/LC_MESSAGES/psql-10.mo
/usr/share/locale/it/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/it/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/it/LC_MESSAGES/psql-10.mo
/usr/share/locale/ja/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/ja/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/ja/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/ja/LC_MESSAGES/psql-10.mo
/usr/share/locale/ko/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/ko/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/ko/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/ko/LC_MESSAGES/psql-10.mo
/usr/share/locale/pl/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/pl/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/pl/LC_MESSAGES/psql-10.mo
/usr/share/locale/pt_BR/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/pt_BR/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/pt_BR/LC_MESSAGES/psql-10.mo
/usr/share/locale/ru/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/ru/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/ru/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/ru/LC_MESSAGES/psql-10.mo
/usr/share/locale/sv/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/sv/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/sv/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/sv/LC_MESSAGES/psql-10.mo
/usr/share/locale/tr/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/tr/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/tr/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/tr/LC_MESSAGES/psql-10.mo
/usr/share/locale/zh_CN/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/zh_CN/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/zh_CN/LC_MESSAGES/psql-10.mo
/usr/share/man/man1/clusterdb.1.gz
/usr/share/man/man1/createdb.1.gz
/usr/share/man/man1/createuser.1.gz
/usr/share/man/man1/dropdb.1.gz
/usr/share/man/man1/dropuser.1.gz
/usr/share/man/man1/pg_dump.1.gz
/usr/share/man/man1/pg_dumpall.1.gz
/usr/share/man/man1/pg_isready.1.gz
/usr/share/man/man1/pg_restore.1.gz
/usr/share/man/man1/pg_upgrade.1.gz
/usr/share/man/man1/psql.1.gz
/usr/share/man/man1/reindexdb.1.gz
/usr/share/man/man1/vacuumdb.1.gz
/usr/share/man/man7/ABORT.7.gz
/usr/share/man/man7/ALTER_AGGREGATE.7.gz
/usr/share/man/man7/ALTER_COLLATION.7.gz
/usr/share/man/man7/ALTER_CONVERSION.7.gz
/usr/share/man/man7/ALTER_DATABASE.7.gz
/usr/share/man/man7/ALTER_DEFAULT_PRIVILEGES.7.gz
/usr/share/man/man7/ALTER_DOMAIN.7.gz
/usr/share/man/man7/ALTER_EVENT_TRIGGER.7.gz
/usr/share/man/man7/ALTER_EXTENSION.7.gz
/usr/share/man/man7/ALTER_FOREIGN_DATA_WRAPPER.7.gz
/usr/share/man/man7/ALTER_FOREIGN_TABLE.7.gz
/usr/share/man/man7/ALTER_FUNCTION.7.gz
/usr/share/man/man7/ALTER_GROUP.7.gz
/usr/share/man/man7/ALTER_INDEX.7.gz
/usr/share/man/man7/ALTER_LANGUAGE.7.gz
/usr/share/man/man7/ALTER_LARGE_OBJECT.7.gz
/usr/share/man/man7/ALTER_MATERIALIZED_VIEW.7.gz
/usr/share/man/man7/ALTER_OPERATOR.7.gz
/usr/share/man/man7/ALTER_OPERATOR_CLASS.7.gz
/usr/share/man/man7/ALTER_OPERATOR_FAMILY.7.gz
/usr/share/man/man7/ALTER_POLICY.7.gz
/usr/share/man/man7/ALTER_PUBLICATION.7.gz
/usr/share/man/man7/ALTER_ROLE.7.gz
/usr/share/man/man7/ALTER_RULE.7.gz
/usr/share/man/man7/ALTER_SCHEMA.7.gz
/usr/share/man/man7/ALTER_SEQUENCE.7.gz
/usr/share/man/man7/ALTER_SERVER.7.gz
/usr/share/man/man7/ALTER_STATISTICS.7.gz
/usr/share/man/man7/ALTER_SUBSCRIPTION.7.gz
/usr/share/man/man7/ALTER_SYSTEM.7.gz
/usr/share/man/man7/ALTER_TABLE.7.gz
/usr/share/man/man7/ALTER_TABLESPACE.7.gz
/usr/share/man/man7/ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
/usr/share/man/man7/ALTER_TEXT_SEARCH_DICTIONARY.7.gz
/usr/share/man/man7/ALTER_TEXT_SEARCH_PARSER.7.gz
/usr/share/man/man7/ALTER_TEXT_SEARCH_TEMPLATE.7.gz
/usr/share/man/man7/ALTER_TRIGGER.7.gz
/usr/share/man/man7/ALTER_TYPE.7.gz
/usr/share/man/man7/ALTER_USER.7.gz
/usr/share/man/man7/ALTER_USER_MAPPING.7.gz
/usr/share/man/man7/ALTER_VIEW.7.gz
/usr/share/man/man7/ANALYZE.7.gz
/usr/share/man/man7/BEGIN.7.gz
/usr/share/man/man7/CHECKPOINT.7.gz
/usr/share/man/man7/CLOSE.7.gz
/usr/share/man/man7/CLUSTER.7.gz
/usr/share/man/man7/COMMENT.7.gz
/usr/share/man/man7/COMMIT.7.gz
/usr/share/man/man7/COMMIT_PREPARED.7.gz
/usr/share/man/man7/COPY.7.gz
/usr/share/man/man7/CREATE_ACCESS_METHOD.7.gz
/usr/share/man/man7/CREATE_AGGREGATE.7.gz
/usr/share/man/man7/CREATE_CAST.7.gz
/usr/share/man/man7/CREATE_COLLATION.7.gz
/usr/share/man/man7/CREATE_CONVERSION.7.gz
/usr/share/man/man7/CREATE_DATABASE.7.gz
/usr/share/man/man7/CREATE_DOMAIN.7.gz
/usr/share/man/man7/CREATE_EVENT_TRIGGER.7.gz
/usr/share/man/man7/CREATE_EXTENSION.7.gz
/usr/share/man/man7/CREATE_FOREIGN_DATA_WRAPPER.7.gz
/usr/share/man/man7/CREATE_FOREIGN_TABLE.7.gz
/usr/share/man/man7/CREATE_FUNCTION.7.gz
/usr/share/man/man7/CREATE_GROUP.7.gz
/usr/share/man/man7/CREATE_INDEX.7.gz
/usr/share/man/man7/CREATE_LANGUAGE.7.gz
/usr/share/man/man7/CREATE_MATERIALIZED_VIEW.7.gz
/usr/share/man/man7/CREATE_OPERATOR.7.gz
/usr/share/man/man7/CREATE_OPERATOR_CLASS.7.gz
/usr/share/man/man7/CREATE_OPERATOR_FAMILY.7.gz
/usr/share/man/man7/CREATE_POLICY.7.gz
/usr/share/man/man7/CREATE_PUBLICATION.7.gz
/usr/share/man/man7/CREATE_ROLE.7.gz
/usr/share/man/man7/CREATE_RULE.7.gz
/usr/share/man/man7/CREATE_SCHEMA.7.gz
/usr/share/man/man7/CREATE_SEQUENCE.7.gz
/usr/share/man/man7/CREATE_SERVER.7.gz
/usr/share/man/man7/CREATE_STATISTICS.7.gz
/usr/share/man/man7/CREATE_SUBSCRIPTION.7.gz
/usr/share/man/man7/CREATE_TABLE.7.gz
/usr/share/man/man7/CREATE_TABLESPACE.7.gz
/usr/share/man/man7/CREATE_TABLE_AS.7.gz
/usr/share/man/man7/CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
/usr/share/man/man7/CREATE_TEXT_SEARCH_DICTIONARY.7.gz
/usr/share/man/man7/CREATE_TEXT_SEARCH_PARSER.7.gz
/usr/share/man/man7/CREATE_TEXT_SEARCH_TEMPLATE.7.gz
/usr/share/man/man7/CREATE_TRANSFORM.7.gz
/usr/share/man/man7/CREATE_TRIGGER.7.gz
/usr/share/man/man7/CREATE_TYPE.7.gz
/usr/share/man/man7/CREATE_USER.7.gz
/usr/share/man/man7/CREATE_USER_MAPPING.7.gz
/usr/share/man/man7/CREATE_VIEW.7.gz
/usr/share/man/man7/DEALLOCATE.7.gz
/usr/share/man/man7/DECLARE.7.gz
/usr/share/man/man7/DELETE.7.gz
/usr/share/man/man7/DISCARD.7.gz
/usr/share/man/man7/DO.7.gz
/usr/share/man/man7/DROP_ACCESS_METHOD.7.gz
/usr/share/man/man7/DROP_AGGREGATE.7.gz
/usr/share/man/man7/DROP_CAST.7.gz
/usr/share/man/man7/DROP_COLLATION.7.gz
/usr/share/man/man7/DROP_CONVERSION.7.gz
/usr/share/man/man7/DROP_DATABASE.7.gz
/usr/share/man/man7/DROP_DOMAIN.7.gz
/usr/share/man/man7/DROP_EVENT_TRIGGER.7.gz
/usr/share/man/man7/DROP_EXTENSION.7.gz
/usr/share/man/man7/DROP_FOREIGN_DATA_WRAPPER.7.gz
/usr/share/man/man7/DROP_FOREIGN_TABLE.7.gz
/usr/share/man/man7/DROP_FUNCTION.7.gz
/usr/share/man/man7/DROP_GROUP.7.gz
/usr/share/man/man7/DROP_INDEX.7.gz
/usr/share/man/man7/DROP_LANGUAGE.7.gz
/usr/share/man/man7/DROP_MATERIALIZED_VIEW.7.gz
/usr/share/man/man7/DROP_OPERATOR.7.gz
/usr/share/man/man7/DROP_OPERATOR_CLASS.7.gz
/usr/share/man/man7/DROP_OPERATOR_FAMILY.7.gz
/usr/share/man/man7/DROP_OWNED.7.gz
/usr/share/man/man7/DROP_POLICY.7.gz
/usr/share/man/man7/DROP_PUBLICATION.7.gz
/usr/share/man/man7/DROP_ROLE.7.gz
/usr/share/man/man7/DROP_RULE.7.gz
/usr/share/man/man7/DROP_SCHEMA.7.gz
/usr/share/man/man7/DROP_SEQUENCE.7.gz
/usr/share/man/man7/DROP_SERVER.7.gz
/usr/share/man/man7/DROP_STATISTICS.7.gz
/usr/share/man/man7/DROP_SUBSCRIPTION.7.gz
/usr/share/man/man7/DROP_TABLE.7.gz
/usr/share/man/man7/DROP_TABLESPACE.7.gz
/usr/share/man/man7/DROP_TEXT_SEARCH_CONFIGURATION.7.gz
/usr/share/man/man7/DROP_TEXT_SEARCH_DICTIONARY.7.gz
/usr/share/man/man7/DROP_TEXT_SEARCH_PARSER.7.gz
/usr/share/man/man7/DROP_TEXT_SEARCH_TEMPLATE.7.gz
/usr/share/man/man7/DROP_TRANSFORM.7.gz
/usr/share/man/man7/DROP_TRIGGER.7.gz
/usr/share/man/man7/DROP_TYPE.7.gz
/usr/share/man/man7/DROP_USER.7.gz
/usr/share/man/man7/DROP_USER_MAPPING.7.gz
/usr/share/man/man7/DROP_VIEW.7.gz
/usr/share/man/man7/END.7.gz
/usr/share/man/man7/EXECUTE.7.gz
/usr/share/man/man7/EXPLAIN.7.gz
/usr/share/man/man7/FETCH.7.gz
/usr/share/man/man7/GRANT.7.gz
/usr/share/man/man7/IMPORT_FOREIGN_SCHEMA.7.gz
/usr/share/man/man7/INSERT.7.gz
/usr/share/man/man7/LISTEN.7.gz
/usr/share/man/man7/LOAD.7.gz
/usr/share/man/man7/LOCK.7.gz
/usr/share/man/man7/MOVE.7.gz
/usr/share/man/man7/NOTIFY.7.gz
/usr/share/man/man7/PREPARE.7.gz
/usr/share/man/man7/PREPARE_TRANSACTION.7.gz
/usr/share/man/man7/REASSIGN_OWNED.7.gz
/usr/share/man/man7/REFRESH_MATERIALIZED_VIEW.7.gz
/usr/share/man/man7/REINDEX.7.gz
/usr/share/man/man7/RELEASE_SAVEPOINT.7.gz
/usr/share/man/man7/RESET.7.gz
/usr/share/man/man7/REVOKE.7.gz
/usr/share/man/man7/ROLLBACK.7.gz
/usr/share/man/man7/ROLLBACK_PREPARED.7.gz
/usr/share/man/man7/ROLLBACK_TO_SAVEPOINT.7.gz
/usr/share/man/man7/SAVEPOINT.7.gz
/usr/share/man/man7/SECURITY_LABEL.7.gz
/usr/share/man/man7/SELECT.7.gz
/usr/share/man/man7/SELECT_INTO.7.gz
/usr/share/man/man7/SET.7.gz
/usr/share/man/man7/SET_CONSTRAINTS.7.gz
/usr/share/man/man7/SET_ROLE.7.gz
/usr/share/man/man7/SET_SESSION_AUTHORIZATION.7.gz
/usr/share/man/man7/SET_TRANSACTION.7.gz
/usr/share/man/man7/SHOW.7.gz
/usr/share/man/man7/START_TRANSACTION.7.gz
/usr/share/man/man7/TABLE.7.gz
/usr/share/man/man7/TRUNCATE.7.gz
/usr/share/man/man7/UNLISTEN.7.gz
/usr/share/man/man7/UPDATE.7.gz
/usr/share/man/man7/VACUUM.7.gz
/usr/share/man/man7/VALUES.7.gz
/usr/share/man/man7/WITH.7.gz
/usr/bin/clusterdb
/usr/bin/createdb
/usr/bin/createuser
/usr/bin/dropdb
/usr/bin/dropuser
/usr/bin/pg_dump
/usr/bin/pg_dumpall
/usr/bin/pg_isready
/usr/bin/pg_restore
/usr/bin/pg_upgrade
/usr/bin/psql
/usr/bin/reindexdb
/usr/bin/vacuumdb
/usr/lib/.build-id
/usr/lib/.build-id/1b
/usr/lib/.build-id/1b/45ba32b8b2a17f4f27ac313be182acf2af660a
/usr/lib/.build-id/21
/usr/lib/.build-id/21/5d64314280a88017823b9edaa83d0588e60fba
/usr/lib/.build-id/22
/usr/lib/.build-id/22/3c3ed52e440f4a341ee5d55a66c88f752ecd4e
/usr/lib/.build-id/36
/usr/lib/.build-id/36/72a91b26f83909c3e182c4e34009618f9bfe39
/usr/lib/.build-id/3b
/usr/lib/.build-id/3b/30039f881757b0c9e6493df3ee47b98d2e0b20
/usr/lib/.build-id/55
/usr/lib/.build-id/55/03b77e21a55a943ab46a36b79bac1d8125f561
/usr/lib/.build-id/5f
/usr/lib/.build-id/5f/9941f1b94cc023bb1b375bf4387e8b31406c63
/usr/lib/.build-id/67
/usr/lib/.build-id/67/968a9a64a24a69f5876fb9af0c306d5e2b5347
/usr/lib/.build-id/6c
/usr/lib/.build-id/6c/a25bc684c3ebbd50c3897c0afbc8887185913b
/usr/lib/.build-id/6f
/usr/lib/.build-id/6f/cff9fa77ad17e6c57f676fb2f95593f50fc9a6
/usr/lib/.build-id/85
/usr/lib/.build-id/85/c315b0f598b3c3976db97f8dc7e2de79833dfd
/usr/lib/.build-id/ac
/usr/lib/.build-id/ac/7d7be6ab34707f8b1deb082b151f4f77d20069
/usr/lib/.build-id/eb
/usr/lib/.build-id/eb/75563c501dde4f6c28864d00e403aedbd5a01b
/usr/share/doc/postgresql
/usr/share/doc/postgresql/COPYRIGHT
/usr/share/doc/postgresql/HISTORY
/usr/share/doc/postgresql/KNOWN_BUGS
/usr/share/doc/postgresql/MISSING_FEATURES
/usr/share/doc/postgresql/README
/usr/share/doc/postgresql/README.rpm-dist
/usr/share/doc/postgresql/TODO
/usr/share/doc/postgresql/bug.template
/usr/share/locale/cs/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/cs/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/cs/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/cs/LC_MESSAGES/psql-10.mo
/usr/share/locale/de/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/de/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/de/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/de/LC_MESSAGES/psql-10.mo
/usr/share/locale/es/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/es/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/es/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/es/LC_MESSAGES/psql-10.mo
/usr/share/locale/fr/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/fr/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/fr/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/fr/LC_MESSAGES/psql-10.mo
/usr/share/locale/he/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/he/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/he/LC_MESSAGES/psql-10.mo
/usr/share/locale/it/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/it/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/it/LC_MESSAGES/psql-10.mo
/usr/share/locale/ja/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/ja/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/ja/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/ja/LC_MESSAGES/psql-10.mo
/usr/share/locale/ko/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/ko/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/ko/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/ko/LC_MESSAGES/psql-10.mo
/usr/share/locale/pl/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/pl/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/pl/LC_MESSAGES/psql-10.mo
/usr/share/locale/pt_BR/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/pt_BR/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/pt_BR/LC_MESSAGES/psql-10.mo
/usr/share/locale/ru/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/ru/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/ru/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/ru/LC_MESSAGES/psql-10.mo
/usr/share/locale/sv/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/sv/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/sv/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/sv/LC_MESSAGES/psql-10.mo
/usr/share/locale/tr/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/tr/LC_MESSAGES/pg_upgrade-10.mo
/usr/share/locale/tr/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/tr/LC_MESSAGES/psql-10.mo
/usr/share/locale/zh_CN/LC_MESSAGES/pg_dump-10.mo
/usr/share/locale/zh_CN/LC_MESSAGES/pgscripts-10.mo
/usr/share/locale/zh_CN/LC_MESSAGES/psql-10.mo
/usr/share/man/man1/clusterdb.1.gz
/usr/share/man/man1/createdb.1.gz
/usr/share/man/man1/createuser.1.gz
/usr/share/man/man1/dropdb.1.gz
/usr/share/man/man1/dropuser.1.gz
/usr/share/man/man1/pg_dump.1.gz
/usr/share/man/man1/pg_dumpall.1.gz
/usr/share/man/man1/pg_isready.1.gz
/usr/share/man/man1/pg_restore.1.gz
/usr/share/man/man1/pg_upgrade.1.gz
/usr/share/man/man1/psql.1.gz
/usr/share/man/man1/reindexdb.1.gz
/usr/share/man/man1/vacuumdb.1.gz
/usr/share/man/man7/ABORT.7.gz
/usr/share/man/man7/ALTER_AGGREGATE.7.gz
/usr/share/man/man7/ALTER_COLLATION.7.gz
/usr/share/man/man7/ALTER_CONVERSION.7.gz
/usr/share/man/man7/ALTER_DATABASE.7.gz
/usr/share/man/man7/ALTER_DEFAULT_PRIVILEGES.7.gz
/usr/share/man/man7/ALTER_DOMAIN.7.gz
/usr/share/man/man7/ALTER_EVENT_TRIGGER.7.gz
/usr/share/man/man7/ALTER_EXTENSION.7.gz
/usr/share/man/man7/ALTER_FOREIGN_DATA_WRAPPER.7.gz
/usr/share/man/man7/ALTER_FOREIGN_TABLE.7.gz
/usr/share/man/man7/ALTER_FUNCTION.7.gz
/usr/share/man/man7/ALTER_GROUP.7.gz
/usr/share/man/man7/ALTER_INDEX.7.gz
/usr/share/man/man7/ALTER_LANGUAGE.7.gz
/usr/share/man/man7/ALTER_LARGE_OBJECT.7.gz
/usr/share/man/man7/ALTER_MATERIALIZED_VIEW.7.gz
/usr/share/man/man7/ALTER_OPERATOR.7.gz
/usr/share/man/man7/ALTER_OPERATOR_CLASS.7.gz
/usr/share/man/man7/ALTER_OPERATOR_FAMILY.7.gz
/usr/share/man/man7/ALTER_POLICY.7.gz
/usr/share/man/man7/ALTER_PUBLICATION.7.gz
/usr/share/man/man7/ALTER_ROLE.7.gz
/usr/share/man/man7/ALTER_RULE.7.gz
/usr/share/man/man7/ALTER_SCHEMA.7.gz
/usr/share/man/man7/ALTER_SEQUENCE.7.gz
/usr/share/man/man7/ALTER_SERVER.7.gz
/usr/share/man/man7/ALTER_STATISTICS.7.gz
/usr/share/man/man7/ALTER_SUBSCRIPTION.7.gz
/usr/share/man/man7/ALTER_SYSTEM.7.gz
/usr/share/man/man7/ALTER_TABLE.7.gz
/usr/share/man/man7/ALTER_TABLESPACE.7.gz
/usr/share/man/man7/ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
/usr/share/man/man7/ALTER_TEXT_SEARCH_DICTIONARY.7.gz
/usr/share/man/man7/ALTER_TEXT_SEARCH_PARSER.7.gz
/usr/share/man/man7/ALTER_TEXT_SEARCH_TEMPLATE.7.gz
/usr/share/man/man7/ALTER_TRIGGER.7.gz
/usr/share/man/man7/ALTER_TYPE.7.gz
/usr/share/man/man7/ALTER_USER.7.gz
/usr/share/man/man7/ALTER_USER_MAPPING.7.gz
/usr/share/man/man7/ALTER_VIEW.7.gz
/usr/share/man/man7/ANALYZE.7.gz
/usr/share/man/man7/BEGIN.7.gz
/usr/share/man/man7/CHECKPOINT.7.gz
/usr/share/man/man7/CLOSE.7.gz
/usr/share/man/man7/CLUSTER.7.gz
/usr/share/man/man7/COMMENT.7.gz
/usr/share/man/man7/COMMIT.7.gz
/usr/share/man/man7/COMMIT_PREPARED.7.gz
/usr/share/man/man7/COPY.7.gz
/usr/share/man/man7/CREATE_ACCESS_METHOD.7.gz
/usr/share/man/man7/CREATE_AGGREGATE.7.gz
/usr/share/man/man7/CREATE_CAST.7.gz
/usr/share/man/man7/CREATE_COLLATION.7.gz
/usr/share/man/man7/CREATE_CONVERSION.7.gz
/usr/share/man/man7/CREATE_DATABASE.7.gz
/usr/share/man/man7/CREATE_DOMAIN.7.gz
/usr/share/man/man7/CREATE_EVENT_TRIGGER.7.gz
/usr/share/man/man7/CREATE_EXTENSION.7.gz
/usr/share/man/man7/CREATE_FOREIGN_DATA_WRAPPER.7.gz
/usr/share/man/man7/CREATE_FOREIGN_TABLE.7.gz
/usr/share/man/man7/CREATE_FUNCTION.7.gz
/usr/share/man/man7/CREATE_GROUP.7.gz
/usr/share/man/man7/CREATE_INDEX.7.gz
/usr/share/man/man7/CREATE_LANGUAGE.7.gz
/usr/share/man/man7/CREATE_MATERIALIZED_VIEW.7.gz
/usr/share/man/man7/CREATE_OPERATOR.7.gz
/usr/share/man/man7/CREATE_OPERATOR_CLASS.7.gz
/usr/share/man/man7/CREATE_OPERATOR_FAMILY.7.gz
/usr/share/man/man7/CREATE_POLICY.7.gz
/usr/share/man/man7/CREATE_PUBLICATION.7.gz
/usr/share/man/man7/CREATE_ROLE.7.gz
/usr/share/man/man7/CREATE_RULE.7.gz
/usr/share/man/man7/CREATE_SCHEMA.7.gz
/usr/share/man/man7/CREATE_SEQUENCE.7.gz
/usr/share/man/man7/CREATE_SERVER.7.gz
/usr/share/man/man7/CREATE_STATISTICS.7.gz
/usr/share/man/man7/CREATE_SUBSCRIPTION.7.gz
/usr/share/man/man7/CREATE_TABLE.7.gz
/usr/share/man/man7/CREATE_TABLESPACE.7.gz
/usr/share/man/man7/CREATE_TABLE_AS.7.gz
/usr/share/man/man7/CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
/usr/share/man/man7/CREATE_TEXT_SEARCH_DICTIONARY.7.gz
/usr/share/man/man7/CREATE_TEXT_SEARCH_PARSER.7.gz
/usr/share/man/man7/CREATE_TEXT_SEARCH_TEMPLATE.7.gz
/usr/share/man/man7/CREATE_TRANSFORM.7.gz
/usr/share/man/man7/CREATE_TRIGGER.7.gz
/usr/share/man/man7/CREATE_TYPE.7.gz
/usr/share/man/man7/CREATE_USER.7.gz
/usr/share/man/man7/CREATE_USER_MAPPING.7.gz
/usr/share/man/man7/CREATE_VIEW.7.gz
/usr/share/man/man7/DEALLOCATE.7.gz
/usr/share/man/man7/DECLARE.7.gz
/usr/share/man/man7/DELETE.7.gz
/usr/share/man/man7/DISCARD.7.gz
/usr/share/man/man7/DO.7.gz
/usr/share/man/man7/DROP_ACCESS_METHOD.7.gz
/usr/share/man/man7/DROP_AGGREGATE.7.gz
/usr/share/man/man7/DROP_CAST.7.gz
/usr/share/man/man7/DROP_COLLATION.7.gz
/usr/share/man/man7/DROP_CONVERSION.7.gz
/usr/share/man/man7/DROP_DATABASE.7.gz
/usr/share/man/man7/DROP_DOMAIN.7.gz
/usr/share/man/man7/DROP_EVENT_TRIGGER.7.gz
/usr/share/man/man7/DROP_EXTENSION.7.gz
/usr/share/man/man7/DROP_FOREIGN_DATA_WRAPPER.7.gz
/usr/share/man/man7/DROP_FOREIGN_TABLE.7.gz
/usr/share/man/man7/DROP_FUNCTION.7.gz
/usr/share/man/man7/DROP_GROUP.7.gz
/usr/share/man/man7/DROP_INDEX.7.gz
/usr/share/man/man7/DROP_LANGUAGE.7.gz
/usr/share/man/man7/DROP_MATERIALIZED_VIEW.7.gz
/usr/share/man/man7/DROP_OPERATOR.7.gz
/usr/share/man/man7/DROP_OPERATOR_CLASS.7.gz
/usr/share/man/man7/DROP_OPERATOR_FAMILY.7.gz
/usr/share/man/man7/DROP_OWNED.7.gz
/usr/share/man/man7/DROP_POLICY.7.gz
/usr/share/man/man7/DROP_PUBLICATION.7.gz
/usr/share/man/man7/DROP_ROLE.7.gz
/usr/share/man/man7/DROP_RULE.7.gz
/usr/share/man/man7/DROP_SCHEMA.7.gz
/usr/share/man/man7/DROP_SEQUENCE.7.gz
/usr/share/man/man7/DROP_SERVER.7.gz
/usr/share/man/man7/DROP_STATISTICS.7.gz
/usr/share/man/man7/DROP_SUBSCRIPTION.7.gz
/usr/share/man/man7/DROP_TABLE.7.gz
/usr/share/man/man7/DROP_TABLESPACE.7.gz
/usr/share/man/man7/DROP_TEXT_SEARCH_CONFIGURATION.7.gz
/usr/share/man/man7/DROP_TEXT_SEARCH_DICTIONARY.7.gz
/usr/share/man/man7/DROP_TEXT_SEARCH_PARSER.7.gz
/usr/share/man/man7/DROP_TEXT_SEARCH_TEMPLATE.7.gz
/usr/share/man/man7/DROP_TRANSFORM.7.gz
/usr/share/man/man7/DROP_TRIGGER.7.gz
/usr/share/man/man7/DROP_TYPE.7.gz
/usr/share/man/man7/DROP_USER.7.gz
/usr/share/man/man7/DROP_USER_MAPPING.7.gz
/usr/share/man/man7/DROP_VIEW.7.gz
/usr/share/man/man7/END.7.gz
/usr/share/man/man7/EXECUTE.7.gz
/usr/share/man/man7/EXPLAIN.7.gz
/usr/share/man/man7/FETCH.7.gz
/usr/share/man/man7/GRANT.7.gz
/usr/share/man/man7/IMPORT_FOREIGN_SCHEMA.7.gz
/usr/share/man/man7/INSERT.7.gz
/usr/share/man/man7/LISTEN.7.gz
/usr/share/man/man7/LOAD.7.gz
/usr/share/man/man7/LOCK.7.gz
/usr/share/man/man7/MOVE.7.gz
/usr/share/man/man7/NOTIFY.7.gz
/usr/share/man/man7/PREPARE.7.gz
/usr/share/man/man7/PREPARE_TRANSACTION.7.gz
/usr/share/man/man7/REASSIGN_OWNED.7.gz
/usr/share/man/man7/REFRESH_MATERIALIZED_VIEW.7.gz
/usr/share/man/man7/REINDEX.7.gz
/usr/share/man/man7/RELEASE_SAVEPOINT.7.gz
/usr/share/man/man7/RESET.7.gz
/usr/share/man/man7/REVOKE.7.gz
/usr/share/man/man7/ROLLBACK.7.gz
/usr/share/man/man7/ROLLBACK_PREPARED.7.gz
/usr/share/man/man7/ROLLBACK_TO_SAVEPOINT.7.gz
/usr/share/man/man7/SAVEPOINT.7.gz
/usr/share/man/man7/SECURITY_LABEL.7.gz
/usr/share/man/man7/SELECT.7.gz
/usr/share/man/man7/SELECT_INTO.7.gz
/usr/share/man/man7/SET.7.gz
/usr/share/man/man7/SET_CONSTRAINTS.7.gz
/usr/share/man/man7/SET_ROLE.7.gz
/usr/share/man/man7/SET_SESSION_AUTHORIZATION.7.gz
/usr/share/man/man7/SET_TRANSACTION.7.gz
/usr/share/man/man7/SHOW.7.gz
/usr/share/man/man7/START_TRANSACTION.7.gz
/usr/share/man/man7/TABLE.7.gz
/usr/share/man/man7/TRUNCATE.7.gz
/usr/share/man/man7/UNLISTEN.7.gz
/usr/share/man/man7/UPDATE.7.gz
/usr/share/man/man7/VACUUM.7.gz
/usr/share/man/man7/VALUES.7.gz
/usr/share/man/man7/WITH.7.gz

References

postgresql website

Summary

In this tutorial we learn how to install postgresql on CentOS 8 using yum and dnf.