1 # Buildsheet autogenerated by ravenadm tool -- Do not edit.
7 SDESC[standard]= Powerful, open source object-relational database
8 HOMEPAGE= https://www.postgresql.org/
12 SITES[main]= PGSQL/source/v10.11
13 DISTFILE[1]= postgresql-10.11.tar.bz2:main
14 DIST_SUBDIR= postgresql
16 SPKGS[standard]= complete
25 OPTIONS_AVAILABLE= NLS
29 BROKEN_SSL= openssl-devel
31 BUILD_DEPENDS= docbook-sgml:single:standard
32 docbook-dsssl:single:standard
33 openjade:single:standard
34 OpenSP:single:standard
35 readline:single:standard
36 BUILDRUN_DEPENDS= libxslt:single:standard
37 BR_DEPS[sunos]= ossp-uuid:single:standard
38 BR_DEPS[linux]= ossp-uuid:single:standard
39 BR_DEPS[darwin]= libuuid:single:standard
41 EXRUN[plpython]= python
42 EXRUN[client]= gettext:runtime:standard
43 libxslt:single:standard
44 readline:single:standard
45 zlib:complete:standard
47 EXRUN[contrib]= postgresql10:client:standard
48 libxslt:single:standard
49 zlib:complete:standard
50 gettext:runtime:standard
53 EXRUN[server]= postgresql10:client:standard
57 USERGROUP_SPKG= server
59 USES= bison gmake perl:build tcl:build ssl python:build
62 DISTNAME= postgresql-10.11
64 LICENSE= PostgreSQL:server
65 LICENSE_FILE= PostgreSQL:{{WRKSRC}}/COPYRIGHT
68 FPC_EQUIVALENT= databases/postgresql10-server
71 CONFIGURE_ARGS= --with-libraries="{{PREFIX}}/lib"
72 --with-includes="{{PREFIX}}/include:{{TCL_INCLUDEDIR}}"
73 --with-tclconfig="{{TCL_LIBDIR}}"
83 CONFIGURE_ENV= PTHREAD_LIBS="-lpthread"
85 pgac_cv_path_stylesheets={{PREFIX}}/share/sgml/docbook/dsssl/modular
88 MAKE_ENV= TCL_INCDIR="{{TCL_INCLUDEDIR}}"
90 INSTALL_TARGET= install-world
92 RC_SUBR= postgresql:server
94 SUB_LIST= PG_GROUP=pgsql
99 VAR_OPSYS[sunos]= CONFIGURE_ENV=ac_cv_search_bind_textdomain_codeset=-lintl
101 [NLS].CONFIGURE_ENABLE_BOTH= nls
102 [NLS].USES_ON= gettext-runtime
106 @${MKDIR} ${STAGEDIR}${PREFIX}/etc/periodic/daily
107 ${INSTALL_SCRIPT} ${WRKDIR}/502.pgsql \
108 ${STAGEDIR}${PREFIX}/etc/periodic/daily
109 # install-world doesn't strip (and install-strip won't install enough)
110 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so
111 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/*.${LIBEXT}
112 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/regress/pg_regress
113 list=$$(${LS} ${STAGEDIR}${PREFIX}/bin/* | ${GREP} -v pltcl_); \
114 ${STRIP_CMD} $${list}
117 ${REINPLACE_CMD} -e '/sqlmansect/d' \
118 ${WRKSRC}/src/makefiles/Makefile.solaris
120 [FILE:1220:descriptions/desc.server]
121 PostgreSQL is a sophisticated Object-Relational DBMS, supporting
122 almost all SQL constructs, including subselects, transactions, and
123 user-defined types and functions. It is the most advanced open-source
124 database available anywhere. Commercial Support is also available.
126 The original Postgres code was the effort of many graduate students,
127 undergraduate students, and staff programmers working under the direction
128 of Professor Michael Stonebraker at the University of California,
129 Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting
130 the DBMS query language to SQL and created a new database system which came
131 to known as Postgres95. Many others contributed to the porting, testing,
132 debugging and enhancement of the Postgres95 code. As the code improved,
133 and 1995 faded into memory, PostgreSQL was born.
135 PostgreSQL development is presently being performed by a team of developers
136 who are now responsible for all current and future development. The
137 development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG).
138 Support is available from the PostgreSQL developer/user community through
139 the support mailing list (questions@PostgreSQL.ORG).
141 This subpackage contains the PostgreSQL server.
144 [FILE:48:descriptions/desc.client]
145 This subpackage contains the PostgreSQL client.
148 [FILE:60:descriptions/desc.contrib]
149 This subpackage contains the contrib modules of PostgreSQL.
152 [FILE:74:descriptions/desc.plperl]
153 This subpackage contains Perl Procedural Language support for PostgreSQL.
156 [FILE:76:descriptions/desc.plpython]
157 This subpackage contains Python Procedural Language support for PostgreSQL.
160 [FILE:73:descriptions/desc.pltcl]
161 This subpackage contains Tcl Procedural Language support for PostgreSQL.
165 0d5d14ff6b075655f4421038fbde3a5d7b418c26a249a187a4175600d7aecc09 19017947 postgresql/postgresql-10.11.tar.bz2
168 [FILE:13336:manifests/plist.server]
169 %%NLS-ON%%share/locale/cs/LC_MESSAGES/
171 pg_archivecleanup-%%PGVER%%.mo
172 pg_basebackup-%%PGVER%%.mo
173 pg_controldata-%%PGVER%%.mo
175 pg_resetwal-%%PGVER%%.mo
176 pg_rewind-%%PGVER%%.mo
177 pg_test_fsync-%%PGVER%%.mo
178 pg_test_timing-%%PGVER%%.mo
179 pg_upgrade-%%PGVER%%.mo
180 pg_waldump-%%PGVER%%.mo
182 %%NLS-ON%%share/locale/de/LC_MESSAGES/
184 pg_archivecleanup-%%PGVER%%.mo
185 pg_basebackup-%%PGVER%%.mo
186 pg_controldata-%%PGVER%%.mo
188 pg_resetwal-%%PGVER%%.mo
189 pg_rewind-%%PGVER%%.mo
190 pg_test_fsync-%%PGVER%%.mo
191 pg_test_timing-%%PGVER%%.mo
192 pg_upgrade-%%PGVER%%.mo
193 pg_waldump-%%PGVER%%.mo
195 postgres-%%PGVER%%.mo
196 %%NLS-ON%%share/locale/es/LC_MESSAGES/
198 pg_archivecleanup-%%PGVER%%.mo
199 pg_basebackup-%%PGVER%%.mo
200 pg_controldata-%%PGVER%%.mo
202 pg_resetwal-%%PGVER%%.mo
203 pg_rewind-%%PGVER%%.mo
204 pg_test_fsync-%%PGVER%%.mo
205 pg_test_timing-%%PGVER%%.mo
206 pg_upgrade-%%PGVER%%.mo
207 pg_waldump-%%PGVER%%.mo
209 postgres-%%PGVER%%.mo
210 %%NLS-ON%%share/locale/fr/LC_MESSAGES/
212 pg_archivecleanup-%%PGVER%%.mo
213 pg_basebackup-%%PGVER%%.mo
214 pg_controldata-%%PGVER%%.mo
216 pg_resetwal-%%PGVER%%.mo
217 pg_rewind-%%PGVER%%.mo
218 pg_test_fsync-%%PGVER%%.mo
219 pg_test_timing-%%PGVER%%.mo
220 pg_upgrade-%%PGVER%%.mo
221 pg_waldump-%%PGVER%%.mo
223 postgres-%%PGVER%%.mo
224 %%NLS-ON%%share/locale/he/LC_MESSAGES/
227 pg_basebackup-%%PGVER%%.mo
228 pg_config-%%PGVER%%.mo
231 pgscripts-%%PGVER%%.mo
232 %%NLS-ON%%share/locale/it/LC_MESSAGES/
234 pg_basebackup-%%PGVER%%.mo
235 pg_controldata-%%PGVER%%.mo
237 pg_rewind-%%PGVER%%.mo
239 postgres-%%PGVER%%.mo
240 %%NLS-ON%%share/locale/ja/LC_MESSAGES/
242 pg_archivecleanup-%%PGVER%%.mo
243 pg_basebackup-%%PGVER%%.mo
244 pg_controldata-%%PGVER%%.mo
246 pg_resetwal-%%PGVER%%.mo
247 pg_rewind-%%PGVER%%.mo
248 pg_test_fsync-%%PGVER%%.mo
249 pg_test_timing-%%PGVER%%.mo
250 pg_upgrade-%%PGVER%%.mo
251 pg_waldump-%%PGVER%%.mo
253 postgres-%%PGVER%%.mo
254 %%NLS-ON%%share/locale/ko/LC_MESSAGES/
256 pg_archivecleanup-%%PGVER%%.mo
257 pg_basebackup-%%PGVER%%.mo
258 pg_controldata-%%PGVER%%.mo
260 pg_resetwal-%%PGVER%%.mo
261 pg_rewind-%%PGVER%%.mo
262 pg_test_fsync-%%PGVER%%.mo
263 pg_test_timing-%%PGVER%%.mo
264 pg_upgrade-%%PGVER%%.mo
265 pg_waldump-%%PGVER%%.mo
267 postgres-%%PGVER%%.mo
268 %%NLS-ON%%share/locale/pl/LC_MESSAGES/
270 pg_archivecleanup-%%PGVER%%.mo
271 pg_basebackup-%%PGVER%%.mo
272 pg_controldata-%%PGVER%%.mo
274 pg_resetwal-%%PGVER%%.mo
275 pg_rewind-%%PGVER%%.mo
276 pg_test_fsync-%%PGVER%%.mo
277 pg_test_timing-%%PGVER%%.mo
279 postgres-%%PGVER%%.mo
280 %%NLS-ON%%share/locale/pt_BR/LC_MESSAGES/
282 pg_controldata-%%PGVER%%.mo
284 pg_resetwal-%%PGVER%%.mo
285 pg_rewind-%%PGVER%%.mo
287 %%NLS-ON%%share/locale/ro/LC_MESSAGES/plpgsql-%%PGVER%%.mo
288 %%NLS-ON%%share/locale/ru/LC_MESSAGES/
290 pg_archivecleanup-%%PGVER%%.mo
291 pg_basebackup-%%PGVER%%.mo
292 pg_controldata-%%PGVER%%.mo
294 pg_resetwal-%%PGVER%%.mo
295 pg_rewind-%%PGVER%%.mo
296 pg_test_fsync-%%PGVER%%.mo
297 pg_test_timing-%%PGVER%%.mo
298 pg_upgrade-%%PGVER%%.mo
299 pg_waldump-%%PGVER%%.mo
301 postgres-%%PGVER%%.mo
302 %%NLS-ON%%share/locale/sv/LC_MESSAGES/
304 ecpglib6-%%PGVER%%.mo
307 pg_archivecleanup-%%PGVER%%.mo
308 pg_basebackup-%%PGVER%%.mo
309 pg_controldata-%%PGVER%%.mo
312 pg_resetwal-%%PGVER%%.mo
313 pg_rewind-%%PGVER%%.mo
314 pg_test_fsync-%%PGVER%%.mo
315 pg_test_timing-%%PGVER%%.mo
316 pg_upgrade-%%PGVER%%.mo
317 pg_waldump-%%PGVER%%.mo
319 postgres-%%PGVER%%.mo
320 %%NLS-ON%%share/locale/tr/LC_MESSAGES/
323 pg_archivecleanup-%%PGVER%%.mo
324 pg_basebackup-%%PGVER%%.mo
325 pg_controldata-%%PGVER%%.mo
328 pg_resetwal-%%PGVER%%.mo
329 pg_rewind-%%PGVER%%.mo
330 pg_test_fsync-%%PGVER%%.mo
331 pg_test_timing-%%PGVER%%.mo
332 pg_upgrade-%%PGVER%%.mo
333 pg_waldump-%%PGVER%%.mo
335 postgres-%%PGVER%%.mo
336 %%NLS-ON%%share/locale/zh_CN/LC_MESSAGES/
338 pg_controldata-%%PGVER%%.mo
340 pg_resetwal-%%PGVER%%.mo
341 pg_rewind-%%PGVER%%.mo
343 postgres-%%PGVER%%.mo
344 %%NLS-ON%%share/locale/zh_TW/LC_MESSAGES/plpgsql-%%PGVER%%.mo
361 etc/periodic/daily/502.pgsql
362 include/postgresql/server/plpgsql.h
365 amcheck.%%SHARED_OBJECT%%
366 ascii_and_mic.%%SHARED_OBJECT%%
367 cyrillic_and_mic.%%SHARED_OBJECT%%
368 dict_snowball.%%SHARED_OBJECT%%
369 euc2004_sjis2004.%%SHARED_OBJECT%%
370 euc_cn_and_mic.%%SHARED_OBJECT%%
371 euc_jp_and_sjis.%%SHARED_OBJECT%%
372 euc_kr_and_mic.%%SHARED_OBJECT%%
373 euc_tw_and_big5.%%SHARED_OBJECT%%
374 latin2_and_win1250.%%SHARED_OBJECT%%
375 latin_and_mic.%%SHARED_OBJECT%%
376 libpqwalreceiver.%%SHARED_OBJECT%%
377 pgoutput.%%SHARED_OBJECT%%
378 plpgsql.%%SHARED_OBJECT%%
379 utf8_and_ascii.%%SHARED_OBJECT%%
380 utf8_and_big5.%%SHARED_OBJECT%%
381 utf8_and_cyrillic.%%SHARED_OBJECT%%
382 utf8_and_euc2004.%%SHARED_OBJECT%%
383 utf8_and_euc_cn.%%SHARED_OBJECT%%
384 utf8_and_euc_jp.%%SHARED_OBJECT%%
385 utf8_and_euc_kr.%%SHARED_OBJECT%%
386 utf8_and_euc_tw.%%SHARED_OBJECT%%
387 utf8_and_gb18030.%%SHARED_OBJECT%%
388 utf8_and_gbk.%%SHARED_OBJECT%%
389 utf8_and_iso8859.%%SHARED_OBJECT%%
390 utf8_and_iso8859_1.%%SHARED_OBJECT%%
391 utf8_and_johab.%%SHARED_OBJECT%%
392 utf8_and_sjis.%%SHARED_OBJECT%%
393 utf8_and_sjis2004.%%SHARED_OBJECT%%
394 utf8_and_uhc.%%SHARED_OBJECT%%
395 utf8_and_win.%%SHARED_OBJECT%%
397 conversion_create.sql
398 information_schema.sql
403 postgres.shdescription
404 postgresql.conf.sample
409 share/postgresql/extension/
411 plpgsql--unpackaged--1.0.sql
413 share/postgresql/timezone/
460 share/postgresql/timezone/Africa/
515 share/postgresql/timezone/America/
656 share/postgresql/timezone/America/Argentina/
670 share/postgresql/timezone/America/Indiana/
679 share/postgresql/timezone/America/Kentucky/
682 share/postgresql/timezone/America/North_Dakota/
686 share/postgresql/timezone/Antarctica/
699 share/postgresql/timezone/Arctic/Longyearbyen
700 share/postgresql/timezone/Asia/
800 share/postgresql/timezone/Atlantic/
813 share/postgresql/timezone/Australia/
837 share/postgresql/timezone/Brazil/
842 share/postgresql/timezone/Canada/
851 share/postgresql/timezone/Chile/
854 share/postgresql/timezone/Etc/
890 share/postgresql/timezone/Europe/
954 share/postgresql/timezone/Indian/
966 share/postgresql/timezone/Mexico/
970 share/postgresql/timezone/Pacific/
1014 share/postgresql/timezone/US/
1027 share/postgresql/timezonesets/
1041 share/postgresql/tsearch_data/
1049 hunspell_sample.affix
1050 hunspell_sample_long.affix
1051 hunspell_sample_long.dict
1052 hunspell_sample_num.affix
1053 hunspell_sample_num.dict
1063 thesaurus_sample.ths
1067 [FILE:20106:manifests/plist.client]
1068 %%NLS-ON%%share/locale/cs/LC_MESSAGES/
1070 ecpglib6-%%PGVER%%.mo
1072 pg_config-%%PGVER%%.mo
1073 pg_dump-%%PGVER%%.mo
1074 pgscripts-%%PGVER%%.mo
1076 %%NLS-ON%%share/locale/de/LC_MESSAGES/
1078 ecpglib6-%%PGVER%%.mo
1080 pg_config-%%PGVER%%.mo
1081 pg_dump-%%PGVER%%.mo
1082 pgscripts-%%PGVER%%.mo
1084 %%NLS-ON%%share/locale/es/LC_MESSAGES/
1086 ecpglib6-%%PGVER%%.mo
1088 pg_config-%%PGVER%%.mo
1089 pg_dump-%%PGVER%%.mo
1090 pgscripts-%%PGVER%%.mo
1092 %%NLS-ON%%share/locale/fr/LC_MESSAGES/
1094 ecpglib6-%%PGVER%%.mo
1096 pg_config-%%PGVER%%.mo
1097 pg_dump-%%PGVER%%.mo
1098 pgscripts-%%PGVER%%.mo
1100 %%NLS-ON%%share/locale/he/LC_MESSAGES/psql-%%PGVER%%.mo
1101 %%NLS-ON%%share/locale/it/LC_MESSAGES/
1103 ecpglib6-%%PGVER%%.mo
1105 pg_config-%%PGVER%%.mo
1106 pg_dump-%%PGVER%%.mo
1107 pgscripts-%%PGVER%%.mo
1109 %%NLS-ON%%share/locale/ja/LC_MESSAGES/
1111 ecpglib6-%%PGVER%%.mo
1113 pg_config-%%PGVER%%.mo
1114 pg_dump-%%PGVER%%.mo
1115 pgscripts-%%PGVER%%.mo
1117 %%NLS-ON%%share/locale/ko/LC_MESSAGES/
1119 ecpglib6-%%PGVER%%.mo
1121 pg_config-%%PGVER%%.mo
1122 pg_dump-%%PGVER%%.mo
1123 pgscripts-%%PGVER%%.mo
1125 %%NLS-ON%%share/locale/nb/LC_MESSAGES/pg_config-%%PGVER%%.mo
1126 %%NLS-ON%%share/locale/pl/LC_MESSAGES/
1128 ecpglib6-%%PGVER%%.mo
1130 pg_config-%%PGVER%%.mo
1131 pg_dump-%%PGVER%%.mo
1132 pgscripts-%%PGVER%%.mo
1134 %%NLS-ON%%share/locale/pt_BR/LC_MESSAGES/
1136 ecpglib6-%%PGVER%%.mo
1138 pg_config-%%PGVER%%.mo
1139 pg_dump-%%PGVER%%.mo
1140 pgscripts-%%PGVER%%.mo
1142 %%NLS-ON%%share/locale/ro/LC_MESSAGES/pg_config-%%PGVER%%.mo
1143 %%NLS-ON%%share/locale/ru/LC_MESSAGES/
1145 ecpglib6-%%PGVER%%.mo
1147 pg_config-%%PGVER%%.mo
1148 pg_dump-%%PGVER%%.mo
1149 pgscripts-%%PGVER%%.mo
1151 %%NLS-ON%%share/locale/sv/LC_MESSAGES/
1152 pg_config-%%PGVER%%.mo
1153 pgscripts-%%PGVER%%.mo
1155 %%NLS-ON%%share/locale/ta/LC_MESSAGES/pg_config-%%PGVER%%.mo
1156 %%NLS-ON%%share/locale/tr/LC_MESSAGES/
1158 ecpglib6-%%PGVER%%.mo
1159 pg_config-%%PGVER%%.mo
1160 pgscripts-%%PGVER%%.mo
1162 %%NLS-ON%%share/locale/zh_CN/LC_MESSAGES/
1164 ecpglib6-%%PGVER%%.mo
1166 pg_config-%%PGVER%%.mo
1167 pg_dump-%%PGVER%%.mo
1168 pgscripts-%%PGVER%%.mo
1170 %%NLS-ON%%share/locale/zh_TW/LC_MESSAGES/
1172 pg_config-%%PGVER%%.mo
1175 libecpg_compat.so.3.10
1218 include/libpq/libpq-fs.h
1219 include/postgresql/informix/esql/
1223 include/postgresql/internal/
1229 include/postgresql/internal/libpq/pqcomm.h
1230 include/postgresql/server/
1253 include/postgresql/server/access/
1324 include/postgresql/server/bootstrap/bootstrap.h
1325 include/postgresql/server/catalog/
1357 pg_db_role_setting.h
1364 pg_foreign_data_wrapper.h
1373 pg_largeobject_metadata.h
1379 pg_partitioned_table.h
1385 pg_publication_rel.h
1387 pg_replication_origin.h
1397 pg_subscription_rel.h
1413 include/postgresql/server/commands/
1449 include/postgresql/server/common/
1467 unicode_norm_table.h
1469 include/postgresql/server/datatype/timestamp.h
1470 include/postgresql/server/executor/
1482 nodeBitmapHeapscan.h
1483 nodeBitmapIndexscan.h
1502 nodeNamedtuplestorescan.h
1505 nodeRecursiveunion.h
1525 include/postgresql/server/fe_utils/
1533 include/postgresql/server/foreign/
1536 include/postgresql/server/lib/
1546 include/postgresql/server/libpq/
1560 include/postgresql/server/mb/pg_wchar.h
1561 include/postgresql/server/nodes/
1581 include/postgresql/server/optimizer/
1591 geqo_recombination.h
1608 include/postgresql/server/parser/
1632 include/postgresql/server/port/
1646 include/postgresql/server/port/atomics/
1659 include/postgresql/server/port/win32/
1664 include/postgresql/server/port/win32/arpa/inet.h
1665 include/postgresql/server/port/win32/netinet/in.h
1666 include/postgresql/server/port/win32/sys/
1669 include/postgresql/server/port/win32_msvc/
1673 include/postgresql/server/port/win32_msvc/sys/
1677 include/postgresql/server/portability/
1680 include/postgresql/server/postmaster/
1683 bgworker_internals.h
1691 include/postgresql/server/regex/
1697 include/postgresql/server/replication/
1718 include/postgresql/server/rewrite/
1726 include/postgresql/server/snowball/header.h
1727 include/postgresql/server/snowball/libstemmer/
1730 stem_ISO_8859_1_danish.h
1731 stem_ISO_8859_1_dutch.h
1732 stem_ISO_8859_1_english.h
1733 stem_ISO_8859_1_finnish.h
1734 stem_ISO_8859_1_french.h
1735 stem_ISO_8859_1_german.h
1736 stem_ISO_8859_1_hungarian.h
1737 stem_ISO_8859_1_italian.h
1738 stem_ISO_8859_1_norwegian.h
1739 stem_ISO_8859_1_porter.h
1740 stem_ISO_8859_1_portuguese.h
1741 stem_ISO_8859_1_spanish.h
1742 stem_ISO_8859_1_swedish.h
1743 stem_ISO_8859_2_romanian.h
1744 stem_KOI8_R_russian.h
1747 stem_UTF_8_english.h
1748 stem_UTF_8_finnish.h
1751 stem_UTF_8_hungarian.h
1752 stem_UTF_8_italian.h
1753 stem_UTF_8_norwegian.h
1755 stem_UTF_8_portuguese.h
1756 stem_UTF_8_romanian.h
1757 stem_UTF_8_russian.h
1758 stem_UTF_8_spanish.h
1759 stem_UTF_8_swedish.h
1760 stem_UTF_8_turkish.h
1761 include/postgresql/server/statistics/
1762 extended_stats_internal.h
1764 include/postgresql/server/storage/
1774 condition_variable.h
1798 predicate_internals.h
1816 include/postgresql/server/tcop/
1823 include/postgresql/server/tsearch/
1829 include/postgresql/server/tsearch/dicts/
1832 include/postgresql/server/utils/
1940 lib/postgresql/pgxs/config/
1943 lib/postgresql/pgxs/src/
1948 lib/postgresql/pgxs/src/makefiles/pgxs.mk
1949 lib/postgresql/pgxs/src/test/regress/pg_regress
1959 pg_archivecleanup.1.gz
1987 SPI_cursor_close.3.gz
1988 SPI_cursor_fetch.3.gz
1989 SPI_cursor_find.3.gz
1990 SPI_cursor_move.3.gz
1991 SPI_cursor_open.3.gz
1992 SPI_cursor_open_with_args.3.gz
1993 SPI_cursor_open_with_paramlist.3.gz
1997 SPI_execute_plan.3.gz
1998 SPI_execute_plan_with_paramlist.3.gz
1999 SPI_execute_with_args.3.gz
2005 SPI_freetuptable.3.gz
2006 SPI_getargcount.3.gz
2007 SPI_getargtypeid.3.gz
2014 SPI_is_cursor_plan.3.gz
2016 SPI_modifytuple.3.gz
2020 SPI_prepare_cursor.3.gz
2021 SPI_prepare_params.3.gz
2022 SPI_register_relation.3.gz
2023 SPI_register_trigger_data.3.gz
2025 SPI_returntuple.3.gz
2027 SPI_scroll_cursor_fetch.3.gz
2028 SPI_scroll_cursor_move.3.gz
2029 SPI_unregister_relation.3.gz
2031 dblink_build_sql_delete.3.gz
2032 dblink_build_sql_insert.3.gz
2033 dblink_build_sql_update.3.gz
2034 dblink_cancel_query.3.gz
2037 dblink_connect_u.3.gz
2038 dblink_disconnect.3.gz
2039 dblink_error_message.3.gz
2042 dblink_get_connections.3.gz
2043 dblink_get_notify.3.gz
2044 dblink_get_pkey.3.gz
2045 dblink_get_result.3.gz
2048 dblink_send_query.3.gz
2051 ALTER_AGGREGATE.7.gz
2052 ALTER_COLLATION.7.gz
2053 ALTER_CONVERSION.7.gz
2055 ALTER_DEFAULT_PRIVILEGES.7.gz
2057 ALTER_EVENT_TRIGGER.7.gz
2058 ALTER_EXTENSION.7.gz
2059 ALTER_FOREIGN_DATA_WRAPPER.7.gz
2060 ALTER_FOREIGN_TABLE.7.gz
2065 ALTER_LARGE_OBJECT.7.gz
2066 ALTER_MATERIALIZED_VIEW.7.gz
2068 ALTER_OPERATOR_CLASS.7.gz
2069 ALTER_OPERATOR_FAMILY.7.gz
2071 ALTER_PUBLICATION.7.gz
2077 ALTER_STATISTICS.7.gz
2078 ALTER_SUBSCRIPTION.7.gz
2081 ALTER_TABLESPACE.7.gz
2082 ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
2083 ALTER_TEXT_SEARCH_DICTIONARY.7.gz
2084 ALTER_TEXT_SEARCH_PARSER.7.gz
2085 ALTER_TEXT_SEARCH_TEMPLATE.7.gz
2089 ALTER_USER_MAPPING.7.gz
2098 COMMIT_PREPARED.7.gz
2100 CREATE_ACCESS_METHOD.7.gz
2101 CREATE_AGGREGATE.7.gz
2103 CREATE_COLLATION.7.gz
2104 CREATE_CONVERSION.7.gz
2105 CREATE_DATABASE.7.gz
2107 CREATE_EVENT_TRIGGER.7.gz
2108 CREATE_EXTENSION.7.gz
2109 CREATE_FOREIGN_DATA_WRAPPER.7.gz
2110 CREATE_FOREIGN_TABLE.7.gz
2111 CREATE_FUNCTION.7.gz
2114 CREATE_LANGUAGE.7.gz
2115 CREATE_MATERIALIZED_VIEW.7.gz
2116 CREATE_OPERATOR.7.gz
2117 CREATE_OPERATOR_CLASS.7.gz
2118 CREATE_OPERATOR_FAMILY.7.gz
2120 CREATE_PUBLICATION.7.gz
2124 CREATE_SEQUENCE.7.gz
2126 CREATE_STATISTICS.7.gz
2127 CREATE_SUBSCRIPTION.7.gz
2129 CREATE_TABLESPACE.7.gz
2130 CREATE_TABLE_AS.7.gz
2131 CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
2132 CREATE_TEXT_SEARCH_DICTIONARY.7.gz
2133 CREATE_TEXT_SEARCH_PARSER.7.gz
2134 CREATE_TEXT_SEARCH_TEMPLATE.7.gz
2135 CREATE_TRANSFORM.7.gz
2139 CREATE_USER_MAPPING.7.gz
2146 DROP_ACCESS_METHOD.7.gz
2150 DROP_CONVERSION.7.gz
2153 DROP_EVENT_TRIGGER.7.gz
2155 DROP_FOREIGN_DATA_WRAPPER.7.gz
2156 DROP_FOREIGN_TABLE.7.gz
2161 DROP_MATERIALIZED_VIEW.7.gz
2163 DROP_OPERATOR_CLASS.7.gz
2164 DROP_OPERATOR_FAMILY.7.gz
2167 DROP_PUBLICATION.7.gz
2173 DROP_STATISTICS.7.gz
2174 DROP_SUBSCRIPTION.7.gz
2176 DROP_TABLESPACE.7.gz
2177 DROP_TEXT_SEARCH_CONFIGURATION.7.gz
2178 DROP_TEXT_SEARCH_DICTIONARY.7.gz
2179 DROP_TEXT_SEARCH_PARSER.7.gz
2180 DROP_TEXT_SEARCH_TEMPLATE.7.gz
2185 DROP_USER_MAPPING.7.gz
2192 IMPORT_FOREIGN_SCHEMA.7.gz
2200 PREPARE_TRANSACTION.7.gz
2202 REFRESH_MATERIALIZED_VIEW.7.gz
2204 RELEASE_SAVEPOINT.7.gz
2208 ROLLBACK_PREPARED.7.gz
2209 ROLLBACK_TO_SAVEPOINT.7.gz
2215 SET_CONSTRAINTS.7.gz
2217 SET_SESSION_AUTHORIZATION.7.gz
2218 SET_TRANSACTION.7.gz
2220 START_TRANSACTION.7.gz
2229 pg_service.conf.sample
2233 [FILE:6067:manifests/plist.contrib]
2239 _int.%%SHARED_OBJECT%%
2240 adminpack.%%SHARED_OBJECT%%
2241 auth_delay.%%SHARED_OBJECT%%
2242 auto_explain.%%SHARED_OBJECT%%
2243 autoinc.%%SHARED_OBJECT%%
2244 bloom.%%SHARED_OBJECT%%
2245 btree_gin.%%SHARED_OBJECT%%
2246 btree_gist.%%SHARED_OBJECT%%
2247 chkpass.%%SHARED_OBJECT%%
2248 citext.%%SHARED_OBJECT%%
2249 cube.%%SHARED_OBJECT%%
2250 dblink.%%SHARED_OBJECT%%
2251 dict_int.%%SHARED_OBJECT%%
2252 dict_xsyn.%%SHARED_OBJECT%%
2253 earthdistance.%%SHARED_OBJECT%%
2254 file_fdw.%%SHARED_OBJECT%%
2255 fuzzystrmatch.%%SHARED_OBJECT%%
2256 hstore.%%SHARED_OBJECT%%
2257 insert_username.%%SHARED_OBJECT%%
2258 isn.%%SHARED_OBJECT%%
2259 lo.%%SHARED_OBJECT%%
2260 ltree.%%SHARED_OBJECT%%
2261 moddatetime.%%SHARED_OBJECT%%
2262 pageinspect.%%SHARED_OBJECT%%
2263 passwordcheck.%%SHARED_OBJECT%%
2264 pg_buffercache.%%SHARED_OBJECT%%
2265 pg_freespacemap.%%SHARED_OBJECT%%
2266 pg_prewarm.%%SHARED_OBJECT%%
2267 pg_stat_statements.%%SHARED_OBJECT%%
2268 pg_trgm.%%SHARED_OBJECT%%
2269 pg_visibility.%%SHARED_OBJECT%%
2270 pgcrypto.%%SHARED_OBJECT%%
2271 pgrowlocks.%%SHARED_OBJECT%%
2272 pgstattuple.%%SHARED_OBJECT%%
2273 pgxml.%%SHARED_OBJECT%%
2274 postgres_fdw.%%SHARED_OBJECT%%
2275 refint.%%SHARED_OBJECT%%
2276 seg.%%SHARED_OBJECT%%
2277 sslinfo.%%SHARED_OBJECT%%
2278 tablefunc.%%SHARED_OBJECT%%
2279 tcn.%%SHARED_OBJECT%%
2280 test_decoding.%%SHARED_OBJECT%%
2281 timetravel.%%SHARED_OBJECT%%
2282 tsm_system_rows.%%SHARED_OBJECT%%
2283 tsm_system_time.%%SHARED_OBJECT%%
2284 unaccent.%%SHARED_OBJECT%%
2285 uuid-ossp.%%SHARED_OBJECT%%
2286 share/postgresql/extension/
2287 adminpack--1.0--1.1.sql
2293 autoinc--unpackaged--1.0.sql
2297 btree_gin--1.0--1.1.sql
2299 btree_gin--1.1--1.2.sql
2300 btree_gin--unpackaged--1.0.sql
2302 btree_gist--1.0--1.1.sql
2303 btree_gist--1.1--1.2.sql
2304 btree_gist--1.2--1.3.sql
2306 btree_gist--1.3--1.4.sql
2307 btree_gist--1.4--1.5.sql
2308 btree_gist--unpackaged--1.0.sql
2311 chkpass--unpackaged--1.0.sql
2313 citext--1.0--1.1.sql
2314 citext--1.1--1.2.sql
2315 citext--1.2--1.3.sql
2316 citext--1.3--1.4.sql
2318 citext--unpackaged--1.0.sql
2323 cube--unpackaged--1.0.sql
2325 dblink--1.0--1.1.sql
2326 dblink--1.1--1.2.sql
2328 dblink--unpackaged--1.0.sql
2331 dict_int--unpackaged--1.0.sql
2334 dict_xsyn--unpackaged--1.0.sql
2336 earthdistance--1.0--1.1.sql
2337 earthdistance--1.1.sql
2338 earthdistance--unpackaged--1.0.sql
2339 earthdistance.control
2342 fuzzystrmatch--1.0--1.1.sql
2343 fuzzystrmatch--1.1.sql
2344 fuzzystrmatch--unpackaged--1.0.sql
2345 fuzzystrmatch.control
2346 hstore--1.0--1.1.sql
2347 hstore--1.1--1.2.sql
2348 hstore--1.2--1.3.sql
2349 hstore--1.3--1.4.sql
2351 hstore--unpackaged--1.0.sql
2353 insert_username--1.0.sql
2354 insert_username--unpackaged--1.0.sql
2355 insert_username.control
2356 intagg--1.0--1.1.sql
2358 intagg--unpackaged--1.0.sql
2360 intarray--1.0--1.1.sql
2361 intarray--1.1--1.2.sql
2363 intarray--unpackaged--1.0.sql
2367 isn--unpackaged--1.0.sql
2371 lo--unpackaged--1.0.sql
2375 ltree--unpackaged--1.0.sql
2377 moddatetime--1.0.sql
2378 moddatetime--unpackaged--1.0.sql
2380 pageinspect--1.0--1.1.sql
2381 pageinspect--1.1--1.2.sql
2382 pageinspect--1.2--1.3.sql
2383 pageinspect--1.3--1.4.sql
2384 pageinspect--1.4--1.5.sql
2385 pageinspect--1.5--1.6.sql
2386 pageinspect--1.5.sql
2387 pageinspect--unpackaged--1.0.sql
2389 pg_buffercache--1.0--1.1.sql
2390 pg_buffercache--1.1--1.2.sql
2391 pg_buffercache--1.2--1.3.sql
2392 pg_buffercache--1.2.sql
2393 pg_buffercache--unpackaged--1.0.sql
2394 pg_buffercache.control
2395 pg_freespacemap--1.0--1.1.sql
2396 pg_freespacemap--1.1--1.2.sql
2397 pg_freespacemap--1.1.sql
2398 pg_freespacemap--unpackaged--1.0.sql
2399 pg_freespacemap.control
2400 pg_prewarm--1.0--1.1.sql
2403 pg_stat_statements--1.0--1.1.sql
2404 pg_stat_statements--1.1--1.2.sql
2405 pg_stat_statements--1.2--1.3.sql
2406 pg_stat_statements--1.3--1.4.sql
2407 pg_stat_statements--1.4--1.5.sql
2408 pg_stat_statements--1.4.sql
2409 pg_stat_statements--1.5--1.6.sql
2410 pg_stat_statements--unpackaged--1.0.sql
2411 pg_stat_statements.control
2412 pg_trgm--1.0--1.1.sql
2413 pg_trgm--1.1--1.2.sql
2414 pg_trgm--1.2--1.3.sql
2416 pg_trgm--unpackaged--1.0.sql
2418 pg_visibility--1.0--1.1.sql
2419 pg_visibility--1.1--1.2.sql
2420 pg_visibility--1.1.sql
2421 pg_visibility.control
2422 pgcrypto--1.0--1.1.sql
2423 pgcrypto--1.1--1.2.sql
2424 pgcrypto--1.2--1.3.sql
2426 pgcrypto--unpackaged--1.0.sql
2428 pgrowlocks--1.0--1.1.sql
2429 pgrowlocks--1.1--1.2.sql
2431 pgrowlocks--unpackaged--1.0.sql
2433 pgstattuple--1.0--1.1.sql
2434 pgstattuple--1.1--1.2.sql
2435 pgstattuple--1.2--1.3.sql
2436 pgstattuple--1.3--1.4.sql
2437 pgstattuple--1.4--1.5.sql
2438 pgstattuple--1.4.sql
2439 pgstattuple--unpackaged--1.0.sql
2441 postgres_fdw--1.0.sql
2442 postgres_fdw.control
2444 refint--unpackaged--1.0.sql
2448 seg--unpackaged--1.0.sql
2450 sslinfo--1.0--1.1.sql
2451 sslinfo--1.1--1.2.sql
2453 sslinfo--unpackaged--1.0.sql
2456 tablefunc--unpackaged--1.0.sql
2461 timetravel--unpackaged--1.0.sql
2463 tsm_system_rows--1.0.sql
2464 tsm_system_rows.control
2465 tsm_system_time--1.0.sql
2466 tsm_system_time.control
2467 unaccent--1.0--1.1.sql
2469 unaccent--unpackaged--1.0.sql
2471 uuid-ossp--1.0--1.1.sql
2473 uuid-ossp--unpackaged--1.0.sql
2477 xml2--unpackaged--1.0.sql
2479 share/postgresql/tsearch_data/
2484 [FILE:1191:manifests/plist.plperl]
2485 %%NLS-ON%%share/locale/cs/LC_MESSAGES/plperl-%%PGVER%%.mo
2486 %%NLS-ON%%share/locale/de/LC_MESSAGES/plperl-%%PGVER%%.mo
2487 %%NLS-ON%%share/locale/es/LC_MESSAGES/plperl-%%PGVER%%.mo
2488 %%NLS-ON%%share/locale/fr/LC_MESSAGES/plperl-%%PGVER%%.mo
2489 %%NLS-ON%%share/locale/it/LC_MESSAGES/plperl-%%PGVER%%.mo
2490 %%NLS-ON%%share/locale/ja/LC_MESSAGES/plperl-%%PGVER%%.mo
2491 %%NLS-ON%%share/locale/ko/LC_MESSAGES/plperl-%%PGVER%%.mo
2492 %%NLS-ON%%share/locale/pl/LC_MESSAGES/plperl-%%PGVER%%.mo
2493 %%NLS-ON%%share/locale/pt_BR/LC_MESSAGES/plperl-%%PGVER%%.mo
2494 %%NLS-ON%%share/locale/ro/LC_MESSAGES/plperl-%%PGVER%%.mo
2495 %%NLS-ON%%share/locale/ru/LC_MESSAGES/plperl-%%PGVER%%.mo
2496 %%NLS-ON%%share/locale/sv/LC_MESSAGES/plperl-%%PGVER%%.mo
2497 %%NLS-ON%%share/locale/tr/LC_MESSAGES/plperl-%%PGVER%%.mo
2498 %%NLS-ON%%share/locale/zh_CN/LC_MESSAGES/plperl-%%PGVER%%.mo
2499 include/postgresql/server/
2503 hstore_plperl.%%SHARED_OBJECT%%
2504 plperl.%%SHARED_OBJECT%%
2505 share/postgresql/extension/
2506 hstore_plperl--1.0.sql
2507 hstore_plperl.control
2508 hstore_plperlu--1.0.sql
2509 hstore_plperlu.control
2511 plperl--unpackaged--1.0.sql
2514 plperlu--unpackaged--1.0.sql
2518 [FILE:1590:manifests/plist.plpython]
2519 %%NLS-ON%%share/locale/cs/LC_MESSAGES/plpython-%%PGVER%%.mo
2520 %%NLS-ON%%share/locale/de/LC_MESSAGES/plpython-%%PGVER%%.mo
2521 %%NLS-ON%%share/locale/es/LC_MESSAGES/plpython-%%PGVER%%.mo
2522 %%NLS-ON%%share/locale/fr/LC_MESSAGES/plpython-%%PGVER%%.mo
2523 %%NLS-ON%%share/locale/it/LC_MESSAGES/plpython-%%PGVER%%.mo
2524 %%NLS-ON%%share/locale/ja/LC_MESSAGES/plpython-%%PGVER%%.mo
2525 %%NLS-ON%%share/locale/ko/LC_MESSAGES/plpython-%%PGVER%%.mo
2526 %%NLS-ON%%share/locale/pl/LC_MESSAGES/plpython-%%PGVER%%.mo
2527 %%NLS-ON%%share/locale/pt_BR/LC_MESSAGES/plpython-%%PGVER%%.mo
2528 %%NLS-ON%%share/locale/ru/LC_MESSAGES/plpython-%%PGVER%%.mo
2529 %%NLS-ON%%share/locale/sv/LC_MESSAGES/plpython-%%PGVER%%.mo
2530 %%NLS-ON%%share/locale/tr/LC_MESSAGES/plpython-%%PGVER%%.mo
2531 %%NLS-ON%%share/locale/zh_CN/LC_MESSAGES/plpython-%%PGVER%%.mo
2532 %%PYTHON2%%share//extension/
2534 plpythonu--unpackaged--1.0.sql
2536 include/postgresql/server/
2540 hstore_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2541 ltree_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2542 plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2543 share/postgresql/extension/
2544 hstore_plpython2u--1.0.sql
2545 hstore_plpython2u.control
2546 hstore_plpython3u--1.0.sql
2547 hstore_plpython3u.control
2548 hstore_plpythonu--1.0.sql
2549 hstore_plpythonu.control
2550 ltree_plpython2u--1.0.sql
2551 ltree_plpython2u.control
2552 ltree_plpython3u--1.0.sql
2553 ltree_plpython3u.control
2554 ltree_plpythonu--1.0.sql
2555 ltree_plpythonu.control
2556 plpython%%PYTHON_MAJOR_VER%%u--1.0.sql
2557 plpython%%PYTHON_MAJOR_VER%%u--unpackaged--1.0.sql
2558 plpython%%PYTHON_MAJOR_VER%%u.control
2561 [FILE:705:manifests/plist.pltcl]
2562 lib/postgresql/pltcl.%%SHARED_OBJECT%%
2563 share/locale/cs/LC_MESSAGES/pltcl-%%PGVER%%.mo
2564 share/locale/de/LC_MESSAGES/pltcl-%%PGVER%%.mo
2565 share/locale/es/LC_MESSAGES/pltcl-%%PGVER%%.mo
2566 share/locale/fr/LC_MESSAGES/pltcl-%%PGVER%%.mo
2567 share/locale/it/LC_MESSAGES/pltcl-%%PGVER%%.mo
2568 share/locale/ja/LC_MESSAGES/pltcl-%%PGVER%%.mo
2569 share/locale/ko/LC_MESSAGES/pltcl-%%PGVER%%.mo
2570 share/locale/pl/LC_MESSAGES/pltcl-%%PGVER%%.mo
2571 share/locale/ru/LC_MESSAGES/pltcl-%%PGVER%%.mo
2572 share/locale/sv/LC_MESSAGES/pltcl-%%PGVER%%.mo
2573 share/locale/tr/LC_MESSAGES/pltcl-%%PGVER%%.mo
2574 share/postgresql/extension/
2576 pltcl--unpackaged--1.0.sql
2579 pltclu--unpackaged--1.0.sql
2583 [FILE:131:manifests/plist.docs]
2584 share/doc/postgresql/extension/
2586 insert_username.example
2592 [FILE:349:patches/patch-doc-Makefile]
2593 --- doc/Makefile.orig 2019-11-11 22:07:14 UTC
2595 @@ -12,5 +12,5 @@ subdir = doc
2597 include $(top_builddir)/src/Makefile.global
2599 -all distprep html man install installdirs uninstall clean distclean maintainer-clean:
2600 +all distprep man install installdirs uninstall clean distclean maintainer-clean:
2604 [FILE:1073:patches/patch-doc-src-sgml-Makefile]
2605 --- doc/src/sgml/Makefile.orig 2019-11-11 22:07:14 UTC
2606 +++ doc/src/sgml/Makefile
2609 # Make "html" the default target, since that is what most people tend
2616 @@ -24,7 +24,7 @@ top_builddir = ../../..
2617 include $(top_builddir)/src/Makefile.global
2623 distprep: html distprep-man
2625 @@ -77,8 +77,6 @@ override SPFLAGS += -wall -wno-unused-pa
2629 -man distprep-man: man-stamp
2631 man-stamp: stylesheet-man.xsl postgres.xml
2632 $(XMLLINT) --noout --valid postgres.xml
2633 $(XSLTPROC) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $^
2634 @@ -246,10 +244,10 @@ check: postgres.sgml $(ALLSGML) check-ta
2638 -install: install-html install-man
2639 +install: install-man
2642 - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2643 + $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2645 # If the install used a man directory shared with other applications, this will remove all files.
2649 [FILE:527:patches/patch-src-backend-Makefile]
2650 --- src/backend/Makefile.orig 2019-11-11 22:07:14 UTC
2651 +++ src/backend/Makefile
2652 @@ -119,6 +119,8 @@ submake-errcodes: $(top_builddir)/src/in
2654 $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport
2656 +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
2659 # The postgres.o target is needed by the rule in Makefile.global that
2660 # creates the exports file when MAKE_EXPORTS = true.
2663 [FILE:587:patches/patch-src_Makefile.shlib]
2664 --- src/Makefile.shlib.orig 2019-11-11 22:07:14 UTC
2665 +++ src/Makefile.shlib
2666 @@ -227,6 +227,9 @@ endif
2668 ifeq ($(PORTNAME), linux)
2669 LINK.shared = $(COMPILER) -shared
2670 + ifdef SO_MAJOR_VERSION
2671 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2674 LINK.shared += -Wl,-soname,$(soname)
2676 @@ -238,6 +241,9 @@ ifeq ($(PORTNAME), linux)
2679 ifeq ($(PORTNAME), solaris)
2680 + ifdef SO_MAJOR_VERSION
2681 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2684 LINK.shared = $(COMPILER) -shared -Wl,-Bsymbolic
2688 [FILE:685:patches/patch-src_backend_utils_misc_postgresql.conf.sample]
2689 --- src/backend/utils/misc/postgresql.conf.sample.orig 2019-11-11 22:07:14 UTC
2690 +++ src/backend/utils/misc/postgresql.conf.sample
2695 +log_destination = 'syslog'
2696 #log_destination = 'stderr' # Valid values are combinations of
2697 # stderr, csvlog, syslog, and eventlog,
2698 # depending on platform. csvlog
2701 #cluster_name = '' # added to process titles if nonempty
2702 # (change requires restart)
2703 -#update_process_title = on
2705 +# On FreeBSD, this is a performance hog, so keep it off if you need speed
2706 +update_process_title = off
2709 #------------------------------------------------------------------------------
2712 [FILE:3090:files/502.pgsql.in]
2715 # Maintenance shell script to vacuum and backup database
2716 # Put this in /usr/local/etc/periodic/daily, and it will be run
2719 # Written by Palle Girgensohn <girgen@pingpong.net>
2721 # In public domain, do what you like with it,
2722 # and use it at your own risk... :)
2725 # Define these variables in either /etc/periodic.conf or
2726 # /etc/periodic.conf.local to override the default values.
2728 # daily_pgsql_backup_enable="YES" # do backup of all databases
2729 # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases
2730 # daily_pgsql_vacuum_enable="YES" # do vacuum
2732 # If there is a global system configuration file, suck it in.
2734 if [ -r /etc/defaults/periodic.conf ]
2736 . /etc/defaults/periodic.conf
2737 source_periodic_confs
2740 : ${daily_pgsql_user:="%%PG_USER%%"}
2741 : ${daily_pgsql_port:=5432}
2742 : ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"}
2743 : ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"}
2744 : ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"}
2745 # backupdir is relative to ~pgsql home directory unless it begins with a slash:
2746 : ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"}
2747 : ${daily_pgsql_savedays:="7"}
2749 # allow '~ยด in dir name
2750 eval backupdir=${daily_pgsql_backupdir}
2755 # daily_pgsql_backupdir must be writeable by user %%PG_USER%%
2756 # ~%%PG_USER%% is just that under normal circumstances,
2757 # but this might not be where you want the backups...
2758 if [ ! -d ${backupdir} ] ; then
2759 echo Creating ${backupdir}
2760 mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir}
2764 echo "PostgreSQL backups"
2769 now=`date "+%Y-%m-%dT%H:%M:%S"`
2770 file=${daily_pgsql_backupdir}/pgglobals_${now}
2771 su -l ${daily_pgsql_user} -c \
2772 "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz"
2777 file=${backupdir}/pgdump_${db}_${now}
2778 su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
2779 [ $? -gt 0 ] && rc=3
2783 if [ $rc -gt 0 ]; then
2785 echo "Errors were reported during backup."
2788 # cleaning up old data
2789 find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \
2790 -a -mtime +${daily_pgsql_savedays} -delete
2794 case "$daily_pgsql_backup_enable" in
2796 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\'"`
2797 pgsql_backup $dbnames
2807 pgsql_backup $daily_pgsql_backup_enable
2811 case "$daily_pgsql_vacuum_enable" in
2815 echo "PostgreSQL vacuum"
2816 su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}"
2820 echo "Errors were reported during vacuum."
2829 [FILE:3171:files/postgresql.in]
2832 # PROVIDE: postgresql
2836 # Add the following line to /etc/rc.conf to enable PostgreSQL:
2838 # postgresql_enable="YES"
2840 # postgresql_data="/var/db/%%PG_USER%%/data100"
2841 # postgresql_flags="-w -s -m fast"
2842 # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
2843 # postgresql_class="default"
2844 # postgresql_profiles=""
2846 # See %%PREFIX%%/share/doc/postgresql/README-server for more info
2848 # This scripts takes one of the following commands:
2850 # start stop restart reload status initdb
2852 # For postmaster startup options, edit ${postgresql_data}/postgresql.conf
2854 command=%%PREFIX%%/bin/pg_ctl
2858 load_rc_config postgresql
2861 postgresql_enable=${postgresql_enable:-"NO"}
2862 postgresql_flags=${postgresql_flags:-"-w -s -m fast"}
2863 postgresql_user=${postgresql_user:-"%%PG_USER%%"}
2864 eval postgresql_data=${postgresql_data:-"~${postgresql_user}/data100"}
2865 postgresql_class=${postgresql_class:-"default"}
2866 postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"}
2869 rcvar=postgresql_enable
2870 extra_commands="reload initdb"
2872 start_cmd="postgresql_command start"
2873 stop_cmd="postgresql_command stop"
2874 restart_cmd="postgresql_command restart"
2875 reload_cmd="postgresql_command reload"
2876 status_cmd="postgresql_command status"
2878 initdb_cmd="postgresql_initdb"
2880 if [ -n "$2" ]; then
2882 if [ "x${postgresql_profiles}" != "x" ]; then
2883 eval postgresql_data="\${postgresql_${profile}_data:-}"
2884 if [ "x${postgresql_data}" = "x" ]; then
2885 echo "You must define a data directory (postgresql_${profile}_data)"
2888 eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}"
2889 eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}"
2890 eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}"
2891 eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}"
2894 if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then
2895 for profile in ${postgresql_profiles}; do
2896 eval _enable="\${postgresql_${profile}_enable}"
2897 case "x${_enable:-${postgresql_enable}}" in
2898 x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee])
2904 if test -z "$_enable"; then
2905 _var=postgresql_enable
2907 _var=postgresql_"${profile}"_enable
2910 "'${_enable:-${postgresql_enable}}'" \
2912 "Profile ${profile} skipped."
2916 echo "===> postgresql profile: ${profile}"
2917 %%PREFIX%%/etc/rc.d/postgresql $1 ${profile}
2919 if [ "0${retcode}" -ne 0 ]; then
2920 failed="${profile} (${retcode}) ${failed:-}"
2922 success="${profile} ${success:-}"
2929 command_args="-D ${postgresql_data} ${postgresql_flags}"
2931 postgresql_command()
2933 su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
2938 su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}"
2944 [FILE:616:files/special.mk]
2945 .if ${OPSYS:MFreeBSD}
2946 TEMPLATE_ARG= --with-template=freebsd
2947 UUID_ARG= --with-uuid=bsd
2948 .elif ${OPSYS:MDragonFly}
2949 TEMPLATE_ARG= --with-template=freebsd
2950 UUID_ARG= --with-uuid=bsd
2951 .elif ${OPSYS:MNetBSD}
2952 TEMPLATE_ARG= --with-template=netbsd
2953 UUID_ARG= --with-uuid=bsd
2954 .elif ${OPSYS:MOpenBSD}
2955 TEMPLATE_ARG= --with-template=openbsd
2956 UUID_ARG= --with-uuid=bsd
2957 .elif ${OPSYS:MDarwin}
2958 TEMPLATE_ARG= --with-template=darwin
2959 UUID_ARG= --with-uuid=e2fs
2960 .elif ${OPSYS:MSunOS}
2961 TEMPLATE_ARG= --with-template=solaris
2962 UUID_ARG= --with-uuid=ossp
2963 .elif ${OPSYS:MLinux}
2964 TEMPLATE_ARG= --with-template=linux
2965 UUID_ARG= --with-uuid=ossp