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/v13.9
14 DISTFILE[1]= postgresql-13.9.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]= postgresql13:client:standard
49 libxslt:single:standard
51 gettext:primary:standard
54 EXRUN[server]= postgresql13:client:standard
58 USERGROUP_SPKG= server
60 USES= bison gmake perl:build tcl:build ssl python:build
63 DISTNAME= postgresql-13.9
65 LICENSE= PostgreSQL:server
66 LICENSE_FILE= PostgreSQL:{{WRKSRC}}/COPYRIGHT
69 CPE_PRODUCT= postgresql
70 CPE_VENDOR= postgresql
71 FPC_EQUIVALENT= databases/postgresql13-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 ef1966c0a5e49fbed3370ad2824928cb6b1164617aeeae1606da283f7f33a415 21439045 postgresql/postgresql-13.9.tar.bz2
181 [FILE:8473:manifests/plist.server]
198 etc/periodic/daily/502.pgsql
199 include/postgresql/server/plpgsql.h
202 amcheck.%%SHARED_OBJECT%%
203 cyrillic_and_mic.%%SHARED_OBJECT%%
204 dict_snowball.%%SHARED_OBJECT%%
205 euc2004_sjis2004.%%SHARED_OBJECT%%
206 euc_cn_and_mic.%%SHARED_OBJECT%%
207 euc_jp_and_sjis.%%SHARED_OBJECT%%
208 euc_kr_and_mic.%%SHARED_OBJECT%%
209 euc_tw_and_big5.%%SHARED_OBJECT%%
210 latin2_and_win1250.%%SHARED_OBJECT%%
211 latin_and_mic.%%SHARED_OBJECT%%
212 libpqwalreceiver.%%SHARED_OBJECT%%
213 pgoutput.%%SHARED_OBJECT%%
214 plpgsql.%%SHARED_OBJECT%%
215 utf8_and_big5.%%SHARED_OBJECT%%
216 utf8_and_cyrillic.%%SHARED_OBJECT%%
217 utf8_and_euc2004.%%SHARED_OBJECT%%
218 utf8_and_euc_cn.%%SHARED_OBJECT%%
219 utf8_and_euc_jp.%%SHARED_OBJECT%%
220 utf8_and_euc_kr.%%SHARED_OBJECT%%
221 utf8_and_euc_tw.%%SHARED_OBJECT%%
222 utf8_and_gb18030.%%SHARED_OBJECT%%
223 utf8_and_gbk.%%SHARED_OBJECT%%
224 utf8_and_iso8859.%%SHARED_OBJECT%%
225 utf8_and_iso8859_1.%%SHARED_OBJECT%%
226 utf8_and_johab.%%SHARED_OBJECT%%
227 utf8_and_sjis.%%SHARED_OBJECT%%
228 utf8_and_sjis2004.%%SHARED_OBJECT%%
229 utf8_and_uhc.%%SHARED_OBJECT%%
230 utf8_and_win.%%SHARED_OBJECT%%
232 information_schema.sql
236 postgresql.conf.sample
240 share/postgresql/extension/
243 share/postgresql/timezone/
289 share/postgresql/timezone/Africa/
344 share/postgresql/timezone/America/
486 share/postgresql/timezone/America/Argentina/
500 share/postgresql/timezone/America/Indiana/
509 share/postgresql/timezone/America/Kentucky/
512 share/postgresql/timezone/America/North_Dakota/
516 share/postgresql/timezone/Antarctica/
529 share/postgresql/timezone/Arctic/Longyearbyen
530 share/postgresql/timezone/Asia/
630 share/postgresql/timezone/Atlantic/
643 share/postgresql/timezone/Australia/
667 share/postgresql/timezone/Brazil/
672 share/postgresql/timezone/Canada/
681 share/postgresql/timezone/Chile/
684 share/postgresql/timezone/Etc/
720 share/postgresql/timezone/Europe/
785 share/postgresql/timezone/Indian/
797 share/postgresql/timezone/Mexico/
801 share/postgresql/timezone/Pacific/
846 share/postgresql/timezone/US/
859 share/postgresql/timezonesets/
873 share/postgresql/tsearch_data/
881 hunspell_sample.affix
882 hunspell_sample_long.affix
883 hunspell_sample_long.dict
884 hunspell_sample_num.affix
885 hunspell_sample_num.dict
900 [FILE:20145:manifests/plist.client]
903 libecpg_compat.so.3.11
948 include/libpq/libpq-fs.h
949 include/postgresql/informix/esql/
953 include/postgresql/internal/
959 include/postgresql/internal/libpq/pqcomm.h
960 include/postgresql/server/
982 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
1156 pg_publication_rel.h
1157 pg_publication_rel_d.h
1160 pg_replication_origin.h
1161 pg_replication_origin_d.h
1171 pg_shdescription_d.h
1177 pg_statistic_ext_d.h
1178 pg_statistic_ext_data.h
1179 pg_statistic_ext_data_d.h
1182 pg_subscription_rel.h
1183 pg_subscription_rel_d.h
1193 pg_ts_config_map_d.h
1208 include/postgresql/server/commands/
1244 include/postgresql/server/common/
1273 unicode_combining_table.h
1275 unicode_norm_table.h
1276 unicode_normprops_table.h
1278 include/postgresql/server/datatype/timestamp.h
1279 include/postgresql/server/executor/
1292 nodeBitmapHeapscan.h
1293 nodeBitmapIndexscan.h
1304 nodeIncrementalSort.h
1313 nodeNamedtuplestorescan.h
1316 nodeRecursiveunion.h
1336 include/postgresql/server/extension/cube/cubedata.h
1337 include/postgresql/server/extension/hstore/hstore.h
1338 include/postgresql/server/extension/isn/isn.h
1339 include/postgresql/server/extension/ltree/ltree.h
1340 include/postgresql/server/extension/seg/segdata.h
1341 include/postgresql/server/fe_utils/
1352 include/postgresql/server/foreign/
1355 include/postgresql/server/jit/
1359 include/postgresql/server/lib/
1373 include/postgresql/server/libpq/
1388 include/postgresql/server/mb/
1391 include/postgresql/server/nodes/
1412 include/postgresql/server/optimizer/
1423 geqo_recombination.h
1440 include/postgresql/server/parser/
1464 include/postgresql/server/partitioning/
1469 include/postgresql/server/port/
1485 include/postgresql/server/port/atomics/
1497 include/postgresql/server/port/win32/
1502 include/postgresql/server/port/win32/arpa/inet.h
1503 include/postgresql/server/port/win32/netinet/in.h
1504 include/postgresql/server/port/win32/sys/
1507 include/postgresql/server/port/win32_msvc/
1511 include/postgresql/server/port/win32_msvc/sys/
1515 include/postgresql/server/portability/
1518 include/postgresql/server/postmaster/
1521 bgworker_internals.h
1530 include/postgresql/server/regex/
1536 include/postgresql/server/replication/
1557 include/postgresql/server/rewrite/
1565 include/postgresql/server/snowball/header.h
1566 include/postgresql/server/snowball/libstemmer/
1569 stem_ISO_8859_1_danish.h
1570 stem_ISO_8859_1_dutch.h
1571 stem_ISO_8859_1_english.h
1572 stem_ISO_8859_1_finnish.h
1573 stem_ISO_8859_1_french.h
1574 stem_ISO_8859_1_german.h
1575 stem_ISO_8859_1_indonesian.h
1576 stem_ISO_8859_1_irish.h
1577 stem_ISO_8859_1_italian.h
1578 stem_ISO_8859_1_norwegian.h
1579 stem_ISO_8859_1_porter.h
1580 stem_ISO_8859_1_portuguese.h
1581 stem_ISO_8859_1_spanish.h
1582 stem_ISO_8859_1_swedish.h
1583 stem_ISO_8859_2_hungarian.h
1584 stem_ISO_8859_2_romanian.h
1585 stem_KOI8_R_russian.h
1589 stem_UTF_8_english.h
1590 stem_UTF_8_finnish.h
1594 stem_UTF_8_hungarian.h
1595 stem_UTF_8_indonesian.h
1597 stem_UTF_8_italian.h
1598 stem_UTF_8_lithuanian.h
1600 stem_UTF_8_norwegian.h
1602 stem_UTF_8_portuguese.h
1603 stem_UTF_8_romanian.h
1604 stem_UTF_8_russian.h
1605 stem_UTF_8_spanish.h
1606 stem_UTF_8_swedish.h
1608 stem_UTF_8_turkish.h
1609 include/postgresql/server/statistics/
1610 extended_stats_internal.h
1612 include/postgresql/server/storage/
1623 condition_variable.h
1648 predicate_internals.h
1668 include/postgresql/server/tcop/
1677 include/postgresql/server/tsearch/
1683 include/postgresql/server/tsearch/dicts/
1686 include/postgresql/server/utils/
1797 lib/postgresql/pgxs/config/
1800 lib/postgresql/pgxs/src/
1805 lib/postgresql/pgxs/src/makefiles/pgxs.mk
1806 lib/postgresql/pgxs/src/test/regress/pg_regress
1816 pg_archivecleanup.1.gz
1834 pg_verifybackup.1.gz
1845 SPI_commit_and_chain.3.gz
1847 SPI_connect_ext.3.gz
1849 SPI_cursor_close.3.gz
1850 SPI_cursor_fetch.3.gz
1851 SPI_cursor_find.3.gz
1852 SPI_cursor_move.3.gz
1853 SPI_cursor_open.3.gz
1854 SPI_cursor_open_with_args.3.gz
1855 SPI_cursor_open_with_paramlist.3.gz
1859 SPI_execute_plan.3.gz
1860 SPI_execute_plan_with_paramlist.3.gz
1861 SPI_execute_with_args.3.gz
1867 SPI_freetuptable.3.gz
1868 SPI_getargcount.3.gz
1869 SPI_getargtypeid.3.gz
1876 SPI_is_cursor_plan.3.gz
1878 SPI_modifytuple.3.gz
1882 SPI_prepare_cursor.3.gz
1883 SPI_prepare_params.3.gz
1884 SPI_register_relation.3.gz
1885 SPI_register_trigger_data.3.gz
1887 SPI_result_code_string.3.gz
1888 SPI_returntuple.3.gz
1890 SPI_rollback_and_chain.3.gz
1892 SPI_scroll_cursor_fetch.3.gz
1893 SPI_scroll_cursor_move.3.gz
1894 SPI_start_transaction.3.gz
1895 SPI_unregister_relation.3.gz
1897 dblink_build_sql_delete.3.gz
1898 dblink_build_sql_insert.3.gz
1899 dblink_build_sql_update.3.gz
1900 dblink_cancel_query.3.gz
1903 dblink_connect_u.3.gz
1904 dblink_disconnect.3.gz
1905 dblink_error_message.3.gz
1908 dblink_get_connections.3.gz
1909 dblink_get_notify.3.gz
1910 dblink_get_pkey.3.gz
1911 dblink_get_result.3.gz
1914 dblink_send_query.3.gz
1917 ALTER_AGGREGATE.7.gz
1918 ALTER_COLLATION.7.gz
1919 ALTER_CONVERSION.7.gz
1921 ALTER_DEFAULT_PRIVILEGES.7.gz
1923 ALTER_EVENT_TRIGGER.7.gz
1924 ALTER_EXTENSION.7.gz
1925 ALTER_FOREIGN_DATA_WRAPPER.7.gz
1926 ALTER_FOREIGN_TABLE.7.gz
1931 ALTER_LARGE_OBJECT.7.gz
1932 ALTER_MATERIALIZED_VIEW.7.gz
1934 ALTER_OPERATOR_CLASS.7.gz
1935 ALTER_OPERATOR_FAMILY.7.gz
1937 ALTER_PROCEDURE.7.gz
1938 ALTER_PUBLICATION.7.gz
1945 ALTER_STATISTICS.7.gz
1946 ALTER_SUBSCRIPTION.7.gz
1949 ALTER_TABLESPACE.7.gz
1950 ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
1951 ALTER_TEXT_SEARCH_DICTIONARY.7.gz
1952 ALTER_TEXT_SEARCH_PARSER.7.gz
1953 ALTER_TEXT_SEARCH_TEMPLATE.7.gz
1957 ALTER_USER_MAPPING.7.gz
1967 COMMIT_PREPARED.7.gz
1969 CREATE_ACCESS_METHOD.7.gz
1970 CREATE_AGGREGATE.7.gz
1972 CREATE_COLLATION.7.gz
1973 CREATE_CONVERSION.7.gz
1974 CREATE_DATABASE.7.gz
1976 CREATE_EVENT_TRIGGER.7.gz
1977 CREATE_EXTENSION.7.gz
1978 CREATE_FOREIGN_DATA_WRAPPER.7.gz
1979 CREATE_FOREIGN_TABLE.7.gz
1980 CREATE_FUNCTION.7.gz
1983 CREATE_LANGUAGE.7.gz
1984 CREATE_MATERIALIZED_VIEW.7.gz
1985 CREATE_OPERATOR.7.gz
1986 CREATE_OPERATOR_CLASS.7.gz
1987 CREATE_OPERATOR_FAMILY.7.gz
1989 CREATE_PROCEDURE.7.gz
1990 CREATE_PUBLICATION.7.gz
1994 CREATE_SEQUENCE.7.gz
1996 CREATE_STATISTICS.7.gz
1997 CREATE_SUBSCRIPTION.7.gz
1999 CREATE_TABLESPACE.7.gz
2000 CREATE_TABLE_AS.7.gz
2001 CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
2002 CREATE_TEXT_SEARCH_DICTIONARY.7.gz
2003 CREATE_TEXT_SEARCH_PARSER.7.gz
2004 CREATE_TEXT_SEARCH_TEMPLATE.7.gz
2005 CREATE_TRANSFORM.7.gz
2009 CREATE_USER_MAPPING.7.gz
2016 DROP_ACCESS_METHOD.7.gz
2020 DROP_CONVERSION.7.gz
2023 DROP_EVENT_TRIGGER.7.gz
2025 DROP_FOREIGN_DATA_WRAPPER.7.gz
2026 DROP_FOREIGN_TABLE.7.gz
2031 DROP_MATERIALIZED_VIEW.7.gz
2033 DROP_OPERATOR_CLASS.7.gz
2034 DROP_OPERATOR_FAMILY.7.gz
2038 DROP_PUBLICATION.7.gz
2045 DROP_STATISTICS.7.gz
2046 DROP_SUBSCRIPTION.7.gz
2048 DROP_TABLESPACE.7.gz
2049 DROP_TEXT_SEARCH_CONFIGURATION.7.gz
2050 DROP_TEXT_SEARCH_DICTIONARY.7.gz
2051 DROP_TEXT_SEARCH_PARSER.7.gz
2052 DROP_TEXT_SEARCH_TEMPLATE.7.gz
2057 DROP_USER_MAPPING.7.gz
2064 IMPORT_FOREIGN_SCHEMA.7.gz
2072 PREPARE_TRANSACTION.7.gz
2074 REFRESH_MATERIALIZED_VIEW.7.gz
2076 RELEASE_SAVEPOINT.7.gz
2080 ROLLBACK_PREPARED.7.gz
2081 ROLLBACK_TO_SAVEPOINT.7.gz
2087 SET_CONSTRAINTS.7.gz
2089 SET_SESSION_AUTHORIZATION.7.gz
2090 SET_TRANSACTION.7.gz
2092 START_TRANSACTION.7.gz
2102 pg_service.conf.sample
2106 [FILE:5463:manifests/plist.contrib]
2112 _int.%%SHARED_OBJECT%%
2113 adminpack.%%SHARED_OBJECT%%
2114 auth_delay.%%SHARED_OBJECT%%
2115 auto_explain.%%SHARED_OBJECT%%
2116 autoinc.%%SHARED_OBJECT%%
2117 bloom.%%SHARED_OBJECT%%
2118 btree_gin.%%SHARED_OBJECT%%
2119 btree_gist.%%SHARED_OBJECT%%
2120 citext.%%SHARED_OBJECT%%
2121 cube.%%SHARED_OBJECT%%
2122 dblink.%%SHARED_OBJECT%%
2123 dict_int.%%SHARED_OBJECT%%
2124 dict_xsyn.%%SHARED_OBJECT%%
2125 earthdistance.%%SHARED_OBJECT%%
2126 file_fdw.%%SHARED_OBJECT%%
2127 fuzzystrmatch.%%SHARED_OBJECT%%
2128 hstore.%%SHARED_OBJECT%%
2129 insert_username.%%SHARED_OBJECT%%
2130 isn.%%SHARED_OBJECT%%
2131 lo.%%SHARED_OBJECT%%
2132 ltree.%%SHARED_OBJECT%%
2133 moddatetime.%%SHARED_OBJECT%%
2134 pageinspect.%%SHARED_OBJECT%%
2135 passwordcheck.%%SHARED_OBJECT%%
2136 pg_buffercache.%%SHARED_OBJECT%%
2137 pg_freespacemap.%%SHARED_OBJECT%%
2138 pg_prewarm.%%SHARED_OBJECT%%
2139 pg_stat_statements.%%SHARED_OBJECT%%
2140 pg_trgm.%%SHARED_OBJECT%%
2141 pg_visibility.%%SHARED_OBJECT%%
2142 pgcrypto.%%SHARED_OBJECT%%
2143 pgrowlocks.%%SHARED_OBJECT%%
2144 pgstattuple.%%SHARED_OBJECT%%
2145 pgxml.%%SHARED_OBJECT%%
2146 postgres_fdw.%%SHARED_OBJECT%%
2147 refint.%%SHARED_OBJECT%%
2148 seg.%%SHARED_OBJECT%%
2149 sslinfo.%%SHARED_OBJECT%%
2150 tablefunc.%%SHARED_OBJECT%%
2151 tcn.%%SHARED_OBJECT%%
2152 test_decoding.%%SHARED_OBJECT%%
2153 tsm_system_rows.%%SHARED_OBJECT%%
2154 tsm_system_time.%%SHARED_OBJECT%%
2155 unaccent.%%SHARED_OBJECT%%
2156 uuid-ossp.%%SHARED_OBJECT%%
2157 share/postgresql/extension/
2158 adminpack--1.0--1.1.sql
2160 adminpack--1.1--2.0.sql
2161 adminpack--2.0--2.1.sql
2163 amcheck--1.0--1.1.sql
2165 amcheck--1.1--1.2.sql
2171 bool_plperl--1.0.sql
2173 bool_plperlu.control
2174 btree_gin--1.0--1.1.sql
2176 btree_gin--1.1--1.2.sql
2177 btree_gin--1.2--1.3.sql
2179 btree_gist--1.0--1.1.sql
2180 btree_gist--1.1--1.2.sql
2181 btree_gist--1.2--1.3.sql
2183 btree_gist--1.3--1.4.sql
2184 btree_gist--1.4--1.5.sql
2186 citext--1.0--1.1.sql
2187 citext--1.1--1.2.sql
2188 citext--1.2--1.3.sql
2189 citext--1.3--1.4.sql
2190 citext--1.4--1.5.sql
2192 citext--1.5--1.6.sql
2200 dblink--1.0--1.1.sql
2201 dblink--1.1--1.2.sql
2208 earthdistance--1.0--1.1.sql
2209 earthdistance--1.1.sql
2210 earthdistance.control
2213 fuzzystrmatch--1.0--1.1.sql
2214 fuzzystrmatch--1.1.sql
2215 fuzzystrmatch.control
2216 hstore--1.0--1.1.sql
2217 hstore--1.1--1.2.sql
2218 hstore--1.2--1.3.sql
2219 hstore--1.3--1.4.sql
2220 hstore--1.4--1.5.sql
2222 hstore--1.5--1.6.sql
2223 hstore--1.6--1.7.sql
2225 insert_username--1.0.sql
2226 insert_username.control
2227 intagg--1.0--1.1.sql
2230 intarray--1.0--1.1.sql
2231 intarray--1.1--1.2.sql
2232 intarray--1.2--1.3.sql
2246 moddatetime--1.0.sql
2248 pageinspect--1.0--1.1.sql
2249 pageinspect--1.1--1.2.sql
2250 pageinspect--1.2--1.3.sql
2251 pageinspect--1.3--1.4.sql
2252 pageinspect--1.4--1.5.sql
2253 pageinspect--1.5--1.6.sql
2254 pageinspect--1.5.sql
2255 pageinspect--1.6--1.7.sql
2256 pageinspect--1.7--1.8.sql
2258 pg_buffercache--1.0--1.1.sql
2259 pg_buffercache--1.1--1.2.sql
2260 pg_buffercache--1.2--1.3.sql
2261 pg_buffercache--1.2.sql
2262 pg_buffercache.control
2263 pg_freespacemap--1.0--1.1.sql
2264 pg_freespacemap--1.1--1.2.sql
2265 pg_freespacemap--1.1.sql
2266 pg_freespacemap.control
2267 pg_prewarm--1.0--1.1.sql
2268 pg_prewarm--1.1--1.2.sql
2271 pg_stat_statements--1.0--1.1.sql
2272 pg_stat_statements--1.1--1.2.sql
2273 pg_stat_statements--1.2--1.3.sql
2274 pg_stat_statements--1.3--1.4.sql
2275 pg_stat_statements--1.4--1.5.sql
2276 pg_stat_statements--1.4.sql
2277 pg_stat_statements--1.5--1.6.sql
2278 pg_stat_statements--1.6--1.7.sql
2279 pg_stat_statements--1.7--1.8.sql
2280 pg_stat_statements.control
2281 pg_trgm--1.0--1.1.sql
2282 pg_trgm--1.1--1.2.sql
2283 pg_trgm--1.2--1.3.sql
2284 pg_trgm--1.3--1.4.sql
2286 pg_trgm--1.4--1.5.sql
2288 pg_visibility--1.0--1.1.sql
2289 pg_visibility--1.1--1.2.sql
2290 pg_visibility--1.1.sql
2291 pg_visibility.control
2292 pgcrypto--1.0--1.1.sql
2293 pgcrypto--1.1--1.2.sql
2294 pgcrypto--1.2--1.3.sql
2297 pgrowlocks--1.0--1.1.sql
2298 pgrowlocks--1.1--1.2.sql
2301 pgstattuple--1.0--1.1.sql
2302 pgstattuple--1.1--1.2.sql
2303 pgstattuple--1.2--1.3.sql
2304 pgstattuple--1.3--1.4.sql
2305 pgstattuple--1.4--1.5.sql
2306 pgstattuple--1.4.sql
2308 postgres_fdw--1.0.sql
2309 postgres_fdw.control
2317 sslinfo--1.0--1.1.sql
2318 sslinfo--1.1--1.2.sql
2325 tsm_system_rows--1.0.sql
2326 tsm_system_rows.control
2327 tsm_system_time--1.0.sql
2328 tsm_system_time.control
2329 unaccent--1.0--1.1.sql
2332 uuid-ossp--1.0--1.1.sql
2338 share/postgresql/tsearch_data/
2343 [FILE:510:manifests/plist.plperl]
2344 include/postgresql/server/
2349 bool_plperl.%%SHARED_OBJECT%%
2350 hstore_plperl.%%SHARED_OBJECT%%
2351 jsonb_plperl.%%SHARED_OBJECT%%
2352 plperl.%%SHARED_OBJECT%%
2353 share/postgresql/extension/
2354 bool_plperlu--1.0.sql
2355 hstore_plperl--1.0.sql
2356 hstore_plperl.control
2357 hstore_plperlu--1.0.sql
2358 hstore_plperlu.control
2359 jsonb_plperl--1.0.sql
2360 jsonb_plperl.control
2361 jsonb_plperlu--1.0.sql
2362 jsonb_plperlu.control
2369 [FILE:1092:manifests/plist.plpython]
2370 include/postgresql/server/
2380 plpy_subxactobject.h
2385 hstore_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2386 jsonb_plpython3.%%SHARED_OBJECT%%
2387 ltree_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2388 plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2389 lib/postgresql/pgxs/src/pl/plpython/regress-python3-mangle.mk
2390 share/postgresql/extension/
2391 hstore_plpython2u--1.0.sql
2392 hstore_plpython2u.control
2393 hstore_plpython3u--1.0.sql
2394 hstore_plpython3u.control
2395 hstore_plpythonu--1.0.sql
2396 hstore_plpythonu.control
2397 jsonb_plpython2u--1.0.sql
2398 jsonb_plpython2u.control
2399 jsonb_plpython3u--1.0.sql
2400 jsonb_plpython3u.control
2401 jsonb_plpythonu--1.0.sql
2402 jsonb_plpythonu.control
2403 ltree_plpython2u--1.0.sql
2404 ltree_plpython2u.control
2405 ltree_plpython3u--1.0.sql
2406 ltree_plpython3u.control
2407 ltree_plpythonu--1.0.sql
2408 ltree_plpythonu.control
2409 plpython%%PYTHON_MAJOR_VER%%u--1.0.sql
2410 plpython%%PYTHON_MAJOR_VER%%u.control
2413 [FILE:131:manifests/plist.pltcl]
2414 lib/postgresql/pltcl.%%SHARED_OBJECT%%
2415 share/postgresql/extension/
2422 [FILE:111:manifests/plist.docs]
2423 share/doc/postgresql/extension/
2425 insert_username.example
2430 [FILE:8244:manifests/plist.nls]
2431 share/locale/cs/LC_MESSAGES/
2433 ecpglib6-%%PGVER%%.mo
2436 pg_archivecleanup-%%PGVER%%.mo
2437 pg_basebackup-%%PGVER%%.mo
2438 pg_checksums-%%PGVER%%.mo
2439 pg_config-%%PGVER%%.mo
2440 pg_controldata-%%PGVER%%.mo
2442 pg_dump-%%PGVER%%.mo
2443 pg_resetwal-%%PGVER%%.mo
2444 pg_rewind-%%PGVER%%.mo
2445 pg_test_fsync-%%PGVER%%.mo
2446 pg_test_timing-%%PGVER%%.mo
2447 pg_upgrade-%%PGVER%%.mo
2448 pg_waldump-%%PGVER%%.mo
2449 pgscripts-%%PGVER%%.mo
2451 plpgsql-%%PGVER%%.mo
2452 plpython-%%PGVER%%.mo
2455 share/locale/de/LC_MESSAGES/
2457 ecpglib6-%%PGVER%%.mo
2460 pg_archivecleanup-%%PGVER%%.mo
2461 pg_basebackup-%%PGVER%%.mo
2462 pg_checksums-%%PGVER%%.mo
2463 pg_config-%%PGVER%%.mo
2464 pg_controldata-%%PGVER%%.mo
2466 pg_dump-%%PGVER%%.mo
2467 pg_resetwal-%%PGVER%%.mo
2468 pg_rewind-%%PGVER%%.mo
2469 pg_test_fsync-%%PGVER%%.mo
2470 pg_test_timing-%%PGVER%%.mo
2471 pg_upgrade-%%PGVER%%.mo
2472 pg_verifybackup-%%PGVER%%.mo
2473 pg_waldump-%%PGVER%%.mo
2474 pgscripts-%%PGVER%%.mo
2476 plpgsql-%%PGVER%%.mo
2477 plpython-%%PGVER%%.mo
2479 postgres-%%PGVER%%.mo
2481 share/locale/es/LC_MESSAGES/
2483 ecpglib6-%%PGVER%%.mo
2486 pg_archivecleanup-%%PGVER%%.mo
2487 pg_basebackup-%%PGVER%%.mo
2488 pg_checksums-%%PGVER%%.mo
2489 pg_config-%%PGVER%%.mo
2490 pg_controldata-%%PGVER%%.mo
2492 pg_dump-%%PGVER%%.mo
2493 pg_resetwal-%%PGVER%%.mo
2494 pg_rewind-%%PGVER%%.mo
2495 pg_test_fsync-%%PGVER%%.mo
2496 pg_test_timing-%%PGVER%%.mo
2497 pg_upgrade-%%PGVER%%.mo
2498 pg_verifybackup-%%PGVER%%.mo
2499 pg_waldump-%%PGVER%%.mo
2500 pgscripts-%%PGVER%%.mo
2502 plpgsql-%%PGVER%%.mo
2503 plpython-%%PGVER%%.mo
2505 postgres-%%PGVER%%.mo
2507 share/locale/fr/LC_MESSAGES/
2509 ecpglib6-%%PGVER%%.mo
2512 pg_archivecleanup-%%PGVER%%.mo
2513 pg_basebackup-%%PGVER%%.mo
2514 pg_checksums-%%PGVER%%.mo
2515 pg_config-%%PGVER%%.mo
2516 pg_controldata-%%PGVER%%.mo
2518 pg_dump-%%PGVER%%.mo
2519 pg_resetwal-%%PGVER%%.mo
2520 pg_rewind-%%PGVER%%.mo
2521 pg_test_fsync-%%PGVER%%.mo
2522 pg_test_timing-%%PGVER%%.mo
2523 pg_upgrade-%%PGVER%%.mo
2524 pg_verifybackup-%%PGVER%%.mo
2525 pg_waldump-%%PGVER%%.mo
2526 pgscripts-%%PGVER%%.mo
2528 plpgsql-%%PGVER%%.mo
2529 plpython-%%PGVER%%.mo
2531 postgres-%%PGVER%%.mo
2533 share/locale/he/LC_MESSAGES/pg_config-%%PGVER%%.mo
2534 share/locale/it/LC_MESSAGES/
2536 ecpglib6-%%PGVER%%.mo
2538 pg_config-%%PGVER%%.mo
2539 pg_controldata-%%PGVER%%.mo
2542 plpgsql-%%PGVER%%.mo
2543 plpython-%%PGVER%%.mo
2545 postgres-%%PGVER%%.mo
2547 share/locale/ja/LC_MESSAGES/
2549 ecpglib6-%%PGVER%%.mo
2552 pg_archivecleanup-%%PGVER%%.mo
2553 pg_basebackup-%%PGVER%%.mo
2554 pg_checksums-%%PGVER%%.mo
2555 pg_config-%%PGVER%%.mo
2556 pg_controldata-%%PGVER%%.mo
2558 pg_dump-%%PGVER%%.mo
2559 pg_resetwal-%%PGVER%%.mo
2560 pg_rewind-%%PGVER%%.mo
2561 pg_test_fsync-%%PGVER%%.mo
2562 pg_test_timing-%%PGVER%%.mo
2563 pg_upgrade-%%PGVER%%.mo
2564 pg_verifybackup-%%PGVER%%.mo
2565 pg_waldump-%%PGVER%%.mo
2566 pgscripts-%%PGVER%%.mo
2568 plpgsql-%%PGVER%%.mo
2569 plpython-%%PGVER%%.mo
2571 postgres-%%PGVER%%.mo
2573 share/locale/ko/LC_MESSAGES/
2575 ecpglib6-%%PGVER%%.mo
2578 pg_archivecleanup-%%PGVER%%.mo
2579 pg_basebackup-%%PGVER%%.mo
2580 pg_checksums-%%PGVER%%.mo
2581 pg_config-%%PGVER%%.mo
2582 pg_controldata-%%PGVER%%.mo
2584 pg_dump-%%PGVER%%.mo
2585 pg_resetwal-%%PGVER%%.mo
2586 pg_rewind-%%PGVER%%.mo
2587 pg_test_fsync-%%PGVER%%.mo
2588 pg_test_timing-%%PGVER%%.mo
2589 pg_upgrade-%%PGVER%%.mo
2590 pg_verifybackup-%%PGVER%%.mo
2591 pg_waldump-%%PGVER%%.mo
2592 pgscripts-%%PGVER%%.mo
2594 plpgsql-%%PGVER%%.mo
2595 plpython-%%PGVER%%.mo
2597 postgres-%%PGVER%%.mo
2599 share/locale/pl/LC_MESSAGES/
2601 ecpglib6-%%PGVER%%.mo
2602 pg_config-%%PGVER%%.mo
2603 pg_test_fsync-%%PGVER%%.mo
2604 pg_test_timing-%%PGVER%%.mo
2606 plpgsql-%%PGVER%%.mo
2607 plpython-%%PGVER%%.mo
2609 share/locale/pt_BR/LC_MESSAGES/
2611 ecpglib6-%%PGVER%%.mo
2613 pg_archivecleanup-%%PGVER%%.mo
2614 pg_checksums-%%PGVER%%.mo
2615 pg_config-%%PGVER%%.mo
2616 pg_controldata-%%PGVER%%.mo
2618 pg_resetwal-%%PGVER%%.mo
2619 pg_test_fsync-%%PGVER%%.mo
2620 pg_test_timing-%%PGVER%%.mo
2621 pgscripts-%%PGVER%%.mo
2623 plpgsql-%%PGVER%%.mo
2624 plpython-%%PGVER%%.mo
2626 share/locale/ro/LC_MESSAGES/plperl-%%PGVER%%.mo
2627 share/locale/ru/LC_MESSAGES/
2629 ecpglib6-%%PGVER%%.mo
2632 pg_archivecleanup-%%PGVER%%.mo
2633 pg_basebackup-%%PGVER%%.mo
2634 pg_checksums-%%PGVER%%.mo
2635 pg_config-%%PGVER%%.mo
2636 pg_controldata-%%PGVER%%.mo
2638 pg_dump-%%PGVER%%.mo
2639 pg_resetwal-%%PGVER%%.mo
2640 pg_rewind-%%PGVER%%.mo
2641 pg_test_fsync-%%PGVER%%.mo
2642 pg_test_timing-%%PGVER%%.mo
2643 pg_upgrade-%%PGVER%%.mo
2644 pg_verifybackup-%%PGVER%%.mo
2645 pg_waldump-%%PGVER%%.mo
2646 pgscripts-%%PGVER%%.mo
2648 plpgsql-%%PGVER%%.mo
2649 plpython-%%PGVER%%.mo
2651 postgres-%%PGVER%%.mo
2653 share/locale/sv/LC_MESSAGES/
2655 ecpglib6-%%PGVER%%.mo
2658 pg_archivecleanup-%%PGVER%%.mo
2659 pg_basebackup-%%PGVER%%.mo
2660 pg_checksums-%%PGVER%%.mo
2661 pg_config-%%PGVER%%.mo
2662 pg_controldata-%%PGVER%%.mo
2664 pg_dump-%%PGVER%%.mo
2665 pg_resetwal-%%PGVER%%.mo
2666 pg_rewind-%%PGVER%%.mo
2667 pg_test_fsync-%%PGVER%%.mo
2668 pg_test_timing-%%PGVER%%.mo
2669 pg_upgrade-%%PGVER%%.mo
2670 pg_verifybackup-%%PGVER%%.mo
2671 pg_waldump-%%PGVER%%.mo
2672 pgscripts-%%PGVER%%.mo
2674 plpgsql-%%PGVER%%.mo
2675 plpython-%%PGVER%%.mo
2677 postgres-%%PGVER%%.mo
2679 share/locale/tr/LC_MESSAGES/
2681 ecpglib6-%%PGVER%%.mo
2684 pg_archivecleanup-%%PGVER%%.mo
2685 pg_basebackup-%%PGVER%%.mo
2686 pg_checksums-%%PGVER%%.mo
2687 pg_config-%%PGVER%%.mo
2688 pg_controldata-%%PGVER%%.mo
2690 pg_dump-%%PGVER%%.mo
2691 pg_resetwal-%%PGVER%%.mo
2692 pg_rewind-%%PGVER%%.mo
2693 pg_test_fsync-%%PGVER%%.mo
2694 pg_test_timing-%%PGVER%%.mo
2695 pg_upgrade-%%PGVER%%.mo
2696 pg_waldump-%%PGVER%%.mo
2697 pgscripts-%%PGVER%%.mo
2699 plpgsql-%%PGVER%%.mo
2700 plpython-%%PGVER%%.mo
2702 postgres-%%PGVER%%.mo
2704 share/locale/uk/LC_MESSAGES/
2706 ecpglib6-%%PGVER%%.mo
2709 pg_archivecleanup-%%PGVER%%.mo
2710 pg_basebackup-%%PGVER%%.mo
2711 pg_checksums-%%PGVER%%.mo
2712 pg_config-%%PGVER%%.mo
2713 pg_controldata-%%PGVER%%.mo
2715 pg_dump-%%PGVER%%.mo
2716 pg_resetwal-%%PGVER%%.mo
2717 pg_rewind-%%PGVER%%.mo
2718 pg_test_fsync-%%PGVER%%.mo
2719 pg_test_timing-%%PGVER%%.mo
2720 pg_upgrade-%%PGVER%%.mo
2721 pg_verifybackup-%%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_test_fsync-%%PGVER%%.mo
2735 pg_test_timing-%%PGVER%%.mo
2737 plpgsql-%%PGVER%%.mo
2738 plpython-%%PGVER%%.mo
2740 share/locale/zh_CN/LC_MESSAGES/
2742 ecpglib6-%%PGVER%%.mo
2745 pg_archivecleanup-%%PGVER%%.mo
2746 pg_basebackup-%%PGVER%%.mo
2747 pg_checksums-%%PGVER%%.mo
2748 pg_config-%%PGVER%%.mo
2749 pg_controldata-%%PGVER%%.mo
2751 pg_dump-%%PGVER%%.mo
2752 pg_resetwal-%%PGVER%%.mo
2753 pg_rewind-%%PGVER%%.mo
2754 pg_test_fsync-%%PGVER%%.mo
2755 pg_test_timing-%%PGVER%%.mo
2756 pg_upgrade-%%PGVER%%.mo
2757 pg_verifybackup-%%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/ecpg-%%PGVER%%.mo
2769 [FILE:393:patches/patch-configure]
2770 --- configure.orig 2022-11-07 21:45:38 UTC
2772 @@ -12298,7 +12298,7 @@ if ac_fn_c_try_link "$LINENO"; then :
2773 # recognize dependent libraries; assume curses is needed if we didn't
2774 # find any dependency.
2776 - netbsd* | openbsd*)
2778 if test x"$pgac_lib" = x"" ; then
2779 pgac_lib=" -lcurses"
2783 [FILE:349:patches/patch-doc-Makefile]
2784 --- doc/Makefile.orig 2022-11-07 21:45:38 UTC
2786 @@ -12,5 +12,5 @@ subdir = doc
2788 include $(top_builddir)/src/Makefile.global
2790 -all distprep html man install installdirs uninstall clean distclean maintainer-clean:
2791 +all distprep man install installdirs uninstall clean distclean maintainer-clean:
2795 [FILE:1196:patches/patch-doc_src_sgml_Makefile]
2796 --- doc/src/sgml/Makefile.orig 2022-11-07 21:45:38 UTC
2797 +++ doc/src/sgml/Makefile
2800 # Make "html" the default target, since that is what most people tend
2805 # We don't need the tree-wide headers or install support here.
2806 NO_GENERATED_HEADERS=yes
2807 @@ -26,7 +26,7 @@ top_builddir = ../../..
2808 include $(top_builddir)/src/Makefile.global
2814 distprep: html distprep-man
2816 @@ -65,8 +65,6 @@ ALL_IMAGES := $(wildcard $(srcdir)/image
2820 -man distprep-man: man-stamp
2822 man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML)
2823 $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^)
2824 $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $(wordlist 1,2,$^)
2825 @@ -220,10 +218,10 @@ check: postgres.sgml $(ALLSGML) check-ta
2829 -install: install-html install-man
2830 +install: install-man
2833 - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2834 + $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2836 # If the install used a man directory shared with other applications, this will remove all files.
2840 [FILE:498:patches/patch-src-backend-Makefile]
2841 --- src/backend/Makefile.orig 2022-11-07 21:45:38 UTC
2842 +++ src/backend/Makefile
2843 @@ -116,6 +116,8 @@ endif # aix
2845 $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport
2847 +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
2850 # The postgres.o target is needed by the rule in Makefile.global that
2851 # creates the exports file when MAKE_EXPORTS = true.
2854 [FILE:863:patches/patch-src_Makefile.shlib]
2855 --- src/Makefile.shlib.orig 2022-11-07 21:45:38 UTC
2856 +++ src/Makefile.shlib
2857 @@ -166,6 +166,9 @@ ifeq ($(PORTNAME), freebsd)
2860 ifeq ($(PORTNAME), netbsd)
2861 + ifdef SO_MAJOR_VERSION
2862 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2864 LINK.shared = $(COMPILER) -shared
2866 LINK.shared += -Wl,-x,-soname,$(soname)
2867 @@ -212,6 +215,9 @@ endif
2869 ifeq ($(PORTNAME), linux)
2870 LINK.shared = $(COMPILER) -shared
2871 + ifdef SO_MAJOR_VERSION
2872 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2875 LINK.shared += -Wl,-soname,$(soname)
2877 @@ -223,6 +229,9 @@ ifeq ($(PORTNAME), linux)
2880 ifeq ($(PORTNAME), solaris)
2881 + ifdef SO_MAJOR_VERSION
2882 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2885 LINK.shared = $(COMPILER) -shared -Wl,-Bsymbolic
2889 [FILE:685:patches/patch-src_backend_utils_misc_postgresql.conf.sample]
2890 --- src/backend/utils/misc/postgresql.conf.sample.orig 2022-11-07 21:45:38 UTC
2891 +++ src/backend/utils/misc/postgresql.conf.sample
2896 +log_destination = 'syslog'
2897 #log_destination = 'stderr' # Valid values are combinations of
2898 # stderr, csvlog, syslog, and eventlog,
2899 # depending on platform. csvlog
2902 #cluster_name = '' # added to process titles if nonempty
2903 # (change requires restart)
2904 -#update_process_title = on
2906 +# On FreeBSD, this is a performance hog, so keep it off if you need speed
2907 +update_process_title = off
2910 #------------------------------------------------------------------------------
2913 [FILE:3090:files/502.pgsql.in]
2916 # Maintenance shell script to vacuum and backup database
2917 # Put this in /usr/local/etc/periodic/daily, and it will be run
2920 # Written by Palle Girgensohn <girgen@pingpong.net>
2922 # In public domain, do what you like with it,
2923 # and use it at your own risk... :)
2926 # Define these variables in either /etc/periodic.conf or
2927 # /etc/periodic.conf.local to override the default values.
2929 # daily_pgsql_backup_enable="YES" # do backup of all databases
2930 # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases
2931 # daily_pgsql_vacuum_enable="YES" # do vacuum
2933 # If there is a global system configuration file, suck it in.
2935 if [ -r /etc/defaults/periodic.conf ]
2937 . /etc/defaults/periodic.conf
2938 source_periodic_confs
2941 : ${daily_pgsql_user:="%%PG_USER%%"}
2942 : ${daily_pgsql_port:=5432}
2943 : ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"}
2944 : ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"}
2945 : ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"}
2946 # backupdir is relative to ~pgsql home directory unless it begins with a slash:
2947 : ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"}
2948 : ${daily_pgsql_savedays:="7"}
2950 # allow '~ยด in dir name
2951 eval backupdir=${daily_pgsql_backupdir}
2956 # daily_pgsql_backupdir must be writeable by user %%PG_USER%%
2957 # ~%%PG_USER%% is just that under normal circumstances,
2958 # but this might not be where you want the backups...
2959 if [ ! -d ${backupdir} ] ; then
2960 echo Creating ${backupdir}
2961 mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir}
2965 echo "PostgreSQL backups"
2970 now=`date "+%Y-%m-%dT%H:%M:%S"`
2971 file=${daily_pgsql_backupdir}/pgglobals_${now}
2972 su -l ${daily_pgsql_user} -c \
2973 "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz"
2978 file=${backupdir}/pgdump_${db}_${now}
2979 su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
2980 [ $? -gt 0 ] && rc=3
2984 if [ $rc -gt 0 ]; then
2986 echo "Errors were reported during backup."
2989 # cleaning up old data
2990 find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \
2991 -a -mtime +${daily_pgsql_savedays} -delete
2995 case "$daily_pgsql_backup_enable" in
2997 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\'"`
2998 pgsql_backup $dbnames
3008 pgsql_backup $daily_pgsql_backup_enable
3012 case "$daily_pgsql_vacuum_enable" in
3016 echo "PostgreSQL vacuum"
3017 su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}"
3021 echo "Errors were reported during vacuum."
3030 [FILE:3182:files/postgresql.in]
3033 # PROVIDE: postgresql
3037 # Add the following line to /etc/rc.conf to enable PostgreSQL:
3039 # postgresql_enable="YES"
3041 # postgresql_data="%%PREFIX%%/%%PG_USER%%/%%DATADIR%%"
3042 # postgresql_flags="-w -s -m fast"
3043 # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
3044 # postgresql_class="default"
3045 # postgresql_profiles=""
3047 # See %%PREFIX%%/share/doc/postgresql/README-server for more info
3049 # This scripts takes one of the following commands:
3051 # start stop restart reload status initdb
3053 # For postmaster startup options, edit ${postgresql_data}/postgresql.conf
3055 command=%%PREFIX%%/bin/pg_ctl
3059 load_rc_config postgresql
3062 postgresql_enable=${postgresql_enable:-"NO"}
3063 postgresql_flags=${postgresql_flags:-"-w -s -m fast"}
3064 postgresql_user=${postgresql_user:-"%%PG_USER%%"}
3065 eval postgresql_data=${postgresql_data:-"~${postgresql_user}/%%DATADIR%%"}
3066 postgresql_class=${postgresql_class:-"default"}
3067 postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"}
3070 rcvar=postgresql_enable
3071 extra_commands="reload initdb"
3073 start_cmd="postgresql_command start"
3074 stop_cmd="postgresql_command stop"
3075 restart_cmd="postgresql_command restart"
3076 reload_cmd="postgresql_command reload"
3077 status_cmd="postgresql_command status"
3079 initdb_cmd="postgresql_initdb"
3081 if [ -n "$2" ]; then
3083 if [ "x${postgresql_profiles}" != "x" ]; then
3084 eval postgresql_data="\${postgresql_${profile}_data:-}"
3085 if [ "x${postgresql_data}" = "x" ]; then
3086 echo "You must define a data directory (postgresql_${profile}_data)"
3089 eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}"
3090 eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}"
3091 eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}"
3092 eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}"
3095 if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then
3096 for profile in ${postgresql_profiles}; do
3097 eval _enable="\${postgresql_${profile}_enable}"
3098 case "x${_enable:-${postgresql_enable}}" in
3099 x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee])
3105 if test -z "$_enable"; then
3106 _var=postgresql_enable
3108 _var=postgresql_"${profile}"_enable
3111 "'${_enable:-${postgresql_enable}}'" \
3113 "Profile ${profile} skipped."
3117 echo "===> postgresql profile: ${profile}"
3118 %%PREFIX%%/etc/rc.d/postgresql $1 ${profile}
3120 if [ "0${retcode}" -ne 0 ]; then
3121 failed="${profile} (${retcode}) ${failed:-}"
3123 success="${profile} ${success:-}"
3130 command_args="-D ${postgresql_data} ${postgresql_flags}"
3132 postgresql_command()
3134 su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
3139 su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}"