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/v14.6
14 DISTFILE[1]= postgresql-14.6.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:runtime:standard
44 libxslt:single:standard
45 readline:single:standard
48 EXRUN[contrib]= postgresql14:client:standard
49 libxslt:single:standard
51 gettext:runtime:standard
54 EXRUN[server]= postgresql14:client:standard
58 USERGROUP_SPKG= server
60 USES= bison gmake perl:build tcl:build ssl python:build
61 zlib gettext-runtime gettext-tools cpe
63 DISTNAME= postgresql-14.6
65 LICENSE= PostgreSQL:server
66 LICENSE_FILE= PostgreSQL:{{WRKSRC}}/COPYRIGHT
69 CPE_PRODUCT= postgresql
70 CPE_VENDOR= postgresql
71 FPC_EQUIVALENT= databases/postgresql14-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 508840fc1809d39ab72274d5f137dabb9fd7fb4f933da4168aeebb20069edf22 22177474 postgresql/postgresql-14.6.tar.bz2
181 [FILE:8038:manifests/plist.server]
198 etc/periodic/daily/502.pgsql
199 include/postgresql/server/plpgsql.h
210 latin2_and_win1250.so
225 utf8_and_iso8859_1.so
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:20984:manifests/plist.client]
903 libecpg_compat.so.3.11
949 include/libpq/libpq-fs.h
950 include/postgresql/informix/esql/
954 include/postgresql/internal/
960 include/postgresql/internal/libpq/pqcomm.h
961 include/postgresql/server/
983 include/postgresql/server/access/
1067 include/postgresql/server/bootstrap/bootstrap.h
1068 include/postgresql/server/catalog/
1110 pg_db_role_setting.h
1111 pg_db_role_setting_d.h
1121 pg_event_trigger_d.h
1124 pg_foreign_data_wrapper.h
1125 pg_foreign_data_wrapper_d.h
1127 pg_foreign_server_d.h
1129 pg_foreign_table_d.h
1140 pg_largeobject_metadata.h
1141 pg_largeobject_metadata_d.h
1150 pg_partitioned_table.h
1151 pg_partitioned_table_d.h
1158 pg_publication_rel.h
1159 pg_publication_rel_d.h
1162 pg_replication_origin.h
1163 pg_replication_origin_d.h
1173 pg_shdescription_d.h
1179 pg_statistic_ext_d.h
1180 pg_statistic_ext_data.h
1181 pg_statistic_ext_data_d.h
1184 pg_subscription_rel.h
1185 pg_subscription_rel_d.h
1195 pg_ts_config_map_d.h
1211 include/postgresql/server/commands/
1248 include/postgresql/server/common/
1280 unicode_combining_table.h
1282 unicode_norm_hashfunc.h
1283 unicode_norm_table.h
1284 unicode_normprops_table.h
1286 include/postgresql/server/datatype/timestamp.h
1287 include/postgresql/server/executor/
1301 nodeBitmapHeapscan.h
1302 nodeBitmapIndexscan.h
1313 nodeIncrementalSort.h
1323 nodeNamedtuplestorescan.h
1326 nodeRecursiveunion.h
1347 include/postgresql/server/extension/cube/cubedata.h
1348 include/postgresql/server/extension/hstore/hstore.h
1349 include/postgresql/server/extension/isn/isn.h
1350 include/postgresql/server/extension/ltree/ltree.h
1351 include/postgresql/server/extension/seg/segdata.h
1352 include/postgresql/server/fe_utils/
1367 include/postgresql/server/foreign/
1370 include/postgresql/server/jit/
1374 include/postgresql/server/lib/
1389 include/postgresql/server/libpq/
1404 include/postgresql/server/mb/
1407 include/postgresql/server/nodes/
1429 include/postgresql/server/optimizer/
1440 geqo_recombination.h
1457 include/postgresql/server/parser/
1481 include/postgresql/server/partitioning/
1486 include/postgresql/server/port/
1504 include/postgresql/server/port/atomics/
1516 include/postgresql/server/port/win32/
1521 include/postgresql/server/port/win32/arpa/inet.h
1522 include/postgresql/server/port/win32/netinet/in.h
1523 include/postgresql/server/port/win32/sys/
1526 include/postgresql/server/port/win32_msvc/
1530 include/postgresql/server/port/win32_msvc/sys/
1534 include/postgresql/server/portability/
1537 include/postgresql/server/postmaster/
1540 bgworker_internals.h
1549 include/postgresql/server/regex/
1555 include/postgresql/server/replication/
1576 include/postgresql/server/rewrite/
1582 rewriteSearchCycle.h
1585 include/postgresql/server/snowball/header.h
1586 include/postgresql/server/snowball/libstemmer/
1589 stem_ISO_8859_1_basque.h
1590 stem_ISO_8859_1_catalan.h
1591 stem_ISO_8859_1_danish.h
1592 stem_ISO_8859_1_dutch.h
1593 stem_ISO_8859_1_english.h
1594 stem_ISO_8859_1_finnish.h
1595 stem_ISO_8859_1_french.h
1596 stem_ISO_8859_1_german.h
1597 stem_ISO_8859_1_indonesian.h
1598 stem_ISO_8859_1_irish.h
1599 stem_ISO_8859_1_italian.h
1600 stem_ISO_8859_1_norwegian.h
1601 stem_ISO_8859_1_porter.h
1602 stem_ISO_8859_1_portuguese.h
1603 stem_ISO_8859_1_spanish.h
1604 stem_ISO_8859_1_swedish.h
1605 stem_ISO_8859_2_hungarian.h
1606 stem_ISO_8859_2_romanian.h
1607 stem_KOI8_R_russian.h
1609 stem_UTF_8_armenian.h
1611 stem_UTF_8_catalan.h
1614 stem_UTF_8_english.h
1615 stem_UTF_8_finnish.h
1620 stem_UTF_8_hungarian.h
1621 stem_UTF_8_indonesian.h
1623 stem_UTF_8_italian.h
1624 stem_UTF_8_lithuanian.h
1626 stem_UTF_8_norwegian.h
1628 stem_UTF_8_portuguese.h
1629 stem_UTF_8_romanian.h
1630 stem_UTF_8_russian.h
1631 stem_UTF_8_serbian.h
1632 stem_UTF_8_spanish.h
1633 stem_UTF_8_swedish.h
1635 stem_UTF_8_turkish.h
1636 stem_UTF_8_yiddish.h
1637 include/postgresql/server/statistics/
1638 extended_stats_internal.h
1640 include/postgresql/server/storage/
1651 condition_variable.h
1676 predicate_internals.h
1696 include/postgresql/server/tcop/
1705 include/postgresql/server/tsearch/
1711 include/postgresql/server/tsearch/dicts/
1714 include/postgresql/server/utils/
1831 lib/postgresql/pgxs/config/
1834 lib/postgresql/pgxs/src/
1839 lib/postgresql/pgxs/src/makefiles/pgxs.mk
1840 lib/postgresql/pgxs/src/test/isolation/
1842 pg_isolation_regress
1843 lib/postgresql/pgxs/src/test/regress/pg_regress
1854 pg_archivecleanup.1.gz
1871 pg_verifybackup.1.gz
1882 SPI_commit_and_chain.3.gz
1884 SPI_connect_ext.3.gz
1886 SPI_cursor_close.3.gz
1887 SPI_cursor_fetch.3.gz
1888 SPI_cursor_find.3.gz
1889 SPI_cursor_move.3.gz
1890 SPI_cursor_open.3.gz
1891 SPI_cursor_open_with_args.3.gz
1892 SPI_cursor_open_with_paramlist.3.gz
1893 SPI_cursor_parse_open.3.gz
1897 SPI_execute_extended.3.gz
1898 SPI_execute_plan.3.gz
1899 SPI_execute_plan_extended.3.gz
1900 SPI_execute_plan_with_paramlist.3.gz
1901 SPI_execute_with_args.3.gz
1907 SPI_freetuptable.3.gz
1908 SPI_getargcount.3.gz
1909 SPI_getargtypeid.3.gz
1916 SPI_is_cursor_plan.3.gz
1918 SPI_modifytuple.3.gz
1922 SPI_prepare_cursor.3.gz
1923 SPI_prepare_extended.3.gz
1924 SPI_prepare_params.3.gz
1925 SPI_register_relation.3.gz
1926 SPI_register_trigger_data.3.gz
1928 SPI_result_code_string.3.gz
1929 SPI_returntuple.3.gz
1931 SPI_rollback_and_chain.3.gz
1933 SPI_scroll_cursor_fetch.3.gz
1934 SPI_scroll_cursor_move.3.gz
1935 SPI_start_transaction.3.gz
1936 SPI_unregister_relation.3.gz
1938 dblink_build_sql_delete.3.gz
1939 dblink_build_sql_insert.3.gz
1940 dblink_build_sql_update.3.gz
1941 dblink_cancel_query.3.gz
1944 dblink_connect_u.3.gz
1945 dblink_disconnect.3.gz
1946 dblink_error_message.3.gz
1949 dblink_get_connections.3.gz
1950 dblink_get_notify.3.gz
1951 dblink_get_pkey.3.gz
1952 dblink_get_result.3.gz
1955 dblink_send_query.3.gz
1958 ALTER_AGGREGATE.7.gz
1959 ALTER_COLLATION.7.gz
1960 ALTER_CONVERSION.7.gz
1962 ALTER_DEFAULT_PRIVILEGES.7.gz
1964 ALTER_EVENT_TRIGGER.7.gz
1965 ALTER_EXTENSION.7.gz
1966 ALTER_FOREIGN_DATA_WRAPPER.7.gz
1967 ALTER_FOREIGN_TABLE.7.gz
1972 ALTER_LARGE_OBJECT.7.gz
1973 ALTER_MATERIALIZED_VIEW.7.gz
1975 ALTER_OPERATOR_CLASS.7.gz
1976 ALTER_OPERATOR_FAMILY.7.gz
1978 ALTER_PROCEDURE.7.gz
1979 ALTER_PUBLICATION.7.gz
1986 ALTER_STATISTICS.7.gz
1987 ALTER_SUBSCRIPTION.7.gz
1990 ALTER_TABLESPACE.7.gz
1991 ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
1992 ALTER_TEXT_SEARCH_DICTIONARY.7.gz
1993 ALTER_TEXT_SEARCH_PARSER.7.gz
1994 ALTER_TEXT_SEARCH_TEMPLATE.7.gz
1998 ALTER_USER_MAPPING.7.gz
2008 COMMIT_PREPARED.7.gz
2010 CREATE_ACCESS_METHOD.7.gz
2011 CREATE_AGGREGATE.7.gz
2013 CREATE_COLLATION.7.gz
2014 CREATE_CONVERSION.7.gz
2015 CREATE_DATABASE.7.gz
2017 CREATE_EVENT_TRIGGER.7.gz
2018 CREATE_EXTENSION.7.gz
2019 CREATE_FOREIGN_DATA_WRAPPER.7.gz
2020 CREATE_FOREIGN_TABLE.7.gz
2021 CREATE_FUNCTION.7.gz
2024 CREATE_LANGUAGE.7.gz
2025 CREATE_MATERIALIZED_VIEW.7.gz
2026 CREATE_OPERATOR.7.gz
2027 CREATE_OPERATOR_CLASS.7.gz
2028 CREATE_OPERATOR_FAMILY.7.gz
2030 CREATE_PROCEDURE.7.gz
2031 CREATE_PUBLICATION.7.gz
2035 CREATE_SEQUENCE.7.gz
2037 CREATE_STATISTICS.7.gz
2038 CREATE_SUBSCRIPTION.7.gz
2040 CREATE_TABLESPACE.7.gz
2041 CREATE_TABLE_AS.7.gz
2042 CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
2043 CREATE_TEXT_SEARCH_DICTIONARY.7.gz
2044 CREATE_TEXT_SEARCH_PARSER.7.gz
2045 CREATE_TEXT_SEARCH_TEMPLATE.7.gz
2046 CREATE_TRANSFORM.7.gz
2050 CREATE_USER_MAPPING.7.gz
2057 DROP_ACCESS_METHOD.7.gz
2061 DROP_CONVERSION.7.gz
2064 DROP_EVENT_TRIGGER.7.gz
2066 DROP_FOREIGN_DATA_WRAPPER.7.gz
2067 DROP_FOREIGN_TABLE.7.gz
2072 DROP_MATERIALIZED_VIEW.7.gz
2074 DROP_OPERATOR_CLASS.7.gz
2075 DROP_OPERATOR_FAMILY.7.gz
2079 DROP_PUBLICATION.7.gz
2086 DROP_STATISTICS.7.gz
2087 DROP_SUBSCRIPTION.7.gz
2089 DROP_TABLESPACE.7.gz
2090 DROP_TEXT_SEARCH_CONFIGURATION.7.gz
2091 DROP_TEXT_SEARCH_DICTIONARY.7.gz
2092 DROP_TEXT_SEARCH_PARSER.7.gz
2093 DROP_TEXT_SEARCH_TEMPLATE.7.gz
2098 DROP_USER_MAPPING.7.gz
2105 IMPORT_FOREIGN_SCHEMA.7.gz
2113 PREPARE_TRANSACTION.7.gz
2115 REFRESH_MATERIALIZED_VIEW.7.gz
2117 RELEASE_SAVEPOINT.7.gz
2121 ROLLBACK_PREPARED.7.gz
2122 ROLLBACK_TO_SAVEPOINT.7.gz
2128 SET_CONSTRAINTS.7.gz
2130 SET_SESSION_AUTHORIZATION.7.gz
2131 SET_TRANSACTION.7.gz
2133 START_TRANSACTION.7.gz
2143 pg_service.conf.sample
2145 system_constraints.sql
2146 system_functions.sql
2149 [FILE:5142:manifests/plist.contrib]
2182 pg_stat_statements.so
2201 share/postgresql/extension/
2202 adminpack--1.0--1.1.sql
2204 adminpack--1.1--2.0.sql
2205 adminpack--2.0--2.1.sql
2207 amcheck--1.0--1.1.sql
2209 amcheck--1.1--1.2.sql
2210 amcheck--1.2--1.3.sql
2216 bool_plperl--1.0.sql
2218 bool_plperlu.control
2219 btree_gin--1.0--1.1.sql
2221 btree_gin--1.1--1.2.sql
2222 btree_gin--1.2--1.3.sql
2224 btree_gist--1.0--1.1.sql
2225 btree_gist--1.1--1.2.sql
2226 btree_gist--1.2--1.3.sql
2228 btree_gist--1.3--1.4.sql
2229 btree_gist--1.4--1.5.sql
2230 btree_gist--1.5--1.6.sql
2232 citext--1.0--1.1.sql
2233 citext--1.1--1.2.sql
2234 citext--1.2--1.3.sql
2235 citext--1.3--1.4.sql
2236 citext--1.4--1.5.sql
2238 citext--1.5--1.6.sql
2247 dblink--1.0--1.1.sql
2248 dblink--1.1--1.2.sql
2255 earthdistance--1.0--1.1.sql
2256 earthdistance--1.1.sql
2257 earthdistance.control
2260 fuzzystrmatch--1.0--1.1.sql
2261 fuzzystrmatch--1.1.sql
2262 fuzzystrmatch.control
2263 hstore--1.1--1.2.sql
2264 hstore--1.2--1.3.sql
2265 hstore--1.3--1.4.sql
2266 hstore--1.4--1.5.sql
2268 hstore--1.5--1.6.sql
2269 hstore--1.6--1.7.sql
2270 hstore--1.7--1.8.sql
2272 insert_username--1.0.sql
2273 insert_username.control
2274 intagg--1.0--1.1.sql
2277 intarray--1.0--1.1.sql
2278 intarray--1.1--1.2.sql
2279 intarray--1.2--1.3.sql
2281 intarray--1.3--1.4.sql
2282 intarray--1.4--1.5.sql
2295 moddatetime--1.0.sql
2297 old_snapshot--1.0.sql
2298 old_snapshot.control
2299 pageinspect--1.0--1.1.sql
2300 pageinspect--1.1--1.2.sql
2301 pageinspect--1.2--1.3.sql
2302 pageinspect--1.3--1.4.sql
2303 pageinspect--1.4--1.5.sql
2304 pageinspect--1.5--1.6.sql
2305 pageinspect--1.5.sql
2306 pageinspect--1.6--1.7.sql
2307 pageinspect--1.7--1.8.sql
2308 pageinspect--1.8--1.9.sql
2310 pg_buffercache--1.0--1.1.sql
2311 pg_buffercache--1.1--1.2.sql
2312 pg_buffercache--1.2--1.3.sql
2313 pg_buffercache--1.2.sql
2314 pg_buffercache.control
2315 pg_freespacemap--1.0--1.1.sql
2316 pg_freespacemap--1.1--1.2.sql
2317 pg_freespacemap--1.1.sql
2318 pg_freespacemap.control
2319 pg_prewarm--1.0--1.1.sql
2320 pg_prewarm--1.1--1.2.sql
2323 pg_stat_statements--1.0--1.1.sql
2324 pg_stat_statements--1.1--1.2.sql
2325 pg_stat_statements--1.2--1.3.sql
2326 pg_stat_statements--1.3--1.4.sql
2327 pg_stat_statements--1.4--1.5.sql
2328 pg_stat_statements--1.4.sql
2329 pg_stat_statements--1.5--1.6.sql
2330 pg_stat_statements--1.6--1.7.sql
2331 pg_stat_statements--1.7--1.8.sql
2332 pg_stat_statements--1.8--1.9.sql
2333 pg_stat_statements.control
2336 pg_trgm--1.0--1.1.sql
2337 pg_trgm--1.1--1.2.sql
2338 pg_trgm--1.2--1.3.sql
2339 pg_trgm--1.3--1.4.sql
2341 pg_trgm--1.4--1.5.sql
2342 pg_trgm--1.5--1.6.sql
2344 pg_visibility--1.0--1.1.sql
2345 pg_visibility--1.1--1.2.sql
2346 pg_visibility--1.1.sql
2347 pg_visibility.control
2348 pgcrypto--1.0--1.1.sql
2349 pgcrypto--1.1--1.2.sql
2350 pgcrypto--1.2--1.3.sql
2353 pgrowlocks--1.0--1.1.sql
2354 pgrowlocks--1.1--1.2.sql
2357 pgstattuple--1.0--1.1.sql
2358 pgstattuple--1.1--1.2.sql
2359 pgstattuple--1.2--1.3.sql
2360 pgstattuple--1.3--1.4.sql
2361 pgstattuple--1.4--1.5.sql
2362 pgstattuple--1.4.sql
2364 postgres_fdw--1.0--1.1.sql
2365 postgres_fdw--1.0.sql
2366 postgres_fdw.control
2375 sslinfo--1.0--1.1.sql
2376 sslinfo--1.1--1.2.sql
2383 tsm_system_rows--1.0.sql
2384 tsm_system_rows.control
2385 tsm_system_time--1.0.sql
2386 tsm_system_time.control
2387 unaccent--1.0--1.1.sql
2390 uuid-ossp--1.0--1.1.sql
2396 share/postgresql/tsearch_data/
2401 [FILE:510:manifests/plist.plperl]
2402 include/postgresql/server/
2407 bool_plperl.%%SHARED_OBJECT%%
2408 hstore_plperl.%%SHARED_OBJECT%%
2409 jsonb_plperl.%%SHARED_OBJECT%%
2410 plperl.%%SHARED_OBJECT%%
2411 share/postgresql/extension/
2412 bool_plperlu--1.0.sql
2413 hstore_plperl--1.0.sql
2414 hstore_plperl.control
2415 hstore_plperlu--1.0.sql
2416 hstore_plperlu.control
2417 jsonb_plperl--1.0.sql
2418 jsonb_plperl.control
2419 jsonb_plperlu--1.0.sql
2420 jsonb_plperlu.control
2427 [FILE:1092:manifests/plist.plpython]
2428 include/postgresql/server/
2438 plpy_subxactobject.h
2443 hstore_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2444 jsonb_plpython3.%%SHARED_OBJECT%%
2445 ltree_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2446 plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2447 lib/postgresql/pgxs/src/pl/plpython/regress-python3-mangle.mk
2448 share/postgresql/extension/
2449 hstore_plpython2u--1.0.sql
2450 hstore_plpython2u.control
2451 hstore_plpython3u--1.0.sql
2452 hstore_plpython3u.control
2453 hstore_plpythonu--1.0.sql
2454 hstore_plpythonu.control
2455 jsonb_plpython2u--1.0.sql
2456 jsonb_plpython2u.control
2457 jsonb_plpython3u--1.0.sql
2458 jsonb_plpython3u.control
2459 jsonb_plpythonu--1.0.sql
2460 jsonb_plpythonu.control
2461 ltree_plpython2u--1.0.sql
2462 ltree_plpython2u.control
2463 ltree_plpython3u--1.0.sql
2464 ltree_plpython3u.control
2465 ltree_plpythonu--1.0.sql
2466 ltree_plpythonu.control
2467 plpython%%PYTHON_MAJOR_VER%%u--1.0.sql
2468 plpython%%PYTHON_MAJOR_VER%%u.control
2471 [FILE:131:manifests/plist.pltcl]
2472 lib/postgresql/pltcl.%%SHARED_OBJECT%%
2473 share/postgresql/extension/
2480 [FILE:111:manifests/plist.docs]
2481 share/doc/postgresql/extension/
2483 insert_username.example
2488 [FILE:8541:manifests/plist.nls]
2489 share/locale/cs/LC_MESSAGES/
2491 ecpglib6-%%PGVER%%.mo
2494 pg_archivecleanup-%%PGVER%%.mo
2495 pg_basebackup-%%PGVER%%.mo
2496 pg_checksums-%%PGVER%%.mo
2497 pg_config-%%PGVER%%.mo
2498 pg_controldata-%%PGVER%%.mo
2500 pg_dump-%%PGVER%%.mo
2501 pg_resetwal-%%PGVER%%.mo
2502 pg_rewind-%%PGVER%%.mo
2503 pg_test_fsync-%%PGVER%%.mo
2504 pg_upgrade-%%PGVER%%.mo
2505 pg_waldump-%%PGVER%%.mo
2506 pgscripts-%%PGVER%%.mo
2508 plpgsql-%%PGVER%%.mo
2509 plpython-%%PGVER%%.mo
2512 share/locale/de/LC_MESSAGES/
2514 ecpglib6-%%PGVER%%.mo
2517 pg_amcheck-%%PGVER%%.mo
2518 pg_archivecleanup-%%PGVER%%.mo
2519 pg_basebackup-%%PGVER%%.mo
2520 pg_checksums-%%PGVER%%.mo
2521 pg_config-%%PGVER%%.mo
2522 pg_controldata-%%PGVER%%.mo
2524 pg_dump-%%PGVER%%.mo
2525 pg_resetwal-%%PGVER%%.mo
2526 pg_rewind-%%PGVER%%.mo
2527 pg_test_fsync-%%PGVER%%.mo
2528 pg_test_timing-%%PGVER%%.mo
2529 pg_upgrade-%%PGVER%%.mo
2530 pg_verifybackup-%%PGVER%%.mo
2531 pg_waldump-%%PGVER%%.mo
2532 pgscripts-%%PGVER%%.mo
2534 plpgsql-%%PGVER%%.mo
2535 plpython-%%PGVER%%.mo
2537 postgres-%%PGVER%%.mo
2539 share/locale/el/LC_MESSAGES/
2541 ecpglib6-%%PGVER%%.mo
2544 pg_amcheck-%%PGVER%%.mo
2545 pg_archivecleanup-%%PGVER%%.mo
2546 pg_basebackup-%%PGVER%%.mo
2547 pg_checksums-%%PGVER%%.mo
2548 pg_config-%%PGVER%%.mo
2549 pg_controldata-%%PGVER%%.mo
2551 pg_dump-%%PGVER%%.mo
2552 pg_resetwal-%%PGVER%%.mo
2553 pg_rewind-%%PGVER%%.mo
2554 pg_test_fsync-%%PGVER%%.mo
2555 pg_test_timing-%%PGVER%%.mo
2556 pg_verifybackup-%%PGVER%%.mo
2557 pg_waldump-%%PGVER%%.mo
2558 pgscripts-%%PGVER%%.mo
2560 plpgsql-%%PGVER%%.mo
2561 plpython-%%PGVER%%.mo
2564 share/locale/es/LC_MESSAGES/
2566 ecpglib6-%%PGVER%%.mo
2569 pg_amcheck-%%PGVER%%.mo
2570 pg_archivecleanup-%%PGVER%%.mo
2571 pg_basebackup-%%PGVER%%.mo
2572 pg_checksums-%%PGVER%%.mo
2573 pg_config-%%PGVER%%.mo
2574 pg_controldata-%%PGVER%%.mo
2576 pg_dump-%%PGVER%%.mo
2577 pg_resetwal-%%PGVER%%.mo
2578 pg_rewind-%%PGVER%%.mo
2579 pg_test_fsync-%%PGVER%%.mo
2580 pg_test_timing-%%PGVER%%.mo
2581 pg_upgrade-%%PGVER%%.mo
2582 pg_verifybackup-%%PGVER%%.mo
2583 pg_waldump-%%PGVER%%.mo
2584 pgscripts-%%PGVER%%.mo
2586 plpgsql-%%PGVER%%.mo
2587 plpython-%%PGVER%%.mo
2589 postgres-%%PGVER%%.mo
2591 share/locale/fr/LC_MESSAGES/
2593 ecpglib6-%%PGVER%%.mo
2596 pg_amcheck-%%PGVER%%.mo
2597 pg_archivecleanup-%%PGVER%%.mo
2598 pg_basebackup-%%PGVER%%.mo
2599 pg_checksums-%%PGVER%%.mo
2600 pg_config-%%PGVER%%.mo
2601 pg_controldata-%%PGVER%%.mo
2603 pg_dump-%%PGVER%%.mo
2604 pg_resetwal-%%PGVER%%.mo
2605 pg_rewind-%%PGVER%%.mo
2606 pg_test_fsync-%%PGVER%%.mo
2607 pg_test_timing-%%PGVER%%.mo
2608 pg_upgrade-%%PGVER%%.mo
2609 pg_verifybackup-%%PGVER%%.mo
2610 pg_waldump-%%PGVER%%.mo
2611 pgscripts-%%PGVER%%.mo
2613 plpgsql-%%PGVER%%.mo
2614 plpython-%%PGVER%%.mo
2616 postgres-%%PGVER%%.mo
2618 share/locale/he/LC_MESSAGES/pg_config-%%PGVER%%.mo
2619 share/locale/it/LC_MESSAGES/
2621 ecpglib6-%%PGVER%%.mo
2622 pg_config-%%PGVER%%.mo
2623 pg_controldata-%%PGVER%%.mo
2626 plpgsql-%%PGVER%%.mo
2627 plpython-%%PGVER%%.mo
2629 postgres-%%PGVER%%.mo
2631 share/locale/ja/LC_MESSAGES/
2633 ecpglib6-%%PGVER%%.mo
2636 pg_amcheck-%%PGVER%%.mo
2637 pg_archivecleanup-%%PGVER%%.mo
2638 pg_basebackup-%%PGVER%%.mo
2639 pg_checksums-%%PGVER%%.mo
2640 pg_config-%%PGVER%%.mo
2641 pg_controldata-%%PGVER%%.mo
2643 pg_dump-%%PGVER%%.mo
2644 pg_resetwal-%%PGVER%%.mo
2645 pg_rewind-%%PGVER%%.mo
2646 pg_test_fsync-%%PGVER%%.mo
2647 pg_test_timing-%%PGVER%%.mo
2648 pg_upgrade-%%PGVER%%.mo
2649 pg_verifybackup-%%PGVER%%.mo
2650 pg_waldump-%%PGVER%%.mo
2651 pgscripts-%%PGVER%%.mo
2653 plpgsql-%%PGVER%%.mo
2654 plpython-%%PGVER%%.mo
2656 postgres-%%PGVER%%.mo
2658 share/locale/ko/LC_MESSAGES/
2660 ecpglib6-%%PGVER%%.mo
2663 pg_archivecleanup-%%PGVER%%.mo
2664 pg_basebackup-%%PGVER%%.mo
2665 pg_checksums-%%PGVER%%.mo
2666 pg_config-%%PGVER%%.mo
2667 pg_controldata-%%PGVER%%.mo
2669 pg_dump-%%PGVER%%.mo
2670 pg_resetwal-%%PGVER%%.mo
2671 pg_test_fsync-%%PGVER%%.mo
2672 pg_upgrade-%%PGVER%%.mo
2673 pg_verifybackup-%%PGVER%%.mo
2674 pg_waldump-%%PGVER%%.mo
2675 pgscripts-%%PGVER%%.mo
2677 plpgsql-%%PGVER%%.mo
2678 plpython-%%PGVER%%.mo
2680 postgres-%%PGVER%%.mo
2682 share/locale/pl/LC_MESSAGES/
2684 ecpglib6-%%PGVER%%.mo
2685 pg_config-%%PGVER%%.mo
2686 pg_test_fsync-%%PGVER%%.mo
2688 plpgsql-%%PGVER%%.mo
2689 plpython-%%PGVER%%.mo
2691 share/locale/pt_BR/LC_MESSAGES/
2693 ecpglib6-%%PGVER%%.mo
2694 pg_config-%%PGVER%%.mo
2696 plpgsql-%%PGVER%%.mo
2697 plpython-%%PGVER%%.mo
2698 share/locale/ro/LC_MESSAGES/plperl-%%PGVER%%.mo
2699 share/locale/ru/LC_MESSAGES/
2701 ecpglib6-%%PGVER%%.mo
2704 pg_amcheck-%%PGVER%%.mo
2705 pg_archivecleanup-%%PGVER%%.mo
2706 pg_basebackup-%%PGVER%%.mo
2707 pg_checksums-%%PGVER%%.mo
2708 pg_config-%%PGVER%%.mo
2709 pg_controldata-%%PGVER%%.mo
2711 pg_dump-%%PGVER%%.mo
2712 pg_resetwal-%%PGVER%%.mo
2713 pg_rewind-%%PGVER%%.mo
2714 pg_test_fsync-%%PGVER%%.mo
2715 pg_test_timing-%%PGVER%%.mo
2716 pg_upgrade-%%PGVER%%.mo
2717 pg_verifybackup-%%PGVER%%.mo
2718 pg_waldump-%%PGVER%%.mo
2719 pgscripts-%%PGVER%%.mo
2721 plpgsql-%%PGVER%%.mo
2722 plpython-%%PGVER%%.mo
2724 postgres-%%PGVER%%.mo
2726 share/locale/sv/LC_MESSAGES/
2728 ecpglib6-%%PGVER%%.mo
2731 pg_amcheck-%%PGVER%%.mo
2732 pg_archivecleanup-%%PGVER%%.mo
2733 pg_basebackup-%%PGVER%%.mo
2734 pg_checksums-%%PGVER%%.mo
2735 pg_config-%%PGVER%%.mo
2736 pg_controldata-%%PGVER%%.mo
2738 pg_dump-%%PGVER%%.mo
2739 pg_resetwal-%%PGVER%%.mo
2740 pg_rewind-%%PGVER%%.mo
2741 pg_test_fsync-%%PGVER%%.mo
2742 pg_test_timing-%%PGVER%%.mo
2743 pg_upgrade-%%PGVER%%.mo
2744 pg_verifybackup-%%PGVER%%.mo
2745 pg_waldump-%%PGVER%%.mo
2746 pgscripts-%%PGVER%%.mo
2748 plpgsql-%%PGVER%%.mo
2749 plpython-%%PGVER%%.mo
2751 postgres-%%PGVER%%.mo
2753 share/locale/tr/LC_MESSAGES/
2755 ecpglib6-%%PGVER%%.mo
2757 pg_archivecleanup-%%PGVER%%.mo
2758 pg_basebackup-%%PGVER%%.mo
2759 pg_checksums-%%PGVER%%.mo
2760 pg_config-%%PGVER%%.mo
2761 pg_controldata-%%PGVER%%.mo
2763 pg_dump-%%PGVER%%.mo
2764 pg_resetwal-%%PGVER%%.mo
2765 pg_test_fsync-%%PGVER%%.mo
2766 pg_upgrade-%%PGVER%%.mo
2767 pg_waldump-%%PGVER%%.mo
2768 pgscripts-%%PGVER%%.mo
2770 plpgsql-%%PGVER%%.mo
2771 plpython-%%PGVER%%.mo
2774 share/locale/uk/LC_MESSAGES/
2776 ecpglib6-%%PGVER%%.mo
2779 pg_amcheck-%%PGVER%%.mo
2780 pg_archivecleanup-%%PGVER%%.mo
2781 pg_basebackup-%%PGVER%%.mo
2782 pg_checksums-%%PGVER%%.mo
2783 pg_config-%%PGVER%%.mo
2784 pg_controldata-%%PGVER%%.mo
2786 pg_dump-%%PGVER%%.mo
2787 pg_resetwal-%%PGVER%%.mo
2788 pg_rewind-%%PGVER%%.mo
2789 pg_test_fsync-%%PGVER%%.mo
2790 pg_test_timing-%%PGVER%%.mo
2791 pg_upgrade-%%PGVER%%.mo
2792 pg_verifybackup-%%PGVER%%.mo
2793 pg_waldump-%%PGVER%%.mo
2794 pgscripts-%%PGVER%%.mo
2796 plpgsql-%%PGVER%%.mo
2797 plpython-%%PGVER%%.mo
2799 postgres-%%PGVER%%.mo
2801 share/locale/vi/LC_MESSAGES/
2803 ecpglib6-%%PGVER%%.mo
2804 pg_config-%%PGVER%%.mo
2805 pg_test_fsync-%%PGVER%%.mo
2807 plpgsql-%%PGVER%%.mo
2808 plpython-%%PGVER%%.mo
2810 share/locale/zh_CN/LC_MESSAGES/
2812 ecpglib6-%%PGVER%%.mo
2815 pg_amcheck-%%PGVER%%.mo
2816 pg_archivecleanup-%%PGVER%%.mo
2817 pg_basebackup-%%PGVER%%.mo
2818 pg_checksums-%%PGVER%%.mo
2819 pg_config-%%PGVER%%.mo
2820 pg_controldata-%%PGVER%%.mo
2822 pg_dump-%%PGVER%%.mo
2823 pg_resetwal-%%PGVER%%.mo
2824 pg_rewind-%%PGVER%%.mo
2825 pg_test_fsync-%%PGVER%%.mo
2826 pg_test_timing-%%PGVER%%.mo
2827 pg_upgrade-%%PGVER%%.mo
2828 pg_verifybackup-%%PGVER%%.mo
2829 pg_waldump-%%PGVER%%.mo
2830 pgscripts-%%PGVER%%.mo
2832 plpgsql-%%PGVER%%.mo
2833 plpython-%%PGVER%%.mo
2835 postgres-%%PGVER%%.mo
2837 share/locale/zh_TW/LC_MESSAGES/ecpg-%%PGVER%%.mo
2840 [FILE:393:patches/patch-configure]
2841 --- configure.orig 2022-11-07 21:38:53 UTC
2843 @@ -12599,7 +12599,7 @@ if ac_fn_c_try_link "$LINENO"; then :
2844 # recognize dependent libraries; assume curses is needed if we didn't
2845 # find any dependency.
2847 - netbsd* | openbsd*)
2849 if test x"$pgac_lib" = x"" ; then
2850 pgac_lib=" -lcurses"
2854 [FILE:349:patches/patch-doc-Makefile]
2855 --- doc/Makefile.orig 2022-11-07 21:38:53 UTC
2857 @@ -12,5 +12,5 @@ subdir = doc
2859 include $(top_builddir)/src/Makefile.global
2861 -all distprep html man install installdirs uninstall clean distclean maintainer-clean:
2862 +all distprep man install installdirs uninstall clean distclean maintainer-clean:
2866 [FILE:1196:patches/patch-doc_src_sgml_Makefile]
2867 --- doc/src/sgml/Makefile.orig 2022-11-07 21:38:53 UTC
2868 +++ doc/src/sgml/Makefile
2871 # Make "html" the default target, since that is what most people tend
2876 # We don't need the tree-wide headers or install support here.
2877 NO_GENERATED_HEADERS=yes
2878 @@ -26,7 +26,7 @@ top_builddir = ../../..
2879 include $(top_builddir)/src/Makefile.global
2885 distprep: html distprep-man
2887 @@ -65,8 +65,6 @@ ALL_IMAGES := $(wildcard $(srcdir)/image
2891 -man distprep-man: man-stamp
2893 man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML)
2894 $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^)
2895 $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $(wordlist 1,2,$^)
2896 @@ -220,10 +218,10 @@ check: postgres.sgml $(ALLSGML) check-ta
2900 -install: install-html install-man
2901 +install: install-man
2904 - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2905 + $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2907 # If the install used a man directory shared with other applications, this will remove all files.
2911 [FILE:498:patches/patch-src-backend-Makefile]
2912 --- src/backend/Makefile.orig 2022-11-07 21:38:53 UTC
2913 +++ src/backend/Makefile
2914 @@ -116,6 +116,8 @@ endif # aix
2916 $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport
2918 +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
2921 # The postgres.o target is needed by the rule in Makefile.global that
2922 # creates the exports file when MAKE_EXPORTS = true.
2925 [FILE:863:patches/patch-src_Makefile.shlib]
2926 --- src/Makefile.shlib.orig 2022-11-07 21:38:53 UTC
2927 +++ src/Makefile.shlib
2928 @@ -166,6 +166,9 @@ ifeq ($(PORTNAME), freebsd)
2931 ifeq ($(PORTNAME), netbsd)
2932 + ifdef SO_MAJOR_VERSION
2933 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2935 LINK.shared = $(COMPILER) -shared
2937 LINK.shared += -Wl,-x,-soname,$(soname)
2938 @@ -212,6 +215,9 @@ endif
2940 ifeq ($(PORTNAME), linux)
2941 LINK.shared = $(COMPILER) -shared
2942 + ifdef SO_MAJOR_VERSION
2943 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2946 LINK.shared += -Wl,-soname,$(soname)
2948 @@ -223,6 +229,9 @@ ifeq ($(PORTNAME), linux)
2951 ifeq ($(PORTNAME), solaris)
2952 + ifdef SO_MAJOR_VERSION
2953 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2956 LINK.shared = $(COMPILER) -shared -Wl,-Bsymbolic
2960 [FILE:685:patches/patch-src_backend_utils_misc_postgresql.conf.sample]
2961 --- src/backend/utils/misc/postgresql.conf.sample.orig 2022-11-07 21:38:53 UTC
2962 +++ src/backend/utils/misc/postgresql.conf.sample
2967 +log_destination = 'syslog'
2968 #log_destination = 'stderr' # Valid values are combinations of
2969 # stderr, csvlog, syslog, and eventlog,
2970 # depending on platform. csvlog
2973 #cluster_name = '' # added to process titles if nonempty
2974 # (change requires restart)
2975 -#update_process_title = on
2977 +# On FreeBSD, this is a performance hog, so keep it off if you need speed
2978 +update_process_title = off
2981 #------------------------------------------------------------------------------
2984 [FILE:3090:files/502.pgsql.in]
2987 # Maintenance shell script to vacuum and backup database
2988 # Put this in /usr/local/etc/periodic/daily, and it will be run
2991 # Written by Palle Girgensohn <girgen@pingpong.net>
2993 # In public domain, do what you like with it,
2994 # and use it at your own risk... :)
2997 # Define these variables in either /etc/periodic.conf or
2998 # /etc/periodic.conf.local to override the default values.
3000 # daily_pgsql_backup_enable="YES" # do backup of all databases
3001 # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases
3002 # daily_pgsql_vacuum_enable="YES" # do vacuum
3004 # If there is a global system configuration file, suck it in.
3006 if [ -r /etc/defaults/periodic.conf ]
3008 . /etc/defaults/periodic.conf
3009 source_periodic_confs
3012 : ${daily_pgsql_user:="%%PG_USER%%"}
3013 : ${daily_pgsql_port:=5432}
3014 : ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"}
3015 : ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"}
3016 : ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"}
3017 # backupdir is relative to ~pgsql home directory unless it begins with a slash:
3018 : ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"}
3019 : ${daily_pgsql_savedays:="7"}
3021 # allow '~ยด in dir name
3022 eval backupdir=${daily_pgsql_backupdir}
3027 # daily_pgsql_backupdir must be writeable by user %%PG_USER%%
3028 # ~%%PG_USER%% is just that under normal circumstances,
3029 # but this might not be where you want the backups...
3030 if [ ! -d ${backupdir} ] ; then
3031 echo Creating ${backupdir}
3032 mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir}
3036 echo "PostgreSQL backups"
3041 now=`date "+%Y-%m-%dT%H:%M:%S"`
3042 file=${daily_pgsql_backupdir}/pgglobals_${now}
3043 su -l ${daily_pgsql_user} -c \
3044 "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz"
3049 file=${backupdir}/pgdump_${db}_${now}
3050 su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
3051 [ $? -gt 0 ] && rc=3
3055 if [ $rc -gt 0 ]; then
3057 echo "Errors were reported during backup."
3060 # cleaning up old data
3061 find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \
3062 -a -mtime +${daily_pgsql_savedays} -delete
3066 case "$daily_pgsql_backup_enable" in
3068 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\'"`
3069 pgsql_backup $dbnames
3079 pgsql_backup $daily_pgsql_backup_enable
3083 case "$daily_pgsql_vacuum_enable" in
3087 echo "PostgreSQL vacuum"
3088 su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}"
3092 echo "Errors were reported during vacuum."
3101 [FILE:3182:files/postgresql.in]
3104 # PROVIDE: postgresql
3108 # Add the following line to /etc/rc.conf to enable PostgreSQL:
3110 # postgresql_enable="YES"
3112 # postgresql_data="%%PREFIX%%/%%PG_USER%%/%%DATADIR%%"
3113 # postgresql_flags="-w -s -m fast"
3114 # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
3115 # postgresql_class="default"
3116 # postgresql_profiles=""
3118 # See %%PREFIX%%/share/doc/postgresql/README-server for more info
3120 # This scripts takes one of the following commands:
3122 # start stop restart reload status initdb
3124 # For postmaster startup options, edit ${postgresql_data}/postgresql.conf
3126 command=%%PREFIX%%/bin/pg_ctl
3130 load_rc_config postgresql
3133 postgresql_enable=${postgresql_enable:-"NO"}
3134 postgresql_flags=${postgresql_flags:-"-w -s -m fast"}
3135 postgresql_user=${postgresql_user:-"%%PG_USER%%"}
3136 eval postgresql_data=${postgresql_data:-"~${postgresql_user}/%%DATADIR%%"}
3137 postgresql_class=${postgresql_class:-"default"}
3138 postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"}
3141 rcvar=postgresql_enable
3142 extra_commands="reload initdb"
3144 start_cmd="postgresql_command start"
3145 stop_cmd="postgresql_command stop"
3146 restart_cmd="postgresql_command restart"
3147 reload_cmd="postgresql_command reload"
3148 status_cmd="postgresql_command status"
3150 initdb_cmd="postgresql_initdb"
3152 if [ -n "$2" ]; then
3154 if [ "x${postgresql_profiles}" != "x" ]; then
3155 eval postgresql_data="\${postgresql_${profile}_data:-}"
3156 if [ "x${postgresql_data}" = "x" ]; then
3157 echo "You must define a data directory (postgresql_${profile}_data)"
3160 eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}"
3161 eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}"
3162 eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}"
3163 eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}"
3166 if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then
3167 for profile in ${postgresql_profiles}; do
3168 eval _enable="\${postgresql_${profile}_enable}"
3169 case "x${_enable:-${postgresql_enable}}" in
3170 x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee])
3176 if test -z "$_enable"; then
3177 _var=postgresql_enable
3179 _var=postgresql_"${profile}"_enable
3182 "'${_enable:-${postgresql_enable}}'" \
3184 "Profile ${profile} skipped."
3188 echo "===> postgresql profile: ${profile}"
3189 %%PREFIX%%/etc/rc.d/postgresql $1 ${profile}
3191 if [ "0${retcode}" -ne 0 ]; then
3192 failed="${profile} (${retcode}) ${failed:-}"
3194 success="${profile} ${success:-}"
3201 command_args="-D ${postgresql_data} ${postgresql_flags}"
3203 postgresql_command()
3205 su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
3210 su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}"