一、需求背景

• 通过yum install -y postgresql15-server安装了postgresql15数据库，现在需要查看postgresql15数据库的安装目录

二、查看yum install安装的软件目录

• 使用命令 rpm -ql postgresql15-server

 rpm -ql postgresql15-server
/etc/pam.d/postgresql
/etc/sysconfig/pgsql
/usr/bin/postgresql-15-setup
/usr/lib/systemd/system/postgresql-15.service
/usr/lib/tmpfiles.d/postgresql-15.conf
/usr/pgsql-15/bin/initdb
/usr/pgsql-15/bin/pg_archivecleanup
/usr/pgsql-15/bin/pg_checksums
/usr/pgsql-15/bin/pg_controldata
/usr/pgsql-15/bin/pg_ctl
/usr/pgsql-15/bin/pg_resetwal
/usr/pgsql-15/bin/pg_rewind
/usr/pgsql-15/bin/pg_test_fsync
/usr/pgsql-15/bin/pg_test_timing
/usr/pgsql-15/bin/pg_upgrade
/usr/pgsql-15/bin/pg_verifybackup
/usr/pgsql-15/bin/postgres
/usr/pgsql-15/bin/postgresql-15-check-db-dir
/usr/pgsql-15/bin/postgresql-15-setup
/usr/pgsql-15/bin/postmaster
/usr/pgsql-15/lib
/usr/pgsql-15/lib/cyrillic_and_mic.so
/usr/pgsql-15/lib/dict_int.so
/usr/pgsql-15/lib/dict_snowball.so
/usr/pgsql-15/lib/dict_xsyn.so
/usr/pgsql-15/lib/euc2004_sjis2004.so
/usr/pgsql-15/lib/euc_cn_and_mic.so
/usr/pgsql-15/lib/euc_jp_and_sjis.so
/usr/pgsql-15/lib/euc_kr_and_mic.so
/usr/pgsql-15/lib/euc_tw_and_big5.so
/usr/pgsql-15/lib/latin2_and_win1250.so
/usr/pgsql-15/lib/latin_and_mic.so
/usr/pgsql-15/lib/pgoutput.so
/usr/pgsql-15/lib/plpgsql.so
/usr/pgsql-15/lib/utf8_and_big5.so
/usr/pgsql-15/lib/utf8_and_cyrillic.so
/usr/pgsql-15/lib/utf8_and_euc2004.so
/usr/pgsql-15/lib/utf8_and_euc_cn.so
/usr/pgsql-15/lib/utf8_and_euc_jp.so
/usr/pgsql-15/lib/utf8_and_euc_kr.so
/usr/pgsql-15/lib/utf8_and_euc_tw.so
/usr/pgsql-15/lib/utf8_and_gb18030.so
/usr/pgsql-15/lib/utf8_and_gbk.so
/usr/pgsql-15/lib/utf8_and_iso8859.so
/usr/pgsql-15/lib/utf8_and_iso8859_1.so
/usr/pgsql-15/lib/utf8_and_johab.so
/usr/pgsql-15/lib/utf8_and_sjis.so
/usr/pgsql-15/lib/utf8_and_sjis2004.so
/usr/pgsql-15/lib/utf8_and_uhc.so
/usr/pgsql-15/lib/utf8_and_win.so
/usr/pgsql-15/share
/usr/pgsql-15/share/extension
/usr/pgsql-15/share/extension/plpgsql--1.0.sql
/usr/pgsql-15/share/extension/plpgsql.control
/usr/pgsql-15/share/information_schema.sql
/usr/pgsql-15/share/locale/cs/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/cs/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/cs/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/cs/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/cs/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/de/LC_MESSAGES/postgres-15.mo
/usr/pgsql-15/share/locale/el/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/el/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/el/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/el/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/el/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/el/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/el/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/el/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/el/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/el/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/es/LC_MESSAGES/postgres-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/fr/LC_MESSAGES/postgres-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/it/LC_MESSAGES/postgres-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/ja/LC_MESSAGES/postgres-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/ka/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/ko/LC_MESSAGES/postgres-15.mo
/usr/pgsql-15/share/locale/pl/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/pt_BR/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/pt_BR/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/pt_BR/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/pt_BR/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/pt_BR/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/pt_BR/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/pt_BR/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/ru/LC_MESSAGES/postgres-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/sv/LC_MESSAGES/postgres-15.mo
/usr/pgsql-15/share/locale/tr/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/tr/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/tr/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/pg_checksums-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/pg_test_fsync-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/pg_waldump-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/uk/LC_MESSAGES/postgres-15.mo
/usr/pgsql-15/share/locale/vi/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/zh_CN/LC_MESSAGES/pg_archivecleanup-15.mo
/usr/pgsql-15/share/locale/zh_CN/LC_MESSAGES/pg_controldata-15.mo
/usr/pgsql-15/share/locale/zh_CN/LC_MESSAGES/pg_resetwal-15.mo
/usr/pgsql-15/share/locale/zh_CN/LC_MESSAGES/pg_rewind-15.mo
/usr/pgsql-15/share/locale/zh_CN/LC_MESSAGES/pg_test_timing-15.mo
/usr/pgsql-15/share/locale/zh_CN/LC_MESSAGES/pg_upgrade-15.mo
/usr/pgsql-15/share/locale/zh_CN/LC_MESSAGES/pg_verifybackup-15.mo
/usr/pgsql-15/share/locale/zh_CN/LC_MESSAGES/plpgsql-15.mo
/usr/pgsql-15/share/locale/zh_CN/LC_MESSAGES/postgres-15.mo
/usr/pgsql-15/share/man/man1/initdb.1
/usr/pgsql-15/share/man/man1/pg_archivecleanup.1
/usr/pgsql-15/share/man/man1/pg_checksums.1
/usr/pgsql-15/share/man/man1/pg_controldata.1
/usr/pgsql-15/share/man/man1/pg_ctl.1
/usr/pgsql-15/share/man/man1/pg_receivewal.1
/usr/pgsql-15/share/man/man1/pg_resetwal.1
/usr/pgsql-15/share/man/man1/pg_rewind.1
/usr/pgsql-15/share/man/man1/pg_test_fsync.1
/usr/pgsql-15/share/man/man1/pg_test_timing.1
/usr/pgsql-15/share/man/man1/pg_upgrade.1
/usr/pgsql-15/share/man/man1/pg_verifybackup.1
/usr/pgsql-15/share/man/man1/pg_waldump.1
/usr/pgsql-15/share/man/man1/postgres.1
/usr/pgsql-15/share/man/man1/postmaster.1
/usr/pgsql-15/share/pg_hba.conf.sample
/usr/pgsql-15/share/pg_ident.conf.sample
/usr/pgsql-15/share/pg_service.conf.sample
/usr/pgsql-15/share/postgres.bki
/usr/pgsql-15/share/postgresql.conf.sample
/usr/pgsql-15/share/psqlrc.sample
/usr/pgsql-15/share/snowball_create.sql
/usr/pgsql-15/share/sql_features.txt
/usr/pgsql-15/share/system_constraints.sql
/usr/pgsql-15/share/system_functions.sql
/usr/pgsql-15/share/system_views.sql
/usr/pgsql-15/share/timezonesets/Africa.txt
/usr/pgsql-15/share/timezonesets/America.txt
/usr/pgsql-15/share/timezonesets/Antarctica.txt
/usr/pgsql-15/share/timezonesets/Asia.txt
/usr/pgsql-15/share/timezonesets/Atlantic.txt
/usr/pgsql-15/share/timezonesets/Australia
/usr/pgsql-15/share/timezonesets/Australia.txt
/usr/pgsql-15/share/timezonesets/Default
/usr/pgsql-15/share/timezonesets/Etc.txt
/usr/pgsql-15/share/timezonesets/Europe.txt
/usr/pgsql-15/share/timezonesets/India
/usr/pgsql-15/share/timezonesets/Indian.txt
/usr/pgsql-15/share/timezonesets/Pacific.txt
/usr/pgsql-15/share/tsearch_data/danish.stop
/usr/pgsql-15/share/tsearch_data/dutch.stop
/usr/pgsql-15/share/tsearch_data/english.stop
/usr/pgsql-15/share/tsearch_data/finnish.stop
/usr/pgsql-15/share/tsearch_data/french.stop
/usr/pgsql-15/share/tsearch_data/german.stop
/usr/pgsql-15/share/tsearch_data/hungarian.stop
/usr/pgsql-15/share/tsearch_data/hunspell_sample.affix
/usr/pgsql-15/share/tsearch_data/hunspell_sample_long.affix
/usr/pgsql-15/share/tsearch_data/hunspell_sample_long.dict
/usr/pgsql-15/share/tsearch_data/hunspell_sample_num.affix
/usr/pgsql-15/share/tsearch_data/hunspell_sample_num.dict
/usr/pgsql-15/share/tsearch_data/ispell_sample.affix
/usr/pgsql-15/share/tsearch_data/ispell_sample.dict
/usr/pgsql-15/share/tsearch_data/italian.stop
/usr/pgsql-15/share/tsearch_data/nepali.stop
/usr/pgsql-15/share/tsearch_data/norwegian.stop
/usr/pgsql-15/share/tsearch_data/portuguese.stop
/usr/pgsql-15/share/tsearch_data/russian.stop
/usr/pgsql-15/share/tsearch_data/spanish.stop
/usr/pgsql-15/share/tsearch_data/swedish.stop
/usr/pgsql-15/share/tsearch_data/synonym_sample.syn
/usr/pgsql-15/share/tsearch_data/thesaurus_sample.ths
/usr/pgsql-15/share/tsearch_data/turkish.stop
/usr/pgsql-15/share/tsearch_data/unaccent.rules
/usr/pgsql-15/share/tsearch_data/xsyn_sample.rules
/var/lib/pgsql
/var/lib/pgsql/15
/var/lib/pgsql/15/backups
/var/lib/pgsql/15/data
/var/run/postgresql

三、确定postgresql数据库安装目录

• postgresql15数据库安装目录为/var/lib/pgsql/15

cd /var/lib/pgsql/15

ls
backups  data  initdb.log

cd data/

ls
base              log           pg_hba.conf    pg_multixact  pg_serial     pg_stat_tmp  pg_twophase  pg_xact               postmaster.opts
current_logfiles  pg_commit_ts  pg_ident.conf  pg_notify     pg_snapshots  pg_subtrans  PG_VERSION   postgresql.auto.conf  postmaster.pid
global            pg_dynshmem   pg_logical     pg_replslot   pg_stat       pg_tblspc    pg_wal       postgresql.conf