The databases/postgresql,-server port
postgresql-server-16.4p0 – PostgreSQL RDBMS (server) (cvsweb github mirror)
Description
PostgreSQL RDBMS server Additional programs and libraries required to run a PostgreSQL server.WWW: https://www.postgresql.org/
Readme
+----------------------------------------------------------------------- | Running ${PKGSTEM} on OpenBSD +----------------------------------------------------------------------- At least two different accounts are involved when working with PostgreSQL: One is an OpenBSD userid, '_postgresql', which is used as the userid of files that are part of PostgreSQL. The other, usually named 'postgres', is not an OpenBSD userid, i.e. you will not find it in /etc/passwd, but an account internal to the database system. The 'postgres' account is called the dba account (database administrator) and is created when a new database is initialized using the initdb command. If you are installing PostgreSQL for the first time, you have to create a default database first. In the following example we install a database in /var/postgresql/data with a dba account 'postgres' and scram-sha-256 authentication. We will be prompted for a password to protect the dba account: # su - _postgresql $ mkdir /var/postgresql/data $ initdb -D /var/postgresql/data -U postgres -A scram-sha-256 -E UTF8 -W It is strongly advised that you do not work with the postgres dba account other than creating more users and/or databases or for administrative tasks. Use the PostgreSQL permission system to make sure that a database is only accessed by programs/users that have the right to do so. Please consult the PostgreSQL website for more information, especially when you are upgrading an existing database installation. Network Connections =================== To allow connections over TCP (and other options) edit the file: /var/postgresql/data/postgresql.conf and also edit the pg_hba.conf (in the same directory) making the appropriate changes to allow connection from your network. To allow SSL connections, edit postgresql.conf and enable the 'ssl' keyword, and create keys and certificates: # su - _postgresql $ cd /var/postgresql/data $ umask 077 $ openssl genrsa -out server.key 2048 $ openssl req -new -key server.key -out server.csr Either take the CSR to a Certifying Authority (CA) to sign your certificate, or self-sign it: $ openssl x509 -req -days 365 -in server.csr \ -signkey server.key -out server.crt Restart PostgreSQL to allow these changes to take effect. Tuning for busy servers ======================= The default sizes in the GENERIC kernel for SysV semaphores are not large enough for PostgreSQL to use the default max_connections configuration value of 100, so PostgreSQL will use a smaller than default max_connections if you do not increase the limits. Adding the following in /etc/sysctl.conf will be reasonable for many systems: kern.seminfo.semmni=256 kern.seminfo.semmns=2048 You may also want to tune the max_connections value in the postgresql.conf file to increase the number of connections to the backend. By default, the _postgresql user, and so the postmaster and backend processes run in the login(1) class of "postgresql". On a busy server, it may be advisable to tune resources, such as more open file descriptors (used for network connections as well as files), possibly more memory, etc. The capability database file is located at /etc/login.conf.d/postgresql For more than about 250 connections, these numbers should be increased. Please report any changes and experiences to the package maintainers so that we can update this file for future versions. Upgrade Howto (for a major upgrade) =================================== If you didn't install PostgreSQL by following this README, you must adapt these instructions to your setup. Option 1: Dump and Restore -------------------------- This will work for any upgrade from any major version of PostgreSQL to the current version. 1) Backup all your data: # su _postgresql -c "cd /var/postgresql && \ pg_dumpall -U postgres > /var/postgresql/full.sqldump" 2) Shutdown the server: # rcctl stop postgresql 3) Upgrade your PostgreSQL package with pkg_add. # pkg_add -ui postgresql-server 4) Backup your old data directory and rename: # cd /var/postgresql && tar cf - data | gzip -1 > data.tar.gz # mv /var/postgresql/data /var/postgresql/data-${PREV_MAJOR} 5) Create a new data directory: # su _postgresql -c "mkdir /var/postgresql/data" # su _postgresql -c "cd /var/postgresql && \ initdb -D /var/postgresql/data -U postgres -A scram-sha-256 -E UTF8 -W" 6) Restore your old pg_hba.conf and (if used) SSL certificates # su _postgresql -c \ "cp /var/postgresql/data-${PREV_MAJOR}/pg_hba.conf /var/postgresql/data/" # su _postgresql -c \ "cp /var/postgresql/data-${PREV_MAJOR}/server.{crt,key} /var/postgresql/data/" Some postgresql.conf settings changed or disappeared in this version. Examine your old file for local changes and apply them to the new version (/var/postgresql/data/postgresql.conf). The following command may help identify them: # diff -wu ${LOCALBASE}/share/postgresql-${PREV_MAJOR}/postgresql.conf.sample \ /var/postgresql/data-${PREV_MAJOR}/postgresql.conf 7) Start PostgreSQL: # rcctl start postgresql 8) Restore your data: # su _postgresql -c "cd /var/postgresql && \ psql -U postgres < /var/postgresql/full.sqldump" Option 2: pg_upgrade -------------------- This will work for an upgrade from the previous major version of PostgreSQL supported by OpenBSD to the current version, and should be faster than a dump and reload, especially for large databases. 1) Shutdown the server: # rcctl stop postgresql 2) Upgrade your PostgreSQL package with pkg_add. # pkg_add postgresql-pg_upgrade 3) Backup your old data directory: # mv /var/postgresql/data /var/postgresql/data-${PREV_MAJOR} 4) Create a new data directory: # su _postgresql -c "mkdir /var/postgresql/data && cd /var/postgresql && \ initdb -D /var/postgresql/data -U postgres -A scram-sha-256 -E UTF8 -W" (The database environment defaults to UTF-8 if your terminal is already in a UTF-8 locale; if that is the case and you require an ASCII database environment, use "initdb --locale=C -D /var/postgresql/data [...]"). 5) Temporarily support connecting without a password for local users by editing pg_hba.conf to include "local all postgres trust" # vi /var/postgresql/data-${PREV_MAJOR}/pg_hba.conf 6) Restore your old pg_hba.conf and (if used) SSL certificates # cp -p /var/postgresql/data-${PREV_MAJOR}/pg_hba.conf /var/postgresql/data/ # cp -p /var/postgresql/data-${PREV_MAJOR}/server.{crt,key} /var/postgresql/data/ Some postgresql.conf settings changed or disappeared in this version. Examine your old file for local changes and apply them to the new version (/var/postgresql/data/postgresql.conf). The following command may help identify them: # diff -wu ${LOCALBASE}/share/postgresql-${PREV_MAJOR}/postgresql.conf.sample \ /var/postgresql/data-${PREV_MAJOR}/postgresql.conf 7) Run pg_upgrade: # su _postgresql -c "cd /var/postgresql && \ pg_upgrade -b /usr/local/bin/postgresql-${PREV_MAJOR}/ -B /usr/local/bin \ -U postgres -d /var/postgresql/data-${PREV_MAJOR}/ -D /var/postgresql/data" 8) Remove "local all postgres trust" line from pg_hba.conf # vi /var/postgresql/data/pg_hba.conf 9) Start PostgreSQL: # rcctl start postgresql Clients/Frontends ================= Many applications can use the PostgreSQL database right away. To facilitate administration of a PostgreSQL database, a client is notable: www/phppgadmin A web based user interface that uses PHP
Maintainer
Jeremy Evans
Multi-packages
postgresql-docs-16.4p0 postgresql-client-16.4p0 postgresql-server-16.4p0 postgresql-contrib-16.4p0 postgresql-pg_upgrade-16.4p0 postgresql-plpython-16.4p0
Categories
Library dependencies
Build dependencies
Test dependencies
Reverse dependencies
- databases/citus
- databases/kdb
- databases/kexi
- databases/libdbi-drivers
- databases/libpqxx
- databases/luadbi
- databases/p5-DBD-Pg
- databases/p5-DBIx-Class
- databases/p5-DBIx-Class-Schema-Loader
- databases/p5-Mojo-Pg
- databases/p5-SQL-Translator
- databases/patroni
- databases/pg_sqlite_fdw
- databases/pgpool
- databases/pgtap
- databases/postgresql
- databases/postgresql-ip4r
- databases/postgresql-pllua
- databases/postgresql-plr
- databases/py-peewee
- databases/py-psycopg2
- databases/py-pygresql
- databases/repmgr
- databases/tdbc-postgres
- databases/timescaledb
- geo/mapserver
- geo/osm2pgsql
- geo/pgpointcloud
- geo/pgrouting
- geo/postgis
- graphics/orthanc/postgresql-plugin
- net/kea
- net/nagios/check_postgres
- x11/kde-applications/akonadi
Files
- /etc/login.conf.d/postgresql
- /etc/rc.d/postgresql
- /usr/local/bin/initdb
- /usr/local/bin/pg_basebackup
- /usr/local/bin/pg_checksums
- /usr/local/bin/pg_controldata
- /usr/local/bin/pg_ctl
- /usr/local/bin/pg_isready
- /usr/local/bin/pg_receivewal
- /usr/local/bin/pg_recvlogical
- /usr/local/bin/pg_resetwal
- /usr/local/bin/pg_rewind
- /usr/local/bin/pg_verifybackup
- /usr/local/bin/pg_waldump
- /usr/local/bin/postgres
- /usr/local/include/postgresql/server/
- /usr/local/include/postgresql/server/access/
- /usr/local/include/postgresql/server/access/amapi.h
- /usr/local/include/postgresql/server/access/amvalidate.h
- /usr/local/include/postgresql/server/access/attmap.h
- /usr/local/include/postgresql/server/access/attnum.h
- /usr/local/include/postgresql/server/access/brin.h
- /usr/local/include/postgresql/server/access/brin_internal.h
- /usr/local/include/postgresql/server/access/brin_page.h
- /usr/local/include/postgresql/server/access/brin_pageops.h
- /usr/local/include/postgresql/server/access/brin_revmap.h
- /usr/local/include/postgresql/server/access/brin_tuple.h
- /usr/local/include/postgresql/server/access/brin_xlog.h
- /usr/local/include/postgresql/server/access/bufmask.h
- /usr/local/include/postgresql/server/access/clog.h
- /usr/local/include/postgresql/server/access/commit_ts.h
- /usr/local/include/postgresql/server/access/detoast.h
- /usr/local/include/postgresql/server/access/genam.h
- /usr/local/include/postgresql/server/access/generic_xlog.h
- /usr/local/include/postgresql/server/access/gin.h
- /usr/local/include/postgresql/server/access/gin_private.h
- /usr/local/include/postgresql/server/access/ginblock.h
- /usr/local/include/postgresql/server/access/ginxlog.h
- /usr/local/include/postgresql/server/access/gist.h
- /usr/local/include/postgresql/server/access/gist_private.h
- /usr/local/include/postgresql/server/access/gistscan.h
- /usr/local/include/postgresql/server/access/gistxlog.h
- /usr/local/include/postgresql/server/access/hash.h
- /usr/local/include/postgresql/server/access/hash_xlog.h
- /usr/local/include/postgresql/server/access/heapam.h
- /usr/local/include/postgresql/server/access/heapam_xlog.h
- /usr/local/include/postgresql/server/access/heaptoast.h
- /usr/local/include/postgresql/server/access/hio.h
- /usr/local/include/postgresql/server/access/htup.h
- /usr/local/include/postgresql/server/access/htup_details.h
- /usr/local/include/postgresql/server/access/itup.h
- /usr/local/include/postgresql/server/access/multixact.h
- /usr/local/include/postgresql/server/access/nbtree.h
- /usr/local/include/postgresql/server/access/nbtxlog.h
- /usr/local/include/postgresql/server/access/parallel.h
- /usr/local/include/postgresql/server/access/printsimple.h
- /usr/local/include/postgresql/server/access/printtup.h
- /usr/local/include/postgresql/server/access/relation.h
- /usr/local/include/postgresql/server/access/reloptions.h
- /usr/local/include/postgresql/server/access/relscan.h
- /usr/local/include/postgresql/server/access/rewriteheap.h
- /usr/local/include/postgresql/server/access/rmgr.h
- /usr/local/include/postgresql/server/access/rmgrdesc_utils.h
- /usr/local/include/postgresql/server/access/rmgrlist.h
- /usr/local/include/postgresql/server/access/sdir.h
- /usr/local/include/postgresql/server/access/session.h
- /usr/local/include/postgresql/server/access/skey.h
- /usr/local/include/postgresql/server/access/slru.h
- /usr/local/include/postgresql/server/access/spgist.h
- /usr/local/include/postgresql/server/access/spgist_private.h
- /usr/local/include/postgresql/server/access/spgxlog.h
- /usr/local/include/postgresql/server/access/stratnum.h
- /usr/local/include/postgresql/server/access/subtrans.h
- /usr/local/include/postgresql/server/access/syncscan.h
- /usr/local/include/postgresql/server/access/sysattr.h
- /usr/local/include/postgresql/server/access/table.h
- /usr/local/include/postgresql/server/access/tableam.h
- /usr/local/include/postgresql/server/access/timeline.h
- /usr/local/include/postgresql/server/access/toast_compression.h
- /usr/local/include/postgresql/server/access/toast_helper.h
- /usr/local/include/postgresql/server/access/toast_internals.h
- /usr/local/include/postgresql/server/access/transam.h
- /usr/local/include/postgresql/server/access/tsmapi.h
- /usr/local/include/postgresql/server/access/tupconvert.h
- /usr/local/include/postgresql/server/access/tupdesc.h
- /usr/local/include/postgresql/server/access/tupdesc_details.h
- /usr/local/include/postgresql/server/access/tupmacs.h
- /usr/local/include/postgresql/server/access/twophase.h
- /usr/local/include/postgresql/server/access/twophase_rmgr.h
- /usr/local/include/postgresql/server/access/valid.h
- /usr/local/include/postgresql/server/access/visibilitymap.h
- /usr/local/include/postgresql/server/access/visibilitymapdefs.h
- /usr/local/include/postgresql/server/access/xact.h
- /usr/local/include/postgresql/server/access/xlog.h
- /usr/local/include/postgresql/server/access/xlog_internal.h
- /usr/local/include/postgresql/server/access/xlogarchive.h
- /usr/local/include/postgresql/server/access/xlogbackup.h
- /usr/local/include/postgresql/server/access/xlogdefs.h
- /usr/local/include/postgresql/server/access/xloginsert.h
- /usr/local/include/postgresql/server/access/xlogprefetcher.h
- /usr/local/include/postgresql/server/access/xlogreader.h
- /usr/local/include/postgresql/server/access/xlogrecord.h
- /usr/local/include/postgresql/server/access/xlogrecovery.h
- /usr/local/include/postgresql/server/access/xlogstats.h
- /usr/local/include/postgresql/server/access/xlogutils.h
- /usr/local/include/postgresql/server/archive/
- /usr/local/include/postgresql/server/archive/archive_module.h
- /usr/local/include/postgresql/server/archive/shell_archive.h
- /usr/local/include/postgresql/server/bootstrap/
- /usr/local/include/postgresql/server/bootstrap/bootstrap.h
- /usr/local/include/postgresql/server/c.h
- /usr/local/include/postgresql/server/catalog/
- /usr/local/include/postgresql/server/catalog/binary_upgrade.h
- /usr/local/include/postgresql/server/catalog/catalog.h
- /usr/local/include/postgresql/server/catalog/catversion.h
- /usr/local/include/postgresql/server/catalog/dependency.h
- /usr/local/include/postgresql/server/catalog/genbki.h
- /usr/local/include/postgresql/server/catalog/heap.h
- /usr/local/include/postgresql/server/catalog/index.h
- /usr/local/include/postgresql/server/catalog/indexing.h
- /usr/local/include/postgresql/server/catalog/namespace.h
- /usr/local/include/postgresql/server/catalog/objectaccess.h
- /usr/local/include/postgresql/server/catalog/objectaddress.h
- /usr/local/include/postgresql/server/catalog/partition.h
- /usr/local/include/postgresql/server/catalog/pg_aggregate.h
- /usr/local/include/postgresql/server/catalog/pg_aggregate_d.h
- /usr/local/include/postgresql/server/catalog/pg_am.h
- /usr/local/include/postgresql/server/catalog/pg_am_d.h
- /usr/local/include/postgresql/server/catalog/pg_amop.h
- /usr/local/include/postgresql/server/catalog/pg_amop_d.h
- /usr/local/include/postgresql/server/catalog/pg_amproc.h
- /usr/local/include/postgresql/server/catalog/pg_amproc_d.h
- /usr/local/include/postgresql/server/catalog/pg_attrdef.h
- /usr/local/include/postgresql/server/catalog/pg_attrdef_d.h
- /usr/local/include/postgresql/server/catalog/pg_attribute.h
- /usr/local/include/postgresql/server/catalog/pg_attribute_d.h
- /usr/local/include/postgresql/server/catalog/pg_auth_members.h
- /usr/local/include/postgresql/server/catalog/pg_auth_members_d.h
- /usr/local/include/postgresql/server/catalog/pg_authid.h
- /usr/local/include/postgresql/server/catalog/pg_authid_d.h
- /usr/local/include/postgresql/server/catalog/pg_cast.h
- /usr/local/include/postgresql/server/catalog/pg_cast_d.h
- /usr/local/include/postgresql/server/catalog/pg_class.h
- /usr/local/include/postgresql/server/catalog/pg_class_d.h
- /usr/local/include/postgresql/server/catalog/pg_collation.h
- /usr/local/include/postgresql/server/catalog/pg_collation_d.h
- /usr/local/include/postgresql/server/catalog/pg_constraint.h
- /usr/local/include/postgresql/server/catalog/pg_constraint_d.h
- /usr/local/include/postgresql/server/catalog/pg_control.h
- /usr/local/include/postgresql/server/catalog/pg_conversion.h
- /usr/local/include/postgresql/server/catalog/pg_conversion_d.h
- /usr/local/include/postgresql/server/catalog/pg_database.h
- /usr/local/include/postgresql/server/catalog/pg_database_d.h
- /usr/local/include/postgresql/server/catalog/pg_db_role_setting.h
- /usr/local/include/postgresql/server/catalog/pg_db_role_setting_d.h
- /usr/local/include/postgresql/server/catalog/pg_default_acl.h
- /usr/local/include/postgresql/server/catalog/pg_default_acl_d.h
- /usr/local/include/postgresql/server/catalog/pg_depend.h
- /usr/local/include/postgresql/server/catalog/pg_depend_d.h
- /usr/local/include/postgresql/server/catalog/pg_description.h
- /usr/local/include/postgresql/server/catalog/pg_description_d.h
- /usr/local/include/postgresql/server/catalog/pg_enum.h
- /usr/local/include/postgresql/server/catalog/pg_enum_d.h
- /usr/local/include/postgresql/server/catalog/pg_event_trigger.h
- /usr/local/include/postgresql/server/catalog/pg_event_trigger_d.h
- /usr/local/include/postgresql/server/catalog/pg_extension.h
- /usr/local/include/postgresql/server/catalog/pg_extension_d.h
- /usr/local/include/postgresql/server/catalog/pg_foreign_data_wrapper.h
- /usr/local/include/postgresql/server/catalog/pg_foreign_data_wrapper_d.h
- /usr/local/include/postgresql/server/catalog/pg_foreign_server.h
- /usr/local/include/postgresql/server/catalog/pg_foreign_server_d.h
- /usr/local/include/postgresql/server/catalog/pg_foreign_table.h
- /usr/local/include/postgresql/server/catalog/pg_foreign_table_d.h
- /usr/local/include/postgresql/server/catalog/pg_index.h
- /usr/local/include/postgresql/server/catalog/pg_index_d.h
- /usr/local/include/postgresql/server/catalog/pg_inherits.h
- /usr/local/include/postgresql/server/catalog/pg_inherits_d.h
- /usr/local/include/postgresql/server/catalog/pg_init_privs.h
- /usr/local/include/postgresql/server/catalog/pg_init_privs_d.h
- /usr/local/include/postgresql/server/catalog/pg_language.h
- /usr/local/include/postgresql/server/catalog/pg_language_d.h
- /usr/local/include/postgresql/server/catalog/pg_largeobject.h
- /usr/local/include/postgresql/server/catalog/pg_largeobject_d.h
- /usr/local/include/postgresql/server/catalog/pg_largeobject_metadata.h
- /usr/local/include/postgresql/server/catalog/pg_largeobject_metadata_d.h
- /usr/local/include/postgresql/server/catalog/pg_namespace.h
- /usr/local/include/postgresql/server/catalog/pg_namespace_d.h
- /usr/local/include/postgresql/server/catalog/pg_opclass.h
- /usr/local/include/postgresql/server/catalog/pg_opclass_d.h
- /usr/local/include/postgresql/server/catalog/pg_operator.h
- /usr/local/include/postgresql/server/catalog/pg_operator_d.h
- /usr/local/include/postgresql/server/catalog/pg_opfamily.h
- /usr/local/include/postgresql/server/catalog/pg_opfamily_d.h
- /usr/local/include/postgresql/server/catalog/pg_parameter_acl.h
- /usr/local/include/postgresql/server/catalog/pg_parameter_acl_d.h
- /usr/local/include/postgresql/server/catalog/pg_partitioned_table.h
- /usr/local/include/postgresql/server/catalog/pg_partitioned_table_d.h
- /usr/local/include/postgresql/server/catalog/pg_policy.h
- /usr/local/include/postgresql/server/catalog/pg_policy_d.h
- /usr/local/include/postgresql/server/catalog/pg_proc.h
- /usr/local/include/postgresql/server/catalog/pg_proc_d.h
- /usr/local/include/postgresql/server/catalog/pg_publication.h
- /usr/local/include/postgresql/server/catalog/pg_publication_d.h
- /usr/local/include/postgresql/server/catalog/pg_publication_namespace.h
- /usr/local/include/postgresql/server/catalog/pg_publication_namespace_d.h
- /usr/local/include/postgresql/server/catalog/pg_publication_rel.h
- /usr/local/include/postgresql/server/catalog/pg_publication_rel_d.h
- /usr/local/include/postgresql/server/catalog/pg_range.h
- /usr/local/include/postgresql/server/catalog/pg_range_d.h
- /usr/local/include/postgresql/server/catalog/pg_replication_origin.h
- /usr/local/include/postgresql/server/catalog/pg_replication_origin_d.h
- /usr/local/include/postgresql/server/catalog/pg_rewrite.h
- /usr/local/include/postgresql/server/catalog/pg_rewrite_d.h
- /usr/local/include/postgresql/server/catalog/pg_seclabel.h
- /usr/local/include/postgresql/server/catalog/pg_seclabel_d.h
- /usr/local/include/postgresql/server/catalog/pg_sequence.h
- /usr/local/include/postgresql/server/catalog/pg_sequence_d.h
- /usr/local/include/postgresql/server/catalog/pg_shdepend.h
- /usr/local/include/postgresql/server/catalog/pg_shdepend_d.h
- /usr/local/include/postgresql/server/catalog/pg_shdescription.h
- /usr/local/include/postgresql/server/catalog/pg_shdescription_d.h
- /usr/local/include/postgresql/server/catalog/pg_shseclabel.h
- /usr/local/include/postgresql/server/catalog/pg_shseclabel_d.h
- /usr/local/include/postgresql/server/catalog/pg_statistic.h
- /usr/local/include/postgresql/server/catalog/pg_statistic_d.h
- /usr/local/include/postgresql/server/catalog/pg_statistic_ext.h
- /usr/local/include/postgresql/server/catalog/pg_statistic_ext_d.h
- /usr/local/include/postgresql/server/catalog/pg_statistic_ext_data.h
- /usr/local/include/postgresql/server/catalog/pg_statistic_ext_data_d.h
- /usr/local/include/postgresql/server/catalog/pg_subscription.h
- /usr/local/include/postgresql/server/catalog/pg_subscription_d.h
- /usr/local/include/postgresql/server/catalog/pg_subscription_rel.h
- /usr/local/include/postgresql/server/catalog/pg_subscription_rel_d.h
- /usr/local/include/postgresql/server/catalog/pg_tablespace.h
- /usr/local/include/postgresql/server/catalog/pg_tablespace_d.h
- /usr/local/include/postgresql/server/catalog/pg_transform.h
- /usr/local/include/postgresql/server/catalog/pg_transform_d.h
- /usr/local/include/postgresql/server/catalog/pg_trigger.h
- /usr/local/include/postgresql/server/catalog/pg_trigger_d.h
- /usr/local/include/postgresql/server/catalog/pg_ts_config.h
- /usr/local/include/postgresql/server/catalog/pg_ts_config_d.h
- /usr/local/include/postgresql/server/catalog/pg_ts_config_map.h
- /usr/local/include/postgresql/server/catalog/pg_ts_config_map_d.h
- /usr/local/include/postgresql/server/catalog/pg_ts_dict.h
- /usr/local/include/postgresql/server/catalog/pg_ts_dict_d.h
- /usr/local/include/postgresql/server/catalog/pg_ts_parser.h
- /usr/local/include/postgresql/server/catalog/pg_ts_parser_d.h
- /usr/local/include/postgresql/server/catalog/pg_ts_template.h
- /usr/local/include/postgresql/server/catalog/pg_ts_template_d.h
- /usr/local/include/postgresql/server/catalog/pg_type.h
- /usr/local/include/postgresql/server/catalog/pg_type_d.h
- /usr/local/include/postgresql/server/catalog/pg_user_mapping.h
- /usr/local/include/postgresql/server/catalog/pg_user_mapping_d.h
- /usr/local/include/postgresql/server/catalog/schemapg.h
- /usr/local/include/postgresql/server/catalog/storage.h
- /usr/local/include/postgresql/server/catalog/storage_xlog.h
- /usr/local/include/postgresql/server/catalog/system_fk_info.h
- /usr/local/include/postgresql/server/catalog/toasting.h
- /usr/local/include/postgresql/server/commands/
- /usr/local/include/postgresql/server/commands/alter.h
- /usr/local/include/postgresql/server/commands/async.h
- /usr/local/include/postgresql/server/commands/cluster.h
- /usr/local/include/postgresql/server/commands/collationcmds.h
- /usr/local/include/postgresql/server/commands/comment.h
- /usr/local/include/postgresql/server/commands/conversioncmds.h
- /usr/local/include/postgresql/server/commands/copy.h
- /usr/local/include/postgresql/server/commands/copyfrom_internal.h
- /usr/local/include/postgresql/server/commands/createas.h
- /usr/local/include/postgresql/server/commands/dbcommands.h
- /usr/local/include/postgresql/server/commands/dbcommands_xlog.h
- /usr/local/include/postgresql/server/commands/defrem.h
- /usr/local/include/postgresql/server/commands/discard.h
- /usr/local/include/postgresql/server/commands/event_trigger.h
- /usr/local/include/postgresql/server/commands/explain.h
- /usr/local/include/postgresql/server/commands/extension.h
- /usr/local/include/postgresql/server/commands/lockcmds.h
- /usr/local/include/postgresql/server/commands/matview.h
- /usr/local/include/postgresql/server/commands/policy.h
- /usr/local/include/postgresql/server/commands/portalcmds.h
- /usr/local/include/postgresql/server/commands/prepare.h
- /usr/local/include/postgresql/server/commands/proclang.h
- /usr/local/include/postgresql/server/commands/progress.h
- /usr/local/include/postgresql/server/commands/publicationcmds.h
- /usr/local/include/postgresql/server/commands/schemacmds.h
- /usr/local/include/postgresql/server/commands/seclabel.h
- /usr/local/include/postgresql/server/commands/sequence.h
- /usr/local/include/postgresql/server/commands/subscriptioncmds.h
- /usr/local/include/postgresql/server/commands/tablecmds.h
- /usr/local/include/postgresql/server/commands/tablespace.h
- /usr/local/include/postgresql/server/commands/trigger.h
- /usr/local/include/postgresql/server/commands/typecmds.h
- /usr/local/include/postgresql/server/commands/user.h
- /usr/local/include/postgresql/server/commands/vacuum.h
- /usr/local/include/postgresql/server/commands/view.h
- /usr/local/include/postgresql/server/common/
- /usr/local/include/postgresql/server/common/archive.h
- /usr/local/include/postgresql/server/common/base64.h
- /usr/local/include/postgresql/server/common/checksum_helper.h
- /usr/local/include/postgresql/server/common/compression.h
- /usr/local/include/postgresql/server/common/config_info.h
- /usr/local/include/postgresql/server/common/connect.h
- /usr/local/include/postgresql/server/common/controldata_utils.h
- /usr/local/include/postgresql/server/common/cryptohash.h
- /usr/local/include/postgresql/server/common/fe_memutils.h
- /usr/local/include/postgresql/server/common/file_perm.h
- /usr/local/include/postgresql/server/common/file_utils.h
- /usr/local/include/postgresql/server/common/hashfn.h
- /usr/local/include/postgresql/server/common/hmac.h
- /usr/local/include/postgresql/server/common/int.h
- /usr/local/include/postgresql/server/common/int128.h
- /usr/local/include/postgresql/server/common/ip.h
- /usr/local/include/postgresql/server/common/jsonapi.h
- /usr/local/include/postgresql/server/common/keywords.h
- /usr/local/include/postgresql/server/common/kwlookup.h
- /usr/local/include/postgresql/server/common/link-canary.h
- /usr/local/include/postgresql/server/common/logging.h
- /usr/local/include/postgresql/server/common/md5.h
- /usr/local/include/postgresql/server/common/openssl.h
- /usr/local/include/postgresql/server/common/percentrepl.h
- /usr/local/include/postgresql/server/common/pg_lzcompress.h
- /usr/local/include/postgresql/server/common/pg_prng.h
- /usr/local/include/postgresql/server/common/relpath.h
- /usr/local/include/postgresql/server/common/restricted_token.h
- /usr/local/include/postgresql/server/common/saslprep.h
- /usr/local/include/postgresql/server/common/scram-common.h
- /usr/local/include/postgresql/server/common/sha1.h
- /usr/local/include/postgresql/server/common/sha2.h
- /usr/local/include/postgresql/server/common/shortest_dec.h
- /usr/local/include/postgresql/server/common/string.h
- /usr/local/include/postgresql/server/common/unicode_east_asian_fw_table.h
- /usr/local/include/postgresql/server/common/unicode_nonspacing_table.h
- /usr/local/include/postgresql/server/common/unicode_norm.h
- /usr/local/include/postgresql/server/common/unicode_norm_hashfunc.h
- /usr/local/include/postgresql/server/common/unicode_norm_table.h
- /usr/local/include/postgresql/server/common/unicode_normprops_table.h
- /usr/local/include/postgresql/server/common/username.h
- /usr/local/include/postgresql/server/datatype/
- /usr/local/include/postgresql/server/datatype/timestamp.h
- /usr/local/include/postgresql/server/executor/
- /usr/local/include/postgresql/server/executor/execAsync.h
- /usr/local/include/postgresql/server/executor/execExpr.h
- /usr/local/include/postgresql/server/executor/execParallel.h
- /usr/local/include/postgresql/server/executor/execPartition.h
- /usr/local/include/postgresql/server/executor/execdebug.h
- /usr/local/include/postgresql/server/executor/execdesc.h
- /usr/local/include/postgresql/server/executor/executor.h
- /usr/local/include/postgresql/server/executor/functions.h
- /usr/local/include/postgresql/server/executor/hashjoin.h
- /usr/local/include/postgresql/server/executor/instrument.h
- /usr/local/include/postgresql/server/executor/nodeAgg.h
- /usr/local/include/postgresql/server/executor/nodeAppend.h
- /usr/local/include/postgresql/server/executor/nodeBitmapAnd.h
- /usr/local/include/postgresql/server/executor/nodeBitmapHeapscan.h
- /usr/local/include/postgresql/server/executor/nodeBitmapIndexscan.h
- /usr/local/include/postgresql/server/executor/nodeBitmapOr.h
- /usr/local/include/postgresql/server/executor/nodeCtescan.h
- /usr/local/include/postgresql/server/executor/nodeCustom.h
- /usr/local/include/postgresql/server/executor/nodeForeignscan.h
- /usr/local/include/postgresql/server/executor/nodeFunctionscan.h
- /usr/local/include/postgresql/server/executor/nodeGather.h
- /usr/local/include/postgresql/server/executor/nodeGatherMerge.h
- /usr/local/include/postgresql/server/executor/nodeGroup.h
- /usr/local/include/postgresql/server/executor/nodeHash.h
- /usr/local/include/postgresql/server/executor/nodeHashjoin.h
- /usr/local/include/postgresql/server/executor/nodeIncrementalSort.h
- /usr/local/include/postgresql/server/executor/nodeIndexonlyscan.h
- /usr/local/include/postgresql/server/executor/nodeIndexscan.h
- /usr/local/include/postgresql/server/executor/nodeLimit.h
- /usr/local/include/postgresql/server/executor/nodeLockRows.h
- /usr/local/include/postgresql/server/executor/nodeMaterial.h
- /usr/local/include/postgresql/server/executor/nodeMemoize.h
- /usr/local/include/postgresql/server/executor/nodeMergeAppend.h
- /usr/local/include/postgresql/server/executor/nodeMergejoin.h
- /usr/local/include/postgresql/server/executor/nodeModifyTable.h
- /usr/local/include/postgresql/server/executor/nodeNamedtuplestorescan.h
- /usr/local/include/postgresql/server/executor/nodeNestloop.h
- /usr/local/include/postgresql/server/executor/nodeProjectSet.h
- /usr/local/include/postgresql/server/executor/nodeRecursiveunion.h
- /usr/local/include/postgresql/server/executor/nodeResult.h
- /usr/local/include/postgresql/server/executor/nodeSamplescan.h
- /usr/local/include/postgresql/server/executor/nodeSeqscan.h
- /usr/local/include/postgresql/server/executor/nodeSetOp.h
- /usr/local/include/postgresql/server/executor/nodeSort.h
- /usr/local/include/postgresql/server/executor/nodeSubplan.h
- /usr/local/include/postgresql/server/executor/nodeSubqueryscan.h
- /usr/local/include/postgresql/server/executor/nodeTableFuncscan.h
- /usr/local/include/postgresql/server/executor/nodeTidrangescan.h
- /usr/local/include/postgresql/server/executor/nodeTidscan.h
- /usr/local/include/postgresql/server/executor/nodeUnique.h
- /usr/local/include/postgresql/server/executor/nodeValuesscan.h
- /usr/local/include/postgresql/server/executor/nodeWindowAgg.h
- /usr/local/include/postgresql/server/executor/nodeWorktablescan.h
- /usr/local/include/postgresql/server/executor/spi.h
- /usr/local/include/postgresql/server/executor/spi_priv.h
- /usr/local/include/postgresql/server/executor/tablefunc.h
- /usr/local/include/postgresql/server/executor/tqueue.h
- /usr/local/include/postgresql/server/executor/tstoreReceiver.h
- /usr/local/include/postgresql/server/executor/tuptable.h
- /usr/local/include/postgresql/server/extension/
- /usr/local/include/postgresql/server/extension/cube/
- /usr/local/include/postgresql/server/extension/cube/cubedata.h
- /usr/local/include/postgresql/server/extension/hstore/
- /usr/local/include/postgresql/server/extension/hstore/hstore.h
- /usr/local/include/postgresql/server/extension/isn/
- /usr/local/include/postgresql/server/extension/isn/isn.h
- /usr/local/include/postgresql/server/extension/ltree/
- /usr/local/include/postgresql/server/extension/ltree/ltree.h
- /usr/local/include/postgresql/server/extension/seg/
- /usr/local/include/postgresql/server/extension/seg/segdata.h
- /usr/local/include/postgresql/server/fe_utils/
- /usr/local/include/postgresql/server/fe_utils/archive.h
- /usr/local/include/postgresql/server/fe_utils/cancel.h
- /usr/local/include/postgresql/server/fe_utils/conditional.h
- /usr/local/include/postgresql/server/fe_utils/connect_utils.h
- /usr/local/include/postgresql/server/fe_utils/mbprint.h
- /usr/local/include/postgresql/server/fe_utils/option_utils.h
- /usr/local/include/postgresql/server/fe_utils/parallel_slot.h
- /usr/local/include/postgresql/server/fe_utils/print.h
- /usr/local/include/postgresql/server/fe_utils/psqlscan.h
- /usr/local/include/postgresql/server/fe_utils/psqlscan_int.h
- /usr/local/include/postgresql/server/fe_utils/query_utils.h
- /usr/local/include/postgresql/server/fe_utils/recovery_gen.h
- /usr/local/include/postgresql/server/fe_utils/simple_list.h
- /usr/local/include/postgresql/server/fe_utils/string_utils.h
- /usr/local/include/postgresql/server/fmgr.h
- /usr/local/include/postgresql/server/foreign/
- /usr/local/include/postgresql/server/foreign/fdwapi.h
- /usr/local/include/postgresql/server/foreign/foreign.h
- /usr/local/include/postgresql/server/funcapi.h
- /usr/local/include/postgresql/server/getopt_long.h
- /usr/local/include/postgresql/server/jit/
- /usr/local/include/postgresql/server/jit/jit.h
- /usr/local/include/postgresql/server/jit/llvmjit.h
- /usr/local/include/postgresql/server/jit/llvmjit_emit.h
- /usr/local/include/postgresql/server/lib/
- /usr/local/include/postgresql/server/lib/binaryheap.h
- /usr/local/include/postgresql/server/lib/bipartite_match.h
- /usr/local/include/postgresql/server/lib/bloomfilter.h
- /usr/local/include/postgresql/server/lib/dshash.h
- /usr/local/include/postgresql/server/lib/hyperloglog.h
- /usr/local/include/postgresql/server/lib/ilist.h
- /usr/local/include/postgresql/server/lib/integerset.h
- /usr/local/include/postgresql/server/lib/knapsack.h
- /usr/local/include/postgresql/server/lib/pairingheap.h
- /usr/local/include/postgresql/server/lib/qunique.h
- /usr/local/include/postgresql/server/lib/rbtree.h
- /usr/local/include/postgresql/server/lib/simplehash.h
- /usr/local/include/postgresql/server/lib/sort_template.h
- /usr/local/include/postgresql/server/lib/stringinfo.h
- /usr/local/include/postgresql/server/libpq/
- /usr/local/include/postgresql/server/libpq/auth.h
- /usr/local/include/postgresql/server/libpq/be-fsstubs.h
- /usr/local/include/postgresql/server/libpq/be-gssapi-common.h
- /usr/local/include/postgresql/server/libpq/crypt.h
- /usr/local/include/postgresql/server/libpq/hba.h
- /usr/local/include/postgresql/server/libpq/ifaddr.h
- /usr/local/include/postgresql/server/libpq/libpq-be-fe-helpers.h
- /usr/local/include/postgresql/server/libpq/libpq-be.h
- /usr/local/include/postgresql/server/libpq/libpq-fs.h
- /usr/local/include/postgresql/server/libpq/libpq.h
- /usr/local/include/postgresql/server/libpq/pqcomm.h
- /usr/local/include/postgresql/server/libpq/pqformat.h
- /usr/local/include/postgresql/server/libpq/pqmq.h
- /usr/local/include/postgresql/server/libpq/pqsignal.h
- /usr/local/include/postgresql/server/libpq/sasl.h
- /usr/local/include/postgresql/server/libpq/scram.h
- /usr/local/include/postgresql/server/mb/
- /usr/local/include/postgresql/server/mb/pg_wchar.h
- /usr/local/include/postgresql/server/mb/stringinfo_mb.h
- /usr/local/include/postgresql/server/miscadmin.h
- /usr/local/include/postgresql/server/nodes/
- /usr/local/include/postgresql/server/nodes/bitmapset.h
- /usr/local/include/postgresql/server/nodes/execnodes.h
- /usr/local/include/postgresql/server/nodes/extensible.h
- /usr/local/include/postgresql/server/nodes/lockoptions.h
- /usr/local/include/postgresql/server/nodes/makefuncs.h
- /usr/local/include/postgresql/server/nodes/memnodes.h
- /usr/local/include/postgresql/server/nodes/miscnodes.h
- /usr/local/include/postgresql/server/nodes/multibitmapset.h
- /usr/local/include/postgresql/server/nodes/nodeFuncs.h
- /usr/local/include/postgresql/server/nodes/nodes.h
- /usr/local/include/postgresql/server/nodes/nodetags.h
- /usr/local/include/postgresql/server/nodes/params.h
- /usr/local/include/postgresql/server/nodes/parsenodes.h
- /usr/local/include/postgresql/server/nodes/pathnodes.h
- /usr/local/include/postgresql/server/nodes/pg_list.h
- /usr/local/include/postgresql/server/nodes/plannodes.h
- /usr/local/include/postgresql/server/nodes/primnodes.h
- /usr/local/include/postgresql/server/nodes/print.h
- /usr/local/include/postgresql/server/nodes/queryjumble.h
- /usr/local/include/postgresql/server/nodes/readfuncs.h
- /usr/local/include/postgresql/server/nodes/replnodes.h
- /usr/local/include/postgresql/server/nodes/subscripting.h
- /usr/local/include/postgresql/server/nodes/supportnodes.h
- /usr/local/include/postgresql/server/nodes/tidbitmap.h
- /usr/local/include/postgresql/server/nodes/value.h
- /usr/local/include/postgresql/server/optimizer/
- /usr/local/include/postgresql/server/optimizer/appendinfo.h
- /usr/local/include/postgresql/server/optimizer/clauses.h
- /usr/local/include/postgresql/server/optimizer/cost.h
- /usr/local/include/postgresql/server/optimizer/geqo.h
- /usr/local/include/postgresql/server/optimizer/geqo_copy.h
- /usr/local/include/postgresql/server/optimizer/geqo_gene.h
- /usr/local/include/postgresql/server/optimizer/geqo_misc.h
- /usr/local/include/postgresql/server/optimizer/geqo_mutation.h
- /usr/local/include/postgresql/server/optimizer/geqo_pool.h
- /usr/local/include/postgresql/server/optimizer/geqo_random.h
- /usr/local/include/postgresql/server/optimizer/geqo_recombination.h
- /usr/local/include/postgresql/server/optimizer/geqo_selection.h
- /usr/local/include/postgresql/server/optimizer/inherit.h
- /usr/local/include/postgresql/server/optimizer/joininfo.h
- /usr/local/include/postgresql/server/optimizer/optimizer.h
- /usr/local/include/postgresql/server/optimizer/orclauses.h
- /usr/local/include/postgresql/server/optimizer/paramassign.h
- /usr/local/include/postgresql/server/optimizer/pathnode.h
- /usr/local/include/postgresql/server/optimizer/paths.h
- /usr/local/include/postgresql/server/optimizer/placeholder.h
- /usr/local/include/postgresql/server/optimizer/plancat.h
- /usr/local/include/postgresql/server/optimizer/planmain.h
- /usr/local/include/postgresql/server/optimizer/planner.h
- /usr/local/include/postgresql/server/optimizer/prep.h
- /usr/local/include/postgresql/server/optimizer/restrictinfo.h
- /usr/local/include/postgresql/server/optimizer/subselect.h
- /usr/local/include/postgresql/server/optimizer/tlist.h
- /usr/local/include/postgresql/server/parser/
- /usr/local/include/postgresql/server/parser/analyze.h
- /usr/local/include/postgresql/server/parser/kwlist.h
- /usr/local/include/postgresql/server/parser/parse_agg.h
- /usr/local/include/postgresql/server/parser/parse_clause.h
- /usr/local/include/postgresql/server/parser/parse_coerce.h
- /usr/local/include/postgresql/server/parser/parse_collate.h
- /usr/local/include/postgresql/server/parser/parse_cte.h
- /usr/local/include/postgresql/server/parser/parse_enr.h
- /usr/local/include/postgresql/server/parser/parse_expr.h
- /usr/local/include/postgresql/server/parser/parse_func.h
- /usr/local/include/postgresql/server/parser/parse_merge.h
- /usr/local/include/postgresql/server/parser/parse_node.h
- /usr/local/include/postgresql/server/parser/parse_oper.h
- /usr/local/include/postgresql/server/parser/parse_param.h
- /usr/local/include/postgresql/server/parser/parse_relation.h
- /usr/local/include/postgresql/server/parser/parse_target.h
- /usr/local/include/postgresql/server/parser/parse_type.h
- /usr/local/include/postgresql/server/parser/parse_utilcmd.h
- /usr/local/include/postgresql/server/parser/parser.h
- /usr/local/include/postgresql/server/parser/parsetree.h
- /usr/local/include/postgresql/server/parser/scanner.h
- /usr/local/include/postgresql/server/parser/scansup.h
- /usr/local/include/postgresql/server/partitioning/
- /usr/local/include/postgresql/server/partitioning/partbounds.h
- /usr/local/include/postgresql/server/partitioning/partdefs.h
- /usr/local/include/postgresql/server/partitioning/partdesc.h
- /usr/local/include/postgresql/server/partitioning/partprune.h
- /usr/local/include/postgresql/server/pg_config.h
- /usr/local/include/postgresql/server/pg_config_ext.h
- /usr/local/include/postgresql/server/pg_config_manual.h
- /usr/local/include/postgresql/server/pg_config_os.h
- /usr/local/include/postgresql/server/pg_getopt.h
- /usr/local/include/postgresql/server/pg_trace.h
- /usr/local/include/postgresql/server/pgstat.h
- /usr/local/include/postgresql/server/pgtar.h
- /usr/local/include/postgresql/server/pgtime.h
- /usr/local/include/postgresql/server/plperl.h
- /usr/local/include/postgresql/server/plperl_system.h
- /usr/local/include/postgresql/server/plpgsql.h
- /usr/local/include/postgresql/server/plpy_cursorobject.h
- /usr/local/include/postgresql/server/plpy_elog.h
- /usr/local/include/postgresql/server/plpy_exec.h
- /usr/local/include/postgresql/server/plpy_main.h
- /usr/local/include/postgresql/server/plpy_planobject.h
- /usr/local/include/postgresql/server/plpy_plpymodule.h
- /usr/local/include/postgresql/server/plpy_procedure.h
- /usr/local/include/postgresql/server/plpy_resultobject.h
- /usr/local/include/postgresql/server/plpy_spi.h
- /usr/local/include/postgresql/server/plpy_subxactobject.h
- /usr/local/include/postgresql/server/plpy_typeio.h
- /usr/local/include/postgresql/server/plpython_system.h
- /usr/local/include/postgresql/server/port.h
- /usr/local/include/postgresql/server/port/
- /usr/local/include/postgresql/server/port/aix.h
- /usr/local/include/postgresql/server/port/atomics.h
- /usr/local/include/postgresql/server/port/atomics/
- /usr/local/include/postgresql/server/port/atomics/arch-arm.h
- /usr/local/include/postgresql/server/port/atomics/arch-hppa.h
- /usr/local/include/postgresql/server/port/atomics/arch-ppc.h
- /usr/local/include/postgresql/server/port/atomics/arch-x86.h
- /usr/local/include/postgresql/server/port/atomics/fallback.h
- /usr/local/include/postgresql/server/port/atomics/generic-gcc.h
- /usr/local/include/postgresql/server/port/atomics/generic-msvc.h
- /usr/local/include/postgresql/server/port/atomics/generic-sunpro.h
- /usr/local/include/postgresql/server/port/atomics/generic.h
- /usr/local/include/postgresql/server/port/cygwin.h
- /usr/local/include/postgresql/server/port/darwin.h
- /usr/local/include/postgresql/server/port/freebsd.h
- /usr/local/include/postgresql/server/port/linux.h
- /usr/local/include/postgresql/server/port/netbsd.h
- /usr/local/include/postgresql/server/port/openbsd.h
- /usr/local/include/postgresql/server/port/pg_bitutils.h
- /usr/local/include/postgresql/server/port/pg_bswap.h
- /usr/local/include/postgresql/server/port/pg_crc32c.h
- /usr/local/include/postgresql/server/port/pg_iovec.h
- /usr/local/include/postgresql/server/port/pg_lfind.h
- /usr/local/include/postgresql/server/port/pg_pthread.h
- /usr/local/include/postgresql/server/port/simd.h
- /usr/local/include/postgresql/server/port/solaris.h
- /usr/local/include/postgresql/server/port/win32ntdll.h
- /usr/local/include/postgresql/server/portability/
- /usr/local/include/postgresql/server/portability/instr_time.h
- /usr/local/include/postgresql/server/portability/mem.h
- /usr/local/include/postgresql/server/postgres.h
- /usr/local/include/postgresql/server/postgres_ext.h
- /usr/local/include/postgresql/server/postgres_fe.h
- /usr/local/include/postgresql/server/postmaster/
- /usr/local/include/postgresql/server/postmaster/autovacuum.h
- /usr/local/include/postgresql/server/postmaster/auxprocess.h
- /usr/local/include/postgresql/server/postmaster/bgworker.h
- /usr/local/include/postgresql/server/postmaster/bgworker_internals.h
- /usr/local/include/postgresql/server/postmaster/bgwriter.h
- /usr/local/include/postgresql/server/postmaster/fork_process.h
- /usr/local/include/postgresql/server/postmaster/interrupt.h
- /usr/local/include/postgresql/server/postmaster/pgarch.h
- /usr/local/include/postgresql/server/postmaster/postmaster.h
- /usr/local/include/postgresql/server/postmaster/startup.h
- /usr/local/include/postgresql/server/postmaster/syslogger.h
- /usr/local/include/postgresql/server/postmaster/walwriter.h
- /usr/local/include/postgresql/server/ppport.h
- /usr/local/include/postgresql/server/regex/
- /usr/local/include/postgresql/server/regex/regcustom.h
- /usr/local/include/postgresql/server/regex/regerrs.h
- /usr/local/include/postgresql/server/regex/regex.h
- /usr/local/include/postgresql/server/regex/regexport.h
- /usr/local/include/postgresql/server/regex/regguts.h
- /usr/local/include/postgresql/server/replication/
- /usr/local/include/postgresql/server/replication/decode.h
- /usr/local/include/postgresql/server/replication/logical.h
- /usr/local/include/postgresql/server/replication/logicallauncher.h
- /usr/local/include/postgresql/server/replication/logicalproto.h
- /usr/local/include/postgresql/server/replication/logicalrelation.h
- /usr/local/include/postgresql/server/replication/logicalworker.h
- /usr/local/include/postgresql/server/replication/message.h
- /usr/local/include/postgresql/server/replication/origin.h
- /usr/local/include/postgresql/server/replication/output_plugin.h
- /usr/local/include/postgresql/server/replication/pgoutput.h
- /usr/local/include/postgresql/server/replication/reorderbuffer.h
- /usr/local/include/postgresql/server/replication/slot.h
- /usr/local/include/postgresql/server/replication/snapbuild.h
- /usr/local/include/postgresql/server/replication/syncrep.h
- /usr/local/include/postgresql/server/replication/walreceiver.h
- /usr/local/include/postgresql/server/replication/walsender.h
- /usr/local/include/postgresql/server/replication/walsender_private.h
- /usr/local/include/postgresql/server/replication/worker_internal.h
- /usr/local/include/postgresql/server/rewrite/
- /usr/local/include/postgresql/server/rewrite/prs2lock.h
- /usr/local/include/postgresql/server/rewrite/rewriteDefine.h
- /usr/local/include/postgresql/server/rewrite/rewriteHandler.h
- /usr/local/include/postgresql/server/rewrite/rewriteManip.h
- /usr/local/include/postgresql/server/rewrite/rewriteRemove.h
- /usr/local/include/postgresql/server/rewrite/rewriteSearchCycle.h
- /usr/local/include/postgresql/server/rewrite/rewriteSupport.h
- /usr/local/include/postgresql/server/rewrite/rowsecurity.h
- /usr/local/include/postgresql/server/snowball/
- /usr/local/include/postgresql/server/snowball/header.h
- /usr/local/include/postgresql/server/snowball/libstemmer/
- /usr/local/include/postgresql/server/snowball/libstemmer/api.h
- /usr/local/include/postgresql/server/snowball/libstemmer/header.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_basque.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_catalan.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_danish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_dutch.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_english.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_finnish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_french.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_german.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_indonesian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_irish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_italian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_norwegian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_porter.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_portuguese.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_spanish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_swedish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_2_hungarian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_ISO_8859_2_romanian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_KOI8_R_russian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_arabic.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_armenian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_basque.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_catalan.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_danish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_dutch.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_english.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_finnish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_french.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_german.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_greek.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_hindi.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_hungarian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_indonesian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_irish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_italian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_lithuanian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_nepali.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_norwegian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_porter.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_portuguese.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_romanian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_russian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_serbian.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_spanish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_swedish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_tamil.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_turkish.h
- /usr/local/include/postgresql/server/snowball/libstemmer/stem_UTF_8_yiddish.h
- /usr/local/include/postgresql/server/statistics/
- /usr/local/include/postgresql/server/statistics/extended_stats_internal.h
- /usr/local/include/postgresql/server/statistics/statistics.h
- /usr/local/include/postgresql/server/storage/
- /usr/local/include/postgresql/server/storage/backendid.h
- /usr/local/include/postgresql/server/storage/barrier.h
- /usr/local/include/postgresql/server/storage/block.h
- /usr/local/include/postgresql/server/storage/buf.h
- /usr/local/include/postgresql/server/storage/buf_internals.h
- /usr/local/include/postgresql/server/storage/buffile.h
- /usr/local/include/postgresql/server/storage/bufmgr.h
- /usr/local/include/postgresql/server/storage/bufpage.h
- /usr/local/include/postgresql/server/storage/checksum.h
- /usr/local/include/postgresql/server/storage/checksum_impl.h
- /usr/local/include/postgresql/server/storage/condition_variable.h
- /usr/local/include/postgresql/server/storage/copydir.h
- /usr/local/include/postgresql/server/storage/dsm.h
- /usr/local/include/postgresql/server/storage/dsm_impl.h
- /usr/local/include/postgresql/server/storage/fd.h
- /usr/local/include/postgresql/server/storage/fileset.h
- /usr/local/include/postgresql/server/storage/freespace.h
- /usr/local/include/postgresql/server/storage/fsm_internals.h
- /usr/local/include/postgresql/server/storage/indexfsm.h
- /usr/local/include/postgresql/server/storage/ipc.h
- /usr/local/include/postgresql/server/storage/item.h
- /usr/local/include/postgresql/server/storage/itemid.h
- /usr/local/include/postgresql/server/storage/itemptr.h
- /usr/local/include/postgresql/server/storage/large_object.h
- /usr/local/include/postgresql/server/storage/latch.h
- /usr/local/include/postgresql/server/storage/lmgr.h
- /usr/local/include/postgresql/server/storage/lock.h
- /usr/local/include/postgresql/server/storage/lockdefs.h
- /usr/local/include/postgresql/server/storage/lwlock.h
- /usr/local/include/postgresql/server/storage/lwlocknames.h
- /usr/local/include/postgresql/server/storage/md.h
- /usr/local/include/postgresql/server/storage/off.h
- /usr/local/include/postgresql/server/storage/pg_sema.h
- /usr/local/include/postgresql/server/storage/pg_shmem.h
- /usr/local/include/postgresql/server/storage/pmsignal.h
- /usr/local/include/postgresql/server/storage/predicate.h
- /usr/local/include/postgresql/server/storage/predicate_internals.h
- /usr/local/include/postgresql/server/storage/proc.h
- /usr/local/include/postgresql/server/storage/procarray.h
- /usr/local/include/postgresql/server/storage/proclist.h
- /usr/local/include/postgresql/server/storage/proclist_types.h
- /usr/local/include/postgresql/server/storage/procsignal.h
- /usr/local/include/postgresql/server/storage/reinit.h
- /usr/local/include/postgresql/server/storage/relfilelocator.h
- /usr/local/include/postgresql/server/storage/s_lock.h
- /usr/local/include/postgresql/server/storage/sharedfileset.h
- /usr/local/include/postgresql/server/storage/shm_mq.h
- /usr/local/include/postgresql/server/storage/shm_toc.h
- /usr/local/include/postgresql/server/storage/shmem.h
- /usr/local/include/postgresql/server/storage/sinval.h
- /usr/local/include/postgresql/server/storage/sinvaladt.h
- /usr/local/include/postgresql/server/storage/smgr.h
- /usr/local/include/postgresql/server/storage/spin.h
- /usr/local/include/postgresql/server/storage/standby.h
- /usr/local/include/postgresql/server/storage/standbydefs.h
- /usr/local/include/postgresql/server/storage/sync.h
- /usr/local/include/postgresql/server/tcop/
- /usr/local/include/postgresql/server/tcop/cmdtag.h
- /usr/local/include/postgresql/server/tcop/cmdtaglist.h
- /usr/local/include/postgresql/server/tcop/deparse_utility.h
- /usr/local/include/postgresql/server/tcop/dest.h
- /usr/local/include/postgresql/server/tcop/fastpath.h
- /usr/local/include/postgresql/server/tcop/pquery.h
- /usr/local/include/postgresql/server/tcop/tcopprot.h
- /usr/local/include/postgresql/server/tcop/utility.h
- /usr/local/include/postgresql/server/tsearch/
- /usr/local/include/postgresql/server/tsearch/dicts/
- /usr/local/include/postgresql/server/tsearch/dicts/regis.h
- /usr/local/include/postgresql/server/tsearch/dicts/spell.h
- /usr/local/include/postgresql/server/tsearch/ts_cache.h
- /usr/local/include/postgresql/server/tsearch/ts_locale.h
- /usr/local/include/postgresql/server/tsearch/ts_public.h
- /usr/local/include/postgresql/server/tsearch/ts_type.h
- /usr/local/include/postgresql/server/tsearch/ts_utils.h
- /usr/local/include/postgresql/server/utils/
- /usr/local/include/postgresql/server/utils/acl.h
- /usr/local/include/postgresql/server/utils/aclchk_internal.h
- /usr/local/include/postgresql/server/utils/array.h
- /usr/local/include/postgresql/server/utils/arrayaccess.h
- /usr/local/include/postgresql/server/utils/ascii.h
- /usr/local/include/postgresql/server/utils/attoptcache.h
- /usr/local/include/postgresql/server/utils/backend_progress.h
- /usr/local/include/postgresql/server/utils/backend_status.h
- /usr/local/include/postgresql/server/utils/builtins.h
- /usr/local/include/postgresql/server/utils/bytea.h
- /usr/local/include/postgresql/server/utils/cash.h
- /usr/local/include/postgresql/server/utils/catcache.h
- /usr/local/include/postgresql/server/utils/combocid.h
- /usr/local/include/postgresql/server/utils/conffiles.h
- /usr/local/include/postgresql/server/utils/date.h
- /usr/local/include/postgresql/server/utils/datetime.h
- /usr/local/include/postgresql/server/utils/datum.h
- /usr/local/include/postgresql/server/utils/dsa.h
- /usr/local/include/postgresql/server/utils/dynahash.h
- /usr/local/include/postgresql/server/utils/elog.h
- /usr/local/include/postgresql/server/utils/errcodes.h
- /usr/local/include/postgresql/server/utils/evtcache.h
- /usr/local/include/postgresql/server/utils/expandeddatum.h
- /usr/local/include/postgresql/server/utils/expandedrecord.h
- /usr/local/include/postgresql/server/utils/float.h
- /usr/local/include/postgresql/server/utils/fmgroids.h
- /usr/local/include/postgresql/server/utils/fmgrprotos.h
- /usr/local/include/postgresql/server/utils/fmgrtab.h
- /usr/local/include/postgresql/server/utils/formatting.h
- /usr/local/include/postgresql/server/utils/freepage.h
- /usr/local/include/postgresql/server/utils/geo_decls.h
- /usr/local/include/postgresql/server/utils/guc.h
- /usr/local/include/postgresql/server/utils/guc_hooks.h
- /usr/local/include/postgresql/server/utils/guc_tables.h
- /usr/local/include/postgresql/server/utils/help_config.h
- /usr/local/include/postgresql/server/utils/hsearch.h
- /usr/local/include/postgresql/server/utils/index_selfuncs.h
- /usr/local/include/postgresql/server/utils/inet.h
- /usr/local/include/postgresql/server/utils/inval.h
- /usr/local/include/postgresql/server/utils/json.h
- /usr/local/include/postgresql/server/utils/jsonb.h
- /usr/local/include/postgresql/server/utils/jsonfuncs.h
- /usr/local/include/postgresql/server/utils/jsonpath.h
- /usr/local/include/postgresql/server/utils/logtape.h
- /usr/local/include/postgresql/server/utils/lsyscache.h
- /usr/local/include/postgresql/server/utils/memdebug.h
- /usr/local/include/postgresql/server/utils/memutils.h
- /usr/local/include/postgresql/server/utils/memutils_internal.h
- /usr/local/include/postgresql/server/utils/memutils_memorychunk.h
- /usr/local/include/postgresql/server/utils/multirangetypes.h
- /usr/local/include/postgresql/server/utils/numeric.h
- /usr/local/include/postgresql/server/utils/old_snapshot.h
- /usr/local/include/postgresql/server/utils/palloc.h
- /usr/local/include/postgresql/server/utils/partcache.h
- /usr/local/include/postgresql/server/utils/pg_crc.h
- /usr/local/include/postgresql/server/utils/pg_locale.h
- /usr/local/include/postgresql/server/utils/pg_lsn.h
- /usr/local/include/postgresql/server/utils/pg_rusage.h
- /usr/local/include/postgresql/server/utils/pgstat_internal.h
- /usr/local/include/postgresql/server/utils/pidfile.h
- /usr/local/include/postgresql/server/utils/plancache.h
- /usr/local/include/postgresql/server/utils/portal.h
- /usr/local/include/postgresql/server/utils/probes.h
- /usr/local/include/postgresql/server/utils/ps_status.h
- /usr/local/include/postgresql/server/utils/queryenvironment.h
- /usr/local/include/postgresql/server/utils/rangetypes.h
- /usr/local/include/postgresql/server/utils/regproc.h
- /usr/local/include/postgresql/server/utils/rel.h
- /usr/local/include/postgresql/server/utils/relcache.h
- /usr/local/include/postgresql/server/utils/relfilenumbermap.h
- /usr/local/include/postgresql/server/utils/relmapper.h
- /usr/local/include/postgresql/server/utils/relptr.h
- /usr/local/include/postgresql/server/utils/reltrigger.h
- /usr/local/include/postgresql/server/utils/resowner.h
- /usr/local/include/postgresql/server/utils/resowner_private.h
- /usr/local/include/postgresql/server/utils/rls.h
- /usr/local/include/postgresql/server/utils/ruleutils.h
- /usr/local/include/postgresql/server/utils/sampling.h
- /usr/local/include/postgresql/server/utils/selfuncs.h
- /usr/local/include/postgresql/server/utils/sharedtuplestore.h
- /usr/local/include/postgresql/server/utils/snapmgr.h
- /usr/local/include/postgresql/server/utils/snapshot.h
- /usr/local/include/postgresql/server/utils/sortsupport.h
- /usr/local/include/postgresql/server/utils/spccache.h
- /usr/local/include/postgresql/server/utils/syscache.h
- /usr/local/include/postgresql/server/utils/timeout.h
- /usr/local/include/postgresql/server/utils/timestamp.h
- /usr/local/include/postgresql/server/utils/tuplesort.h
- /usr/local/include/postgresql/server/utils/tuplestore.h
- /usr/local/include/postgresql/server/utils/typcache.h
- /usr/local/include/postgresql/server/utils/tzparser.h
- /usr/local/include/postgresql/server/utils/usercontext.h
- /usr/local/include/postgresql/server/utils/uuid.h
- /usr/local/include/postgresql/server/utils/varbit.h
- /usr/local/include/postgresql/server/utils/varlena.h
- /usr/local/include/postgresql/server/utils/wait_event.h
- /usr/local/include/postgresql/server/utils/xid8.h
- /usr/local/include/postgresql/server/utils/xml.h
- /usr/local/include/postgresql/server/varatt.h
- /usr/local/include/postgresql/server/windowapi.h
- /usr/local/lib/postgresql/cyrillic_and_mic.so
- /usr/local/lib/postgresql/dict_int.so
- /usr/local/lib/postgresql/dict_snowball.so
- /usr/local/lib/postgresql/dict_xsyn.so
- /usr/local/lib/postgresql/euc2004_sjis2004.so
- /usr/local/lib/postgresql/euc_cn_and_mic.so
- /usr/local/lib/postgresql/euc_jp_and_sjis.so
- /usr/local/lib/postgresql/euc_kr_and_mic.so
- /usr/local/lib/postgresql/euc_tw_and_big5.so
- /usr/local/lib/postgresql/jsonb_plperl.so
- /usr/local/lib/postgresql/latin2_and_win1250.so
- /usr/local/lib/postgresql/latin_and_mic.so
- /usr/local/lib/postgresql/libpqwalreceiver.so
- /usr/local/lib/postgresql/pgoutput.so
- /usr/local/lib/postgresql/pgxs/src/test/isolation/
- /usr/local/lib/postgresql/pgxs/src/test/isolation/isolationtester
- /usr/local/lib/postgresql/pgxs/src/test/isolation/pg_isolation_regress
- /usr/local/lib/postgresql/plperl.so
- /usr/local/lib/postgresql/plpgsql.so
- /usr/local/lib/postgresql/test_decoding.so
- /usr/local/lib/postgresql/utf8_and_big5.so
- /usr/local/lib/postgresql/utf8_and_cyrillic.so
- /usr/local/lib/postgresql/utf8_and_euc2004.so
- /usr/local/lib/postgresql/utf8_and_euc_cn.so
- /usr/local/lib/postgresql/utf8_and_euc_jp.so
- /usr/local/lib/postgresql/utf8_and_euc_kr.so
- /usr/local/lib/postgresql/utf8_and_euc_tw.so
- /usr/local/lib/postgresql/utf8_and_gb18030.so
- /usr/local/lib/postgresql/utf8_and_gbk.so
- /usr/local/lib/postgresql/utf8_and_iso8859.so
- /usr/local/lib/postgresql/utf8_and_iso8859_1.so
- /usr/local/lib/postgresql/utf8_and_johab.so
- /usr/local/lib/postgresql/utf8_and_sjis.so
- /usr/local/lib/postgresql/utf8_and_sjis2004.so
- /usr/local/lib/postgresql/utf8_and_uhc.so
- /usr/local/lib/postgresql/utf8_and_win.so
- /usr/local/man/man1/initdb.1
- /usr/local/man/man1/pg_basebackup.1
- /usr/local/man/man1/pg_checksums.1
- /usr/local/man/man1/pg_controldata.1
- /usr/local/man/man1/pg_ctl.1
- /usr/local/man/man1/pg_receivewal.1
- /usr/local/man/man1/pg_recvlogical.1
- /usr/local/man/man1/pg_resetwal.1
- /usr/local/man/man1/pg_rewind.1
- /usr/local/man/man1/pg_verifybackup.1
- /usr/local/man/man1/pg_waldump.1
- /usr/local/man/man1/postgres.1
- /usr/local/share/doc/pkg-readmes/postgresql-server
- /usr/local/share/examples/login.conf.d/postgresql
- /usr/local/share/postgresql/extension/
- /usr/local/share/postgresql/extension/plperl--1.0.sql
- /usr/local/share/postgresql/extension/plperl.control
- /usr/local/share/postgresql/extension/plperlu--1.0.sql
- /usr/local/share/postgresql/extension/plperlu.control
- /usr/local/share/postgresql/extension/plpgsql--1.0.sql
- /usr/local/share/postgresql/extension/plpgsql.control
- /usr/local/share/postgresql/fix-CVE-2024-4317.sql
- /usr/local/share/postgresql/pg_hba.conf.sample
- /usr/local/share/postgresql/pg_ident.conf.sample
- /usr/local/share/postgresql/pg_service.conf.sample
- /usr/local/share/postgresql/postgres.bki
- /usr/local/share/postgresql/postgresql.conf.sample
- /usr/local/share/postgresql/system_constraints.sql
- /usr/local/share/postgresql/system_functions.sql
- /usr/local/share/postgresql/tsearch_data/
- /usr/local/share/postgresql/tsearch_data/danish.stop
- /usr/local/share/postgresql/tsearch_data/dutch.stop
- /usr/local/share/postgresql/tsearch_data/english.stop
- /usr/local/share/postgresql/tsearch_data/finnish.stop
- /usr/local/share/postgresql/tsearch_data/french.stop
- /usr/local/share/postgresql/tsearch_data/german.stop
- /usr/local/share/postgresql/tsearch_data/hungarian.stop
- /usr/local/share/postgresql/tsearch_data/hunspell_sample.affix
- /usr/local/share/postgresql/tsearch_data/hunspell_sample_long.affix
- /usr/local/share/postgresql/tsearch_data/hunspell_sample_long.dict
- /usr/local/share/postgresql/tsearch_data/hunspell_sample_num.affix
- /usr/local/share/postgresql/tsearch_data/hunspell_sample_num.dict
- /usr/local/share/postgresql/tsearch_data/ispell_sample.affix
- /usr/local/share/postgresql/tsearch_data/ispell_sample.dict
- /usr/local/share/postgresql/tsearch_data/italian.stop
- /usr/local/share/postgresql/tsearch_data/nepali.stop
- /usr/local/share/postgresql/tsearch_data/norwegian.stop
- /usr/local/share/postgresql/tsearch_data/portuguese.stop
- /usr/local/share/postgresql/tsearch_data/russian.stop
- /usr/local/share/postgresql/tsearch_data/spanish.stop
- /usr/local/share/postgresql/tsearch_data/swedish.stop
- /usr/local/share/postgresql/tsearch_data/synonym_sample.syn
- /usr/local/share/postgresql/tsearch_data/thesaurus_sample.ths
- /usr/local/share/postgresql/tsearch_data/turkish.stop
- /usr/local/share/postgresql/tsearch_data/unaccent.rules
- /usr/local/share/postgresql/tsearch_data/xsyn_sample.rules
- /var/postgresql/
- @conflict pgsql-*
- @conflict pgsql-clients-*
- @conflict postgresql-*
- @conflict postgresql-clients-*
- @conflict postgresql-server-*
- @newgroup _postgresql:503
- @newuser _postgresql:503:_postgresql::PostgreSQL Manager:/var/postgresql:/bin/sh