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/v14.9
13 DISTFILE[1]= postgresql-14.9.tar.bz2:main
14 DIST_SUBDIR= postgresql
16 SPKGS[standard]= complete
28 OPTIONS_AVAILABLE= none
29 OPTIONS_STANDARD= none
31 BUILD_DEPENDS= docbook-sgml:single:standard
32 docbook-dsssl:single:standard
33 openjade:single:standard
34 OpenSP:single:standard
36 readline:primary:standard
38 BUILDRUN_DEPENDS= libxslt:primary:standard
39 B_DEPS[sunos]= ossp-uuid:dev:standard
40 B_DEPS[linux]= ossp-uuid:dev:standard
41 B_DEPS[darwin]= libuuid:dev:standard
42 BR_DEPS[sunos]= ossp-uuid:primary:standard
43 BR_DEPS[linux]= ossp-uuid:primary:standard
44 BR_DEPS[darwin]= libuuid:primary:standard
46 EXRUN[plpython]= python
47 EXRUN[client]= gettext:primary:standard
48 libxslt:primary:standard
49 readline:primary:standard
52 EXRUN[contrib]= postgresql14:client:standard
53 libxslt:primary:standard
55 gettext:primary:standard
58 EXRUN[server]= postgresql14:client:standard
62 USERGROUP_SPKG= server
64 USES= bison gmake perl:build tcl:build ssl python:build
66 GNOME_COMPONENTS= libxml2
68 DISTNAME= postgresql-14.9
70 LICENSE= PostgreSQL:server
71 LICENSE_FILE= PostgreSQL:{{WRKSRC}}/COPYRIGHT
74 CPE_PRODUCT= postgresql
75 CPE_VENDOR= postgresql
76 FPC_EQUIVALENT= databases/postgresql14-server
79 CONFIGURE_ARGS= --with-libraries="{{PREFIX}}/lib"
80 --with-includes="{{PREFIX}}/include:{{TCL_INCLUDEDIR}}"
81 --with-tclconfig="{{TCL_LIBDIR}}"
90 CONFIGURE_ENV= PTHREAD_LIBS="-lpthread"
92 pgac_cv_path_stylesheets={{PREFIX}}/share/sgml/docbook/dsssl/modular
95 MAKE_ENV= TCL_INCDIR="{{TCL_INCLUDEDIR}}"
97 INSTALL_TARGET= install-world
99 RC_SUBR= postgresql:server
101 SUB_LIST= PG_GROUP=pgsql
107 VAR_OPSYS[freebsd]= CONFIGURE_ARGS=--with-template=freebsd
108 CONFIGURE_ARGS=--with-uuid=bsd
109 VAR_OPSYS[sunos]= CONFIGURE_ENV=ac_cv_search_bind_textdomain_codeset=-lintl
110 CONFIGURE_ARGS=--with-template=solaris
111 CONFIGURE_ARGS=--with-uuid=ossp
112 LDFLAGS=-L{{PREFIX}}/lib/ossp
113 LDFLAGS=-Wl,-rpath,{{PREFIX}}/lib/ossp
114 VAR_OPSYS[linux]= CONFIGURE_ARGS=--with-template=linux
115 CONFIGURE_ARGS=--with-uuid=ossp
116 LDFLAGS=-L{{PREFIX}}/lib/ossp
117 LDFLAGS=-Wl,-rpath,{{PREFIX}}/lib/ossp
118 VAR_OPSYS[darwin]= CONFIGURE_ARGS=--with-template=darwin
119 CONFIGURE_ARGS=--with-uuid=e2fs
120 VAR_OPSYS[netbsd]= CONFIGURE_ARGS=--with-template=netbsd
121 CONFIGURE_ARGS=--with-uuid=bsd
122 VAR_OPSYS[openbsd]= CONFIGURE_ARGS=--with-template=openbsd
123 CONFIGURE_ARGS=--with-uuid=bsd
124 VAR_OPSYS[dragonfly]= CONFIGURE_ARGS=--with-template=freebsd
125 CONFIGURE_ARGS=--with-uuid=bsd
126 VAR_OPSYS[midnightbsd]= CONFIGURE_ARGS=--with-template=freebsd
127 CONFIGURE_ARGS=--with-uuid=bsd
130 ${MKDIR} ${STAGEDIR}${PREFIX}/etc/periodic/daily
131 ${INSTALL_SCRIPT} ${WRKDIR}/502.pgsql \
132 ${STAGEDIR}${PREFIX}/etc/periodic/daily
133 # install-world doesn't strip (and install-strip won't install enough)
134 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so
135 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/*.${LIBEXT}
136 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/regress/pg_regress
137 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/isolation/isolationtester
138 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/isolation/pg_isolation_regress
139 list=$$(${LS} ${STAGEDIR}${PREFIX}/bin/* | ${GREP} -v pltcl_); \
140 ${STRIP_CMD} $${list}
143 ${REINPLACE_CMD} -e '/sqlmansect/d' \
144 ${WRKSRC}/src/makefiles/Makefile.solaris
146 [FILE:1220:descriptions/desc.server]
147 PostgreSQL is a sophisticated Object-Relational DBMS, supporting
148 almost all SQL constructs, including subselects, transactions, and
149 user-defined types and functions. It is the most advanced open-source
150 database available anywhere. Commercial Support is also available.
152 The original Postgres code was the effort of many graduate students,
153 undergraduate students, and staff programmers working under the direction
154 of Professor Michael Stonebraker at the University of California,
155 Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting
156 the DBMS query language to SQL and created a new database system which came
157 to known as Postgres95. Many others contributed to the porting, testing,
158 debugging and enhancement of the Postgres95 code. As the code improved,
159 and 1995 faded into memory, PostgreSQL was born.
161 PostgreSQL development is presently being performed by a team of developers
162 who are now responsible for all current and future development. The
163 development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG).
164 Support is available from the PostgreSQL developer/user community through
165 the support mailing list (questions@PostgreSQL.ORG).
167 This subpackage contains the PostgreSQL server.
170 [FILE:48:descriptions/desc.client]
171 This subpackage contains the PostgreSQL client.
174 [FILE:60:descriptions/desc.contrib]
175 This subpackage contains the contrib modules of PostgreSQL.
178 [FILE:74:descriptions/desc.plperl]
179 This subpackage contains Perl Procedural Language support for PostgreSQL.
182 [FILE:76:descriptions/desc.plpython]
183 This subpackage contains Python Procedural Language support for PostgreSQL.
186 [FILE:73:descriptions/desc.pltcl]
187 This subpackage contains Tcl Procedural Language support for PostgreSQL.
191 b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef 22207374 postgresql/postgresql-14.9.tar.bz2
194 [FILE:8053:manifests/plist.server]
211 etc/periodic/daily/502.pgsql
212 include/postgresql/server/plpgsql.h
223 latin2_and_win1250.so
238 utf8_and_iso8859_1.so
245 information_schema.sql
249 postgresql.conf.sample
253 share/postgresql/extension/
256 share/postgresql/timezone/
302 share/postgresql/timezone/Africa/
357 share/postgresql/timezone/America/
500 share/postgresql/timezone/America/Argentina/
514 share/postgresql/timezone/America/Indiana/
523 share/postgresql/timezone/America/Kentucky/
526 share/postgresql/timezone/America/North_Dakota/
530 share/postgresql/timezone/Antarctica/
543 share/postgresql/timezone/Arctic/Longyearbyen
544 share/postgresql/timezone/Asia/
644 share/postgresql/timezone/Atlantic/
657 share/postgresql/timezone/Australia/
681 share/postgresql/timezone/Brazil/
686 share/postgresql/timezone/Canada/
695 share/postgresql/timezone/Chile/
698 share/postgresql/timezone/Etc/
734 share/postgresql/timezone/Europe/
799 share/postgresql/timezone/Indian/
811 share/postgresql/timezone/Mexico/
815 share/postgresql/timezone/Pacific/
860 share/postgresql/timezone/US/
873 share/postgresql/timezonesets/
887 share/postgresql/tsearch_data/
895 hunspell_sample.affix
896 hunspell_sample_long.affix
897 hunspell_sample_long.dict
898 hunspell_sample_num.affix
899 hunspell_sample_num.dict
914 [FILE:20984:manifests/plist.client]
917 libecpg_compat.so.3.11
963 include/libpq/libpq-fs.h
964 include/postgresql/informix/esql/
968 include/postgresql/internal/
974 include/postgresql/internal/libpq/pqcomm.h
975 include/postgresql/server/
997 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
1164 pg_partitioned_table.h
1165 pg_partitioned_table_d.h
1172 pg_publication_rel.h
1173 pg_publication_rel_d.h
1176 pg_replication_origin.h
1177 pg_replication_origin_d.h
1187 pg_shdescription_d.h
1193 pg_statistic_ext_d.h
1194 pg_statistic_ext_data.h
1195 pg_statistic_ext_data_d.h
1198 pg_subscription_rel.h
1199 pg_subscription_rel_d.h
1209 pg_ts_config_map_d.h
1225 include/postgresql/server/commands/
1262 include/postgresql/server/common/
1294 unicode_combining_table.h
1296 unicode_norm_hashfunc.h
1297 unicode_norm_table.h
1298 unicode_normprops_table.h
1300 include/postgresql/server/datatype/timestamp.h
1301 include/postgresql/server/executor/
1315 nodeBitmapHeapscan.h
1316 nodeBitmapIndexscan.h
1327 nodeIncrementalSort.h
1337 nodeNamedtuplestorescan.h
1340 nodeRecursiveunion.h
1361 include/postgresql/server/extension/cube/cubedata.h
1362 include/postgresql/server/extension/hstore/hstore.h
1363 include/postgresql/server/extension/isn/isn.h
1364 include/postgresql/server/extension/ltree/ltree.h
1365 include/postgresql/server/extension/seg/segdata.h
1366 include/postgresql/server/fe_utils/
1381 include/postgresql/server/foreign/
1384 include/postgresql/server/jit/
1388 include/postgresql/server/lib/
1403 include/postgresql/server/libpq/
1418 include/postgresql/server/mb/
1421 include/postgresql/server/nodes/
1443 include/postgresql/server/optimizer/
1454 geqo_recombination.h
1471 include/postgresql/server/parser/
1495 include/postgresql/server/partitioning/
1500 include/postgresql/server/port/
1518 include/postgresql/server/port/atomics/
1530 include/postgresql/server/port/win32/
1535 include/postgresql/server/port/win32/arpa/inet.h
1536 include/postgresql/server/port/win32/netinet/in.h
1537 include/postgresql/server/port/win32/sys/
1540 include/postgresql/server/port/win32_msvc/
1544 include/postgresql/server/port/win32_msvc/sys/
1548 include/postgresql/server/portability/
1551 include/postgresql/server/postmaster/
1554 bgworker_internals.h
1563 include/postgresql/server/regex/
1569 include/postgresql/server/replication/
1590 include/postgresql/server/rewrite/
1596 rewriteSearchCycle.h
1599 include/postgresql/server/snowball/header.h
1600 include/postgresql/server/snowball/libstemmer/
1603 stem_ISO_8859_1_basque.h
1604 stem_ISO_8859_1_catalan.h
1605 stem_ISO_8859_1_danish.h
1606 stem_ISO_8859_1_dutch.h
1607 stem_ISO_8859_1_english.h
1608 stem_ISO_8859_1_finnish.h
1609 stem_ISO_8859_1_french.h
1610 stem_ISO_8859_1_german.h
1611 stem_ISO_8859_1_indonesian.h
1612 stem_ISO_8859_1_irish.h
1613 stem_ISO_8859_1_italian.h
1614 stem_ISO_8859_1_norwegian.h
1615 stem_ISO_8859_1_porter.h
1616 stem_ISO_8859_1_portuguese.h
1617 stem_ISO_8859_1_spanish.h
1618 stem_ISO_8859_1_swedish.h
1619 stem_ISO_8859_2_hungarian.h
1620 stem_ISO_8859_2_romanian.h
1621 stem_KOI8_R_russian.h
1623 stem_UTF_8_armenian.h
1625 stem_UTF_8_catalan.h
1628 stem_UTF_8_english.h
1629 stem_UTF_8_finnish.h
1634 stem_UTF_8_hungarian.h
1635 stem_UTF_8_indonesian.h
1637 stem_UTF_8_italian.h
1638 stem_UTF_8_lithuanian.h
1640 stem_UTF_8_norwegian.h
1642 stem_UTF_8_portuguese.h
1643 stem_UTF_8_romanian.h
1644 stem_UTF_8_russian.h
1645 stem_UTF_8_serbian.h
1646 stem_UTF_8_spanish.h
1647 stem_UTF_8_swedish.h
1649 stem_UTF_8_turkish.h
1650 stem_UTF_8_yiddish.h
1651 include/postgresql/server/statistics/
1652 extended_stats_internal.h
1654 include/postgresql/server/storage/
1665 condition_variable.h
1690 predicate_internals.h
1710 include/postgresql/server/tcop/
1719 include/postgresql/server/tsearch/
1725 include/postgresql/server/tsearch/dicts/
1728 include/postgresql/server/utils/
1845 lib/postgresql/pgxs/config/
1848 lib/postgresql/pgxs/src/
1853 lib/postgresql/pgxs/src/makefiles/pgxs.mk
1854 lib/postgresql/pgxs/src/test/isolation/
1856 pg_isolation_regress
1857 lib/postgresql/pgxs/src/test/regress/pg_regress
1868 pg_archivecleanup.1.gz
1885 pg_verifybackup.1.gz
1896 SPI_commit_and_chain.3.gz
1898 SPI_connect_ext.3.gz
1900 SPI_cursor_close.3.gz
1901 SPI_cursor_fetch.3.gz
1902 SPI_cursor_find.3.gz
1903 SPI_cursor_move.3.gz
1904 SPI_cursor_open.3.gz
1905 SPI_cursor_open_with_args.3.gz
1906 SPI_cursor_open_with_paramlist.3.gz
1907 SPI_cursor_parse_open.3.gz
1911 SPI_execute_extended.3.gz
1912 SPI_execute_plan.3.gz
1913 SPI_execute_plan_extended.3.gz
1914 SPI_execute_plan_with_paramlist.3.gz
1915 SPI_execute_with_args.3.gz
1921 SPI_freetuptable.3.gz
1922 SPI_getargcount.3.gz
1923 SPI_getargtypeid.3.gz
1930 SPI_is_cursor_plan.3.gz
1932 SPI_modifytuple.3.gz
1936 SPI_prepare_cursor.3.gz
1937 SPI_prepare_extended.3.gz
1938 SPI_prepare_params.3.gz
1939 SPI_register_relation.3.gz
1940 SPI_register_trigger_data.3.gz
1942 SPI_result_code_string.3.gz
1943 SPI_returntuple.3.gz
1945 SPI_rollback_and_chain.3.gz
1947 SPI_scroll_cursor_fetch.3.gz
1948 SPI_scroll_cursor_move.3.gz
1949 SPI_start_transaction.3.gz
1950 SPI_unregister_relation.3.gz
1952 dblink_build_sql_delete.3.gz
1953 dblink_build_sql_insert.3.gz
1954 dblink_build_sql_update.3.gz
1955 dblink_cancel_query.3.gz
1958 dblink_connect_u.3.gz
1959 dblink_disconnect.3.gz
1960 dblink_error_message.3.gz
1963 dblink_get_connections.3.gz
1964 dblink_get_notify.3.gz
1965 dblink_get_pkey.3.gz
1966 dblink_get_result.3.gz
1969 dblink_send_query.3.gz
1972 ALTER_AGGREGATE.7.gz
1973 ALTER_COLLATION.7.gz
1974 ALTER_CONVERSION.7.gz
1976 ALTER_DEFAULT_PRIVILEGES.7.gz
1978 ALTER_EVENT_TRIGGER.7.gz
1979 ALTER_EXTENSION.7.gz
1980 ALTER_FOREIGN_DATA_WRAPPER.7.gz
1981 ALTER_FOREIGN_TABLE.7.gz
1986 ALTER_LARGE_OBJECT.7.gz
1987 ALTER_MATERIALIZED_VIEW.7.gz
1989 ALTER_OPERATOR_CLASS.7.gz
1990 ALTER_OPERATOR_FAMILY.7.gz
1992 ALTER_PROCEDURE.7.gz
1993 ALTER_PUBLICATION.7.gz
2000 ALTER_STATISTICS.7.gz
2001 ALTER_SUBSCRIPTION.7.gz
2004 ALTER_TABLESPACE.7.gz
2005 ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
2006 ALTER_TEXT_SEARCH_DICTIONARY.7.gz
2007 ALTER_TEXT_SEARCH_PARSER.7.gz
2008 ALTER_TEXT_SEARCH_TEMPLATE.7.gz
2012 ALTER_USER_MAPPING.7.gz
2022 COMMIT_PREPARED.7.gz
2024 CREATE_ACCESS_METHOD.7.gz
2025 CREATE_AGGREGATE.7.gz
2027 CREATE_COLLATION.7.gz
2028 CREATE_CONVERSION.7.gz
2029 CREATE_DATABASE.7.gz
2031 CREATE_EVENT_TRIGGER.7.gz
2032 CREATE_EXTENSION.7.gz
2033 CREATE_FOREIGN_DATA_WRAPPER.7.gz
2034 CREATE_FOREIGN_TABLE.7.gz
2035 CREATE_FUNCTION.7.gz
2038 CREATE_LANGUAGE.7.gz
2039 CREATE_MATERIALIZED_VIEW.7.gz
2040 CREATE_OPERATOR.7.gz
2041 CREATE_OPERATOR_CLASS.7.gz
2042 CREATE_OPERATOR_FAMILY.7.gz
2044 CREATE_PROCEDURE.7.gz
2045 CREATE_PUBLICATION.7.gz
2049 CREATE_SEQUENCE.7.gz
2051 CREATE_STATISTICS.7.gz
2052 CREATE_SUBSCRIPTION.7.gz
2054 CREATE_TABLESPACE.7.gz
2055 CREATE_TABLE_AS.7.gz
2056 CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
2057 CREATE_TEXT_SEARCH_DICTIONARY.7.gz
2058 CREATE_TEXT_SEARCH_PARSER.7.gz
2059 CREATE_TEXT_SEARCH_TEMPLATE.7.gz
2060 CREATE_TRANSFORM.7.gz
2064 CREATE_USER_MAPPING.7.gz
2071 DROP_ACCESS_METHOD.7.gz
2075 DROP_CONVERSION.7.gz
2078 DROP_EVENT_TRIGGER.7.gz
2080 DROP_FOREIGN_DATA_WRAPPER.7.gz
2081 DROP_FOREIGN_TABLE.7.gz
2086 DROP_MATERIALIZED_VIEW.7.gz
2088 DROP_OPERATOR_CLASS.7.gz
2089 DROP_OPERATOR_FAMILY.7.gz
2093 DROP_PUBLICATION.7.gz
2100 DROP_STATISTICS.7.gz
2101 DROP_SUBSCRIPTION.7.gz
2103 DROP_TABLESPACE.7.gz
2104 DROP_TEXT_SEARCH_CONFIGURATION.7.gz
2105 DROP_TEXT_SEARCH_DICTIONARY.7.gz
2106 DROP_TEXT_SEARCH_PARSER.7.gz
2107 DROP_TEXT_SEARCH_TEMPLATE.7.gz
2112 DROP_USER_MAPPING.7.gz
2119 IMPORT_FOREIGN_SCHEMA.7.gz
2127 PREPARE_TRANSACTION.7.gz
2129 REFRESH_MATERIALIZED_VIEW.7.gz
2131 RELEASE_SAVEPOINT.7.gz
2135 ROLLBACK_PREPARED.7.gz
2136 ROLLBACK_TO_SAVEPOINT.7.gz
2142 SET_CONSTRAINTS.7.gz
2144 SET_SESSION_AUTHORIZATION.7.gz
2145 SET_TRANSACTION.7.gz
2147 START_TRANSACTION.7.gz
2157 pg_service.conf.sample
2159 system_constraints.sql
2160 system_functions.sql
2163 [FILE:5142:manifests/plist.contrib]
2196 pg_stat_statements.so
2215 share/postgresql/extension/
2216 adminpack--1.0--1.1.sql
2218 adminpack--1.1--2.0.sql
2219 adminpack--2.0--2.1.sql
2221 amcheck--1.0--1.1.sql
2223 amcheck--1.1--1.2.sql
2224 amcheck--1.2--1.3.sql
2230 bool_plperl--1.0.sql
2232 bool_plperlu.control
2233 btree_gin--1.0--1.1.sql
2235 btree_gin--1.1--1.2.sql
2236 btree_gin--1.2--1.3.sql
2238 btree_gist--1.0--1.1.sql
2239 btree_gist--1.1--1.2.sql
2240 btree_gist--1.2--1.3.sql
2242 btree_gist--1.3--1.4.sql
2243 btree_gist--1.4--1.5.sql
2244 btree_gist--1.5--1.6.sql
2246 citext--1.0--1.1.sql
2247 citext--1.1--1.2.sql
2248 citext--1.2--1.3.sql
2249 citext--1.3--1.4.sql
2250 citext--1.4--1.5.sql
2252 citext--1.5--1.6.sql
2261 dblink--1.0--1.1.sql
2262 dblink--1.1--1.2.sql
2269 earthdistance--1.0--1.1.sql
2270 earthdistance--1.1.sql
2271 earthdistance.control
2274 fuzzystrmatch--1.0--1.1.sql
2275 fuzzystrmatch--1.1.sql
2276 fuzzystrmatch.control
2277 hstore--1.1--1.2.sql
2278 hstore--1.2--1.3.sql
2279 hstore--1.3--1.4.sql
2280 hstore--1.4--1.5.sql
2282 hstore--1.5--1.6.sql
2283 hstore--1.6--1.7.sql
2284 hstore--1.7--1.8.sql
2286 insert_username--1.0.sql
2287 insert_username.control
2288 intagg--1.0--1.1.sql
2291 intarray--1.0--1.1.sql
2292 intarray--1.1--1.2.sql
2293 intarray--1.2--1.3.sql
2295 intarray--1.3--1.4.sql
2296 intarray--1.4--1.5.sql
2309 moddatetime--1.0.sql
2311 old_snapshot--1.0.sql
2312 old_snapshot.control
2313 pageinspect--1.0--1.1.sql
2314 pageinspect--1.1--1.2.sql
2315 pageinspect--1.2--1.3.sql
2316 pageinspect--1.3--1.4.sql
2317 pageinspect--1.4--1.5.sql
2318 pageinspect--1.5--1.6.sql
2319 pageinspect--1.5.sql
2320 pageinspect--1.6--1.7.sql
2321 pageinspect--1.7--1.8.sql
2322 pageinspect--1.8--1.9.sql
2324 pg_buffercache--1.0--1.1.sql
2325 pg_buffercache--1.1--1.2.sql
2326 pg_buffercache--1.2--1.3.sql
2327 pg_buffercache--1.2.sql
2328 pg_buffercache.control
2329 pg_freespacemap--1.0--1.1.sql
2330 pg_freespacemap--1.1--1.2.sql
2331 pg_freespacemap--1.1.sql
2332 pg_freespacemap.control
2333 pg_prewarm--1.0--1.1.sql
2334 pg_prewarm--1.1--1.2.sql
2337 pg_stat_statements--1.0--1.1.sql
2338 pg_stat_statements--1.1--1.2.sql
2339 pg_stat_statements--1.2--1.3.sql
2340 pg_stat_statements--1.3--1.4.sql
2341 pg_stat_statements--1.4--1.5.sql
2342 pg_stat_statements--1.4.sql
2343 pg_stat_statements--1.5--1.6.sql
2344 pg_stat_statements--1.6--1.7.sql
2345 pg_stat_statements--1.7--1.8.sql
2346 pg_stat_statements--1.8--1.9.sql
2347 pg_stat_statements.control
2350 pg_trgm--1.0--1.1.sql
2351 pg_trgm--1.1--1.2.sql
2352 pg_trgm--1.2--1.3.sql
2353 pg_trgm--1.3--1.4.sql
2355 pg_trgm--1.4--1.5.sql
2356 pg_trgm--1.5--1.6.sql
2358 pg_visibility--1.0--1.1.sql
2359 pg_visibility--1.1--1.2.sql
2360 pg_visibility--1.1.sql
2361 pg_visibility.control
2362 pgcrypto--1.0--1.1.sql
2363 pgcrypto--1.1--1.2.sql
2364 pgcrypto--1.2--1.3.sql
2367 pgrowlocks--1.0--1.1.sql
2368 pgrowlocks--1.1--1.2.sql
2371 pgstattuple--1.0--1.1.sql
2372 pgstattuple--1.1--1.2.sql
2373 pgstattuple--1.2--1.3.sql
2374 pgstattuple--1.3--1.4.sql
2375 pgstattuple--1.4--1.5.sql
2376 pgstattuple--1.4.sql
2378 postgres_fdw--1.0--1.1.sql
2379 postgres_fdw--1.0.sql
2380 postgres_fdw.control
2389 sslinfo--1.0--1.1.sql
2390 sslinfo--1.1--1.2.sql
2397 tsm_system_rows--1.0.sql
2398 tsm_system_rows.control
2399 tsm_system_time--1.0.sql
2400 tsm_system_time.control
2401 unaccent--1.0--1.1.sql
2404 uuid-ossp--1.0--1.1.sql
2410 share/postgresql/tsearch_data/
2415 [FILE:510:manifests/plist.plperl]
2416 include/postgresql/server/
2421 bool_plperl.%%SHARED_OBJECT%%
2422 hstore_plperl.%%SHARED_OBJECT%%
2423 jsonb_plperl.%%SHARED_OBJECT%%
2424 plperl.%%SHARED_OBJECT%%
2425 share/postgresql/extension/
2426 bool_plperlu--1.0.sql
2427 hstore_plperl--1.0.sql
2428 hstore_plperl.control
2429 hstore_plperlu--1.0.sql
2430 hstore_plperlu.control
2431 jsonb_plperl--1.0.sql
2432 jsonb_plperl.control
2433 jsonb_plperlu--1.0.sql
2434 jsonb_plperlu.control
2441 [FILE:1092:manifests/plist.plpython]
2442 include/postgresql/server/
2452 plpy_subxactobject.h
2457 hstore_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2458 jsonb_plpython3.%%SHARED_OBJECT%%
2459 ltree_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2460 plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2461 lib/postgresql/pgxs/src/pl/plpython/regress-python3-mangle.mk
2462 share/postgresql/extension/
2463 hstore_plpython2u--1.0.sql
2464 hstore_plpython2u.control
2465 hstore_plpython3u--1.0.sql
2466 hstore_plpython3u.control
2467 hstore_plpythonu--1.0.sql
2468 hstore_plpythonu.control
2469 jsonb_plpython2u--1.0.sql
2470 jsonb_plpython2u.control
2471 jsonb_plpython3u--1.0.sql
2472 jsonb_plpython3u.control
2473 jsonb_plpythonu--1.0.sql
2474 jsonb_plpythonu.control
2475 ltree_plpython2u--1.0.sql
2476 ltree_plpython2u.control
2477 ltree_plpython3u--1.0.sql
2478 ltree_plpython3u.control
2479 ltree_plpythonu--1.0.sql
2480 ltree_plpythonu.control
2481 plpython%%PYTHON_MAJOR_VER%%u--1.0.sql
2482 plpython%%PYTHON_MAJOR_VER%%u.control
2485 [FILE:131:manifests/plist.pltcl]
2486 lib/postgresql/pltcl.%%SHARED_OBJECT%%
2487 share/postgresql/extension/
2494 [FILE:111:manifests/plist.docs]
2495 share/doc/postgresql/extension/
2497 insert_username.example
2502 [FILE:8541:manifests/plist.nls]
2503 share/locale/cs/LC_MESSAGES/
2505 ecpglib6-%%PGVER%%.mo
2508 pg_archivecleanup-%%PGVER%%.mo
2509 pg_basebackup-%%PGVER%%.mo
2510 pg_checksums-%%PGVER%%.mo
2511 pg_config-%%PGVER%%.mo
2512 pg_controldata-%%PGVER%%.mo
2514 pg_dump-%%PGVER%%.mo
2515 pg_resetwal-%%PGVER%%.mo
2516 pg_rewind-%%PGVER%%.mo
2517 pg_test_fsync-%%PGVER%%.mo
2518 pg_upgrade-%%PGVER%%.mo
2519 pg_waldump-%%PGVER%%.mo
2520 pgscripts-%%PGVER%%.mo
2522 plpgsql-%%PGVER%%.mo
2523 plpython-%%PGVER%%.mo
2526 share/locale/de/LC_MESSAGES/
2528 ecpglib6-%%PGVER%%.mo
2531 pg_amcheck-%%PGVER%%.mo
2532 pg_archivecleanup-%%PGVER%%.mo
2533 pg_basebackup-%%PGVER%%.mo
2534 pg_checksums-%%PGVER%%.mo
2535 pg_config-%%PGVER%%.mo
2536 pg_controldata-%%PGVER%%.mo
2538 pg_dump-%%PGVER%%.mo
2539 pg_resetwal-%%PGVER%%.mo
2540 pg_rewind-%%PGVER%%.mo
2541 pg_test_fsync-%%PGVER%%.mo
2542 pg_test_timing-%%PGVER%%.mo
2543 pg_upgrade-%%PGVER%%.mo
2544 pg_verifybackup-%%PGVER%%.mo
2545 pg_waldump-%%PGVER%%.mo
2546 pgscripts-%%PGVER%%.mo
2548 plpgsql-%%PGVER%%.mo
2549 plpython-%%PGVER%%.mo
2551 postgres-%%PGVER%%.mo
2553 share/locale/el/LC_MESSAGES/
2555 ecpglib6-%%PGVER%%.mo
2558 pg_amcheck-%%PGVER%%.mo
2559 pg_archivecleanup-%%PGVER%%.mo
2560 pg_basebackup-%%PGVER%%.mo
2561 pg_checksums-%%PGVER%%.mo
2562 pg_config-%%PGVER%%.mo
2563 pg_controldata-%%PGVER%%.mo
2565 pg_dump-%%PGVER%%.mo
2566 pg_resetwal-%%PGVER%%.mo
2567 pg_rewind-%%PGVER%%.mo
2568 pg_test_fsync-%%PGVER%%.mo
2569 pg_test_timing-%%PGVER%%.mo
2570 pg_verifybackup-%%PGVER%%.mo
2571 pg_waldump-%%PGVER%%.mo
2572 pgscripts-%%PGVER%%.mo
2574 plpgsql-%%PGVER%%.mo
2575 plpython-%%PGVER%%.mo
2578 share/locale/es/LC_MESSAGES/
2580 ecpglib6-%%PGVER%%.mo
2583 pg_amcheck-%%PGVER%%.mo
2584 pg_archivecleanup-%%PGVER%%.mo
2585 pg_basebackup-%%PGVER%%.mo
2586 pg_checksums-%%PGVER%%.mo
2587 pg_config-%%PGVER%%.mo
2588 pg_controldata-%%PGVER%%.mo
2590 pg_dump-%%PGVER%%.mo
2591 pg_resetwal-%%PGVER%%.mo
2592 pg_rewind-%%PGVER%%.mo
2593 pg_test_fsync-%%PGVER%%.mo
2594 pg_test_timing-%%PGVER%%.mo
2595 pg_upgrade-%%PGVER%%.mo
2596 pg_verifybackup-%%PGVER%%.mo
2597 pg_waldump-%%PGVER%%.mo
2598 pgscripts-%%PGVER%%.mo
2600 plpgsql-%%PGVER%%.mo
2601 plpython-%%PGVER%%.mo
2603 postgres-%%PGVER%%.mo
2605 share/locale/fr/LC_MESSAGES/
2607 ecpglib6-%%PGVER%%.mo
2610 pg_amcheck-%%PGVER%%.mo
2611 pg_archivecleanup-%%PGVER%%.mo
2612 pg_basebackup-%%PGVER%%.mo
2613 pg_checksums-%%PGVER%%.mo
2614 pg_config-%%PGVER%%.mo
2615 pg_controldata-%%PGVER%%.mo
2617 pg_dump-%%PGVER%%.mo
2618 pg_resetwal-%%PGVER%%.mo
2619 pg_rewind-%%PGVER%%.mo
2620 pg_test_fsync-%%PGVER%%.mo
2621 pg_test_timing-%%PGVER%%.mo
2622 pg_upgrade-%%PGVER%%.mo
2623 pg_verifybackup-%%PGVER%%.mo
2624 pg_waldump-%%PGVER%%.mo
2625 pgscripts-%%PGVER%%.mo
2627 plpgsql-%%PGVER%%.mo
2628 plpython-%%PGVER%%.mo
2630 postgres-%%PGVER%%.mo
2632 share/locale/he/LC_MESSAGES/pg_config-%%PGVER%%.mo
2633 share/locale/it/LC_MESSAGES/
2635 ecpglib6-%%PGVER%%.mo
2636 pg_config-%%PGVER%%.mo
2637 pg_controldata-%%PGVER%%.mo
2640 plpgsql-%%PGVER%%.mo
2641 plpython-%%PGVER%%.mo
2643 postgres-%%PGVER%%.mo
2645 share/locale/ja/LC_MESSAGES/
2647 ecpglib6-%%PGVER%%.mo
2650 pg_amcheck-%%PGVER%%.mo
2651 pg_archivecleanup-%%PGVER%%.mo
2652 pg_basebackup-%%PGVER%%.mo
2653 pg_checksums-%%PGVER%%.mo
2654 pg_config-%%PGVER%%.mo
2655 pg_controldata-%%PGVER%%.mo
2657 pg_dump-%%PGVER%%.mo
2658 pg_resetwal-%%PGVER%%.mo
2659 pg_rewind-%%PGVER%%.mo
2660 pg_test_fsync-%%PGVER%%.mo
2661 pg_test_timing-%%PGVER%%.mo
2662 pg_upgrade-%%PGVER%%.mo
2663 pg_verifybackup-%%PGVER%%.mo
2664 pg_waldump-%%PGVER%%.mo
2665 pgscripts-%%PGVER%%.mo
2667 plpgsql-%%PGVER%%.mo
2668 plpython-%%PGVER%%.mo
2670 postgres-%%PGVER%%.mo
2672 share/locale/ko/LC_MESSAGES/
2674 ecpglib6-%%PGVER%%.mo
2677 pg_archivecleanup-%%PGVER%%.mo
2678 pg_basebackup-%%PGVER%%.mo
2679 pg_checksums-%%PGVER%%.mo
2680 pg_config-%%PGVER%%.mo
2681 pg_controldata-%%PGVER%%.mo
2683 pg_dump-%%PGVER%%.mo
2684 pg_resetwal-%%PGVER%%.mo
2685 pg_test_fsync-%%PGVER%%.mo
2686 pg_upgrade-%%PGVER%%.mo
2687 pg_verifybackup-%%PGVER%%.mo
2688 pg_waldump-%%PGVER%%.mo
2689 pgscripts-%%PGVER%%.mo
2691 plpgsql-%%PGVER%%.mo
2692 plpython-%%PGVER%%.mo
2694 postgres-%%PGVER%%.mo
2696 share/locale/pl/LC_MESSAGES/
2698 ecpglib6-%%PGVER%%.mo
2699 pg_config-%%PGVER%%.mo
2700 pg_test_fsync-%%PGVER%%.mo
2702 plpgsql-%%PGVER%%.mo
2703 plpython-%%PGVER%%.mo
2705 share/locale/pt_BR/LC_MESSAGES/
2707 ecpglib6-%%PGVER%%.mo
2708 pg_config-%%PGVER%%.mo
2710 plpgsql-%%PGVER%%.mo
2711 plpython-%%PGVER%%.mo
2712 share/locale/ro/LC_MESSAGES/plperl-%%PGVER%%.mo
2713 share/locale/ru/LC_MESSAGES/
2715 ecpglib6-%%PGVER%%.mo
2718 pg_amcheck-%%PGVER%%.mo
2719 pg_archivecleanup-%%PGVER%%.mo
2720 pg_basebackup-%%PGVER%%.mo
2721 pg_checksums-%%PGVER%%.mo
2722 pg_config-%%PGVER%%.mo
2723 pg_controldata-%%PGVER%%.mo
2725 pg_dump-%%PGVER%%.mo
2726 pg_resetwal-%%PGVER%%.mo
2727 pg_rewind-%%PGVER%%.mo
2728 pg_test_fsync-%%PGVER%%.mo
2729 pg_test_timing-%%PGVER%%.mo
2730 pg_upgrade-%%PGVER%%.mo
2731 pg_verifybackup-%%PGVER%%.mo
2732 pg_waldump-%%PGVER%%.mo
2733 pgscripts-%%PGVER%%.mo
2735 plpgsql-%%PGVER%%.mo
2736 plpython-%%PGVER%%.mo
2738 postgres-%%PGVER%%.mo
2740 share/locale/sv/LC_MESSAGES/
2742 ecpglib6-%%PGVER%%.mo
2745 pg_amcheck-%%PGVER%%.mo
2746 pg_archivecleanup-%%PGVER%%.mo
2747 pg_basebackup-%%PGVER%%.mo
2748 pg_checksums-%%PGVER%%.mo
2749 pg_config-%%PGVER%%.mo
2750 pg_controldata-%%PGVER%%.mo
2752 pg_dump-%%PGVER%%.mo
2753 pg_resetwal-%%PGVER%%.mo
2754 pg_rewind-%%PGVER%%.mo
2755 pg_test_fsync-%%PGVER%%.mo
2756 pg_test_timing-%%PGVER%%.mo
2757 pg_upgrade-%%PGVER%%.mo
2758 pg_verifybackup-%%PGVER%%.mo
2759 pg_waldump-%%PGVER%%.mo
2760 pgscripts-%%PGVER%%.mo
2762 plpgsql-%%PGVER%%.mo
2763 plpython-%%PGVER%%.mo
2765 postgres-%%PGVER%%.mo
2767 share/locale/tr/LC_MESSAGES/
2769 ecpglib6-%%PGVER%%.mo
2771 pg_archivecleanup-%%PGVER%%.mo
2772 pg_basebackup-%%PGVER%%.mo
2773 pg_checksums-%%PGVER%%.mo
2774 pg_config-%%PGVER%%.mo
2775 pg_controldata-%%PGVER%%.mo
2777 pg_dump-%%PGVER%%.mo
2778 pg_resetwal-%%PGVER%%.mo
2779 pg_test_fsync-%%PGVER%%.mo
2780 pg_upgrade-%%PGVER%%.mo
2781 pg_waldump-%%PGVER%%.mo
2782 pgscripts-%%PGVER%%.mo
2784 plpgsql-%%PGVER%%.mo
2785 plpython-%%PGVER%%.mo
2788 share/locale/uk/LC_MESSAGES/
2790 ecpglib6-%%PGVER%%.mo
2793 pg_amcheck-%%PGVER%%.mo
2794 pg_archivecleanup-%%PGVER%%.mo
2795 pg_basebackup-%%PGVER%%.mo
2796 pg_checksums-%%PGVER%%.mo
2797 pg_config-%%PGVER%%.mo
2798 pg_controldata-%%PGVER%%.mo
2800 pg_dump-%%PGVER%%.mo
2801 pg_resetwal-%%PGVER%%.mo
2802 pg_rewind-%%PGVER%%.mo
2803 pg_test_fsync-%%PGVER%%.mo
2804 pg_test_timing-%%PGVER%%.mo
2805 pg_upgrade-%%PGVER%%.mo
2806 pg_verifybackup-%%PGVER%%.mo
2807 pg_waldump-%%PGVER%%.mo
2808 pgscripts-%%PGVER%%.mo
2810 plpgsql-%%PGVER%%.mo
2811 plpython-%%PGVER%%.mo
2813 postgres-%%PGVER%%.mo
2815 share/locale/vi/LC_MESSAGES/
2817 ecpglib6-%%PGVER%%.mo
2818 pg_config-%%PGVER%%.mo
2819 pg_test_fsync-%%PGVER%%.mo
2821 plpgsql-%%PGVER%%.mo
2822 plpython-%%PGVER%%.mo
2824 share/locale/zh_CN/LC_MESSAGES/
2826 ecpglib6-%%PGVER%%.mo
2829 pg_amcheck-%%PGVER%%.mo
2830 pg_archivecleanup-%%PGVER%%.mo
2831 pg_basebackup-%%PGVER%%.mo
2832 pg_checksums-%%PGVER%%.mo
2833 pg_config-%%PGVER%%.mo
2834 pg_controldata-%%PGVER%%.mo
2836 pg_dump-%%PGVER%%.mo
2837 pg_resetwal-%%PGVER%%.mo
2838 pg_rewind-%%PGVER%%.mo
2839 pg_test_fsync-%%PGVER%%.mo
2840 pg_test_timing-%%PGVER%%.mo
2841 pg_upgrade-%%PGVER%%.mo
2842 pg_verifybackup-%%PGVER%%.mo
2843 pg_waldump-%%PGVER%%.mo
2844 pgscripts-%%PGVER%%.mo
2846 plpgsql-%%PGVER%%.mo
2847 plpython-%%PGVER%%.mo
2849 postgres-%%PGVER%%.mo
2851 share/locale/zh_TW/LC_MESSAGES/ecpg-%%PGVER%%.mo
2854 [FILE:393:patches/patch-configure]
2855 --- configure.orig 2023-08-07 20:10:05 UTC
2857 @@ -12599,7 +12599,7 @@ if ac_fn_c_try_link "$LINENO"; then :
2858 # recognize dependent libraries; assume curses is needed if we didn't
2859 # find any dependency.
2861 - netbsd* | openbsd*)
2863 if test x"$pgac_lib" = x"" ; then
2864 pgac_lib=" -lcurses"
2868 [FILE:349:patches/patch-doc-Makefile]
2869 --- doc/Makefile.orig 2023-08-07 20:10:05 UTC
2871 @@ -12,5 +12,5 @@ subdir = doc
2873 include $(top_builddir)/src/Makefile.global
2875 -all distprep html man install installdirs uninstall clean distclean maintainer-clean:
2876 +all distprep man install installdirs uninstall clean distclean maintainer-clean:
2880 [FILE:1196:patches/patch-doc_src_sgml_Makefile]
2881 --- doc/src/sgml/Makefile.orig 2023-08-07 20:10:05 UTC
2882 +++ doc/src/sgml/Makefile
2885 # Make "html" the default target, since that is what most people tend
2890 # We don't need the tree-wide headers or install support here.
2891 NO_GENERATED_HEADERS=yes
2892 @@ -26,7 +26,7 @@ top_builddir = ../../..
2893 include $(top_builddir)/src/Makefile.global
2899 distprep: html distprep-man
2901 @@ -69,8 +69,6 @@ ALL_IMAGES := $(wildcard $(srcdir)/image
2905 -man distprep-man: man-stamp
2907 man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML)
2908 $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^)
2909 $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $(wordlist 1,2,$^)
2910 @@ -224,10 +222,10 @@ check: postgres.sgml $(ALLSGML) check-ta
2914 -install: install-html install-man
2915 +install: install-man
2918 - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2919 + $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2921 # If the install used a man directory shared with other applications, this will remove all files.
2925 [FILE:498:patches/patch-src-backend-Makefile]
2926 --- src/backend/Makefile.orig 2023-08-07 20:10:05 UTC
2927 +++ src/backend/Makefile
2928 @@ -116,6 +116,8 @@ endif # aix
2930 $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport
2932 +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
2935 # The postgres.o target is needed by the rule in Makefile.global that
2936 # creates the exports file when MAKE_EXPORTS = true.
2939 [FILE:863:patches/patch-src_Makefile.shlib]
2940 --- src/Makefile.shlib.orig 2023-08-07 20:10:05 UTC
2941 +++ src/Makefile.shlib
2942 @@ -166,6 +166,9 @@ ifeq ($(PORTNAME), freebsd)
2945 ifeq ($(PORTNAME), netbsd)
2946 + ifdef SO_MAJOR_VERSION
2947 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2949 LINK.shared = $(COMPILER) -shared
2951 LINK.shared += -Wl,-x,-soname,$(soname)
2952 @@ -212,6 +215,9 @@ endif
2954 ifeq ($(PORTNAME), linux)
2955 LINK.shared = $(COMPILER) -shared
2956 + ifdef SO_MAJOR_VERSION
2957 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2960 LINK.shared += -Wl,-soname,$(soname)
2962 @@ -223,6 +229,9 @@ ifeq ($(PORTNAME), linux)
2965 ifeq ($(PORTNAME), solaris)
2966 + ifdef SO_MAJOR_VERSION
2967 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2970 LINK.shared = $(COMPILER) -shared -Wl,-Bsymbolic
2974 [FILE:685:patches/patch-src_backend_utils_misc_postgresql.conf.sample]
2975 --- src/backend/utils/misc/postgresql.conf.sample.orig 2023-08-07 20:10:05 UTC
2976 +++ src/backend/utils/misc/postgresql.conf.sample
2981 +log_destination = 'syslog'
2982 #log_destination = 'stderr' # Valid values are combinations of
2983 # stderr, csvlog, syslog, and eventlog,
2984 # depending on platform. csvlog
2987 #cluster_name = '' # added to process titles if nonempty
2988 # (change requires restart)
2989 -#update_process_title = on
2991 +# On FreeBSD, this is a performance hog, so keep it off if you need speed
2992 +update_process_title = off
2995 #------------------------------------------------------------------------------
2998 [FILE:3090:files/502.pgsql.in]
3001 # Maintenance shell script to vacuum and backup database
3002 # Put this in /usr/local/etc/periodic/daily, and it will be run
3005 # Written by Palle Girgensohn <girgen@pingpong.net>
3007 # In public domain, do what you like with it,
3008 # and use it at your own risk... :)
3011 # Define these variables in either /etc/periodic.conf or
3012 # /etc/periodic.conf.local to override the default values.
3014 # daily_pgsql_backup_enable="YES" # do backup of all databases
3015 # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases
3016 # daily_pgsql_vacuum_enable="YES" # do vacuum
3018 # If there is a global system configuration file, suck it in.
3020 if [ -r /etc/defaults/periodic.conf ]
3022 . /etc/defaults/periodic.conf
3023 source_periodic_confs
3026 : ${daily_pgsql_user:="%%PG_USER%%"}
3027 : ${daily_pgsql_port:=5432}
3028 : ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"}
3029 : ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"}
3030 : ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"}
3031 # backupdir is relative to ~pgsql home directory unless it begins with a slash:
3032 : ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"}
3033 : ${daily_pgsql_savedays:="7"}
3035 # allow '~ยด in dir name
3036 eval backupdir=${daily_pgsql_backupdir}
3041 # daily_pgsql_backupdir must be writeable by user %%PG_USER%%
3042 # ~%%PG_USER%% is just that under normal circumstances,
3043 # but this might not be where you want the backups...
3044 if [ ! -d ${backupdir} ] ; then
3045 echo Creating ${backupdir}
3046 mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir}
3050 echo "PostgreSQL backups"
3055 now=`date "+%Y-%m-%dT%H:%M:%S"`
3056 file=${daily_pgsql_backupdir}/pgglobals_${now}
3057 su -l ${daily_pgsql_user} -c \
3058 "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz"
3063 file=${backupdir}/pgdump_${db}_${now}
3064 su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
3065 [ $? -gt 0 ] && rc=3
3069 if [ $rc -gt 0 ]; then
3071 echo "Errors were reported during backup."
3074 # cleaning up old data
3075 find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \
3076 -a -mtime +${daily_pgsql_savedays} -delete
3080 case "$daily_pgsql_backup_enable" in
3082 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\'"`
3083 pgsql_backup $dbnames
3093 pgsql_backup $daily_pgsql_backup_enable
3097 case "$daily_pgsql_vacuum_enable" in
3101 echo "PostgreSQL vacuum"
3102 su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}"
3106 echo "Errors were reported during vacuum."
3115 [FILE:3182:files/postgresql.in]
3118 # PROVIDE: postgresql
3122 # Add the following line to /etc/rc.conf to enable PostgreSQL:
3124 # postgresql_enable="YES"
3126 # postgresql_data="%%PREFIX%%/%%PG_USER%%/%%DATADIR%%"
3127 # postgresql_flags="-w -s -m fast"
3128 # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
3129 # postgresql_class="default"
3130 # postgresql_profiles=""
3132 # See %%PREFIX%%/share/doc/postgresql/README-server for more info
3134 # This scripts takes one of the following commands:
3136 # start stop restart reload status initdb
3138 # For postmaster startup options, edit ${postgresql_data}/postgresql.conf
3140 command=%%PREFIX%%/bin/pg_ctl
3144 load_rc_config postgresql
3147 postgresql_enable=${postgresql_enable:-"NO"}
3148 postgresql_flags=${postgresql_flags:-"-w -s -m fast"}
3149 postgresql_user=${postgresql_user:-"%%PG_USER%%"}
3150 eval postgresql_data=${postgresql_data:-"~${postgresql_user}/%%DATADIR%%"}
3151 postgresql_class=${postgresql_class:-"default"}
3152 postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"}
3155 rcvar=postgresql_enable
3156 extra_commands="reload initdb"
3158 start_cmd="postgresql_command start"
3159 stop_cmd="postgresql_command stop"
3160 restart_cmd="postgresql_command restart"
3161 reload_cmd="postgresql_command reload"
3162 status_cmd="postgresql_command status"
3164 initdb_cmd="postgresql_initdb"
3166 if [ -n "$2" ]; then
3168 if [ "x${postgresql_profiles}" != "x" ]; then
3169 eval postgresql_data="\${postgresql_${profile}_data:-}"
3170 if [ "x${postgresql_data}" = "x" ]; then
3171 echo "You must define a data directory (postgresql_${profile}_data)"
3174 eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}"
3175 eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}"
3176 eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}"
3177 eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}"
3180 if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then
3181 for profile in ${postgresql_profiles}; do
3182 eval _enable="\${postgresql_${profile}_enable}"
3183 case "x${_enable:-${postgresql_enable}}" in
3184 x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee])
3190 if test -z "$_enable"; then
3191 _var=postgresql_enable
3193 _var=postgresql_"${profile}"_enable
3196 "'${_enable:-${postgresql_enable}}'" \
3198 "Profile ${profile} skipped."
3202 echo "===> postgresql profile: ${profile}"
3203 %%PREFIX%%/etc/rc.d/postgresql $1 ${profile}
3205 if [ "0${retcode}" -ne 0 ]; then
3206 failed="${profile} (${retcode}) ${failed:-}"
3208 success="${profile} ${success:-}"
3215 command_args="-D ${postgresql_data} ${postgresql_flags}"
3217 postgresql_command()
3219 su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
3224 su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}"