1 # Buildsheet autogenerated by ravenadm tool -- Do not edit.
8 SDESC[standard]= Powerful, open source object-relational database
9 HOMEPAGE= https://www.postgresql.org/
13 SITES[main]= PGSQL/source/v11.18
14 DISTFILE[1]= postgresql-11.18.tar.bz2:main
15 DIST_SUBDIR= postgresql
17 SPKGS[standard]= complete
27 OPTIONS_AVAILABLE= none
28 OPTIONS_STANDARD= none
32 BUILD_DEPENDS= docbook-sgml:single:standard
33 docbook-dsssl:single:standard
34 openjade:single:standard
35 OpenSP:single:standard
36 readline:single:standard
37 BUILDRUN_DEPENDS= libxslt:single:standard
38 B_DEPS[sunos]= ossp-uuid:dev:standard
39 B_DEPS[linux]= ossp-uuid:dev:standard
40 BR_DEPS[sunos]= ossp-uuid:primary:standard
41 BR_DEPS[linux]= ossp-uuid:primary:standard
42 BR_DEPS[darwin]= libuuid:single:standard
44 EXRUN[plpython]= python
45 EXRUN[client]= gettext:primary:standard
46 libxslt:single:standard
47 readline:single:standard
50 EXRUN[contrib]= postgresql11:client:standard
51 libxslt:single:standard
53 gettext:primary:standard
56 EXRUN[server]= postgresql11:client:standard
60 USERGROUP_SPKG= server
62 USES= bison gmake perl:build tcl:build ssl python:build
65 DISTNAME= postgresql-11.18
67 LICENSE= PostgreSQL:server
68 LICENSE_FILE= PostgreSQL:{{WRKSRC}}/COPYRIGHT
71 CPE_PRODUCT= postgresql
72 CPE_VENDOR= postgresql
73 FPC_EQUIVALENT= databases/postgresql11-server
76 CONFIGURE_ARGS= --with-libraries="{{PREFIX}}/lib"
77 --with-includes="{{PREFIX}}/include:{{TCL_INCLUDEDIR}}"
78 --with-tclconfig="{{TCL_LIBDIR}}"
87 CONFIGURE_ENV= PTHREAD_LIBS="-lpthread"
89 pgac_cv_path_stylesheets={{PREFIX}}/share/sgml/docbook/dsssl/modular
92 MAKE_ENV= TCL_INCDIR="{{TCL_INCLUDEDIR}}"
94 INSTALL_TARGET= install-world
96 RC_SUBR= postgresql:server
98 SUB_LIST= PG_GROUP=pgsql
104 VAR_OPSYS[freebsd]= CONFIGURE_ARGS=--with-template=freebsd
105 CONFIGURE_ARGS=--with-uuid=bsd
106 VAR_OPSYS[sunos]= CONFIGURE_ENV=ac_cv_search_bind_textdomain_codeset=-lintl
107 CONFIGURE_ARGS=--with-template=solaris
108 CONFIGURE_ARGS=--with-uuid=ossp
109 VAR_OPSYS[linux]= CONFIGURE_ARGS=--with-template=linux
110 CONFIGURE_ARGS=--with-uuid=ossp
111 VAR_OPSYS[darwin]= CONFIGURE_ARGS=--with-template=darwin
112 CONFIGURE_ARGS=--with-uuid=e2fs
113 VAR_OPSYS[netbsd]= CONFIGURE_ARGS=--with-template=netbsd
114 CONFIGURE_ARGS=--with-uuid=bsd
115 VAR_OPSYS[openbsd]= CONFIGURE_ARGS=--with-template=openbsd
116 CONFIGURE_ARGS=--with-uuid=bsd
117 VAR_OPSYS[dragonfly]= CONFIGURE_ARGS=--with-template=freebsd
118 CONFIGURE_ARGS=--with-uuid=bsd
121 @${MKDIR} ${STAGEDIR}${PREFIX}/etc/periodic/daily
122 ${INSTALL_SCRIPT} ${WRKDIR}/502.pgsql \
123 ${STAGEDIR}${PREFIX}/etc/periodic/daily
124 # install-world doesn't strip (and install-strip won't install enough)
125 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so
126 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/*.${LIBEXT}
127 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/regress/pg_regress
128 list=$$(${LS} ${STAGEDIR}${PREFIX}/bin/* | ${GREP} -v pltcl_); \
129 ${STRIP_CMD} $${list}
132 ${REINPLACE_CMD} -e '/sqlmansect/d' \
133 ${WRKSRC}/src/makefiles/Makefile.solaris
135 [FILE:1220:descriptions/desc.server]
136 PostgreSQL is a sophisticated Object-Relational DBMS, supporting
137 almost all SQL constructs, including subselects, transactions, and
138 user-defined types and functions. It is the most advanced open-source
139 database available anywhere. Commercial Support is also available.
141 The original Postgres code was the effort of many graduate students,
142 undergraduate students, and staff programmers working under the direction
143 of Professor Michael Stonebraker at the University of California,
144 Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting
145 the DBMS query language to SQL and created a new database system which came
146 to known as Postgres95. Many others contributed to the porting, testing,
147 debugging and enhancement of the Postgres95 code. As the code improved,
148 and 1995 faded into memory, PostgreSQL was born.
150 PostgreSQL development is presently being performed by a team of developers
151 who are now responsible for all current and future development. The
152 development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG).
153 Support is available from the PostgreSQL developer/user community through
154 the support mailing list (questions@PostgreSQL.ORG).
156 This subpackage contains the PostgreSQL server.
159 [FILE:48:descriptions/desc.client]
160 This subpackage contains the PostgreSQL client.
163 [FILE:60:descriptions/desc.contrib]
164 This subpackage contains the contrib modules of PostgreSQL.
167 [FILE:74:descriptions/desc.plperl]
168 This subpackage contains Perl Procedural Language support for PostgreSQL.
171 [FILE:76:descriptions/desc.plpython]
172 This subpackage contains Python Procedural Language support for PostgreSQL.
175 [FILE:73:descriptions/desc.pltcl]
176 This subpackage contains Tcl Procedural Language support for PostgreSQL.
180 d24f20efc52e918acfbcca21e9cea28e0e263b846a0c408fcfac3b3c4a0f7504 20428126 postgresql/postgresql-11.18.tar.bz2
183 [FILE:8703:manifests/plist.server]
200 etc/periodic/daily/502.pgsql
201 include/postgresql/server/plpgsql.h
202 include/postgresql/server/common/connect.h
205 amcheck.%%SHARED_OBJECT%%
206 ascii_and_mic.%%SHARED_OBJECT%%
207 cyrillic_and_mic.%%SHARED_OBJECT%%
208 dict_snowball.%%SHARED_OBJECT%%
209 euc2004_sjis2004.%%SHARED_OBJECT%%
210 euc_cn_and_mic.%%SHARED_OBJECT%%
211 euc_jp_and_sjis.%%SHARED_OBJECT%%
212 euc_kr_and_mic.%%SHARED_OBJECT%%
213 euc_tw_and_big5.%%SHARED_OBJECT%%
214 latin2_and_win1250.%%SHARED_OBJECT%%
215 latin_and_mic.%%SHARED_OBJECT%%
216 libpqwalreceiver.%%SHARED_OBJECT%%
217 pgoutput.%%SHARED_OBJECT%%
218 plpgsql.%%SHARED_OBJECT%%
219 utf8_and_ascii.%%SHARED_OBJECT%%
220 utf8_and_big5.%%SHARED_OBJECT%%
221 utf8_and_cyrillic.%%SHARED_OBJECT%%
222 utf8_and_euc2004.%%SHARED_OBJECT%%
223 utf8_and_euc_cn.%%SHARED_OBJECT%%
224 utf8_and_euc_jp.%%SHARED_OBJECT%%
225 utf8_and_euc_kr.%%SHARED_OBJECT%%
226 utf8_and_euc_tw.%%SHARED_OBJECT%%
227 utf8_and_gb18030.%%SHARED_OBJECT%%
228 utf8_and_gbk.%%SHARED_OBJECT%%
229 utf8_and_iso8859.%%SHARED_OBJECT%%
230 utf8_and_iso8859_1.%%SHARED_OBJECT%%
231 utf8_and_johab.%%SHARED_OBJECT%%
232 utf8_and_sjis.%%SHARED_OBJECT%%
233 utf8_and_sjis2004.%%SHARED_OBJECT%%
234 utf8_and_uhc.%%SHARED_OBJECT%%
235 utf8_and_win.%%SHARED_OBJECT%%
237 conversion_create.sql
238 information_schema.sql
243 postgres.shdescription
244 postgresql.conf.sample
249 share/postgresql/extension/
251 plpgsql--unpackaged--1.0.sql
253 share/postgresql/timezone/
300 share/postgresql/timezone/Africa/
355 share/postgresql/timezone/America/
497 share/postgresql/timezone/America/Argentina/
511 share/postgresql/timezone/America/Indiana/
520 share/postgresql/timezone/America/Kentucky/
523 share/postgresql/timezone/America/North_Dakota/
527 share/postgresql/timezone/Antarctica/
540 share/postgresql/timezone/Arctic/Longyearbyen
541 share/postgresql/timezone/Asia/
641 share/postgresql/timezone/Atlantic/
654 share/postgresql/timezone/Australia/
678 share/postgresql/timezone/Brazil/
683 share/postgresql/timezone/Canada/
692 share/postgresql/timezone/Chile/
695 share/postgresql/timezone/Etc/
731 share/postgresql/timezone/Europe/
796 share/postgresql/timezone/Indian/
808 share/postgresql/timezone/Mexico/
812 share/postgresql/timezone/Pacific/
857 share/postgresql/timezone/US/
870 share/postgresql/timezonesets/
884 share/postgresql/tsearch_data/
892 hunspell_sample.affix
893 hunspell_sample_long.affix
894 hunspell_sample_long.dict
895 hunspell_sample_num.affix
896 hunspell_sample_num.dict
910 [FILE:19334:manifests/plist.client]
913 libecpg_compat.so.3.11
957 include/libpq/libpq-fs.h
958 include/postgresql/informix/esql/
962 include/postgresql/internal/
968 include/postgresql/internal/libpq/pqcomm.h
969 include/postgresql/server/
992 include/postgresql/server/access/
1065 include/postgresql/server/bootstrap/bootstrap.h
1066 include/postgresql/server/catalog/
1109 pg_db_role_setting.h
1110 pg_db_role_setting_d.h
1120 pg_event_trigger_d.h
1123 pg_foreign_data_wrapper.h
1124 pg_foreign_data_wrapper_d.h
1126 pg_foreign_server_d.h
1128 pg_foreign_table_d.h
1139 pg_largeobject_metadata.h
1140 pg_largeobject_metadata_d.h
1149 pg_partitioned_table.h
1150 pg_partitioned_table_d.h
1159 pg_publication_rel.h
1160 pg_publication_rel_d.h
1163 pg_replication_origin.h
1164 pg_replication_origin_d.h
1174 pg_shdescription_d.h
1180 pg_statistic_ext_d.h
1183 pg_subscription_rel.h
1184 pg_subscription_rel_d.h
1194 pg_ts_config_map_d.h
1209 include/postgresql/server/commands/
1245 include/postgresql/server/common/
1265 unicode_norm_table.h
1267 include/postgresql/server/datatype/timestamp.h
1268 include/postgresql/server/executor/
1281 nodeBitmapHeapscan.h
1282 nodeBitmapIndexscan.h
1301 nodeNamedtuplestorescan.h
1304 nodeRecursiveunion.h
1324 include/postgresql/server/extension/cube/cubedata.h
1325 include/postgresql/server/extension/hstore/hstore.h
1326 include/postgresql/server/extension/isn/isn.h
1327 include/postgresql/server/extension/ltree/ltree.h
1328 include/postgresql/server/extension/seg/segdata.h
1329 include/postgresql/server/fe_utils/
1338 include/postgresql/server/foreign/
1341 include/postgresql/server/jit/
1345 include/postgresql/server/lib/
1357 include/postgresql/server/libpq/
1371 include/postgresql/server/mb/pg_wchar.h
1372 include/postgresql/server/nodes/
1392 include/postgresql/server/optimizer/
1402 geqo_recombination.h
1419 include/postgresql/server/parser/
1443 include/postgresql/server/partitioning/
1447 include/postgresql/server/port/
1462 include/postgresql/server/port/atomics/
1475 include/postgresql/server/port/win32/
1480 include/postgresql/server/port/win32/arpa/inet.h
1481 include/postgresql/server/port/win32/netinet/in.h
1482 include/postgresql/server/port/win32/sys/
1485 include/postgresql/server/port/win32_msvc/
1489 include/postgresql/server/port/win32_msvc/sys/
1493 include/postgresql/server/portability/
1496 include/postgresql/server/postmaster/
1499 bgworker_internals.h
1507 include/postgresql/server/regex/
1513 include/postgresql/server/replication/
1534 include/postgresql/server/rewrite/
1542 include/postgresql/server/snowball/header.h
1543 include/postgresql/server/snowball/libstemmer/
1546 stem_ISO_8859_1_danish.h
1547 stem_ISO_8859_1_dutch.h
1548 stem_ISO_8859_1_english.h
1549 stem_ISO_8859_1_finnish.h
1550 stem_ISO_8859_1_french.h
1551 stem_ISO_8859_1_german.h
1552 stem_ISO_8859_1_hungarian.h
1553 stem_ISO_8859_1_italian.h
1554 stem_ISO_8859_1_norwegian.h
1555 stem_ISO_8859_1_porter.h
1556 stem_ISO_8859_1_portuguese.h
1557 stem_ISO_8859_1_spanish.h
1558 stem_ISO_8859_1_swedish.h
1559 stem_ISO_8859_2_romanian.h
1560 stem_KOI8_R_russian.h
1563 stem_UTF_8_english.h
1564 stem_UTF_8_finnish.h
1567 stem_UTF_8_hungarian.h
1568 stem_UTF_8_italian.h
1569 stem_UTF_8_norwegian.h
1571 stem_UTF_8_portuguese.h
1572 stem_UTF_8_romanian.h
1573 stem_UTF_8_russian.h
1574 stem_UTF_8_spanish.h
1575 stem_UTF_8_swedish.h
1576 stem_UTF_8_turkish.h
1577 include/postgresql/server/statistics/
1578 extended_stats_internal.h
1580 include/postgresql/server/storage/
1591 condition_variable.h
1615 predicate_internals.h
1634 include/postgresql/server/tcop/
1641 include/postgresql/server/tsearch/
1647 include/postgresql/server/tsearch/dicts/
1650 include/postgresql/server/utils/
1761 lib/postgresql/pgxs/config/
1764 lib/postgresql/pgxs/src/
1769 lib/postgresql/pgxs/src/makefiles/pgxs.mk
1770 lib/postgresql/pgxs/src/test/regress/pg_regress
1780 pg_archivecleanup.1.gz
1797 pg_verify_checksums.1.gz
1809 SPI_connect_ext.3.gz
1811 SPI_cursor_close.3.gz
1812 SPI_cursor_fetch.3.gz
1813 SPI_cursor_find.3.gz
1814 SPI_cursor_move.3.gz
1815 SPI_cursor_open.3.gz
1816 SPI_cursor_open_with_args.3.gz
1817 SPI_cursor_open_with_paramlist.3.gz
1821 SPI_execute_plan.3.gz
1822 SPI_execute_plan_with_paramlist.3.gz
1823 SPI_execute_with_args.3.gz
1829 SPI_freetuptable.3.gz
1830 SPI_getargcount.3.gz
1831 SPI_getargtypeid.3.gz
1838 SPI_is_cursor_plan.3.gz
1840 SPI_modifytuple.3.gz
1844 SPI_prepare_cursor.3.gz
1845 SPI_prepare_params.3.gz
1846 SPI_register_relation.3.gz
1847 SPI_register_trigger_data.3.gz
1849 SPI_result_code_string.3.gz
1850 SPI_returntuple.3.gz
1853 SPI_scroll_cursor_fetch.3.gz
1854 SPI_scroll_cursor_move.3.gz
1855 SPI_start_transaction.3.gz
1856 SPI_unregister_relation.3.gz
1858 dblink_build_sql_delete.3.gz
1859 dblink_build_sql_insert.3.gz
1860 dblink_build_sql_update.3.gz
1861 dblink_cancel_query.3.gz
1864 dblink_connect_u.3.gz
1865 dblink_disconnect.3.gz
1866 dblink_error_message.3.gz
1869 dblink_get_connections.3.gz
1870 dblink_get_notify.3.gz
1871 dblink_get_pkey.3.gz
1872 dblink_get_result.3.gz
1875 dblink_send_query.3.gz
1878 ALTER_AGGREGATE.7.gz
1879 ALTER_COLLATION.7.gz
1880 ALTER_CONVERSION.7.gz
1882 ALTER_DEFAULT_PRIVILEGES.7.gz
1884 ALTER_EVENT_TRIGGER.7.gz
1885 ALTER_EXTENSION.7.gz
1886 ALTER_FOREIGN_DATA_WRAPPER.7.gz
1887 ALTER_FOREIGN_TABLE.7.gz
1892 ALTER_LARGE_OBJECT.7.gz
1893 ALTER_MATERIALIZED_VIEW.7.gz
1895 ALTER_OPERATOR_CLASS.7.gz
1896 ALTER_OPERATOR_FAMILY.7.gz
1898 ALTER_PROCEDURE.7.gz
1899 ALTER_PUBLICATION.7.gz
1906 ALTER_STATISTICS.7.gz
1907 ALTER_SUBSCRIPTION.7.gz
1910 ALTER_TABLESPACE.7.gz
1911 ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
1912 ALTER_TEXT_SEARCH_DICTIONARY.7.gz
1913 ALTER_TEXT_SEARCH_PARSER.7.gz
1914 ALTER_TEXT_SEARCH_TEMPLATE.7.gz
1918 ALTER_USER_MAPPING.7.gz
1928 COMMIT_PREPARED.7.gz
1930 CREATE_ACCESS_METHOD.7.gz
1931 CREATE_AGGREGATE.7.gz
1933 CREATE_COLLATION.7.gz
1934 CREATE_CONVERSION.7.gz
1935 CREATE_DATABASE.7.gz
1937 CREATE_EVENT_TRIGGER.7.gz
1938 CREATE_EXTENSION.7.gz
1939 CREATE_FOREIGN_DATA_WRAPPER.7.gz
1940 CREATE_FOREIGN_TABLE.7.gz
1941 CREATE_FUNCTION.7.gz
1944 CREATE_LANGUAGE.7.gz
1945 CREATE_MATERIALIZED_VIEW.7.gz
1946 CREATE_OPERATOR.7.gz
1947 CREATE_OPERATOR_CLASS.7.gz
1948 CREATE_OPERATOR_FAMILY.7.gz
1950 CREATE_PROCEDURE.7.gz
1951 CREATE_PUBLICATION.7.gz
1955 CREATE_SEQUENCE.7.gz
1957 CREATE_STATISTICS.7.gz
1958 CREATE_SUBSCRIPTION.7.gz
1960 CREATE_TABLESPACE.7.gz
1961 CREATE_TABLE_AS.7.gz
1962 CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
1963 CREATE_TEXT_SEARCH_DICTIONARY.7.gz
1964 CREATE_TEXT_SEARCH_PARSER.7.gz
1965 CREATE_TEXT_SEARCH_TEMPLATE.7.gz
1966 CREATE_TRANSFORM.7.gz
1970 CREATE_USER_MAPPING.7.gz
1977 DROP_ACCESS_METHOD.7.gz
1981 DROP_CONVERSION.7.gz
1984 DROP_EVENT_TRIGGER.7.gz
1986 DROP_FOREIGN_DATA_WRAPPER.7.gz
1987 DROP_FOREIGN_TABLE.7.gz
1992 DROP_MATERIALIZED_VIEW.7.gz
1994 DROP_OPERATOR_CLASS.7.gz
1995 DROP_OPERATOR_FAMILY.7.gz
1999 DROP_PUBLICATION.7.gz
2006 DROP_STATISTICS.7.gz
2007 DROP_SUBSCRIPTION.7.gz
2009 DROP_TABLESPACE.7.gz
2010 DROP_TEXT_SEARCH_CONFIGURATION.7.gz
2011 DROP_TEXT_SEARCH_DICTIONARY.7.gz
2012 DROP_TEXT_SEARCH_PARSER.7.gz
2013 DROP_TEXT_SEARCH_TEMPLATE.7.gz
2018 DROP_USER_MAPPING.7.gz
2025 IMPORT_FOREIGN_SCHEMA.7.gz
2033 PREPARE_TRANSACTION.7.gz
2035 REFRESH_MATERIALIZED_VIEW.7.gz
2037 RELEASE_SAVEPOINT.7.gz
2041 ROLLBACK_PREPARED.7.gz
2042 ROLLBACK_TO_SAVEPOINT.7.gz
2048 SET_CONSTRAINTS.7.gz
2050 SET_SESSION_AUTHORIZATION.7.gz
2051 SET_TRANSACTION.7.gz
2053 START_TRANSACTION.7.gz
2063 pg_service.conf.sample
2067 [FILE:6265:manifests/plist.contrib]
2073 _int.%%SHARED_OBJECT%%
2074 adminpack.%%SHARED_OBJECT%%
2075 auth_delay.%%SHARED_OBJECT%%
2076 auto_explain.%%SHARED_OBJECT%%
2077 autoinc.%%SHARED_OBJECT%%
2078 bloom.%%SHARED_OBJECT%%
2079 btree_gin.%%SHARED_OBJECT%%
2080 btree_gist.%%SHARED_OBJECT%%
2081 citext.%%SHARED_OBJECT%%
2082 cube.%%SHARED_OBJECT%%
2083 dblink.%%SHARED_OBJECT%%
2084 dict_int.%%SHARED_OBJECT%%
2085 dict_xsyn.%%SHARED_OBJECT%%
2086 earthdistance.%%SHARED_OBJECT%%
2087 file_fdw.%%SHARED_OBJECT%%
2088 fuzzystrmatch.%%SHARED_OBJECT%%
2089 hstore.%%SHARED_OBJECT%%
2090 insert_username.%%SHARED_OBJECT%%
2091 isn.%%SHARED_OBJECT%%
2092 lo.%%SHARED_OBJECT%%
2093 ltree.%%SHARED_OBJECT%%
2094 moddatetime.%%SHARED_OBJECT%%
2095 pageinspect.%%SHARED_OBJECT%%
2096 passwordcheck.%%SHARED_OBJECT%%
2097 pg_buffercache.%%SHARED_OBJECT%%
2098 pg_freespacemap.%%SHARED_OBJECT%%
2099 pg_prewarm.%%SHARED_OBJECT%%
2100 pg_stat_statements.%%SHARED_OBJECT%%
2101 pg_trgm.%%SHARED_OBJECT%%
2102 pg_visibility.%%SHARED_OBJECT%%
2103 pgcrypto.%%SHARED_OBJECT%%
2104 pgrowlocks.%%SHARED_OBJECT%%
2105 pgstattuple.%%SHARED_OBJECT%%
2106 pgxml.%%SHARED_OBJECT%%
2107 postgres_fdw.%%SHARED_OBJECT%%
2108 refint.%%SHARED_OBJECT%%
2109 seg.%%SHARED_OBJECT%%
2110 sslinfo.%%SHARED_OBJECT%%
2111 tablefunc.%%SHARED_OBJECT%%
2112 tcn.%%SHARED_OBJECT%%
2113 test_decoding.%%SHARED_OBJECT%%
2114 timetravel.%%SHARED_OBJECT%%
2115 tsm_system_rows.%%SHARED_OBJECT%%
2116 tsm_system_time.%%SHARED_OBJECT%%
2117 unaccent.%%SHARED_OBJECT%%
2118 uuid-ossp.%%SHARED_OBJECT%%
2119 share/postgresql/extension/
2120 adminpack--1.0--1.1.sql
2122 adminpack--1.1--2.0.sql
2124 amcheck--1.0--1.1.sql
2128 autoinc--unpackaged--1.0.sql
2132 btree_gin--1.0--1.1.sql
2134 btree_gin--1.1--1.2.sql
2135 btree_gin--1.2--1.3.sql
2136 btree_gin--unpackaged--1.0.sql
2138 btree_gist--1.0--1.1.sql
2139 btree_gist--1.1--1.2.sql
2140 btree_gist--1.2--1.3.sql
2142 btree_gist--1.3--1.4.sql
2143 btree_gist--1.4--1.5.sql
2144 btree_gist--unpackaged--1.0.sql
2146 citext--1.0--1.1.sql
2147 citext--1.1--1.2.sql
2148 citext--1.2--1.3.sql
2149 citext--1.3--1.4.sql
2150 citext--1.4--1.5.sql
2152 citext--unpackaged--1.0.sql
2159 cube--unpackaged--1.0.sql
2161 dblink--1.0--1.1.sql
2162 dblink--1.1--1.2.sql
2164 dblink--unpackaged--1.0.sql
2167 dict_int--unpackaged--1.0.sql
2170 dict_xsyn--unpackaged--1.0.sql
2172 earthdistance--1.0--1.1.sql
2173 earthdistance--1.1.sql
2174 earthdistance--unpackaged--1.0.sql
2175 earthdistance.control
2178 fuzzystrmatch--1.0--1.1.sql
2179 fuzzystrmatch--1.1.sql
2180 fuzzystrmatch--unpackaged--1.0.sql
2181 fuzzystrmatch.control
2182 hstore--1.0--1.1.sql
2183 hstore--1.1--1.2.sql
2184 hstore--1.2--1.3.sql
2185 hstore--1.3--1.4.sql
2186 hstore--1.4--1.5.sql
2188 hstore--unpackaged--1.0.sql
2190 insert_username--1.0.sql
2191 insert_username--unpackaged--1.0.sql
2192 insert_username.control
2193 intagg--1.0--1.1.sql
2195 intagg--unpackaged--1.0.sql
2197 intarray--1.0--1.1.sql
2198 intarray--1.1--1.2.sql
2200 intarray--unpackaged--1.0.sql
2205 isn--unpackaged--1.0.sql
2209 lo--unpackaged--1.0.sql
2213 ltree--unpackaged--1.0.sql
2215 moddatetime--1.0.sql
2216 moddatetime--unpackaged--1.0.sql
2218 pageinspect--1.0--1.1.sql
2219 pageinspect--1.1--1.2.sql
2220 pageinspect--1.2--1.3.sql
2221 pageinspect--1.3--1.4.sql
2222 pageinspect--1.4--1.5.sql
2223 pageinspect--1.5--1.6.sql
2224 pageinspect--1.5.sql
2225 pageinspect--1.6--1.7.sql
2226 pageinspect--unpackaged--1.0.sql
2228 pg_buffercache--1.0--1.1.sql
2229 pg_buffercache--1.1--1.2.sql
2230 pg_buffercache--1.2--1.3.sql
2231 pg_buffercache--1.2.sql
2232 pg_buffercache--unpackaged--1.0.sql
2233 pg_buffercache.control
2234 pg_freespacemap--1.0--1.1.sql
2235 pg_freespacemap--1.1--1.2.sql
2236 pg_freespacemap--1.1.sql
2237 pg_freespacemap--unpackaged--1.0.sql
2238 pg_freespacemap.control
2239 pg_prewarm--1.0--1.1.sql
2240 pg_prewarm--1.1--1.2.sql
2243 pg_stat_statements--1.0--1.1.sql
2244 pg_stat_statements--1.1--1.2.sql
2245 pg_stat_statements--1.2--1.3.sql
2246 pg_stat_statements--1.3--1.4.sql
2247 pg_stat_statements--1.4--1.5.sql
2248 pg_stat_statements--1.4.sql
2249 pg_stat_statements--1.5--1.6.sql
2250 pg_stat_statements--unpackaged--1.0.sql
2251 pg_stat_statements.control
2252 pg_trgm--1.0--1.1.sql
2253 pg_trgm--1.1--1.2.sql
2254 pg_trgm--1.2--1.3.sql
2255 pg_trgm--1.3--1.4.sql
2257 pg_trgm--unpackaged--1.0.sql
2259 pg_visibility--1.0--1.1.sql
2260 pg_visibility--1.1--1.2.sql
2261 pg_visibility--1.1.sql
2262 pg_visibility.control
2263 pgcrypto--1.0--1.1.sql
2264 pgcrypto--1.1--1.2.sql
2265 pgcrypto--1.2--1.3.sql
2267 pgcrypto--unpackaged--1.0.sql
2269 pgrowlocks--1.0--1.1.sql
2270 pgrowlocks--1.1--1.2.sql
2272 pgrowlocks--unpackaged--1.0.sql
2274 pgstattuple--1.0--1.1.sql
2275 pgstattuple--1.1--1.2.sql
2276 pgstattuple--1.2--1.3.sql
2277 pgstattuple--1.3--1.4.sql
2278 pgstattuple--1.4--1.5.sql
2279 pgstattuple--1.4.sql
2280 pgstattuple--unpackaged--1.0.sql
2282 postgres_fdw--1.0.sql
2283 postgres_fdw.control
2285 refint--unpackaged--1.0.sql
2291 seg--unpackaged--1.0.sql
2293 sslinfo--1.0--1.1.sql
2294 sslinfo--1.1--1.2.sql
2296 sslinfo--unpackaged--1.0.sql
2299 tablefunc--unpackaged--1.0.sql
2304 timetravel--unpackaged--1.0.sql
2306 tsm_system_rows--1.0.sql
2307 tsm_system_rows.control
2308 tsm_system_time--1.0.sql
2309 tsm_system_time.control
2310 unaccent--1.0--1.1.sql
2312 unaccent--unpackaged--1.0.sql
2314 uuid-ossp--1.0--1.1.sql
2316 uuid-ossp--unpackaged--1.0.sql
2320 xml2--unpackaged--1.0.sql
2322 share/postgresql/tsearch_data/
2327 [FILE:515:manifests/plist.plperl]
2328 include/postgresql/server/
2333 hstore_plperl.%%SHARED_OBJECT%%
2334 jsonb_plperl.%%SHARED_OBJECT%%
2335 plperl.%%SHARED_OBJECT%%
2336 share/postgresql/extension/
2337 hstore_plperl--1.0.sql
2338 hstore_plperl.control
2339 hstore_plperlu--1.0.sql
2340 hstore_plperlu.control
2341 jsonb_plperl--1.0.sql
2342 jsonb_plperl.control
2343 jsonb_plperlu--1.0.sql
2344 jsonb_plperlu.control
2346 plperl--unpackaged--1.0.sql
2349 plperlu--unpackaged--1.0.sql
2353 [FILE:1144:manifests/plist.plpython]
2354 include/postgresql/server/
2364 plpy_subxactobject.h
2369 hstore_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2370 jsonb_plpython3.%%SHARED_OBJECT%%
2371 ltree_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2372 plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2373 lib/postgresql/pgxs/src/pl/plpython/regress-python3-mangle.mk
2374 share/postgresql/extension/
2375 hstore_plpython2u--1.0.sql
2376 hstore_plpython2u.control
2377 hstore_plpython3u--1.0.sql
2378 hstore_plpython3u.control
2379 hstore_plpythonu--1.0.sql
2380 hstore_plpythonu.control
2381 jsonb_plpython2u--1.0.sql
2382 jsonb_plpython2u.control
2383 jsonb_plpython3u--1.0.sql
2384 jsonb_plpython3u.control
2385 jsonb_plpythonu--1.0.sql
2386 jsonb_plpythonu.control
2387 ltree_plpython2u--1.0.sql
2388 ltree_plpython2u.control
2389 ltree_plpython3u--1.0.sql
2390 ltree_plpython3u.control
2391 ltree_plpythonu--1.0.sql
2392 ltree_plpythonu.control
2393 plpython%%PYTHON_MAJOR_VER%%u--1.0.sql
2394 plpython%%PYTHON_MAJOR_VER%%u--unpackaged--1.0.sql
2395 plpython%%PYTHON_MAJOR_VER%%u.control
2398 [FILE:188:manifests/plist.pltcl]
2399 lib/postgresql/pltcl.%%SHARED_OBJECT%%
2400 share/postgresql/extension/
2402 pltcl--unpackaged--1.0.sql
2405 pltclu--unpackaged--1.0.sql
2409 [FILE:131:manifests/plist.docs]
2410 share/doc/postgresql/extension/
2412 insert_username.example
2418 [FILE:8215:manifests/plist.nls]
2419 share/locale/cs/LC_MESSAGES/
2421 ecpglib6-%%PGVER%%.mo
2424 pg_archivecleanup-%%PGVER%%.mo
2425 pg_basebackup-%%PGVER%%.mo
2426 pg_config-%%PGVER%%.mo
2427 pg_controldata-%%PGVER%%.mo
2429 pg_dump-%%PGVER%%.mo
2430 pg_resetwal-%%PGVER%%.mo
2431 pg_rewind-%%PGVER%%.mo
2432 pg_test_fsync-%%PGVER%%.mo
2433 pg_test_timing-%%PGVER%%.mo
2434 pg_upgrade-%%PGVER%%.mo
2435 pg_verify_checksums-%%PGVER%%.mo
2436 pg_waldump-%%PGVER%%.mo
2437 pgscripts-%%PGVER%%.mo
2439 plpgsql-%%PGVER%%.mo
2440 plpython-%%PGVER%%.mo
2443 share/locale/de/LC_MESSAGES/
2445 ecpglib6-%%PGVER%%.mo
2448 pg_archivecleanup-%%PGVER%%.mo
2449 pg_basebackup-%%PGVER%%.mo
2450 pg_config-%%PGVER%%.mo
2451 pg_controldata-%%PGVER%%.mo
2453 pg_dump-%%PGVER%%.mo
2454 pg_resetwal-%%PGVER%%.mo
2455 pg_rewind-%%PGVER%%.mo
2456 pg_test_fsync-%%PGVER%%.mo
2457 pg_test_timing-%%PGVER%%.mo
2458 pg_upgrade-%%PGVER%%.mo
2459 pg_verify_checksums-%%PGVER%%.mo
2460 pg_waldump-%%PGVER%%.mo
2461 pgscripts-%%PGVER%%.mo
2463 plpgsql-%%PGVER%%.mo
2464 plpython-%%PGVER%%.mo
2466 postgres-%%PGVER%%.mo
2468 share/locale/es/LC_MESSAGES/
2470 ecpglib6-%%PGVER%%.mo
2473 pg_archivecleanup-%%PGVER%%.mo
2474 pg_basebackup-%%PGVER%%.mo
2475 pg_config-%%PGVER%%.mo
2476 pg_controldata-%%PGVER%%.mo
2478 pg_dump-%%PGVER%%.mo
2479 pg_resetwal-%%PGVER%%.mo
2480 pg_rewind-%%PGVER%%.mo
2481 pg_test_fsync-%%PGVER%%.mo
2482 pg_test_timing-%%PGVER%%.mo
2483 pg_upgrade-%%PGVER%%.mo
2484 pg_verify_checksums-%%PGVER%%.mo
2485 pg_waldump-%%PGVER%%.mo
2486 pgscripts-%%PGVER%%.mo
2488 plpgsql-%%PGVER%%.mo
2489 plpython-%%PGVER%%.mo
2491 postgres-%%PGVER%%.mo
2493 share/locale/fr/LC_MESSAGES/
2495 ecpglib6-%%PGVER%%.mo
2498 pg_archivecleanup-%%PGVER%%.mo
2499 pg_basebackup-%%PGVER%%.mo
2500 pg_config-%%PGVER%%.mo
2501 pg_controldata-%%PGVER%%.mo
2503 pg_dump-%%PGVER%%.mo
2504 pg_resetwal-%%PGVER%%.mo
2505 pg_rewind-%%PGVER%%.mo
2506 pg_test_fsync-%%PGVER%%.mo
2507 pg_test_timing-%%PGVER%%.mo
2508 pg_upgrade-%%PGVER%%.mo
2509 pg_verify_checksums-%%PGVER%%.mo
2510 pg_waldump-%%PGVER%%.mo
2511 pgscripts-%%PGVER%%.mo
2513 plpgsql-%%PGVER%%.mo
2514 plpython-%%PGVER%%.mo
2516 postgres-%%PGVER%%.mo
2518 share/locale/he/LC_MESSAGES/
2521 pg_basebackup-%%PGVER%%.mo
2522 pg_config-%%PGVER%%.mo
2524 pg_dump-%%PGVER%%.mo
2525 pgscripts-%%PGVER%%.mo
2527 share/locale/it/LC_MESSAGES/
2529 ecpglib6-%%PGVER%%.mo
2532 pg_basebackup-%%PGVER%%.mo
2533 pg_config-%%PGVER%%.mo
2534 pg_controldata-%%PGVER%%.mo
2536 pg_dump-%%PGVER%%.mo
2537 pg_rewind-%%PGVER%%.mo
2538 pgscripts-%%PGVER%%.mo
2540 plpgsql-%%PGVER%%.mo
2541 plpython-%%PGVER%%.mo
2543 postgres-%%PGVER%%.mo
2545 share/locale/ja/LC_MESSAGES/
2547 ecpglib6-%%PGVER%%.mo
2550 pg_archivecleanup-%%PGVER%%.mo
2551 pg_basebackup-%%PGVER%%.mo
2552 pg_config-%%PGVER%%.mo
2553 pg_controldata-%%PGVER%%.mo
2555 pg_dump-%%PGVER%%.mo
2556 pg_resetwal-%%PGVER%%.mo
2557 pg_rewind-%%PGVER%%.mo
2558 pg_test_fsync-%%PGVER%%.mo
2559 pg_test_timing-%%PGVER%%.mo
2560 pg_upgrade-%%PGVER%%.mo
2561 pg_verify_checksums-%%PGVER%%.mo
2562 pg_waldump-%%PGVER%%.mo
2563 pgscripts-%%PGVER%%.mo
2565 plpgsql-%%PGVER%%.mo
2566 plpython-%%PGVER%%.mo
2568 postgres-%%PGVER%%.mo
2570 share/locale/ko/LC_MESSAGES/
2572 ecpglib6-%%PGVER%%.mo
2575 pg_archivecleanup-%%PGVER%%.mo
2576 pg_basebackup-%%PGVER%%.mo
2577 pg_config-%%PGVER%%.mo
2578 pg_controldata-%%PGVER%%.mo
2580 pg_dump-%%PGVER%%.mo
2581 pg_resetwal-%%PGVER%%.mo
2582 pg_rewind-%%PGVER%%.mo
2583 pg_test_fsync-%%PGVER%%.mo
2584 pg_test_timing-%%PGVER%%.mo
2585 pg_upgrade-%%PGVER%%.mo
2586 pg_verify_checksums-%%PGVER%%.mo
2587 pg_waldump-%%PGVER%%.mo
2588 pgscripts-%%PGVER%%.mo
2590 plpgsql-%%PGVER%%.mo
2591 plpython-%%PGVER%%.mo
2593 postgres-%%PGVER%%.mo
2595 share/locale/nb/LC_MESSAGES/pg_config-%%PGVER%%.mo
2596 share/locale/pl/LC_MESSAGES/
2598 ecpglib6-%%PGVER%%.mo
2601 pg_archivecleanup-%%PGVER%%.mo
2602 pg_basebackup-%%PGVER%%.mo
2603 pg_config-%%PGVER%%.mo
2604 pg_controldata-%%PGVER%%.mo
2606 pg_dump-%%PGVER%%.mo
2607 pg_rewind-%%PGVER%%.mo
2608 pg_test_fsync-%%PGVER%%.mo
2609 pg_test_timing-%%PGVER%%.mo
2610 pgscripts-%%PGVER%%.mo
2612 plpgsql-%%PGVER%%.mo
2613 plpython-%%PGVER%%.mo
2615 postgres-%%PGVER%%.mo
2617 share/locale/pt_BR/LC_MESSAGES/
2619 ecpglib6-%%PGVER%%.mo
2622 pg_config-%%PGVER%%.mo
2623 pg_controldata-%%PGVER%%.mo
2625 pg_dump-%%PGVER%%.mo
2626 pg_rewind-%%PGVER%%.mo
2627 pgscripts-%%PGVER%%.mo
2629 plpgsql-%%PGVER%%.mo
2630 plpython-%%PGVER%%.mo
2632 share/locale/ro/LC_MESSAGES/
2633 pg_config-%%PGVER%%.mo
2635 plpgsql-%%PGVER%%.mo
2636 share/locale/ru/LC_MESSAGES/
2638 ecpglib6-%%PGVER%%.mo
2641 pg_archivecleanup-%%PGVER%%.mo
2642 pg_basebackup-%%PGVER%%.mo
2643 pg_config-%%PGVER%%.mo
2644 pg_controldata-%%PGVER%%.mo
2646 pg_dump-%%PGVER%%.mo
2647 pg_resetwal-%%PGVER%%.mo
2648 pg_rewind-%%PGVER%%.mo
2649 pg_test_fsync-%%PGVER%%.mo
2650 pg_test_timing-%%PGVER%%.mo
2651 pg_upgrade-%%PGVER%%.mo
2652 pg_verify_checksums-%%PGVER%%.mo
2653 pg_waldump-%%PGVER%%.mo
2654 pgscripts-%%PGVER%%.mo
2656 plpgsql-%%PGVER%%.mo
2657 plpython-%%PGVER%%.mo
2659 postgres-%%PGVER%%.mo
2661 share/locale/sv/LC_MESSAGES/
2663 ecpglib6-%%PGVER%%.mo
2666 pg_archivecleanup-%%PGVER%%.mo
2667 pg_basebackup-%%PGVER%%.mo
2668 pg_config-%%PGVER%%.mo
2669 pg_controldata-%%PGVER%%.mo
2671 pg_dump-%%PGVER%%.mo
2672 pg_resetwal-%%PGVER%%.mo
2673 pg_rewind-%%PGVER%%.mo
2674 pg_test_fsync-%%PGVER%%.mo
2675 pg_test_timing-%%PGVER%%.mo
2676 pg_upgrade-%%PGVER%%.mo
2677 pg_verify_checksums-%%PGVER%%.mo
2678 pg_waldump-%%PGVER%%.mo
2679 pgscripts-%%PGVER%%.mo
2681 plpgsql-%%PGVER%%.mo
2682 plpython-%%PGVER%%.mo
2684 postgres-%%PGVER%%.mo
2686 share/locale/ta/LC_MESSAGES/pg_config-%%PGVER%%.mo
2687 share/locale/tr/LC_MESSAGES/
2689 ecpglib6-%%PGVER%%.mo
2692 pg_archivecleanup-%%PGVER%%.mo
2693 pg_basebackup-%%PGVER%%.mo
2694 pg_config-%%PGVER%%.mo
2695 pg_controldata-%%PGVER%%.mo
2697 pg_dump-%%PGVER%%.mo
2698 pg_resetwal-%%PGVER%%.mo
2699 pg_rewind-%%PGVER%%.mo
2700 pg_test_fsync-%%PGVER%%.mo
2701 pg_test_timing-%%PGVER%%.mo
2702 pg_upgrade-%%PGVER%%.mo
2703 pg_verify_checksums-%%PGVER%%.mo
2704 pg_waldump-%%PGVER%%.mo
2705 pgscripts-%%PGVER%%.mo
2707 plpgsql-%%PGVER%%.mo
2708 plpython-%%PGVER%%.mo
2710 postgres-%%PGVER%%.mo
2712 share/locale/vi/LC_MESSAGES/
2714 ecpglib6-%%PGVER%%.mo
2716 pg_archivecleanup-%%PGVER%%.mo
2717 pg_basebackup-%%PGVER%%.mo
2718 pg_config-%%PGVER%%.mo
2719 pg_controldata-%%PGVER%%.mo
2720 pg_test_fsync-%%PGVER%%.mo
2721 pg_test_timing-%%PGVER%%.mo
2722 pg_waldump-%%PGVER%%.mo
2724 plpgsql-%%PGVER%%.mo
2725 plpython-%%PGVER%%.mo
2727 share/locale/zh_CN/LC_MESSAGES/
2729 ecpglib6-%%PGVER%%.mo
2732 pg_archivecleanup-%%PGVER%%.mo
2733 pg_basebackup-%%PGVER%%.mo
2734 pg_config-%%PGVER%%.mo
2735 pg_controldata-%%PGVER%%.mo
2737 pg_dump-%%PGVER%%.mo
2738 pg_resetwal-%%PGVER%%.mo
2739 pg_rewind-%%PGVER%%.mo
2740 pg_test_fsync-%%PGVER%%.mo
2741 pg_test_timing-%%PGVER%%.mo
2742 pg_upgrade-%%PGVER%%.mo
2743 pg_verify_checksums-%%PGVER%%.mo
2744 pg_waldump-%%PGVER%%.mo
2745 pgscripts-%%PGVER%%.mo
2747 plpgsql-%%PGVER%%.mo
2748 plpython-%%PGVER%%.mo
2750 postgres-%%PGVER%%.mo
2752 share/locale/zh_TW/LC_MESSAGES/
2754 pg_config-%%PGVER%%.mo
2757 [FILE:399:patches/patch-configure]
2758 --- configure.orig 2022-11-07 21:49:11 UTC
2760 @@ -11884,7 +11884,7 @@ if ac_fn_c_try_link "$LINENO"; then :
2761 # recognize dependent libraries; assume curses is needed if we didn't
2762 # find any dependency.
2764 - netbsd* | openbsd* | irix*)
2766 if test x"$pgac_lib" = x"" ; then
2767 pgac_lib=" -lcurses"
2771 [FILE:349:patches/patch-doc-Makefile]
2772 --- doc/Makefile.orig 2022-11-07 21:49:11 UTC
2774 @@ -12,5 +12,5 @@ subdir = doc
2776 include $(top_builddir)/src/Makefile.global
2778 -all distprep html man install installdirs uninstall clean distclean maintainer-clean:
2779 +all distprep man install installdirs uninstall clean distclean maintainer-clean:
2783 [FILE:1196:patches/patch-doc_src_sgml_Makefile]
2784 --- doc/src/sgml/Makefile.orig 2022-11-07 21:49:11 UTC
2785 +++ doc/src/sgml/Makefile
2788 # Make "html" the default target, since that is what most people tend
2793 # We don't need the tree-wide headers or install support here.
2794 NO_GENERATED_HEADERS=yes
2795 @@ -26,7 +26,7 @@ top_builddir = ../../..
2796 include $(top_builddir)/src/Makefile.global
2802 distprep: html distprep-man
2804 @@ -62,8 +62,6 @@ ALLSGML := $(wildcard $(srcdir)/*.sgml $
2808 -man distprep-man: man-stamp
2810 man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML)
2811 $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^)
2812 $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $(wordlist 1,2,$^)
2813 @@ -212,10 +210,10 @@ check: postgres.sgml $(ALLSGML) check-ta
2817 -install: install-html install-man
2818 +install: install-man
2821 - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2822 + $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2824 # If the install used a man directory shared with other applications, this will remove all files.
2828 [FILE:498:patches/patch-src-backend-Makefile]
2829 --- src/backend/Makefile.orig 2022-11-07 21:49:11 UTC
2830 +++ src/backend/Makefile
2831 @@ -113,6 +113,8 @@ endif # aix
2833 $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport
2835 +symlinks: $(top_builddir)/src/include/parser/gram.h $(top_builddir)/src/include/utils/fmgroids.h $(top_builddir)/src/include/utils/probes.h $(top_builddir)/src/include/storage/lwlocknames.h
2838 # The postgres.o target is needed by the rule in Makefile.global that
2839 # creates the exports file when MAKE_EXPORTS = true.
2842 [FILE:865:patches/patch-src_Makefile.shlib]
2843 --- src/Makefile.shlib.orig 2022-11-07 21:49:11 UTC
2844 +++ src/Makefile.shlib
2845 @@ -179,6 +179,9 @@ endif
2847 ifeq ($(PORTNAME), netbsd)
2849 + ifdef SO_MAJOR_VERSION
2850 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2852 LINK.shared = $(COMPILER) -shared
2854 LINK.shared += -Wl,-x,-soname,$(soname)
2855 @@ -228,6 +231,9 @@ endif
2857 ifeq ($(PORTNAME), linux)
2858 LINK.shared = $(COMPILER) -shared
2859 + ifdef SO_MAJOR_VERSION
2860 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2863 LINK.shared += -Wl,-soname,$(soname)
2865 @@ -239,6 +245,9 @@ ifeq ($(PORTNAME), linux)
2868 ifeq ($(PORTNAME), solaris)
2869 + ifdef SO_MAJOR_VERSION
2870 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2873 LINK.shared = $(COMPILER) -shared -Wl,-Bsymbolic
2877 [FILE:685:patches/patch-src_backend_utils_misc_postgresql.conf.sample]
2878 --- src/backend/utils/misc/postgresql.conf.sample.orig 2022-11-07 21:49:11 UTC
2879 +++ src/backend/utils/misc/postgresql.conf.sample
2884 +log_destination = 'syslog'
2885 #log_destination = 'stderr' # Valid values are combinations of
2886 # stderr, csvlog, syslog, and eventlog,
2887 # depending on platform. csvlog
2890 #cluster_name = '' # added to process titles if nonempty
2891 # (change requires restart)
2892 -#update_process_title = on
2894 +# On FreeBSD, this is a performance hog, so keep it off if you need speed
2895 +update_process_title = off
2898 #------------------------------------------------------------------------------
2901 [FILE:3090:files/502.pgsql.in]
2904 # Maintenance shell script to vacuum and backup database
2905 # Put this in /usr/local/etc/periodic/daily, and it will be run
2908 # Written by Palle Girgensohn <girgen@pingpong.net>
2910 # In public domain, do what you like with it,
2911 # and use it at your own risk... :)
2914 # Define these variables in either /etc/periodic.conf or
2915 # /etc/periodic.conf.local to override the default values.
2917 # daily_pgsql_backup_enable="YES" # do backup of all databases
2918 # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases
2919 # daily_pgsql_vacuum_enable="YES" # do vacuum
2921 # If there is a global system configuration file, suck it in.
2923 if [ -r /etc/defaults/periodic.conf ]
2925 . /etc/defaults/periodic.conf
2926 source_periodic_confs
2929 : ${daily_pgsql_user:="%%PG_USER%%"}
2930 : ${daily_pgsql_port:=5432}
2931 : ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"}
2932 : ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"}
2933 : ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"}
2934 # backupdir is relative to ~pgsql home directory unless it begins with a slash:
2935 : ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"}
2936 : ${daily_pgsql_savedays:="7"}
2938 # allow '~ยด in dir name
2939 eval backupdir=${daily_pgsql_backupdir}
2944 # daily_pgsql_backupdir must be writeable by user %%PG_USER%%
2945 # ~%%PG_USER%% is just that under normal circumstances,
2946 # but this might not be where you want the backups...
2947 if [ ! -d ${backupdir} ] ; then
2948 echo Creating ${backupdir}
2949 mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir}
2953 echo "PostgreSQL backups"
2958 now=`date "+%Y-%m-%dT%H:%M:%S"`
2959 file=${daily_pgsql_backupdir}/pgglobals_${now}
2960 su -l ${daily_pgsql_user} -c \
2961 "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz"
2966 file=${backupdir}/pgdump_${db}_${now}
2967 su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
2968 [ $? -gt 0 ] && rc=3
2972 if [ $rc -gt 0 ]; then
2974 echo "Errors were reported during backup."
2977 # cleaning up old data
2978 find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \
2979 -a -mtime +${daily_pgsql_savedays} -delete
2983 case "$daily_pgsql_backup_enable" in
2985 dbnames=`su -l ${daily_pgsql_user} -c "umask 077; psql -U ${daily_pgsql_user} -p ${daily_pgsql_port} -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"`
2986 pgsql_backup $dbnames
2996 pgsql_backup $daily_pgsql_backup_enable
3000 case "$daily_pgsql_vacuum_enable" in
3004 echo "PostgreSQL vacuum"
3005 su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}"
3009 echo "Errors were reported during vacuum."
3018 [FILE:3182:files/postgresql.in]
3021 # PROVIDE: postgresql
3025 # Add the following line to /etc/rc.conf to enable PostgreSQL:
3027 # postgresql_enable="YES"
3029 # postgresql_data="%%PREFIX%%/%%PG_USER%%/%%DATADIR%%"
3030 # postgresql_flags="-w -s -m fast"
3031 # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
3032 # postgresql_class="default"
3033 # postgresql_profiles=""
3035 # See %%PREFIX%%/share/doc/postgresql/README-server for more info
3037 # This scripts takes one of the following commands:
3039 # start stop restart reload status initdb
3041 # For postmaster startup options, edit ${postgresql_data}/postgresql.conf
3043 command=%%PREFIX%%/bin/pg_ctl
3047 load_rc_config postgresql
3050 postgresql_enable=${postgresql_enable:-"NO"}
3051 postgresql_flags=${postgresql_flags:-"-w -s -m fast"}
3052 postgresql_user=${postgresql_user:-"%%PG_USER%%"}
3053 eval postgresql_data=${postgresql_data:-"~${postgresql_user}/%%DATADIR%%"}
3054 postgresql_class=${postgresql_class:-"default"}
3055 postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"}
3058 rcvar=postgresql_enable
3059 extra_commands="reload initdb"
3061 start_cmd="postgresql_command start"
3062 stop_cmd="postgresql_command stop"
3063 restart_cmd="postgresql_command restart"
3064 reload_cmd="postgresql_command reload"
3065 status_cmd="postgresql_command status"
3067 initdb_cmd="postgresql_initdb"
3069 if [ -n "$2" ]; then
3071 if [ "x${postgresql_profiles}" != "x" ]; then
3072 eval postgresql_data="\${postgresql_${profile}_data:-}"
3073 if [ "x${postgresql_data}" = "x" ]; then
3074 echo "You must define a data directory (postgresql_${profile}_data)"
3077 eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}"
3078 eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}"
3079 eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}"
3080 eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}"
3083 if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then
3084 for profile in ${postgresql_profiles}; do
3085 eval _enable="\${postgresql_${profile}_enable}"
3086 case "x${_enable:-${postgresql_enable}}" in
3087 x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee])
3093 if test -z "$_enable"; then
3094 _var=postgresql_enable
3096 _var=postgresql_"${profile}"_enable
3099 "'${_enable:-${postgresql_enable}}'" \
3101 "Profile ${profile} skipped."
3105 echo "===> postgresql profile: ${profile}"
3106 %%PREFIX%%/etc/rc.d/postgresql $1 ${profile}
3108 if [ "0${retcode}" -ne 0 ]; then
3109 failed="${profile} (${retcode}) ${failed:-}"
3111 success="${profile} ${success:-}"
3118 command_args="-D ${postgresql_data} ${postgresql_flags}"
3120 postgresql_command()
3122 su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
3127 su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}"