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/v12.13
14 DISTFILE[1]= postgresql-12.13.tar.bz2:main
15 DIST_SUBDIR= postgresql
17 SPKGS[standard]= complete
27 OPTIONS_AVAILABLE= none
28 OPTIONS_STANDARD= none
30 BUILD_DEPENDS= docbook-sgml:single:standard
31 docbook-dsssl:single:standard
32 openjade:single:standard
33 OpenSP:single:standard
34 readline:single:standard
35 BUILDRUN_DEPENDS= libxslt:single:standard
36 B_DEPS[sunos]= ossp-uuid:dev:standard
37 B_DEPS[linux]= ossp-uuid:dev:standard
38 BR_DEPS[sunos]= ossp-uuid:primary:standard
39 BR_DEPS[linux]= ossp-uuid:primary:standard
40 BR_DEPS[darwin]= libuuid:single:standard
42 EXRUN[plpython]= python
43 EXRUN[client]= gettext:primary:standard
44 libxslt:single:standard
45 readline:single:standard
48 EXRUN[contrib]= postgresql12:client:standard
49 libxslt:single:standard
51 gettext:primary:standard
54 EXRUN[server]= postgresql12:client:standard
58 USERGROUP_SPKG= server
60 USES= bison gmake perl:build tcl:build ssl python:build
63 DISTNAME= postgresql-12.13
65 LICENSE= PostgreSQL:server
66 LICENSE_FILE= PostgreSQL:{{WRKSRC}}/COPYRIGHT
69 CPE_PRODUCT= postgresql
70 CPE_VENDOR= postgresql
71 FPC_EQUIVALENT= databases/postgresql12-server
74 CONFIGURE_ARGS= --with-libraries="{{PREFIX}}/lib"
75 --with-includes="{{PREFIX}}/include:{{TCL_INCLUDEDIR}}"
76 --with-tclconfig="{{TCL_LIBDIR}}"
85 CONFIGURE_ENV= PTHREAD_LIBS="-lpthread"
87 pgac_cv_path_stylesheets={{PREFIX}}/share/sgml/docbook/dsssl/modular
90 MAKE_ENV= TCL_INCDIR="{{TCL_INCLUDEDIR}}"
92 INSTALL_TARGET= install-world
94 RC_SUBR= postgresql:server
96 SUB_LIST= PG_GROUP=pgsql
102 VAR_OPSYS[freebsd]= CONFIGURE_ARGS=--with-template=freebsd
103 CONFIGURE_ARGS=--with-uuid=bsd
104 VAR_OPSYS[sunos]= CONFIGURE_ENV=ac_cv_search_bind_textdomain_codeset=-lintl
105 CONFIGURE_ARGS=--with-template=solaris
106 CONFIGURE_ARGS=--with-uuid=ossp
107 VAR_OPSYS[linux]= CONFIGURE_ARGS=--with-template=linux
108 CONFIGURE_ARGS=--with-uuid=ossp
109 VAR_OPSYS[darwin]= CONFIGURE_ARGS=--with-template=darwin
110 CONFIGURE_ARGS=--with-uuid=e2fs
111 VAR_OPSYS[netbsd]= CONFIGURE_ARGS=--with-template=netbsd
112 CONFIGURE_ARGS=--with-uuid=bsd
113 VAR_OPSYS[openbsd]= CONFIGURE_ARGS=--with-template=openbsd
114 CONFIGURE_ARGS=--with-uuid=bsd
115 VAR_OPSYS[dragonfly]= CONFIGURE_ARGS=--with-template=freebsd
116 CONFIGURE_ARGS=--with-uuid=bsd
119 @${MKDIR} ${STAGEDIR}${PREFIX}/etc/periodic/daily
120 ${INSTALL_SCRIPT} ${WRKDIR}/502.pgsql \
121 ${STAGEDIR}${PREFIX}/etc/periodic/daily
122 # install-world doesn't strip (and install-strip won't install enough)
123 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so
124 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/*.${LIBEXT}
125 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/regress/pg_regress
126 list=$$(${LS} ${STAGEDIR}${PREFIX}/bin/* | ${GREP} -v pltcl_); \
127 ${STRIP_CMD} $${list}
130 ${REINPLACE_CMD} -e '/sqlmansect/d' \
131 ${WRKSRC}/src/makefiles/Makefile.solaris
133 [FILE:1220:descriptions/desc.server]
134 PostgreSQL is a sophisticated Object-Relational DBMS, supporting
135 almost all SQL constructs, including subselects, transactions, and
136 user-defined types and functions. It is the most advanced open-source
137 database available anywhere. Commercial Support is also available.
139 The original Postgres code was the effort of many graduate students,
140 undergraduate students, and staff programmers working under the direction
141 of Professor Michael Stonebraker at the University of California,
142 Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting
143 the DBMS query language to SQL and created a new database system which came
144 to known as Postgres95. Many others contributed to the porting, testing,
145 debugging and enhancement of the Postgres95 code. As the code improved,
146 and 1995 faded into memory, PostgreSQL was born.
148 PostgreSQL development is presently being performed by a team of developers
149 who are now responsible for all current and future development. The
150 development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG).
151 Support is available from the PostgreSQL developer/user community through
152 the support mailing list (questions@PostgreSQL.ORG).
154 This subpackage contains the PostgreSQL server.
157 [FILE:48:descriptions/desc.client]
158 This subpackage contains the PostgreSQL client.
161 [FILE:60:descriptions/desc.contrib]
162 This subpackage contains the contrib modules of PostgreSQL.
165 [FILE:74:descriptions/desc.plperl]
166 This subpackage contains Perl Procedural Language support for PostgreSQL.
169 [FILE:76:descriptions/desc.plpython]
170 This subpackage contains Python Procedural Language support for PostgreSQL.
173 [FILE:73:descriptions/desc.pltcl]
174 This subpackage contains Tcl Procedural Language support for PostgreSQL.
178 b6c623046af4548f11a84b407934d675d11ed070c793d15b04683bf5f322e02d 21114311 postgresql/postgresql-12.13.tar.bz2
181 [FILE:8671:manifests/plist.server]
198 etc/periodic/daily/502.pgsql
199 include/postgresql/server/plpgsql.h
200 include/postgresql/server/common/connect.h
203 amcheck.%%SHARED_OBJECT%%
204 ascii_and_mic.%%SHARED_OBJECT%%
205 cyrillic_and_mic.%%SHARED_OBJECT%%
206 dict_snowball.%%SHARED_OBJECT%%
207 euc2004_sjis2004.%%SHARED_OBJECT%%
208 euc_cn_and_mic.%%SHARED_OBJECT%%
209 euc_jp_and_sjis.%%SHARED_OBJECT%%
210 euc_kr_and_mic.%%SHARED_OBJECT%%
211 euc_tw_and_big5.%%SHARED_OBJECT%%
212 latin2_and_win1250.%%SHARED_OBJECT%%
213 latin_and_mic.%%SHARED_OBJECT%%
214 libpqwalreceiver.%%SHARED_OBJECT%%
215 pgoutput.%%SHARED_OBJECT%%
216 plpgsql.%%SHARED_OBJECT%%
217 utf8_and_ascii.%%SHARED_OBJECT%%
218 utf8_and_big5.%%SHARED_OBJECT%%
219 utf8_and_cyrillic.%%SHARED_OBJECT%%
220 utf8_and_euc2004.%%SHARED_OBJECT%%
221 utf8_and_euc_cn.%%SHARED_OBJECT%%
222 utf8_and_euc_jp.%%SHARED_OBJECT%%
223 utf8_and_euc_kr.%%SHARED_OBJECT%%
224 utf8_and_euc_tw.%%SHARED_OBJECT%%
225 utf8_and_gb18030.%%SHARED_OBJECT%%
226 utf8_and_gbk.%%SHARED_OBJECT%%
227 utf8_and_iso8859.%%SHARED_OBJECT%%
228 utf8_and_iso8859_1.%%SHARED_OBJECT%%
229 utf8_and_johab.%%SHARED_OBJECT%%
230 utf8_and_sjis.%%SHARED_OBJECT%%
231 utf8_and_sjis2004.%%SHARED_OBJECT%%
232 utf8_and_uhc.%%SHARED_OBJECT%%
233 utf8_and_win.%%SHARED_OBJECT%%
235 information_schema.sql
240 postgres.shdescription
241 postgresql.conf.sample
245 share/postgresql/extension/
247 plpgsql--unpackaged--1.0.sql
249 share/postgresql/timezone/
296 share/postgresql/timezone/Africa/
351 share/postgresql/timezone/America/
493 share/postgresql/timezone/America/Argentina/
507 share/postgresql/timezone/America/Indiana/
516 share/postgresql/timezone/America/Kentucky/
519 share/postgresql/timezone/America/North_Dakota/
523 share/postgresql/timezone/Antarctica/
536 share/postgresql/timezone/Arctic/Longyearbyen
537 share/postgresql/timezone/Asia/
637 share/postgresql/timezone/Atlantic/
650 share/postgresql/timezone/Australia/
674 share/postgresql/timezone/Brazil/
679 share/postgresql/timezone/Canada/
688 share/postgresql/timezone/Chile/
691 share/postgresql/timezone/Etc/
727 share/postgresql/timezone/Europe/
792 share/postgresql/timezone/Indian/
804 share/postgresql/timezone/Mexico/
808 share/postgresql/timezone/Pacific/
853 share/postgresql/timezone/US/
866 share/postgresql/timezonesets/
880 share/postgresql/tsearch_data/
888 hunspell_sample.affix
889 hunspell_sample_long.affix
890 hunspell_sample_long.dict
891 hunspell_sample_num.affix
892 hunspell_sample_num.dict
907 [FILE:19803:manifests/plist.client]
910 libecpg_compat.so.3.11
954 include/libpq/libpq-fs.h
955 include/postgresql/informix/esql/
959 include/postgresql/internal/
965 include/postgresql/internal/libpq/pqcomm.h
966 include/postgresql/server/
988 include/postgresql/server/access/
1064 include/postgresql/server/bootstrap/bootstrap.h
1065 include/postgresql/server/catalog/
1108 pg_db_role_setting.h
1109 pg_db_role_setting_d.h
1119 pg_event_trigger_d.h
1122 pg_foreign_data_wrapper.h
1123 pg_foreign_data_wrapper_d.h
1125 pg_foreign_server_d.h
1127 pg_foreign_table_d.h
1138 pg_largeobject_metadata.h
1139 pg_largeobject_metadata_d.h
1148 pg_partitioned_table.h
1149 pg_partitioned_table_d.h
1158 pg_publication_rel.h
1159 pg_publication_rel_d.h
1162 pg_replication_origin.h
1163 pg_replication_origin_d.h
1173 pg_shdescription_d.h
1179 pg_statistic_ext_d.h
1180 pg_statistic_ext_data.h
1181 pg_statistic_ext_data_d.h
1184 pg_subscription_rel.h
1185 pg_subscription_rel_d.h
1195 pg_ts_config_map_d.h
1210 include/postgresql/server/commands/
1246 include/postgresql/server/common/
1270 unicode_norm_table.h
1272 include/postgresql/server/datatype/timestamp.h
1273 include/postgresql/server/executor/
1286 nodeBitmapHeapscan.h
1287 nodeBitmapIndexscan.h
1306 nodeNamedtuplestorescan.h
1309 nodeRecursiveunion.h
1329 include/postgresql/server/extension/cube/cubedata.h
1330 include/postgresql/server/extension/hstore/hstore.h
1331 include/postgresql/server/extension/isn/isn.h
1332 include/postgresql/server/extension/ltree/ltree.h
1333 include/postgresql/server/extension/seg/segdata.h
1334 include/postgresql/server/fe_utils/
1343 include/postgresql/server/foreign/
1346 include/postgresql/server/jit/
1350 include/postgresql/server/lib/
1363 include/postgresql/server/libpq/
1378 include/postgresql/server/mb/pg_wchar.h
1379 include/postgresql/server/nodes/
1400 include/postgresql/server/optimizer/
1411 geqo_recombination.h
1428 include/postgresql/server/parser/
1452 include/postgresql/server/partitioning/
1457 include/postgresql/server/port/
1473 include/postgresql/server/port/atomics/
1486 include/postgresql/server/port/win32/
1491 include/postgresql/server/port/win32/arpa/inet.h
1492 include/postgresql/server/port/win32/netinet/in.h
1493 include/postgresql/server/port/win32/sys/
1496 include/postgresql/server/port/win32_msvc/
1500 include/postgresql/server/port/win32_msvc/sys/
1504 include/postgresql/server/portability/
1507 include/postgresql/server/postmaster/
1510 bgworker_internals.h
1518 include/postgresql/server/regex/
1524 include/postgresql/server/replication/
1545 include/postgresql/server/rewrite/
1553 include/postgresql/server/snowball/header.h
1554 include/postgresql/server/snowball/libstemmer/
1557 stem_ISO_8859_1_danish.h
1558 stem_ISO_8859_1_dutch.h
1559 stem_ISO_8859_1_english.h
1560 stem_ISO_8859_1_finnish.h
1561 stem_ISO_8859_1_french.h
1562 stem_ISO_8859_1_german.h
1563 stem_ISO_8859_1_indonesian.h
1564 stem_ISO_8859_1_irish.h
1565 stem_ISO_8859_1_italian.h
1566 stem_ISO_8859_1_norwegian.h
1567 stem_ISO_8859_1_porter.h
1568 stem_ISO_8859_1_portuguese.h
1569 stem_ISO_8859_1_spanish.h
1570 stem_ISO_8859_1_swedish.h
1571 stem_ISO_8859_2_hungarian.h
1572 stem_ISO_8859_2_romanian.h
1573 stem_KOI8_R_russian.h
1577 stem_UTF_8_english.h
1578 stem_UTF_8_finnish.h
1581 stem_UTF_8_hungarian.h
1582 stem_UTF_8_indonesian.h
1584 stem_UTF_8_italian.h
1585 stem_UTF_8_lithuanian.h
1587 stem_UTF_8_norwegian.h
1589 stem_UTF_8_portuguese.h
1590 stem_UTF_8_romanian.h
1591 stem_UTF_8_russian.h
1592 stem_UTF_8_spanish.h
1593 stem_UTF_8_swedish.h
1595 stem_UTF_8_turkish.h
1596 include/postgresql/server/statistics/
1597 extended_stats_internal.h
1599 include/postgresql/server/storage/
1610 condition_variable.h
1635 predicate_internals.h
1655 include/postgresql/server/tcop/
1662 include/postgresql/server/tsearch/
1668 include/postgresql/server/tsearch/dicts/
1671 include/postgresql/server/utils/
1782 lib/postgresql/pgxs/config/
1785 lib/postgresql/pgxs/src/
1790 lib/postgresql/pgxs/src/makefiles/pgxs.mk
1791 lib/postgresql/pgxs/src/test/regress/pg_regress
1801 pg_archivecleanup.1.gz
1829 SPI_commit_and_chain.3.gz
1831 SPI_connect_ext.3.gz
1833 SPI_cursor_close.3.gz
1834 SPI_cursor_fetch.3.gz
1835 SPI_cursor_find.3.gz
1836 SPI_cursor_move.3.gz
1837 SPI_cursor_open.3.gz
1838 SPI_cursor_open_with_args.3.gz
1839 SPI_cursor_open_with_paramlist.3.gz
1843 SPI_execute_plan.3.gz
1844 SPI_execute_plan_with_paramlist.3.gz
1845 SPI_execute_with_args.3.gz
1851 SPI_freetuptable.3.gz
1852 SPI_getargcount.3.gz
1853 SPI_getargtypeid.3.gz
1860 SPI_is_cursor_plan.3.gz
1862 SPI_modifytuple.3.gz
1866 SPI_prepare_cursor.3.gz
1867 SPI_prepare_params.3.gz
1868 SPI_register_relation.3.gz
1869 SPI_register_trigger_data.3.gz
1871 SPI_result_code_string.3.gz
1872 SPI_returntuple.3.gz
1874 SPI_rollback_and_chain.3.gz
1876 SPI_scroll_cursor_fetch.3.gz
1877 SPI_scroll_cursor_move.3.gz
1878 SPI_start_transaction.3.gz
1879 SPI_unregister_relation.3.gz
1881 dblink_build_sql_delete.3.gz
1882 dblink_build_sql_insert.3.gz
1883 dblink_build_sql_update.3.gz
1884 dblink_cancel_query.3.gz
1887 dblink_connect_u.3.gz
1888 dblink_disconnect.3.gz
1889 dblink_error_message.3.gz
1892 dblink_get_connections.3.gz
1893 dblink_get_notify.3.gz
1894 dblink_get_pkey.3.gz
1895 dblink_get_result.3.gz
1898 dblink_send_query.3.gz
1901 ALTER_AGGREGATE.7.gz
1902 ALTER_COLLATION.7.gz
1903 ALTER_CONVERSION.7.gz
1905 ALTER_DEFAULT_PRIVILEGES.7.gz
1907 ALTER_EVENT_TRIGGER.7.gz
1908 ALTER_EXTENSION.7.gz
1909 ALTER_FOREIGN_DATA_WRAPPER.7.gz
1910 ALTER_FOREIGN_TABLE.7.gz
1915 ALTER_LARGE_OBJECT.7.gz
1916 ALTER_MATERIALIZED_VIEW.7.gz
1918 ALTER_OPERATOR_CLASS.7.gz
1919 ALTER_OPERATOR_FAMILY.7.gz
1921 ALTER_PROCEDURE.7.gz
1922 ALTER_PUBLICATION.7.gz
1929 ALTER_STATISTICS.7.gz
1930 ALTER_SUBSCRIPTION.7.gz
1933 ALTER_TABLESPACE.7.gz
1934 ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
1935 ALTER_TEXT_SEARCH_DICTIONARY.7.gz
1936 ALTER_TEXT_SEARCH_PARSER.7.gz
1937 ALTER_TEXT_SEARCH_TEMPLATE.7.gz
1941 ALTER_USER_MAPPING.7.gz
1951 COMMIT_PREPARED.7.gz
1953 CREATE_ACCESS_METHOD.7.gz
1954 CREATE_AGGREGATE.7.gz
1956 CREATE_COLLATION.7.gz
1957 CREATE_CONVERSION.7.gz
1958 CREATE_DATABASE.7.gz
1960 CREATE_EVENT_TRIGGER.7.gz
1961 CREATE_EXTENSION.7.gz
1962 CREATE_FOREIGN_DATA_WRAPPER.7.gz
1963 CREATE_FOREIGN_TABLE.7.gz
1964 CREATE_FUNCTION.7.gz
1967 CREATE_LANGUAGE.7.gz
1968 CREATE_MATERIALIZED_VIEW.7.gz
1969 CREATE_OPERATOR.7.gz
1970 CREATE_OPERATOR_CLASS.7.gz
1971 CREATE_OPERATOR_FAMILY.7.gz
1973 CREATE_PROCEDURE.7.gz
1974 CREATE_PUBLICATION.7.gz
1978 CREATE_SEQUENCE.7.gz
1980 CREATE_STATISTICS.7.gz
1981 CREATE_SUBSCRIPTION.7.gz
1983 CREATE_TABLESPACE.7.gz
1984 CREATE_TABLE_AS.7.gz
1985 CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
1986 CREATE_TEXT_SEARCH_DICTIONARY.7.gz
1987 CREATE_TEXT_SEARCH_PARSER.7.gz
1988 CREATE_TEXT_SEARCH_TEMPLATE.7.gz
1989 CREATE_TRANSFORM.7.gz
1993 CREATE_USER_MAPPING.7.gz
2000 DROP_ACCESS_METHOD.7.gz
2004 DROP_CONVERSION.7.gz
2007 DROP_EVENT_TRIGGER.7.gz
2009 DROP_FOREIGN_DATA_WRAPPER.7.gz
2010 DROP_FOREIGN_TABLE.7.gz
2015 DROP_MATERIALIZED_VIEW.7.gz
2017 DROP_OPERATOR_CLASS.7.gz
2018 DROP_OPERATOR_FAMILY.7.gz
2022 DROP_PUBLICATION.7.gz
2029 DROP_STATISTICS.7.gz
2030 DROP_SUBSCRIPTION.7.gz
2032 DROP_TABLESPACE.7.gz
2033 DROP_TEXT_SEARCH_CONFIGURATION.7.gz
2034 DROP_TEXT_SEARCH_DICTIONARY.7.gz
2035 DROP_TEXT_SEARCH_PARSER.7.gz
2036 DROP_TEXT_SEARCH_TEMPLATE.7.gz
2041 DROP_USER_MAPPING.7.gz
2048 IMPORT_FOREIGN_SCHEMA.7.gz
2056 PREPARE_TRANSACTION.7.gz
2058 REFRESH_MATERIALIZED_VIEW.7.gz
2060 RELEASE_SAVEPOINT.7.gz
2064 ROLLBACK_PREPARED.7.gz
2065 ROLLBACK_TO_SAVEPOINT.7.gz
2071 SET_CONSTRAINTS.7.gz
2073 SET_SESSION_AUTHORIZATION.7.gz
2074 SET_TRANSACTION.7.gz
2076 START_TRANSACTION.7.gz
2086 pg_service.conf.sample
2090 [FILE:6262:manifests/plist.contrib]
2096 _int.%%SHARED_OBJECT%%
2097 adminpack.%%SHARED_OBJECT%%
2098 auth_delay.%%SHARED_OBJECT%%
2099 auto_explain.%%SHARED_OBJECT%%
2100 autoinc.%%SHARED_OBJECT%%
2101 bloom.%%SHARED_OBJECT%%
2102 btree_gin.%%SHARED_OBJECT%%
2103 btree_gist.%%SHARED_OBJECT%%
2104 citext.%%SHARED_OBJECT%%
2105 cube.%%SHARED_OBJECT%%
2106 dblink.%%SHARED_OBJECT%%
2107 dict_int.%%SHARED_OBJECT%%
2108 dict_xsyn.%%SHARED_OBJECT%%
2109 earthdistance.%%SHARED_OBJECT%%
2110 file_fdw.%%SHARED_OBJECT%%
2111 fuzzystrmatch.%%SHARED_OBJECT%%
2112 hstore.%%SHARED_OBJECT%%
2113 insert_username.%%SHARED_OBJECT%%
2114 isn.%%SHARED_OBJECT%%
2115 lo.%%SHARED_OBJECT%%
2116 ltree.%%SHARED_OBJECT%%
2117 moddatetime.%%SHARED_OBJECT%%
2118 pageinspect.%%SHARED_OBJECT%%
2119 passwordcheck.%%SHARED_OBJECT%%
2120 pg_buffercache.%%SHARED_OBJECT%%
2121 pg_freespacemap.%%SHARED_OBJECT%%
2122 pg_prewarm.%%SHARED_OBJECT%%
2123 pg_stat_statements.%%SHARED_OBJECT%%
2124 pg_trgm.%%SHARED_OBJECT%%
2125 pg_visibility.%%SHARED_OBJECT%%
2126 pgcrypto.%%SHARED_OBJECT%%
2127 pgrowlocks.%%SHARED_OBJECT%%
2128 pgstattuple.%%SHARED_OBJECT%%
2129 pgxml.%%SHARED_OBJECT%%
2130 postgres_fdw.%%SHARED_OBJECT%%
2131 refint.%%SHARED_OBJECT%%
2132 seg.%%SHARED_OBJECT%%
2133 sslinfo.%%SHARED_OBJECT%%
2134 tablefunc.%%SHARED_OBJECT%%
2135 tcn.%%SHARED_OBJECT%%
2136 test_decoding.%%SHARED_OBJECT%%
2137 tsm_system_rows.%%SHARED_OBJECT%%
2138 tsm_system_time.%%SHARED_OBJECT%%
2139 unaccent.%%SHARED_OBJECT%%
2140 uuid-ossp.%%SHARED_OBJECT%%
2141 share/postgresql/extension/
2142 adminpack--1.0--1.1.sql
2144 adminpack--1.1--2.0.sql
2146 amcheck--1.0--1.1.sql
2148 amcheck--1.1--1.2.sql
2151 autoinc--unpackaged--1.0.sql
2155 btree_gin--1.0--1.1.sql
2157 btree_gin--1.1--1.2.sql
2158 btree_gin--1.2--1.3.sql
2159 btree_gin--unpackaged--1.0.sql
2161 btree_gist--1.0--1.1.sql
2162 btree_gist--1.1--1.2.sql
2163 btree_gist--1.2--1.3.sql
2165 btree_gist--1.3--1.4.sql
2166 btree_gist--1.4--1.5.sql
2167 btree_gist--unpackaged--1.0.sql
2169 citext--1.0--1.1.sql
2170 citext--1.1--1.2.sql
2171 citext--1.2--1.3.sql
2172 citext--1.3--1.4.sql
2173 citext--1.4--1.5.sql
2175 citext--1.5--1.6.sql
2176 citext--unpackaged--1.0.sql
2183 cube--unpackaged--1.0.sql
2185 dblink--1.0--1.1.sql
2186 dblink--1.1--1.2.sql
2188 dblink--unpackaged--1.0.sql
2191 dict_int--unpackaged--1.0.sql
2194 dict_xsyn--unpackaged--1.0.sql
2196 earthdistance--1.0--1.1.sql
2197 earthdistance--1.1.sql
2198 earthdistance--unpackaged--1.0.sql
2199 earthdistance.control
2202 fuzzystrmatch--1.0--1.1.sql
2203 fuzzystrmatch--1.1.sql
2204 fuzzystrmatch--unpackaged--1.0.sql
2205 fuzzystrmatch.control
2206 hstore--1.0--1.1.sql
2207 hstore--1.1--1.2.sql
2208 hstore--1.2--1.3.sql
2209 hstore--1.3--1.4.sql
2210 hstore--1.4--1.5.sql
2212 hstore--1.5--1.6.sql
2213 hstore--unpackaged--1.0.sql
2215 insert_username--1.0.sql
2216 insert_username--unpackaged--1.0.sql
2217 insert_username.control
2218 intagg--1.0--1.1.sql
2220 intagg--unpackaged--1.0.sql
2222 intarray--1.0--1.1.sql
2223 intarray--1.1--1.2.sql
2225 intarray--unpackaged--1.0.sql
2230 isn--unpackaged--1.0.sql
2234 lo--unpackaged--1.0.sql
2238 ltree--unpackaged--1.0.sql
2240 moddatetime--1.0.sql
2241 moddatetime--unpackaged--1.0.sql
2243 pageinspect--1.0--1.1.sql
2244 pageinspect--1.1--1.2.sql
2245 pageinspect--1.2--1.3.sql
2246 pageinspect--1.3--1.4.sql
2247 pageinspect--1.4--1.5.sql
2248 pageinspect--1.5--1.6.sql
2249 pageinspect--1.5.sql
2250 pageinspect--1.6--1.7.sql
2251 pageinspect--unpackaged--1.0.sql
2253 pg_buffercache--1.0--1.1.sql
2254 pg_buffercache--1.1--1.2.sql
2255 pg_buffercache--1.2--1.3.sql
2256 pg_buffercache--1.2.sql
2257 pg_buffercache--unpackaged--1.0.sql
2258 pg_buffercache.control
2259 pg_freespacemap--1.0--1.1.sql
2260 pg_freespacemap--1.1--1.2.sql
2261 pg_freespacemap--1.1.sql
2262 pg_freespacemap--unpackaged--1.0.sql
2263 pg_freespacemap.control
2264 pg_prewarm--1.0--1.1.sql
2265 pg_prewarm--1.1--1.2.sql
2268 pg_stat_statements--1.0--1.1.sql
2269 pg_stat_statements--1.1--1.2.sql
2270 pg_stat_statements--1.2--1.3.sql
2271 pg_stat_statements--1.3--1.4.sql
2272 pg_stat_statements--1.4--1.5.sql
2273 pg_stat_statements--1.4.sql
2274 pg_stat_statements--1.5--1.6.sql
2275 pg_stat_statements--1.6--1.7.sql
2276 pg_stat_statements--unpackaged--1.0.sql
2277 pg_stat_statements.control
2278 pg_trgm--1.0--1.1.sql
2279 pg_trgm--1.1--1.2.sql
2280 pg_trgm--1.2--1.3.sql
2281 pg_trgm--1.3--1.4.sql
2283 pg_trgm--unpackaged--1.0.sql
2285 pg_visibility--1.0--1.1.sql
2286 pg_visibility--1.1--1.2.sql
2287 pg_visibility--1.1.sql
2288 pg_visibility.control
2289 pgcrypto--1.0--1.1.sql
2290 pgcrypto--1.1--1.2.sql
2291 pgcrypto--1.2--1.3.sql
2293 pgcrypto--unpackaged--1.0.sql
2295 pgrowlocks--1.0--1.1.sql
2296 pgrowlocks--1.1--1.2.sql
2298 pgrowlocks--unpackaged--1.0.sql
2300 pgstattuple--1.0--1.1.sql
2301 pgstattuple--1.1--1.2.sql
2302 pgstattuple--1.2--1.3.sql
2303 pgstattuple--1.3--1.4.sql
2304 pgstattuple--1.4--1.5.sql
2305 pgstattuple--1.4.sql
2306 pgstattuple--unpackaged--1.0.sql
2308 postgres_fdw--1.0.sql
2309 postgres_fdw.control
2311 refint--unpackaged--1.0.sql
2317 seg--unpackaged--1.0.sql
2319 sslinfo--1.0--1.1.sql
2320 sslinfo--1.1--1.2.sql
2322 sslinfo--unpackaged--1.0.sql
2325 tablefunc--unpackaged--1.0.sql
2329 tsm_system_rows--1.0.sql
2330 tsm_system_rows.control
2331 tsm_system_time--1.0.sql
2332 tsm_system_time.control
2333 unaccent--1.0--1.1.sql
2335 unaccent--unpackaged--1.0.sql
2337 uuid-ossp--1.0--1.1.sql
2339 uuid-ossp--unpackaged--1.0.sql
2343 xml2--unpackaged--1.0.sql
2345 share/postgresql/tsearch_data/
2350 [FILE:515:manifests/plist.plperl]
2351 include/postgresql/server/
2356 hstore_plperl.%%SHARED_OBJECT%%
2357 jsonb_plperl.%%SHARED_OBJECT%%
2358 plperl.%%SHARED_OBJECT%%
2359 share/postgresql/extension/
2360 hstore_plperl--1.0.sql
2361 hstore_plperl.control
2362 hstore_plperlu--1.0.sql
2363 hstore_plperlu.control
2364 jsonb_plperl--1.0.sql
2365 jsonb_plperl.control
2366 jsonb_plperlu--1.0.sql
2367 jsonb_plperlu.control
2369 plperl--unpackaged--1.0.sql
2372 plperlu--unpackaged--1.0.sql
2376 [FILE:1144:manifests/plist.plpython]
2377 include/postgresql/server/
2387 plpy_subxactobject.h
2392 hstore_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2393 jsonb_plpython3.%%SHARED_OBJECT%%
2394 ltree_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2395 plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2396 lib/postgresql/pgxs/src/pl/plpython/regress-python3-mangle.mk
2397 share/postgresql/extension/
2398 hstore_plpython2u--1.0.sql
2399 hstore_plpython2u.control
2400 hstore_plpython3u--1.0.sql
2401 hstore_plpython3u.control
2402 hstore_plpythonu--1.0.sql
2403 hstore_plpythonu.control
2404 jsonb_plpython2u--1.0.sql
2405 jsonb_plpython2u.control
2406 jsonb_plpython3u--1.0.sql
2407 jsonb_plpython3u.control
2408 jsonb_plpythonu--1.0.sql
2409 jsonb_plpythonu.control
2410 ltree_plpython2u--1.0.sql
2411 ltree_plpython2u.control
2412 ltree_plpython3u--1.0.sql
2413 ltree_plpython3u.control
2414 ltree_plpythonu--1.0.sql
2415 ltree_plpythonu.control
2416 plpython%%PYTHON_MAJOR_VER%%u--1.0.sql
2417 plpython%%PYTHON_MAJOR_VER%%u--unpackaged--1.0.sql
2418 plpython%%PYTHON_MAJOR_VER%%u.control
2421 [FILE:188:manifests/plist.pltcl]
2422 lib/postgresql/pltcl.%%SHARED_OBJECT%%
2423 share/postgresql/extension/
2425 pltcl--unpackaged--1.0.sql
2428 pltclu--unpackaged--1.0.sql
2432 [FILE:111:manifests/plist.docs]
2433 share/doc/postgresql/extension/
2435 insert_username.example
2440 [FILE:7915:manifests/plist.nls]
2441 share/locale/cs/LC_MESSAGES/
2443 ecpglib6-%%PGVER%%.mo
2446 pg_archivecleanup-%%PGVER%%.mo
2447 pg_basebackup-%%PGVER%%.mo
2448 pg_checksums-%%PGVER%%.mo
2449 pg_config-%%PGVER%%.mo
2450 pg_controldata-%%PGVER%%.mo
2452 pg_dump-%%PGVER%%.mo
2453 pg_resetwal-%%PGVER%%.mo
2454 pg_rewind-%%PGVER%%.mo
2455 pg_test_fsync-%%PGVER%%.mo
2456 pg_test_timing-%%PGVER%%.mo
2457 pg_upgrade-%%PGVER%%.mo
2458 pg_waldump-%%PGVER%%.mo
2459 pgscripts-%%PGVER%%.mo
2461 plpgsql-%%PGVER%%.mo
2462 plpython-%%PGVER%%.mo
2465 share/locale/de/LC_MESSAGES/
2467 ecpglib6-%%PGVER%%.mo
2470 pg_archivecleanup-%%PGVER%%.mo
2471 pg_basebackup-%%PGVER%%.mo
2472 pg_checksums-%%PGVER%%.mo
2473 pg_config-%%PGVER%%.mo
2474 pg_controldata-%%PGVER%%.mo
2476 pg_dump-%%PGVER%%.mo
2477 pg_resetwal-%%PGVER%%.mo
2478 pg_rewind-%%PGVER%%.mo
2479 pg_test_fsync-%%PGVER%%.mo
2480 pg_test_timing-%%PGVER%%.mo
2481 pg_upgrade-%%PGVER%%.mo
2482 pg_waldump-%%PGVER%%.mo
2483 pgscripts-%%PGVER%%.mo
2485 plpgsql-%%PGVER%%.mo
2486 plpython-%%PGVER%%.mo
2488 postgres-%%PGVER%%.mo
2490 share/locale/es/LC_MESSAGES/
2492 ecpglib6-%%PGVER%%.mo
2495 pg_archivecleanup-%%PGVER%%.mo
2496 pg_basebackup-%%PGVER%%.mo
2497 pg_checksums-%%PGVER%%.mo
2498 pg_config-%%PGVER%%.mo
2499 pg_controldata-%%PGVER%%.mo
2501 pg_dump-%%PGVER%%.mo
2502 pg_resetwal-%%PGVER%%.mo
2503 pg_rewind-%%PGVER%%.mo
2504 pg_test_fsync-%%PGVER%%.mo
2505 pg_test_timing-%%PGVER%%.mo
2506 pg_upgrade-%%PGVER%%.mo
2507 pg_waldump-%%PGVER%%.mo
2508 pgscripts-%%PGVER%%.mo
2510 plpgsql-%%PGVER%%.mo
2511 plpython-%%PGVER%%.mo
2513 postgres-%%PGVER%%.mo
2515 share/locale/fr/LC_MESSAGES/
2517 ecpglib6-%%PGVER%%.mo
2520 pg_archivecleanup-%%PGVER%%.mo
2521 pg_basebackup-%%PGVER%%.mo
2522 pg_checksums-%%PGVER%%.mo
2523 pg_config-%%PGVER%%.mo
2524 pg_controldata-%%PGVER%%.mo
2526 pg_dump-%%PGVER%%.mo
2527 pg_resetwal-%%PGVER%%.mo
2528 pg_rewind-%%PGVER%%.mo
2529 pg_test_fsync-%%PGVER%%.mo
2530 pg_test_timing-%%PGVER%%.mo
2531 pg_upgrade-%%PGVER%%.mo
2532 pg_waldump-%%PGVER%%.mo
2533 pgscripts-%%PGVER%%.mo
2535 plpgsql-%%PGVER%%.mo
2536 plpython-%%PGVER%%.mo
2538 postgres-%%PGVER%%.mo
2540 share/locale/he/LC_MESSAGES/
2542 pg_config-%%PGVER%%.mo
2544 share/locale/it/LC_MESSAGES/
2546 ecpglib6-%%PGVER%%.mo
2548 pg_config-%%PGVER%%.mo
2549 pg_controldata-%%PGVER%%.mo
2552 plpgsql-%%PGVER%%.mo
2553 plpython-%%PGVER%%.mo
2555 postgres-%%PGVER%%.mo
2557 share/locale/ja/LC_MESSAGES/
2559 ecpglib6-%%PGVER%%.mo
2562 pg_archivecleanup-%%PGVER%%.mo
2563 pg_basebackup-%%PGVER%%.mo
2564 pg_checksums-%%PGVER%%.mo
2565 pg_config-%%PGVER%%.mo
2566 pg_controldata-%%PGVER%%.mo
2568 pg_dump-%%PGVER%%.mo
2569 pg_resetwal-%%PGVER%%.mo
2570 pg_rewind-%%PGVER%%.mo
2571 pg_test_fsync-%%PGVER%%.mo
2572 pg_test_timing-%%PGVER%%.mo
2573 pg_upgrade-%%PGVER%%.mo
2574 pg_waldump-%%PGVER%%.mo
2575 pgscripts-%%PGVER%%.mo
2577 plpgsql-%%PGVER%%.mo
2578 plpython-%%PGVER%%.mo
2580 postgres-%%PGVER%%.mo
2582 share/locale/ko/LC_MESSAGES/
2584 ecpglib6-%%PGVER%%.mo
2587 pg_archivecleanup-%%PGVER%%.mo
2588 pg_basebackup-%%PGVER%%.mo
2589 pg_checksums-%%PGVER%%.mo
2590 pg_config-%%PGVER%%.mo
2591 pg_controldata-%%PGVER%%.mo
2593 pg_dump-%%PGVER%%.mo
2594 pg_resetwal-%%PGVER%%.mo
2595 pg_rewind-%%PGVER%%.mo
2596 pg_test_fsync-%%PGVER%%.mo
2597 pg_test_timing-%%PGVER%%.mo
2598 pg_upgrade-%%PGVER%%.mo
2599 pg_waldump-%%PGVER%%.mo
2600 pgscripts-%%PGVER%%.mo
2602 plpgsql-%%PGVER%%.mo
2603 plpython-%%PGVER%%.mo
2605 postgres-%%PGVER%%.mo
2607 share/locale/pl/LC_MESSAGES/
2609 ecpglib6-%%PGVER%%.mo
2610 pg_config-%%PGVER%%.mo
2611 pg_controldata-%%PGVER%%.mo
2613 pg_test_fsync-%%PGVER%%.mo
2614 pg_test_timing-%%PGVER%%.mo
2616 plpgsql-%%PGVER%%.mo
2617 plpython-%%PGVER%%.mo
2619 postgres-%%PGVER%%.mo
2620 share/locale/pt_BR/LC_MESSAGES/
2622 ecpglib6-%%PGVER%%.mo
2623 pg_config-%%PGVER%%.mo
2625 plpgsql-%%PGVER%%.mo
2626 plpython-%%PGVER%%.mo
2627 share/locale/ro/LC_MESSAGES/
2628 pg_config-%%PGVER%%.mo
2630 share/locale/ru/LC_MESSAGES/
2632 ecpglib6-%%PGVER%%.mo
2635 pg_archivecleanup-%%PGVER%%.mo
2636 pg_basebackup-%%PGVER%%.mo
2637 pg_checksums-%%PGVER%%.mo
2638 pg_config-%%PGVER%%.mo
2639 pg_controldata-%%PGVER%%.mo
2641 pg_dump-%%PGVER%%.mo
2642 pg_resetwal-%%PGVER%%.mo
2643 pg_rewind-%%PGVER%%.mo
2644 pg_test_fsync-%%PGVER%%.mo
2645 pg_test_timing-%%PGVER%%.mo
2646 pg_upgrade-%%PGVER%%.mo
2647 pg_waldump-%%PGVER%%.mo
2648 pgscripts-%%PGVER%%.mo
2650 plpgsql-%%PGVER%%.mo
2651 plpython-%%PGVER%%.mo
2653 postgres-%%PGVER%%.mo
2655 share/locale/sv/LC_MESSAGES/
2657 ecpglib6-%%PGVER%%.mo
2660 pg_archivecleanup-%%PGVER%%.mo
2661 pg_basebackup-%%PGVER%%.mo
2662 pg_checksums-%%PGVER%%.mo
2663 pg_config-%%PGVER%%.mo
2664 pg_controldata-%%PGVER%%.mo
2666 pg_dump-%%PGVER%%.mo
2667 pg_resetwal-%%PGVER%%.mo
2668 pg_rewind-%%PGVER%%.mo
2669 pg_test_fsync-%%PGVER%%.mo
2670 pg_test_timing-%%PGVER%%.mo
2671 pg_upgrade-%%PGVER%%.mo
2672 pg_waldump-%%PGVER%%.mo
2673 pgscripts-%%PGVER%%.mo
2675 plpgsql-%%PGVER%%.mo
2676 plpython-%%PGVER%%.mo
2678 postgres-%%PGVER%%.mo
2680 share/locale/tr/LC_MESSAGES/
2682 ecpglib6-%%PGVER%%.mo
2685 pg_archivecleanup-%%PGVER%%.mo
2686 pg_basebackup-%%PGVER%%.mo
2687 pg_checksums-%%PGVER%%.mo
2688 pg_config-%%PGVER%%.mo
2689 pg_controldata-%%PGVER%%.mo
2691 pg_dump-%%PGVER%%.mo
2692 pg_resetwal-%%PGVER%%.mo
2693 pg_rewind-%%PGVER%%.mo
2694 pg_test_fsync-%%PGVER%%.mo
2695 pg_test_timing-%%PGVER%%.mo
2696 pg_upgrade-%%PGVER%%.mo
2697 pg_waldump-%%PGVER%%.mo
2698 pgscripts-%%PGVER%%.mo
2700 plpgsql-%%PGVER%%.mo
2701 plpython-%%PGVER%%.mo
2703 postgres-%%PGVER%%.mo
2705 share/locale/uk/LC_MESSAGES/
2707 ecpglib6-%%PGVER%%.mo
2710 pg_archivecleanup-%%PGVER%%.mo
2711 pg_basebackup-%%PGVER%%.mo
2712 pg_checksums-%%PGVER%%.mo
2713 pg_config-%%PGVER%%.mo
2714 pg_controldata-%%PGVER%%.mo
2716 pg_dump-%%PGVER%%.mo
2717 pg_resetwal-%%PGVER%%.mo
2718 pg_rewind-%%PGVER%%.mo
2719 pg_test_fsync-%%PGVER%%.mo
2720 pg_test_timing-%%PGVER%%.mo
2721 pg_upgrade-%%PGVER%%.mo
2722 pg_waldump-%%PGVER%%.mo
2723 pgscripts-%%PGVER%%.mo
2725 plpgsql-%%PGVER%%.mo
2726 plpython-%%PGVER%%.mo
2728 postgres-%%PGVER%%.mo
2730 share/locale/vi/LC_MESSAGES/
2732 ecpglib6-%%PGVER%%.mo
2733 pg_config-%%PGVER%%.mo
2734 pg_controldata-%%PGVER%%.mo
2735 pg_test_fsync-%%PGVER%%.mo
2736 pg_test_timing-%%PGVER%%.mo
2738 plpgsql-%%PGVER%%.mo
2739 plpython-%%PGVER%%.mo
2741 share/locale/zh_CN/LC_MESSAGES/
2743 ecpglib6-%%PGVER%%.mo
2746 pg_archivecleanup-%%PGVER%%.mo
2747 pg_basebackup-%%PGVER%%.mo
2748 pg_checksums-%%PGVER%%.mo
2749 pg_config-%%PGVER%%.mo
2750 pg_controldata-%%PGVER%%.mo
2752 pg_dump-%%PGVER%%.mo
2753 pg_resetwal-%%PGVER%%.mo
2754 pg_rewind-%%PGVER%%.mo
2755 pg_test_fsync-%%PGVER%%.mo
2756 pg_test_timing-%%PGVER%%.mo
2757 pg_upgrade-%%PGVER%%.mo
2758 pg_waldump-%%PGVER%%.mo
2759 pgscripts-%%PGVER%%.mo
2761 plpgsql-%%PGVER%%.mo
2762 plpython-%%PGVER%%.mo
2764 postgres-%%PGVER%%.mo
2766 share/locale/zh_TW/LC_MESSAGES/
2768 pg_config-%%PGVER%%.mo
2771 [FILE:399:patches/patch-configure]
2772 --- configure.orig 2022-11-07 21:47:13 UTC
2774 @@ -12226,7 +12226,7 @@ if ac_fn_c_try_link "$LINENO"; then :
2775 # recognize dependent libraries; assume curses is needed if we didn't
2776 # find any dependency.
2778 - netbsd* | openbsd* | irix*)
2780 if test x"$pgac_lib" = x"" ; then
2781 pgac_lib=" -lcurses"
2785 [FILE:349:patches/patch-doc-Makefile]
2786 --- doc/Makefile.orig 2022-11-07 21:47:13 UTC
2788 @@ -12,5 +12,5 @@ subdir = doc
2790 include $(top_builddir)/src/Makefile.global
2792 -all distprep html man install installdirs uninstall clean distclean maintainer-clean:
2793 +all distprep man install installdirs uninstall clean distclean maintainer-clean:
2797 [FILE:1196:patches/patch-doc_src_sgml_Makefile]
2798 --- doc/src/sgml/Makefile.orig 2022-11-07 21:47:13 UTC
2799 +++ doc/src/sgml/Makefile
2802 # Make "html" the default target, since that is what most people tend
2807 # We don't need the tree-wide headers or install support here.
2808 NO_GENERATED_HEADERS=yes
2809 @@ -26,7 +26,7 @@ top_builddir = ../../..
2810 include $(top_builddir)/src/Makefile.global
2816 distprep: html distprep-man
2818 @@ -65,8 +65,6 @@ ALL_IMAGES := $(wildcard $(srcdir)/image
2822 -man distprep-man: man-stamp
2824 man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML)
2825 $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^)
2826 $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $(wordlist 1,2,$^)
2827 @@ -220,10 +218,10 @@ check: postgres.sgml $(ALLSGML) check-ta
2831 -install: install-html install-man
2832 +install: install-man
2835 - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2836 + $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2838 # If the install used a man directory shared with other applications, this will remove all files.
2842 [FILE:498:patches/patch-src-backend-Makefile]
2843 --- src/backend/Makefile.orig 2022-11-07 21:47:13 UTC
2844 +++ src/backend/Makefile
2845 @@ -113,6 +113,8 @@ endif # aix
2847 $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport
2849 +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
2852 # The postgres.o target is needed by the rule in Makefile.global that
2853 # creates the exports file when MAKE_EXPORTS = true.
2856 [FILE:865:patches/patch-src_Makefile.shlib]
2857 --- src/Makefile.shlib.orig 2022-11-07 21:47:13 UTC
2858 +++ src/Makefile.shlib
2859 @@ -179,6 +179,9 @@ endif
2861 ifeq ($(PORTNAME), netbsd)
2863 + ifdef SO_MAJOR_VERSION
2864 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2866 LINK.shared = $(COMPILER) -shared
2868 LINK.shared += -Wl,-x,-soname,$(soname)
2869 @@ -228,6 +231,9 @@ endif
2871 ifeq ($(PORTNAME), linux)
2872 LINK.shared = $(COMPILER) -shared
2873 + ifdef SO_MAJOR_VERSION
2874 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2877 LINK.shared += -Wl,-soname,$(soname)
2879 @@ -239,6 +245,9 @@ ifeq ($(PORTNAME), linux)
2882 ifeq ($(PORTNAME), solaris)
2883 + ifdef SO_MAJOR_VERSION
2884 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2887 LINK.shared = $(COMPILER) -shared -Wl,-Bsymbolic
2891 [FILE:685:patches/patch-src_backend_utils_misc_postgresql.conf.sample]
2892 --- src/backend/utils/misc/postgresql.conf.sample.orig 2022-11-07 21:47:13 UTC
2893 +++ src/backend/utils/misc/postgresql.conf.sample
2898 +log_destination = 'syslog'
2899 #log_destination = 'stderr' # Valid values are combinations of
2900 # stderr, csvlog, syslog, and eventlog,
2901 # depending on platform. csvlog
2904 #cluster_name = '' # added to process titles if nonempty
2905 # (change requires restart)
2906 -#update_process_title = on
2908 +# On FreeBSD, this is a performance hog, so keep it off if you need speed
2909 +update_process_title = off
2912 #------------------------------------------------------------------------------
2915 [FILE:3090:files/502.pgsql.in]
2918 # Maintenance shell script to vacuum and backup database
2919 # Put this in /usr/local/etc/periodic/daily, and it will be run
2922 # Written by Palle Girgensohn <girgen@pingpong.net>
2924 # In public domain, do what you like with it,
2925 # and use it at your own risk... :)
2928 # Define these variables in either /etc/periodic.conf or
2929 # /etc/periodic.conf.local to override the default values.
2931 # daily_pgsql_backup_enable="YES" # do backup of all databases
2932 # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases
2933 # daily_pgsql_vacuum_enable="YES" # do vacuum
2935 # If there is a global system configuration file, suck it in.
2937 if [ -r /etc/defaults/periodic.conf ]
2939 . /etc/defaults/periodic.conf
2940 source_periodic_confs
2943 : ${daily_pgsql_user:="%%PG_USER%%"}
2944 : ${daily_pgsql_port:=5432}
2945 : ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"}
2946 : ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"}
2947 : ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"}
2948 # backupdir is relative to ~pgsql home directory unless it begins with a slash:
2949 : ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"}
2950 : ${daily_pgsql_savedays:="7"}
2952 # allow '~ยด in dir name
2953 eval backupdir=${daily_pgsql_backupdir}
2958 # daily_pgsql_backupdir must be writeable by user %%PG_USER%%
2959 # ~%%PG_USER%% is just that under normal circumstances,
2960 # but this might not be where you want the backups...
2961 if [ ! -d ${backupdir} ] ; then
2962 echo Creating ${backupdir}
2963 mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir}
2967 echo "PostgreSQL backups"
2972 now=`date "+%Y-%m-%dT%H:%M:%S"`
2973 file=${daily_pgsql_backupdir}/pgglobals_${now}
2974 su -l ${daily_pgsql_user} -c \
2975 "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz"
2980 file=${backupdir}/pgdump_${db}_${now}
2981 su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
2982 [ $? -gt 0 ] && rc=3
2986 if [ $rc -gt 0 ]; then
2988 echo "Errors were reported during backup."
2991 # cleaning up old data
2992 find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \
2993 -a -mtime +${daily_pgsql_savedays} -delete
2997 case "$daily_pgsql_backup_enable" in
2999 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\'"`
3000 pgsql_backup $dbnames
3010 pgsql_backup $daily_pgsql_backup_enable
3014 case "$daily_pgsql_vacuum_enable" in
3018 echo "PostgreSQL vacuum"
3019 su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}"
3023 echo "Errors were reported during vacuum."
3032 [FILE:3182:files/postgresql.in]
3035 # PROVIDE: postgresql
3039 # Add the following line to /etc/rc.conf to enable PostgreSQL:
3041 # postgresql_enable="YES"
3043 # postgresql_data="%%PREFIX%%/%%PG_USER%%/%%DATADIR%%"
3044 # postgresql_flags="-w -s -m fast"
3045 # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
3046 # postgresql_class="default"
3047 # postgresql_profiles=""
3049 # See %%PREFIX%%/share/doc/postgresql/README-server for more info
3051 # This scripts takes one of the following commands:
3053 # start stop restart reload status initdb
3055 # For postmaster startup options, edit ${postgresql_data}/postgresql.conf
3057 command=%%PREFIX%%/bin/pg_ctl
3061 load_rc_config postgresql
3064 postgresql_enable=${postgresql_enable:-"NO"}
3065 postgresql_flags=${postgresql_flags:-"-w -s -m fast"}
3066 postgresql_user=${postgresql_user:-"%%PG_USER%%"}
3067 eval postgresql_data=${postgresql_data:-"~${postgresql_user}/%%DATADIR%%"}
3068 postgresql_class=${postgresql_class:-"default"}
3069 postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"}
3072 rcvar=postgresql_enable
3073 extra_commands="reload initdb"
3075 start_cmd="postgresql_command start"
3076 stop_cmd="postgresql_command stop"
3077 restart_cmd="postgresql_command restart"
3078 reload_cmd="postgresql_command reload"
3079 status_cmd="postgresql_command status"
3081 initdb_cmd="postgresql_initdb"
3083 if [ -n "$2" ]; then
3085 if [ "x${postgresql_profiles}" != "x" ]; then
3086 eval postgresql_data="\${postgresql_${profile}_data:-}"
3087 if [ "x${postgresql_data}" = "x" ]; then
3088 echo "You must define a data directory (postgresql_${profile}_data)"
3091 eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}"
3092 eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}"
3093 eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}"
3094 eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}"
3097 if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then
3098 for profile in ${postgresql_profiles}; do
3099 eval _enable="\${postgresql_${profile}_enable}"
3100 case "x${_enable:-${postgresql_enable}}" in
3101 x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee])
3107 if test -z "$_enable"; then
3108 _var=postgresql_enable
3110 _var=postgresql_"${profile}"_enable
3113 "'${_enable:-${postgresql_enable}}'" \
3115 "Profile ${profile} skipped."
3119 echo "===> postgresql profile: ${profile}"
3120 %%PREFIX%%/etc/rc.d/postgresql $1 ${profile}
3122 if [ "0${retcode}" -ne 0 ]; then
3123 failed="${profile} (${retcode}) ${failed:-}"
3125 success="${profile} ${success:-}"
3132 command_args="-D ${postgresql_data} ${postgresql_flags}"
3134 postgresql_command()
3136 su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
3141 su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}"