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/v15.1
14 DISTFILE[1]= postgresql-15.1.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
35 readline:primary:standard
37 BUILDRUN_DEPENDS= libxslt:primary:standard
38 B_DEPS[sunos]= ossp-uuid:dev:standard
39 B_DEPS[linux]= ossp-uuid:dev:standard
40 BR_DEPS[sunos]= ossp-uuid:primary:standard
41 BR_DEPS[linux]= ossp-uuid:primary:standard
42 BR_DEPS[darwin]= libuuid:single:standard
44 EXRUN[plpython]= python
45 EXRUN[client]= gettext:primary:standard
46 libxslt:primary:standard
47 readline:primary:standard
50 EXRUN[contrib]= postgresql15:client:standard
51 libxslt:primary:standard
53 gettext:primary:standard
56 EXRUN[server]= postgresql15:client:standard
60 USERGROUP_SPKG= server
62 USES= bison gmake perl:build tcl:build ssl python:build
64 GNOME_COMPONENTS= libxml2
66 DISTNAME= postgresql-15.1
68 LICENSE= PostgreSQL:server
69 LICENSE_FILE= PostgreSQL:{{WRKSRC}}/COPYRIGHT
72 CPE_PRODUCT= postgresql
73 CPE_VENDOR= postgresql
74 FPC_EQUIVALENT= databases/postgresql15-server
77 CONFIGURE_ARGS= --with-libraries="{{PREFIX}}/lib"
78 --with-includes="{{PREFIX}}/include:{{TCL_INCLUDEDIR}}"
79 --with-tclconfig="{{TCL_LIBDIR}}"
88 CONFIGURE_ENV= PTHREAD_LIBS="-lpthread"
90 pgac_cv_path_stylesheets={{PREFIX}}/share/sgml/docbook/dsssl/modular
93 MAKE_ENV= TCL_INCDIR="{{TCL_INCLUDEDIR}}"
95 INSTALL_TARGET= install-world
97 RC_SUBR= postgresql:server
99 SUB_LIST= PG_GROUP=pgsql
105 VAR_OPSYS[freebsd]= CONFIGURE_ARGS=--with-template=freebsd
106 CONFIGURE_ARGS=--with-uuid=bsd
107 VAR_OPSYS[sunos]= CONFIGURE_ENV=ac_cv_search_bind_textdomain_codeset=-lintl
108 CONFIGURE_ARGS=--with-template=solaris
109 CONFIGURE_ARGS=--with-uuid=ossp
110 VAR_OPSYS[linux]= CONFIGURE_ARGS=--with-template=linux
111 CONFIGURE_ARGS=--with-uuid=ossp
112 VAR_OPSYS[darwin]= CONFIGURE_ARGS=--with-template=darwin
113 CONFIGURE_ARGS=--with-uuid=e2fs
114 VAR_OPSYS[netbsd]= CONFIGURE_ARGS=--with-template=netbsd
115 CONFIGURE_ARGS=--with-uuid=bsd
116 VAR_OPSYS[openbsd]= CONFIGURE_ARGS=--with-template=openbsd
117 CONFIGURE_ARGS=--with-uuid=bsd
118 VAR_OPSYS[dragonfly]= CONFIGURE_ARGS=--with-template=freebsd
119 CONFIGURE_ARGS=--with-uuid=bsd
122 ${MKDIR} ${STAGEDIR}${PREFIX}/etc/periodic/daily
123 ${INSTALL_SCRIPT} ${WRKDIR}/502.pgsql \
124 ${STAGEDIR}${PREFIX}/etc/periodic/daily
125 # install-world doesn't strip (and install-strip won't install enough)
126 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so
127 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/*.${LIBEXT}
128 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/regress/pg_regress
129 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/isolation/isolationtester
130 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/isolation/pg_isolation_regress
131 list=$$(${LS} ${STAGEDIR}${PREFIX}/bin/* | ${GREP} -v pltcl_); \
132 ${STRIP_CMD} $${list}
135 ${REINPLACE_CMD} -e '/sqlmansect/d' \
136 ${WRKSRC}/src/makefiles/Makefile.solaris
138 [FILE:1220:descriptions/desc.server]
139 PostgreSQL is a sophisticated Object-Relational DBMS, supporting
140 almost all SQL constructs, including subselects, transactions, and
141 user-defined types and functions. It is the most advanced open-source
142 database available anywhere. Commercial Support is also available.
144 The original Postgres code was the effort of many graduate students,
145 undergraduate students, and staff programmers working under the direction
146 of Professor Michael Stonebraker at the University of California,
147 Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting
148 the DBMS query language to SQL and created a new database system which came
149 to known as Postgres95. Many others contributed to the porting, testing,
150 debugging and enhancement of the Postgres95 code. As the code improved,
151 and 1995 faded into memory, PostgreSQL was born.
153 PostgreSQL development is presently being performed by a team of developers
154 who are now responsible for all current and future development. The
155 development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG).
156 Support is available from the PostgreSQL developer/user community through
157 the support mailing list (questions@PostgreSQL.ORG).
159 This subpackage contains the PostgreSQL server.
162 [FILE:48:descriptions/desc.client]
163 This subpackage contains the PostgreSQL client.
166 [FILE:60:descriptions/desc.contrib]
167 This subpackage contains the contrib modules of PostgreSQL.
170 [FILE:74:descriptions/desc.plperl]
171 This subpackage contains Perl Procedural Language support for PostgreSQL.
174 [FILE:76:descriptions/desc.plpython]
175 This subpackage contains Python Procedural Language support for PostgreSQL.
178 [FILE:73:descriptions/desc.pltcl]
179 This subpackage contains Tcl Procedural Language support for PostgreSQL.
183 64fdf23d734afad0dfe4077daca96ac51dcd697e68ae2d3d4ca6c45cb14e21ae 22666134 postgresql/postgresql-15.1.tar.bz2
186 [FILE:8109:manifests/plist.server]
203 etc/periodic/daily/502.pgsql
207 basebackup_to_shell.so
216 latin2_and_win1250.so
232 utf8_and_iso8859_1.so
239 information_schema.sql
243 postgresql.conf.sample
247 share/postgresql/extension/
248 pg_walinspect--1.0.sql
249 pg_walinspect.control
252 share/postgresql/timezone/
298 share/postgresql/timezone/Africa/
353 share/postgresql/timezone/America/
495 share/postgresql/timezone/America/Argentina/
509 share/postgresql/timezone/America/Indiana/
518 share/postgresql/timezone/America/Kentucky/
521 share/postgresql/timezone/America/North_Dakota/
525 share/postgresql/timezone/Antarctica/
538 share/postgresql/timezone/Arctic/Longyearbyen
539 share/postgresql/timezone/Asia/
639 share/postgresql/timezone/Atlantic/
652 share/postgresql/timezone/Australia/
676 share/postgresql/timezone/Brazil/
681 share/postgresql/timezone/Canada/
690 share/postgresql/timezone/Chile/
693 share/postgresql/timezone/Etc/
729 share/postgresql/timezone/Europe/
794 share/postgresql/timezone/Indian/
806 share/postgresql/timezone/Mexico/
810 share/postgresql/timezone/Pacific/
855 share/postgresql/timezone/US/
868 share/postgresql/timezonesets/
882 share/postgresql/tsearch_data/
890 hunspell_sample.affix
891 hunspell_sample_long.affix
892 hunspell_sample_long.dict
893 hunspell_sample_num.affix
894 hunspell_sample_num.dict
909 [FILE:21267:manifests/plist.client]
912 libecpg_compat.so.3.11
958 include/libpq/libpq-fs.h
959 include/postgresql/informix/esql/
963 include/postgresql/internal/
970 include/postgresql/internal/libpq/pqcomm.h
971 include/postgresql/server/
994 include/postgresql/server/access/
1081 include/postgresql/server/bootstrap/bootstrap.h
1082 include/postgresql/server/catalog/
1124 pg_db_role_setting.h
1125 pg_db_role_setting_d.h
1135 pg_event_trigger_d.h
1138 pg_foreign_data_wrapper.h
1139 pg_foreign_data_wrapper_d.h
1141 pg_foreign_server_d.h
1143 pg_foreign_table_d.h
1154 pg_largeobject_metadata.h
1155 pg_largeobject_metadata_d.h
1165 pg_parameter_acl_d.h
1166 pg_partitioned_table.h
1167 pg_partitioned_table_d.h
1174 pg_publication_namespace.h
1175 pg_publication_namespace_d.h
1176 pg_publication_rel.h
1177 pg_publication_rel_d.h
1180 pg_replication_origin.h
1181 pg_replication_origin_d.h
1191 pg_shdescription_d.h
1197 pg_statistic_ext_d.h
1198 pg_statistic_ext_data.h
1199 pg_statistic_ext_data_d.h
1202 pg_subscription_rel.h
1203 pg_subscription_rel_d.h
1213 pg_ts_config_map_d.h
1229 include/postgresql/server/commands/
1266 include/postgresql/server/common/
1300 unicode_combining_table.h
1301 unicode_east_asian_fw_table.h
1303 unicode_norm_hashfunc.h
1304 unicode_norm_table.h
1305 unicode_normprops_table.h
1307 include/postgresql/server/datatype/timestamp.h
1308 include/postgresql/server/executor/
1322 nodeBitmapHeapscan.h
1323 nodeBitmapIndexscan.h
1334 nodeIncrementalSort.h
1344 nodeNamedtuplestorescan.h
1347 nodeRecursiveunion.h
1368 include/postgresql/server/extension/cube/cubedata.h
1369 include/postgresql/server/extension/hstore/hstore.h
1370 include/postgresql/server/extension/isn/isn.h
1371 include/postgresql/server/extension/ltree/ltree.h
1372 include/postgresql/server/extension/seg/segdata.h
1373 include/postgresql/server/fe_utils/
1388 include/postgresql/server/foreign/
1391 include/postgresql/server/jit/
1395 include/postgresql/server/lib/
1410 include/postgresql/server/libpq/
1426 include/postgresql/server/mb/
1429 include/postgresql/server/nodes/
1451 include/postgresql/server/optimizer/
1462 geqo_recombination.h
1479 include/postgresql/server/parser/
1504 include/postgresql/server/partitioning/
1509 include/postgresql/server/port/
1528 include/postgresql/server/port/atomics/
1540 include/postgresql/server/port/win32/
1545 include/postgresql/server/port/win32/arpa/inet.h
1546 include/postgresql/server/port/win32/netinet/in.h
1547 include/postgresql/server/port/win32/sys/
1550 include/postgresql/server/port/win32_msvc/
1554 include/postgresql/server/port/win32_msvc/sys/
1558 include/postgresql/server/portability/
1561 include/postgresql/server/postmaster/
1565 bgworker_internals.h
1574 include/postgresql/server/regex/
1580 include/postgresql/server/replication/
1599 include/postgresql/server/rewrite/
1605 rewriteSearchCycle.h
1608 include/postgresql/server/snowball/header.h
1609 include/postgresql/server/snowball/libstemmer/
1612 stem_ISO_8859_1_basque.h
1613 stem_ISO_8859_1_catalan.h
1614 stem_ISO_8859_1_danish.h
1615 stem_ISO_8859_1_dutch.h
1616 stem_ISO_8859_1_english.h
1617 stem_ISO_8859_1_finnish.h
1618 stem_ISO_8859_1_french.h
1619 stem_ISO_8859_1_german.h
1620 stem_ISO_8859_1_indonesian.h
1621 stem_ISO_8859_1_irish.h
1622 stem_ISO_8859_1_italian.h
1623 stem_ISO_8859_1_norwegian.h
1624 stem_ISO_8859_1_porter.h
1625 stem_ISO_8859_1_portuguese.h
1626 stem_ISO_8859_1_spanish.h
1627 stem_ISO_8859_1_swedish.h
1628 stem_ISO_8859_2_hungarian.h
1629 stem_ISO_8859_2_romanian.h
1630 stem_KOI8_R_russian.h
1632 stem_UTF_8_armenian.h
1634 stem_UTF_8_catalan.h
1637 stem_UTF_8_english.h
1638 stem_UTF_8_finnish.h
1643 stem_UTF_8_hungarian.h
1644 stem_UTF_8_indonesian.h
1646 stem_UTF_8_italian.h
1647 stem_UTF_8_lithuanian.h
1649 stem_UTF_8_norwegian.h
1651 stem_UTF_8_portuguese.h
1652 stem_UTF_8_romanian.h
1653 stem_UTF_8_russian.h
1654 stem_UTF_8_serbian.h
1655 stem_UTF_8_spanish.h
1656 stem_UTF_8_swedish.h
1658 stem_UTF_8_turkish.h
1659 stem_UTF_8_yiddish.h
1660 include/postgresql/server/statistics/
1661 extended_stats_internal.h
1663 include/postgresql/server/storage/
1674 condition_variable.h
1700 predicate_internals.h
1720 include/postgresql/server/tcop/
1729 include/postgresql/server/tsearch/
1735 include/postgresql/server/tsearch/dicts/
1738 include/postgresql/server/utils/
1855 lib/postgresql/pgxs/config/
1858 lib/postgresql/pgxs/src/
1863 lib/postgresql/pgxs/src/makefiles/pgxs.mk
1864 lib/postgresql/pgxs/src/test/isolation/
1866 pg_isolation_regress
1867 lib/postgresql/pgxs/src/test/regress/pg_regress
1878 pg_archivecleanup.1.gz
1895 pg_verifybackup.1.gz
1906 SPI_commit_and_chain.3.gz
1908 SPI_connect_ext.3.gz
1910 SPI_cursor_close.3.gz
1911 SPI_cursor_fetch.3.gz
1912 SPI_cursor_find.3.gz
1913 SPI_cursor_move.3.gz
1914 SPI_cursor_open.3.gz
1915 SPI_cursor_open_with_args.3.gz
1916 SPI_cursor_open_with_paramlist.3.gz
1917 SPI_cursor_parse_open.3.gz
1921 SPI_execute_extended.3.gz
1922 SPI_execute_plan.3.gz
1923 SPI_execute_plan_extended.3.gz
1924 SPI_execute_plan_with_paramlist.3.gz
1925 SPI_execute_with_args.3.gz
1931 SPI_freetuptable.3.gz
1932 SPI_getargcount.3.gz
1933 SPI_getargtypeid.3.gz
1940 SPI_is_cursor_plan.3.gz
1942 SPI_modifytuple.3.gz
1946 SPI_prepare_cursor.3.gz
1947 SPI_prepare_extended.3.gz
1948 SPI_prepare_params.3.gz
1949 SPI_register_relation.3.gz
1950 SPI_register_trigger_data.3.gz
1952 SPI_result_code_string.3.gz
1953 SPI_returntuple.3.gz
1955 SPI_rollback_and_chain.3.gz
1957 SPI_scroll_cursor_fetch.3.gz
1958 SPI_scroll_cursor_move.3.gz
1959 SPI_start_transaction.3.gz
1960 SPI_unregister_relation.3.gz
1962 dblink_build_sql_delete.3.gz
1963 dblink_build_sql_insert.3.gz
1964 dblink_build_sql_update.3.gz
1965 dblink_cancel_query.3.gz
1968 dblink_connect_u.3.gz
1969 dblink_disconnect.3.gz
1970 dblink_error_message.3.gz
1973 dblink_get_connections.3.gz
1974 dblink_get_notify.3.gz
1975 dblink_get_pkey.3.gz
1976 dblink_get_result.3.gz
1979 dblink_send_query.3.gz
1982 ALTER_AGGREGATE.7.gz
1983 ALTER_COLLATION.7.gz
1984 ALTER_CONVERSION.7.gz
1986 ALTER_DEFAULT_PRIVILEGES.7.gz
1988 ALTER_EVENT_TRIGGER.7.gz
1989 ALTER_EXTENSION.7.gz
1990 ALTER_FOREIGN_DATA_WRAPPER.7.gz
1991 ALTER_FOREIGN_TABLE.7.gz
1996 ALTER_LARGE_OBJECT.7.gz
1997 ALTER_MATERIALIZED_VIEW.7.gz
1999 ALTER_OPERATOR_CLASS.7.gz
2000 ALTER_OPERATOR_FAMILY.7.gz
2002 ALTER_PROCEDURE.7.gz
2003 ALTER_PUBLICATION.7.gz
2010 ALTER_STATISTICS.7.gz
2011 ALTER_SUBSCRIPTION.7.gz
2014 ALTER_TABLESPACE.7.gz
2015 ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
2016 ALTER_TEXT_SEARCH_DICTIONARY.7.gz
2017 ALTER_TEXT_SEARCH_PARSER.7.gz
2018 ALTER_TEXT_SEARCH_TEMPLATE.7.gz
2022 ALTER_USER_MAPPING.7.gz
2032 COMMIT_PREPARED.7.gz
2034 CREATE_ACCESS_METHOD.7.gz
2035 CREATE_AGGREGATE.7.gz
2037 CREATE_COLLATION.7.gz
2038 CREATE_CONVERSION.7.gz
2039 CREATE_DATABASE.7.gz
2041 CREATE_EVENT_TRIGGER.7.gz
2042 CREATE_EXTENSION.7.gz
2043 CREATE_FOREIGN_DATA_WRAPPER.7.gz
2044 CREATE_FOREIGN_TABLE.7.gz
2045 CREATE_FUNCTION.7.gz
2048 CREATE_LANGUAGE.7.gz
2049 CREATE_MATERIALIZED_VIEW.7.gz
2050 CREATE_OPERATOR.7.gz
2051 CREATE_OPERATOR_CLASS.7.gz
2052 CREATE_OPERATOR_FAMILY.7.gz
2054 CREATE_PROCEDURE.7.gz
2055 CREATE_PUBLICATION.7.gz
2059 CREATE_SEQUENCE.7.gz
2061 CREATE_STATISTICS.7.gz
2062 CREATE_SUBSCRIPTION.7.gz
2064 CREATE_TABLESPACE.7.gz
2065 CREATE_TABLE_AS.7.gz
2066 CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
2067 CREATE_TEXT_SEARCH_DICTIONARY.7.gz
2068 CREATE_TEXT_SEARCH_PARSER.7.gz
2069 CREATE_TEXT_SEARCH_TEMPLATE.7.gz
2070 CREATE_TRANSFORM.7.gz
2074 CREATE_USER_MAPPING.7.gz
2081 DROP_ACCESS_METHOD.7.gz
2085 DROP_CONVERSION.7.gz
2088 DROP_EVENT_TRIGGER.7.gz
2090 DROP_FOREIGN_DATA_WRAPPER.7.gz
2091 DROP_FOREIGN_TABLE.7.gz
2096 DROP_MATERIALIZED_VIEW.7.gz
2098 DROP_OPERATOR_CLASS.7.gz
2099 DROP_OPERATOR_FAMILY.7.gz
2103 DROP_PUBLICATION.7.gz
2110 DROP_STATISTICS.7.gz
2111 DROP_SUBSCRIPTION.7.gz
2113 DROP_TABLESPACE.7.gz
2114 DROP_TEXT_SEARCH_CONFIGURATION.7.gz
2115 DROP_TEXT_SEARCH_DICTIONARY.7.gz
2116 DROP_TEXT_SEARCH_PARSER.7.gz
2117 DROP_TEXT_SEARCH_TEMPLATE.7.gz
2122 DROP_USER_MAPPING.7.gz
2129 IMPORT_FOREIGN_SCHEMA.7.gz
2138 PREPARE_TRANSACTION.7.gz
2140 REFRESH_MATERIALIZED_VIEW.7.gz
2142 RELEASE_SAVEPOINT.7.gz
2146 ROLLBACK_PREPARED.7.gz
2147 ROLLBACK_TO_SAVEPOINT.7.gz
2153 SET_CONSTRAINTS.7.gz
2155 SET_SESSION_AUTHORIZATION.7.gz
2156 SET_TRANSACTION.7.gz
2158 START_TRANSACTION.7.gz
2168 pg_service.conf.sample
2170 system_constraints.sql
2171 system_functions.sql
2174 [FILE:5231:manifests/plist.contrib]
2207 pg_stat_statements.so
2226 share/postgresql/extension/
2227 adminpack--1.0--1.1.sql
2229 adminpack--1.1--2.0.sql
2230 adminpack--2.0--2.1.sql
2232 amcheck--1.0--1.1.sql
2234 amcheck--1.1--1.2.sql
2235 amcheck--1.2--1.3.sql
2241 bool_plperl--1.0.sql
2243 bool_plperlu.control
2244 btree_gin--1.0--1.1.sql
2246 btree_gin--1.1--1.2.sql
2247 btree_gin--1.2--1.3.sql
2249 btree_gist--1.0--1.1.sql
2250 btree_gist--1.1--1.2.sql
2251 btree_gist--1.2--1.3.sql
2253 btree_gist--1.3--1.4.sql
2254 btree_gist--1.4--1.5.sql
2255 btree_gist--1.5--1.6.sql
2256 btree_gist--1.6--1.7.sql
2258 citext--1.0--1.1.sql
2259 citext--1.1--1.2.sql
2260 citext--1.2--1.3.sql
2261 citext--1.3--1.4.sql
2262 citext--1.4--1.5.sql
2264 citext--1.5--1.6.sql
2273 dblink--1.0--1.1.sql
2274 dblink--1.1--1.2.sql
2281 earthdistance--1.0--1.1.sql
2282 earthdistance--1.1.sql
2283 earthdistance.control
2286 fuzzystrmatch--1.0--1.1.sql
2287 fuzzystrmatch--1.1.sql
2288 fuzzystrmatch.control
2289 hstore--1.1--1.2.sql
2290 hstore--1.2--1.3.sql
2291 hstore--1.3--1.4.sql
2292 hstore--1.4--1.5.sql
2294 hstore--1.5--1.6.sql
2295 hstore--1.6--1.7.sql
2296 hstore--1.7--1.8.sql
2298 insert_username--1.0.sql
2299 insert_username.control
2300 intagg--1.0--1.1.sql
2303 intarray--1.0--1.1.sql
2304 intarray--1.1--1.2.sql
2305 intarray--1.2--1.3.sql
2307 intarray--1.3--1.4.sql
2308 intarray--1.4--1.5.sql
2321 moddatetime--1.0.sql
2323 old_snapshot--1.0.sql
2324 old_snapshot.control
2325 pageinspect--1.0--1.1.sql
2326 pageinspect--1.1--1.2.sql
2327 pageinspect--1.2--1.3.sql
2328 pageinspect--1.3--1.4.sql
2329 pageinspect--1.4--1.5.sql
2330 pageinspect--1.5--1.6.sql
2331 pageinspect--1.5.sql
2332 pageinspect--1.6--1.7.sql
2333 pageinspect--1.7--1.8.sql
2334 pageinspect--1.8--1.9.sql
2335 pageinspect--1.9--1.10.sql
2337 pg_buffercache--1.0--1.1.sql
2338 pg_buffercache--1.1--1.2.sql
2339 pg_buffercache--1.2--1.3.sql
2340 pg_buffercache--1.2.sql
2341 pg_buffercache.control
2342 pg_freespacemap--1.0--1.1.sql
2343 pg_freespacemap--1.1--1.2.sql
2344 pg_freespacemap--1.1.sql
2345 pg_freespacemap.control
2346 pg_prewarm--1.0--1.1.sql
2347 pg_prewarm--1.1--1.2.sql
2350 pg_stat_statements--1.0--1.1.sql
2351 pg_stat_statements--1.1--1.2.sql
2352 pg_stat_statements--1.2--1.3.sql
2353 pg_stat_statements--1.3--1.4.sql
2354 pg_stat_statements--1.4--1.5.sql
2355 pg_stat_statements--1.4.sql
2356 pg_stat_statements--1.5--1.6.sql
2357 pg_stat_statements--1.6--1.7.sql
2358 pg_stat_statements--1.7--1.8.sql
2359 pg_stat_statements--1.8--1.9.sql
2360 pg_stat_statements--1.9--1.10.sql
2361 pg_stat_statements.control
2364 pg_trgm--1.0--1.1.sql
2365 pg_trgm--1.1--1.2.sql
2366 pg_trgm--1.2--1.3.sql
2367 pg_trgm--1.3--1.4.sql
2369 pg_trgm--1.4--1.5.sql
2370 pg_trgm--1.5--1.6.sql
2372 pg_visibility--1.0--1.1.sql
2373 pg_visibility--1.1--1.2.sql
2374 pg_visibility--1.1.sql
2375 pg_visibility.control
2376 pgcrypto--1.0--1.1.sql
2377 pgcrypto--1.1--1.2.sql
2378 pgcrypto--1.2--1.3.sql
2381 pgrowlocks--1.0--1.1.sql
2382 pgrowlocks--1.1--1.2.sql
2385 pgstattuple--1.0--1.1.sql
2386 pgstattuple--1.1--1.2.sql
2387 pgstattuple--1.2--1.3.sql
2388 pgstattuple--1.3--1.4.sql
2389 pgstattuple--1.4--1.5.sql
2390 pgstattuple--1.4.sql
2392 postgres_fdw--1.0--1.1.sql
2393 postgres_fdw--1.0.sql
2394 postgres_fdw.control
2403 sslinfo--1.0--1.1.sql
2404 sslinfo--1.1--1.2.sql
2411 tsm_system_rows--1.0.sql
2412 tsm_system_rows.control
2413 tsm_system_time--1.0.sql
2414 tsm_system_time.control
2415 unaccent--1.0--1.1.sql
2418 uuid-ossp--1.0--1.1.sql
2424 share/postgresql/tsearch_data/
2429 [FILE:510:manifests/plist.plperl]
2430 include/postgresql/server/
2435 bool_plperl.%%SHARED_OBJECT%%
2436 hstore_plperl.%%SHARED_OBJECT%%
2437 jsonb_plperl.%%SHARED_OBJECT%%
2438 plperl.%%SHARED_OBJECT%%
2439 share/postgresql/extension/
2440 bool_plperlu--1.0.sql
2441 hstore_plperl--1.0.sql
2442 hstore_plperl.control
2443 hstore_plperlu--1.0.sql
2444 hstore_plperlu.control
2445 jsonb_plperl--1.0.sql
2446 jsonb_plperl.control
2447 jsonb_plperlu--1.0.sql
2448 jsonb_plperlu.control
2455 [FILE:714:manifests/plist.plpython]
2456 include/postgresql/server/
2466 plpy_subxactobject.h
2471 hstore_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2472 jsonb_plpython3.%%SHARED_OBJECT%%
2473 ltree_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2474 plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2475 share/postgresql/extension/
2476 hstore_plpython3u--1.0.sql
2477 hstore_plpython3u.control
2478 jsonb_plpython3u--1.0.sql
2479 jsonb_plpython3u.control
2480 ltree_plpython3u--1.0.sql
2481 ltree_plpython3u.control
2482 plpython%%PYTHON_MAJOR_VER%%u--1.0.sql
2483 plpython%%PYTHON_MAJOR_VER%%u.control
2486 [FILE:131:manifests/plist.pltcl]
2487 lib/postgresql/pltcl.%%SHARED_OBJECT%%
2488 share/postgresql/extension/
2495 [FILE:111:manifests/plist.docs]
2496 share/doc/postgresql/extension/
2498 insert_username.example
2503 [FILE:9021:manifests/plist.nls]
2504 share/locale/cs/LC_MESSAGES/
2506 ecpglib6-%%PGVER%%.mo
2508 pg_archivecleanup-%%PGVER%%.mo
2509 pg_config-%%PGVER%%.mo
2510 pg_controldata-%%PGVER%%.mo
2512 pg_dump-%%PGVER%%.mo
2513 pg_resetwal-%%PGVER%%.mo
2514 pg_upgrade-%%PGVER%%.mo
2515 pgscripts-%%PGVER%%.mo
2517 plpgsql-%%PGVER%%.mo
2518 plpython-%%PGVER%%.mo
2521 share/locale/de/LC_MESSAGES/
2523 ecpglib6-%%PGVER%%.mo
2526 pg_amcheck-%%PGVER%%.mo
2527 pg_archivecleanup-%%PGVER%%.mo
2528 pg_basebackup-%%PGVER%%.mo
2529 pg_checksums-%%PGVER%%.mo
2530 pg_config-%%PGVER%%.mo
2531 pg_controldata-%%PGVER%%.mo
2533 pg_dump-%%PGVER%%.mo
2534 pg_resetwal-%%PGVER%%.mo
2535 pg_rewind-%%PGVER%%.mo
2536 pg_test_fsync-%%PGVER%%.mo
2537 pg_test_timing-%%PGVER%%.mo
2538 pg_upgrade-%%PGVER%%.mo
2539 pg_verifybackup-%%PGVER%%.mo
2540 pg_waldump-%%PGVER%%.mo
2541 pgscripts-%%PGVER%%.mo
2543 plpgsql-%%PGVER%%.mo
2544 plpython-%%PGVER%%.mo
2546 postgres-%%PGVER%%.mo
2548 share/locale/el/LC_MESSAGES/
2550 ecpglib6-%%PGVER%%.mo
2553 pg_amcheck-%%PGVER%%.mo
2554 pg_archivecleanup-%%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_timing-%%PGVER%%.mo
2562 pg_verifybackup-%%PGVER%%.mo
2563 pgscripts-%%PGVER%%.mo
2565 plpgsql-%%PGVER%%.mo
2566 plpython-%%PGVER%%.mo
2569 share/locale/es/LC_MESSAGES/
2571 ecpglib6-%%PGVER%%.mo
2574 pg_amcheck-%%PGVER%%.mo
2575 pg_archivecleanup-%%PGVER%%.mo
2576 pg_basebackup-%%PGVER%%.mo
2577 pg_checksums-%%PGVER%%.mo
2578 pg_config-%%PGVER%%.mo
2579 pg_controldata-%%PGVER%%.mo
2581 pg_dump-%%PGVER%%.mo
2582 pg_resetwal-%%PGVER%%.mo
2583 pg_rewind-%%PGVER%%.mo
2584 pg_test_fsync-%%PGVER%%.mo
2585 pg_test_timing-%%PGVER%%.mo
2586 pg_upgrade-%%PGVER%%.mo
2587 pg_verifybackup-%%PGVER%%.mo
2588 pg_waldump-%%PGVER%%.mo
2589 pgscripts-%%PGVER%%.mo
2591 plpgsql-%%PGVER%%.mo
2592 plpython-%%PGVER%%.mo
2594 postgres-%%PGVER%%.mo
2596 share/locale/fr/LC_MESSAGES/
2598 ecpglib6-%%PGVER%%.mo
2601 pg_amcheck-%%PGVER%%.mo
2602 pg_archivecleanup-%%PGVER%%.mo
2603 pg_basebackup-%%PGVER%%.mo
2604 pg_checksums-%%PGVER%%.mo
2605 pg_config-%%PGVER%%.mo
2606 pg_controldata-%%PGVER%%.mo
2608 pg_dump-%%PGVER%%.mo
2609 pg_resetwal-%%PGVER%%.mo
2610 pg_rewind-%%PGVER%%.mo
2611 pg_test_fsync-%%PGVER%%.mo
2612 pg_test_timing-%%PGVER%%.mo
2613 pg_upgrade-%%PGVER%%.mo
2614 pg_verifybackup-%%PGVER%%.mo
2615 pg_waldump-%%PGVER%%.mo
2616 pgscripts-%%PGVER%%.mo
2618 plpgsql-%%PGVER%%.mo
2619 plpython-%%PGVER%%.mo
2621 postgres-%%PGVER%%.mo
2623 share/locale/he/LC_MESSAGES/pg_config-%%PGVER%%.mo
2624 share/locale/it/LC_MESSAGES/
2626 ecpglib6-%%PGVER%%.mo
2629 pg_amcheck-%%PGVER%%.mo
2630 pg_archivecleanup-%%PGVER%%.mo
2631 pg_basebackup-%%PGVER%%.mo
2632 pg_checksums-%%PGVER%%.mo
2633 pg_config-%%PGVER%%.mo
2634 pg_controldata-%%PGVER%%.mo
2636 pg_dump-%%PGVER%%.mo
2637 pg_resetwal-%%PGVER%%.mo
2638 pg_rewind-%%PGVER%%.mo
2639 pg_test_fsync-%%PGVER%%.mo
2640 pg_test_timing-%%PGVER%%.mo
2641 pg_upgrade-%%PGVER%%.mo
2642 pg_verifybackup-%%PGVER%%.mo
2643 pg_waldump-%%PGVER%%.mo
2644 pgscripts-%%PGVER%%.mo
2646 plpgsql-%%PGVER%%.mo
2647 plpython-%%PGVER%%.mo
2649 postgres-%%PGVER%%.mo
2651 share/locale/ja/LC_MESSAGES/
2653 ecpglib6-%%PGVER%%.mo
2656 pg_amcheck-%%PGVER%%.mo
2657 pg_archivecleanup-%%PGVER%%.mo
2658 pg_basebackup-%%PGVER%%.mo
2659 pg_checksums-%%PGVER%%.mo
2660 pg_config-%%PGVER%%.mo
2661 pg_controldata-%%PGVER%%.mo
2663 pg_dump-%%PGVER%%.mo
2664 pg_resetwal-%%PGVER%%.mo
2665 pg_rewind-%%PGVER%%.mo
2666 pg_test_fsync-%%PGVER%%.mo
2667 pg_test_timing-%%PGVER%%.mo
2668 pg_upgrade-%%PGVER%%.mo
2669 pg_verifybackup-%%PGVER%%.mo
2670 pg_waldump-%%PGVER%%.mo
2671 pgscripts-%%PGVER%%.mo
2673 plpgsql-%%PGVER%%.mo
2674 plpython-%%PGVER%%.mo
2676 postgres-%%PGVER%%.mo
2678 share/locale/ka/LC_MESSAGES/
2680 ecpglib6-%%PGVER%%.mo
2683 pg_amcheck-%%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_verifybackup-%%PGVER%%.mo
2697 pg_waldump-%%PGVER%%.mo
2698 pgscripts-%%PGVER%%.mo
2700 plpgsql-%%PGVER%%.mo
2701 plpython-%%PGVER%%.mo
2704 share/locale/ko/LC_MESSAGES/
2706 ecpglib6-%%PGVER%%.mo
2708 pg_archivecleanup-%%PGVER%%.mo
2709 pg_config-%%PGVER%%.mo
2710 pg_controldata-%%PGVER%%.mo
2712 pg_dump-%%PGVER%%.mo
2713 pg_resetwal-%%PGVER%%.mo
2714 pg_upgrade-%%PGVER%%.mo
2715 pg_verifybackup-%%PGVER%%.mo
2716 pgscripts-%%PGVER%%.mo
2718 plpgsql-%%PGVER%%.mo
2719 plpython-%%PGVER%%.mo
2721 postgres-%%PGVER%%.mo
2723 share/locale/pl/LC_MESSAGES/
2725 ecpglib6-%%PGVER%%.mo
2726 pg_config-%%PGVER%%.mo
2728 plpgsql-%%PGVER%%.mo
2729 plpython-%%PGVER%%.mo
2731 share/locale/pt_BR/LC_MESSAGES/
2733 ecpglib6-%%PGVER%%.mo
2735 pg_archivecleanup-%%PGVER%%.mo
2736 pg_checksums-%%PGVER%%.mo
2737 pg_config-%%PGVER%%.mo
2738 pg_controldata-%%PGVER%%.mo
2740 pg_resetwal-%%PGVER%%.mo
2741 pg_test_fsync-%%PGVER%%.mo
2742 pg_test_timing-%%PGVER%%.mo
2743 pgscripts-%%PGVER%%.mo
2745 plpgsql-%%PGVER%%.mo
2746 plpython-%%PGVER%%.mo
2748 share/locale/ru/LC_MESSAGES/
2750 ecpglib6-%%PGVER%%.mo
2753 pg_amcheck-%%PGVER%%.mo
2754 pg_archivecleanup-%%PGVER%%.mo
2755 pg_basebackup-%%PGVER%%.mo
2756 pg_checksums-%%PGVER%%.mo
2757 pg_config-%%PGVER%%.mo
2758 pg_controldata-%%PGVER%%.mo
2760 pg_dump-%%PGVER%%.mo
2761 pg_resetwal-%%PGVER%%.mo
2762 pg_rewind-%%PGVER%%.mo
2763 pg_test_fsync-%%PGVER%%.mo
2764 pg_test_timing-%%PGVER%%.mo
2765 pg_upgrade-%%PGVER%%.mo
2766 pg_verifybackup-%%PGVER%%.mo
2767 pg_waldump-%%PGVER%%.mo
2768 pgscripts-%%PGVER%%.mo
2770 plpgsql-%%PGVER%%.mo
2771 plpython-%%PGVER%%.mo
2773 postgres-%%PGVER%%.mo
2775 share/locale/sv/LC_MESSAGES/
2777 ecpglib6-%%PGVER%%.mo
2780 pg_amcheck-%%PGVER%%.mo
2781 pg_archivecleanup-%%PGVER%%.mo
2782 pg_basebackup-%%PGVER%%.mo
2783 pg_checksums-%%PGVER%%.mo
2784 pg_config-%%PGVER%%.mo
2785 pg_controldata-%%PGVER%%.mo
2787 pg_dump-%%PGVER%%.mo
2788 pg_resetwal-%%PGVER%%.mo
2789 pg_rewind-%%PGVER%%.mo
2790 pg_test_fsync-%%PGVER%%.mo
2791 pg_test_timing-%%PGVER%%.mo
2792 pg_upgrade-%%PGVER%%.mo
2793 pg_verifybackup-%%PGVER%%.mo
2794 pg_waldump-%%PGVER%%.mo
2795 pgscripts-%%PGVER%%.mo
2797 plpgsql-%%PGVER%%.mo
2798 plpython-%%PGVER%%.mo
2800 postgres-%%PGVER%%.mo
2802 share/locale/tr/LC_MESSAGES/
2804 ecpglib6-%%PGVER%%.mo
2805 pg_archivecleanup-%%PGVER%%.mo
2806 pg_config-%%PGVER%%.mo
2807 pg_controldata-%%PGVER%%.mo
2809 pg_dump-%%PGVER%%.mo
2810 pgscripts-%%PGVER%%.mo
2812 plpgsql-%%PGVER%%.mo
2813 plpython-%%PGVER%%.mo
2815 share/locale/uk/LC_MESSAGES/
2817 ecpglib6-%%PGVER%%.mo
2820 pg_amcheck-%%PGVER%%.mo
2821 pg_archivecleanup-%%PGVER%%.mo
2822 pg_basebackup-%%PGVER%%.mo
2823 pg_checksums-%%PGVER%%.mo
2824 pg_config-%%PGVER%%.mo
2825 pg_controldata-%%PGVER%%.mo
2827 pg_dump-%%PGVER%%.mo
2828 pg_resetwal-%%PGVER%%.mo
2829 pg_rewind-%%PGVER%%.mo
2830 pg_test_fsync-%%PGVER%%.mo
2831 pg_test_timing-%%PGVER%%.mo
2832 pg_upgrade-%%PGVER%%.mo
2833 pg_verifybackup-%%PGVER%%.mo
2834 pg_waldump-%%PGVER%%.mo
2835 pgscripts-%%PGVER%%.mo
2837 plpgsql-%%PGVER%%.mo
2838 plpython-%%PGVER%%.mo
2840 postgres-%%PGVER%%.mo
2842 share/locale/vi/LC_MESSAGES/
2844 ecpglib6-%%PGVER%%.mo
2845 pg_config-%%PGVER%%.mo
2847 plpgsql-%%PGVER%%.mo
2848 plpython-%%PGVER%%.mo
2850 share/locale/zh_CN/LC_MESSAGES/
2852 ecpglib6-%%PGVER%%.mo
2855 pg_amcheck-%%PGVER%%.mo
2856 pg_archivecleanup-%%PGVER%%.mo
2857 pg_config-%%PGVER%%.mo
2858 pg_controldata-%%PGVER%%.mo
2860 pg_dump-%%PGVER%%.mo
2861 pg_resetwal-%%PGVER%%.mo
2862 pg_rewind-%%PGVER%%.mo
2863 pg_test_timing-%%PGVER%%.mo
2864 pg_upgrade-%%PGVER%%.mo
2865 pg_verifybackup-%%PGVER%%.mo
2866 pgscripts-%%PGVER%%.mo
2868 plpgsql-%%PGVER%%.mo
2869 plpython-%%PGVER%%.mo
2871 postgres-%%PGVER%%.mo
2873 share/locale/zh_TW/LC_MESSAGES/ecpg-%%PGVER%%.mo
2876 [FILE:393:patches/patch-configure]
2877 --- configure.orig 2022-11-07 21:36:53 UTC
2879 @@ -12767,7 +12767,7 @@ if ac_fn_c_try_link "$LINENO"; then :
2880 # recognize dependent libraries; assume curses is needed if we didn't
2881 # find any dependency.
2883 - netbsd* | openbsd*)
2885 if test x"$pgac_lib" = x"" ; then
2886 pgac_lib=" -lcurses"
2890 [FILE:349:patches/patch-doc-Makefile]
2891 --- doc/Makefile.orig 2022-11-07 21:36:53 UTC
2893 @@ -12,5 +12,5 @@ subdir = doc
2895 include $(top_builddir)/src/Makefile.global
2897 -all distprep html man install installdirs uninstall clean distclean maintainer-clean:
2898 +all distprep man install installdirs uninstall clean distclean maintainer-clean:
2902 [FILE:1196:patches/patch-doc_src_sgml_Makefile]
2903 --- doc/src/sgml/Makefile.orig 2022-11-07 21:36:53 UTC
2904 +++ doc/src/sgml/Makefile
2907 # Make "html" the default target, since that is what most people tend
2912 # We don't need the tree-wide headers or install support here.
2913 NO_GENERATED_HEADERS=yes
2914 @@ -26,7 +26,7 @@ top_builddir = ../../..
2915 include $(top_builddir)/src/Makefile.global
2921 distprep: html distprep-man
2923 @@ -65,8 +65,6 @@ ALL_IMAGES := $(wildcard $(srcdir)/image
2927 -man distprep-man: man-stamp
2929 man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML)
2930 $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^)
2931 $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $(wordlist 1,2,$^)
2932 @@ -220,10 +218,10 @@ check: postgres.sgml $(ALLSGML) check-ta
2936 -install: install-html install-man
2937 +install: install-man
2940 - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2941 + $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2943 # If the install used a man directory shared with other applications, this will remove all files.
2947 [FILE:498:patches/patch-src-backend-Makefile]
2948 --- src/backend/Makefile.orig 2022-11-07 21:36:53 UTC
2949 +++ src/backend/Makefile
2950 @@ -117,6 +117,8 @@ endif # aix
2952 $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport
2954 +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
2957 # The postgres.o target is needed by the rule in Makefile.global that
2958 # creates the exports file when MAKE_EXPORTS = true.
2961 [FILE:863:patches/patch-src_Makefile.shlib]
2962 --- src/Makefile.shlib.orig 2022-11-07 21:36:53 UTC
2963 +++ src/Makefile.shlib
2964 @@ -166,6 +166,9 @@ ifeq ($(PORTNAME), freebsd)
2967 ifeq ($(PORTNAME), netbsd)
2968 + ifdef SO_MAJOR_VERSION
2969 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2971 LINK.shared = $(COMPILER) -shared
2973 LINK.shared += -Wl,-x,-soname,$(soname)
2974 @@ -212,6 +215,9 @@ endif
2976 ifeq ($(PORTNAME), linux)
2977 LINK.shared = $(COMPILER) -shared
2978 + ifdef SO_MAJOR_VERSION
2979 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2982 LINK.shared += -Wl,-soname,$(soname)
2984 @@ -223,6 +229,9 @@ ifeq ($(PORTNAME), linux)
2987 ifeq ($(PORTNAME), solaris)
2988 + ifdef SO_MAJOR_VERSION
2989 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2992 LINK.shared = $(COMPILER) -shared -Wl,-Bsymbolic
2996 [FILE:686:patches/patch-src_backend_utils_misc_postgresql.conf.sample]
2997 --- src/backend/utils/misc/postgresql.conf.sample.orig 2022-11-07 21:36:53 UTC
2998 +++ src/backend/utils/misc/postgresql.conf.sample
3003 +log_destination = 'syslog'
3004 #log_destination = 'stderr' # Valid values are combinations of
3005 # stderr, csvlog, jsonlog, syslog, and
3006 # eventlog, depending on platform.
3009 #cluster_name = '' # added to process titles if nonempty
3010 # (change requires restart)
3011 -#update_process_title = on
3013 +# On FreeBSD, this is a performance hog, so keep it off if you need speed
3014 +update_process_title = off
3017 #------------------------------------------------------------------------------
3020 [FILE:3090:files/502.pgsql.in]
3023 # Maintenance shell script to vacuum and backup database
3024 # Put this in /usr/local/etc/periodic/daily, and it will be run
3027 # Written by Palle Girgensohn <girgen@pingpong.net>
3029 # In public domain, do what you like with it,
3030 # and use it at your own risk... :)
3033 # Define these variables in either /etc/periodic.conf or
3034 # /etc/periodic.conf.local to override the default values.
3036 # daily_pgsql_backup_enable="YES" # do backup of all databases
3037 # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases
3038 # daily_pgsql_vacuum_enable="YES" # do vacuum
3040 # If there is a global system configuration file, suck it in.
3042 if [ -r /etc/defaults/periodic.conf ]
3044 . /etc/defaults/periodic.conf
3045 source_periodic_confs
3048 : ${daily_pgsql_user:="%%PG_USER%%"}
3049 : ${daily_pgsql_port:=5432}
3050 : ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"}
3051 : ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"}
3052 : ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"}
3053 # backupdir is relative to ~pgsql home directory unless it begins with a slash:
3054 : ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"}
3055 : ${daily_pgsql_savedays:="7"}
3057 # allow '~ยด in dir name
3058 eval backupdir=${daily_pgsql_backupdir}
3063 # daily_pgsql_backupdir must be writeable by user %%PG_USER%%
3064 # ~%%PG_USER%% is just that under normal circumstances,
3065 # but this might not be where you want the backups...
3066 if [ ! -d ${backupdir} ] ; then
3067 echo Creating ${backupdir}
3068 mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir}
3072 echo "PostgreSQL backups"
3077 now=`date "+%Y-%m-%dT%H:%M:%S"`
3078 file=${daily_pgsql_backupdir}/pgglobals_${now}
3079 su -l ${daily_pgsql_user} -c \
3080 "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz"
3085 file=${backupdir}/pgdump_${db}_${now}
3086 su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
3087 [ $? -gt 0 ] && rc=3
3091 if [ $rc -gt 0 ]; then
3093 echo "Errors were reported during backup."
3096 # cleaning up old data
3097 find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \
3098 -a -mtime +${daily_pgsql_savedays} -delete
3102 case "$daily_pgsql_backup_enable" in
3104 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\'"`
3105 pgsql_backup $dbnames
3115 pgsql_backup $daily_pgsql_backup_enable
3119 case "$daily_pgsql_vacuum_enable" in
3123 echo "PostgreSQL vacuum"
3124 su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}"
3128 echo "Errors were reported during vacuum."
3137 [FILE:3182:files/postgresql.in]
3140 # PROVIDE: postgresql
3144 # Add the following line to /etc/rc.conf to enable PostgreSQL:
3146 # postgresql_enable="YES"
3148 # postgresql_data="%%PREFIX%%/%%PG_USER%%/%%DATADIR%%"
3149 # postgresql_flags="-w -s -m fast"
3150 # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
3151 # postgresql_class="default"
3152 # postgresql_profiles=""
3154 # See %%PREFIX%%/share/doc/postgresql/README-server for more info
3156 # This scripts takes one of the following commands:
3158 # start stop restart reload status initdb
3160 # For postmaster startup options, edit ${postgresql_data}/postgresql.conf
3162 command=%%PREFIX%%/bin/pg_ctl
3166 load_rc_config postgresql
3169 postgresql_enable=${postgresql_enable:-"NO"}
3170 postgresql_flags=${postgresql_flags:-"-w -s -m fast"}
3171 postgresql_user=${postgresql_user:-"%%PG_USER%%"}
3172 eval postgresql_data=${postgresql_data:-"~${postgresql_user}/%%DATADIR%%"}
3173 postgresql_class=${postgresql_class:-"default"}
3174 postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"}
3177 rcvar=postgresql_enable
3178 extra_commands="reload initdb"
3180 start_cmd="postgresql_command start"
3181 stop_cmd="postgresql_command stop"
3182 restart_cmd="postgresql_command restart"
3183 reload_cmd="postgresql_command reload"
3184 status_cmd="postgresql_command status"
3186 initdb_cmd="postgresql_initdb"
3188 if [ -n "$2" ]; then
3190 if [ "x${postgresql_profiles}" != "x" ]; then
3191 eval postgresql_data="\${postgresql_${profile}_data:-}"
3192 if [ "x${postgresql_data}" = "x" ]; then
3193 echo "You must define a data directory (postgresql_${profile}_data)"
3196 eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}"
3197 eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}"
3198 eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}"
3199 eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}"
3202 if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then
3203 for profile in ${postgresql_profiles}; do
3204 eval _enable="\${postgresql_${profile}_enable}"
3205 case "x${_enable:-${postgresql_enable}}" in
3206 x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee])
3212 if test -z "$_enable"; then
3213 _var=postgresql_enable
3215 _var=postgresql_"${profile}"_enable
3218 "'${_enable:-${postgresql_enable}}'" \
3220 "Profile ${profile} skipped."
3224 echo "===> postgresql profile: ${profile}"
3225 %%PREFIX%%/etc/rc.d/postgresql $1 ${profile}
3227 if [ "0${retcode}" -ne 0 ]; then
3228 failed="${profile} (${retcode}) ${failed:-}"
3230 success="${profile} ${success:-}"
3237 command_args="-D ${postgresql_data} ${postgresql_flags}"
3239 postgresql_command()
3241 su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
3246 su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}"