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.7
13 DISTFILE[1]= postgresql-14.7.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 BR_DEPS[sunos]= ossp-uuid:primary:standard
42 BR_DEPS[linux]= ossp-uuid:primary:standard
43 BR_DEPS[darwin]= libuuid:single:standard
45 EXRUN[plpython]= python
46 EXRUN[client]= gettext:primary:standard
47 libxslt:primary:standard
48 readline:primary:standard
51 EXRUN[contrib]= postgresql14:client:standard
52 libxslt:primary:standard
54 gettext:primary:standard
57 EXRUN[server]= postgresql14:client:standard
61 USERGROUP_SPKG= server
63 USES= bison gmake perl:build tcl:build ssl python:build
65 GNOME_COMPONENTS= libxml2
67 DISTNAME= postgresql-14.7
69 LICENSE= PostgreSQL:server
70 LICENSE_FILE= PostgreSQL:{{WRKSRC}}/COPYRIGHT
73 CPE_PRODUCT= postgresql
74 CPE_VENDOR= postgresql
75 FPC_EQUIVALENT= databases/postgresql14-server
78 CONFIGURE_ARGS= --with-libraries="{{PREFIX}}/lib"
79 --with-includes="{{PREFIX}}/include:{{TCL_INCLUDEDIR}}"
80 --with-tclconfig="{{TCL_LIBDIR}}"
89 CONFIGURE_ENV= PTHREAD_LIBS="-lpthread"
91 pgac_cv_path_stylesheets={{PREFIX}}/share/sgml/docbook/dsssl/modular
94 MAKE_ENV= TCL_INCDIR="{{TCL_INCLUDEDIR}}"
96 INSTALL_TARGET= install-world
98 RC_SUBR= postgresql:server
100 SUB_LIST= PG_GROUP=pgsql
106 VAR_OPSYS[freebsd]= CONFIGURE_ARGS=--with-template=freebsd
107 CONFIGURE_ARGS=--with-uuid=bsd
108 VAR_OPSYS[sunos]= CONFIGURE_ENV=ac_cv_search_bind_textdomain_codeset=-lintl
109 CONFIGURE_ARGS=--with-template=solaris
110 CONFIGURE_ARGS=--with-uuid=ossp
111 LDFLAGS=-L{{PREFIX}}/lib/ossp
112 LDFLAGS=-Wl,-rpath,{{PREFIX}}/lib/ossp
113 VAR_OPSYS[linux]= CONFIGURE_ARGS=--with-template=linux
114 CONFIGURE_ARGS=--with-uuid=ossp
115 LDFLAGS=-L{{PREFIX}}/lib/ossp
116 LDFLAGS=-Wl,-rpath,{{PREFIX}}/lib/ossp
117 VAR_OPSYS[darwin]= CONFIGURE_ARGS=--with-template=darwin
118 CONFIGURE_ARGS=--with-uuid=e2fs
119 VAR_OPSYS[netbsd]= CONFIGURE_ARGS=--with-template=netbsd
120 CONFIGURE_ARGS=--with-uuid=bsd
121 VAR_OPSYS[openbsd]= CONFIGURE_ARGS=--with-template=openbsd
122 CONFIGURE_ARGS=--with-uuid=bsd
123 VAR_OPSYS[dragonfly]= CONFIGURE_ARGS=--with-template=freebsd
124 CONFIGURE_ARGS=--with-uuid=bsd
127 ${MKDIR} ${STAGEDIR}${PREFIX}/etc/periodic/daily
128 ${INSTALL_SCRIPT} ${WRKDIR}/502.pgsql \
129 ${STAGEDIR}${PREFIX}/etc/periodic/daily
130 # install-world doesn't strip (and install-strip won't install enough)
131 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so
132 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/*.${LIBEXT}
133 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/regress/pg_regress
134 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/isolation/isolationtester
135 ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/isolation/pg_isolation_regress
136 list=$$(${LS} ${STAGEDIR}${PREFIX}/bin/* | ${GREP} -v pltcl_); \
137 ${STRIP_CMD} $${list}
140 ${REINPLACE_CMD} -e '/sqlmansect/d' \
141 ${WRKSRC}/src/makefiles/Makefile.solaris
143 [FILE:1220:descriptions/desc.server]
144 PostgreSQL is a sophisticated Object-Relational DBMS, supporting
145 almost all SQL constructs, including subselects, transactions, and
146 user-defined types and functions. It is the most advanced open-source
147 database available anywhere. Commercial Support is also available.
149 The original Postgres code was the effort of many graduate students,
150 undergraduate students, and staff programmers working under the direction
151 of Professor Michael Stonebraker at the University of California,
152 Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting
153 the DBMS query language to SQL and created a new database system which came
154 to known as Postgres95. Many others contributed to the porting, testing,
155 debugging and enhancement of the Postgres95 code. As the code improved,
156 and 1995 faded into memory, PostgreSQL was born.
158 PostgreSQL development is presently being performed by a team of developers
159 who are now responsible for all current and future development. The
160 development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG).
161 Support is available from the PostgreSQL developer/user community through
162 the support mailing list (questions@PostgreSQL.ORG).
164 This subpackage contains the PostgreSQL server.
167 [FILE:48:descriptions/desc.client]
168 This subpackage contains the PostgreSQL client.
171 [FILE:60:descriptions/desc.contrib]
172 This subpackage contains the contrib modules of PostgreSQL.
175 [FILE:74:descriptions/desc.plperl]
176 This subpackage contains Perl Procedural Language support for PostgreSQL.
179 [FILE:76:descriptions/desc.plpython]
180 This subpackage contains Python Procedural Language support for PostgreSQL.
183 [FILE:73:descriptions/desc.pltcl]
184 This subpackage contains Tcl Procedural Language support for PostgreSQL.
188 cef60f0098fa8101c1546f4254e45b722af5431337945b37af207007630db331 22182073 postgresql/postgresql-14.7.tar.bz2
191 [FILE:8053:manifests/plist.server]
208 etc/periodic/daily/502.pgsql
209 include/postgresql/server/plpgsql.h
220 latin2_and_win1250.so
235 utf8_and_iso8859_1.so
242 information_schema.sql
246 postgresql.conf.sample
250 share/postgresql/extension/
253 share/postgresql/timezone/
299 share/postgresql/timezone/Africa/
354 share/postgresql/timezone/America/
497 share/postgresql/timezone/America/Argentina/
511 share/postgresql/timezone/America/Indiana/
520 share/postgresql/timezone/America/Kentucky/
523 share/postgresql/timezone/America/North_Dakota/
527 share/postgresql/timezone/Antarctica/
540 share/postgresql/timezone/Arctic/Longyearbyen
541 share/postgresql/timezone/Asia/
641 share/postgresql/timezone/Atlantic/
654 share/postgresql/timezone/Australia/
678 share/postgresql/timezone/Brazil/
683 share/postgresql/timezone/Canada/
692 share/postgresql/timezone/Chile/
695 share/postgresql/timezone/Etc/
731 share/postgresql/timezone/Europe/
796 share/postgresql/timezone/Indian/
808 share/postgresql/timezone/Mexico/
812 share/postgresql/timezone/Pacific/
857 share/postgresql/timezone/US/
870 share/postgresql/timezonesets/
884 share/postgresql/tsearch_data/
892 hunspell_sample.affix
893 hunspell_sample_long.affix
894 hunspell_sample_long.dict
895 hunspell_sample_num.affix
896 hunspell_sample_num.dict
911 [FILE:20984:manifests/plist.client]
914 libecpg_compat.so.3.11
960 include/libpq/libpq-fs.h
961 include/postgresql/informix/esql/
965 include/postgresql/internal/
971 include/postgresql/internal/libpq/pqcomm.h
972 include/postgresql/server/
994 include/postgresql/server/access/
1078 include/postgresql/server/bootstrap/bootstrap.h
1079 include/postgresql/server/catalog/
1121 pg_db_role_setting.h
1122 pg_db_role_setting_d.h
1132 pg_event_trigger_d.h
1135 pg_foreign_data_wrapper.h
1136 pg_foreign_data_wrapper_d.h
1138 pg_foreign_server_d.h
1140 pg_foreign_table_d.h
1151 pg_largeobject_metadata.h
1152 pg_largeobject_metadata_d.h
1161 pg_partitioned_table.h
1162 pg_partitioned_table_d.h
1169 pg_publication_rel.h
1170 pg_publication_rel_d.h
1173 pg_replication_origin.h
1174 pg_replication_origin_d.h
1184 pg_shdescription_d.h
1190 pg_statistic_ext_d.h
1191 pg_statistic_ext_data.h
1192 pg_statistic_ext_data_d.h
1195 pg_subscription_rel.h
1196 pg_subscription_rel_d.h
1206 pg_ts_config_map_d.h
1222 include/postgresql/server/commands/
1259 include/postgresql/server/common/
1291 unicode_combining_table.h
1293 unicode_norm_hashfunc.h
1294 unicode_norm_table.h
1295 unicode_normprops_table.h
1297 include/postgresql/server/datatype/timestamp.h
1298 include/postgresql/server/executor/
1312 nodeBitmapHeapscan.h
1313 nodeBitmapIndexscan.h
1324 nodeIncrementalSort.h
1334 nodeNamedtuplestorescan.h
1337 nodeRecursiveunion.h
1358 include/postgresql/server/extension/cube/cubedata.h
1359 include/postgresql/server/extension/hstore/hstore.h
1360 include/postgresql/server/extension/isn/isn.h
1361 include/postgresql/server/extension/ltree/ltree.h
1362 include/postgresql/server/extension/seg/segdata.h
1363 include/postgresql/server/fe_utils/
1378 include/postgresql/server/foreign/
1381 include/postgresql/server/jit/
1385 include/postgresql/server/lib/
1400 include/postgresql/server/libpq/
1415 include/postgresql/server/mb/
1418 include/postgresql/server/nodes/
1440 include/postgresql/server/optimizer/
1451 geqo_recombination.h
1468 include/postgresql/server/parser/
1492 include/postgresql/server/partitioning/
1497 include/postgresql/server/port/
1515 include/postgresql/server/port/atomics/
1527 include/postgresql/server/port/win32/
1532 include/postgresql/server/port/win32/arpa/inet.h
1533 include/postgresql/server/port/win32/netinet/in.h
1534 include/postgresql/server/port/win32/sys/
1537 include/postgresql/server/port/win32_msvc/
1541 include/postgresql/server/port/win32_msvc/sys/
1545 include/postgresql/server/portability/
1548 include/postgresql/server/postmaster/
1551 bgworker_internals.h
1560 include/postgresql/server/regex/
1566 include/postgresql/server/replication/
1587 include/postgresql/server/rewrite/
1593 rewriteSearchCycle.h
1596 include/postgresql/server/snowball/header.h
1597 include/postgresql/server/snowball/libstemmer/
1600 stem_ISO_8859_1_basque.h
1601 stem_ISO_8859_1_catalan.h
1602 stem_ISO_8859_1_danish.h
1603 stem_ISO_8859_1_dutch.h
1604 stem_ISO_8859_1_english.h
1605 stem_ISO_8859_1_finnish.h
1606 stem_ISO_8859_1_french.h
1607 stem_ISO_8859_1_german.h
1608 stem_ISO_8859_1_indonesian.h
1609 stem_ISO_8859_1_irish.h
1610 stem_ISO_8859_1_italian.h
1611 stem_ISO_8859_1_norwegian.h
1612 stem_ISO_8859_1_porter.h
1613 stem_ISO_8859_1_portuguese.h
1614 stem_ISO_8859_1_spanish.h
1615 stem_ISO_8859_1_swedish.h
1616 stem_ISO_8859_2_hungarian.h
1617 stem_ISO_8859_2_romanian.h
1618 stem_KOI8_R_russian.h
1620 stem_UTF_8_armenian.h
1622 stem_UTF_8_catalan.h
1625 stem_UTF_8_english.h
1626 stem_UTF_8_finnish.h
1631 stem_UTF_8_hungarian.h
1632 stem_UTF_8_indonesian.h
1634 stem_UTF_8_italian.h
1635 stem_UTF_8_lithuanian.h
1637 stem_UTF_8_norwegian.h
1639 stem_UTF_8_portuguese.h
1640 stem_UTF_8_romanian.h
1641 stem_UTF_8_russian.h
1642 stem_UTF_8_serbian.h
1643 stem_UTF_8_spanish.h
1644 stem_UTF_8_swedish.h
1646 stem_UTF_8_turkish.h
1647 stem_UTF_8_yiddish.h
1648 include/postgresql/server/statistics/
1649 extended_stats_internal.h
1651 include/postgresql/server/storage/
1662 condition_variable.h
1687 predicate_internals.h
1707 include/postgresql/server/tcop/
1716 include/postgresql/server/tsearch/
1722 include/postgresql/server/tsearch/dicts/
1725 include/postgresql/server/utils/
1842 lib/postgresql/pgxs/config/
1845 lib/postgresql/pgxs/src/
1850 lib/postgresql/pgxs/src/makefiles/pgxs.mk
1851 lib/postgresql/pgxs/src/test/isolation/
1853 pg_isolation_regress
1854 lib/postgresql/pgxs/src/test/regress/pg_regress
1865 pg_archivecleanup.1.gz
1882 pg_verifybackup.1.gz
1893 SPI_commit_and_chain.3.gz
1895 SPI_connect_ext.3.gz
1897 SPI_cursor_close.3.gz
1898 SPI_cursor_fetch.3.gz
1899 SPI_cursor_find.3.gz
1900 SPI_cursor_move.3.gz
1901 SPI_cursor_open.3.gz
1902 SPI_cursor_open_with_args.3.gz
1903 SPI_cursor_open_with_paramlist.3.gz
1904 SPI_cursor_parse_open.3.gz
1908 SPI_execute_extended.3.gz
1909 SPI_execute_plan.3.gz
1910 SPI_execute_plan_extended.3.gz
1911 SPI_execute_plan_with_paramlist.3.gz
1912 SPI_execute_with_args.3.gz
1918 SPI_freetuptable.3.gz
1919 SPI_getargcount.3.gz
1920 SPI_getargtypeid.3.gz
1927 SPI_is_cursor_plan.3.gz
1929 SPI_modifytuple.3.gz
1933 SPI_prepare_cursor.3.gz
1934 SPI_prepare_extended.3.gz
1935 SPI_prepare_params.3.gz
1936 SPI_register_relation.3.gz
1937 SPI_register_trigger_data.3.gz
1939 SPI_result_code_string.3.gz
1940 SPI_returntuple.3.gz
1942 SPI_rollback_and_chain.3.gz
1944 SPI_scroll_cursor_fetch.3.gz
1945 SPI_scroll_cursor_move.3.gz
1946 SPI_start_transaction.3.gz
1947 SPI_unregister_relation.3.gz
1949 dblink_build_sql_delete.3.gz
1950 dblink_build_sql_insert.3.gz
1951 dblink_build_sql_update.3.gz
1952 dblink_cancel_query.3.gz
1955 dblink_connect_u.3.gz
1956 dblink_disconnect.3.gz
1957 dblink_error_message.3.gz
1960 dblink_get_connections.3.gz
1961 dblink_get_notify.3.gz
1962 dblink_get_pkey.3.gz
1963 dblink_get_result.3.gz
1966 dblink_send_query.3.gz
1969 ALTER_AGGREGATE.7.gz
1970 ALTER_COLLATION.7.gz
1971 ALTER_CONVERSION.7.gz
1973 ALTER_DEFAULT_PRIVILEGES.7.gz
1975 ALTER_EVENT_TRIGGER.7.gz
1976 ALTER_EXTENSION.7.gz
1977 ALTER_FOREIGN_DATA_WRAPPER.7.gz
1978 ALTER_FOREIGN_TABLE.7.gz
1983 ALTER_LARGE_OBJECT.7.gz
1984 ALTER_MATERIALIZED_VIEW.7.gz
1986 ALTER_OPERATOR_CLASS.7.gz
1987 ALTER_OPERATOR_FAMILY.7.gz
1989 ALTER_PROCEDURE.7.gz
1990 ALTER_PUBLICATION.7.gz
1997 ALTER_STATISTICS.7.gz
1998 ALTER_SUBSCRIPTION.7.gz
2001 ALTER_TABLESPACE.7.gz
2002 ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
2003 ALTER_TEXT_SEARCH_DICTIONARY.7.gz
2004 ALTER_TEXT_SEARCH_PARSER.7.gz
2005 ALTER_TEXT_SEARCH_TEMPLATE.7.gz
2009 ALTER_USER_MAPPING.7.gz
2019 COMMIT_PREPARED.7.gz
2021 CREATE_ACCESS_METHOD.7.gz
2022 CREATE_AGGREGATE.7.gz
2024 CREATE_COLLATION.7.gz
2025 CREATE_CONVERSION.7.gz
2026 CREATE_DATABASE.7.gz
2028 CREATE_EVENT_TRIGGER.7.gz
2029 CREATE_EXTENSION.7.gz
2030 CREATE_FOREIGN_DATA_WRAPPER.7.gz
2031 CREATE_FOREIGN_TABLE.7.gz
2032 CREATE_FUNCTION.7.gz
2035 CREATE_LANGUAGE.7.gz
2036 CREATE_MATERIALIZED_VIEW.7.gz
2037 CREATE_OPERATOR.7.gz
2038 CREATE_OPERATOR_CLASS.7.gz
2039 CREATE_OPERATOR_FAMILY.7.gz
2041 CREATE_PROCEDURE.7.gz
2042 CREATE_PUBLICATION.7.gz
2046 CREATE_SEQUENCE.7.gz
2048 CREATE_STATISTICS.7.gz
2049 CREATE_SUBSCRIPTION.7.gz
2051 CREATE_TABLESPACE.7.gz
2052 CREATE_TABLE_AS.7.gz
2053 CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
2054 CREATE_TEXT_SEARCH_DICTIONARY.7.gz
2055 CREATE_TEXT_SEARCH_PARSER.7.gz
2056 CREATE_TEXT_SEARCH_TEMPLATE.7.gz
2057 CREATE_TRANSFORM.7.gz
2061 CREATE_USER_MAPPING.7.gz
2068 DROP_ACCESS_METHOD.7.gz
2072 DROP_CONVERSION.7.gz
2075 DROP_EVENT_TRIGGER.7.gz
2077 DROP_FOREIGN_DATA_WRAPPER.7.gz
2078 DROP_FOREIGN_TABLE.7.gz
2083 DROP_MATERIALIZED_VIEW.7.gz
2085 DROP_OPERATOR_CLASS.7.gz
2086 DROP_OPERATOR_FAMILY.7.gz
2090 DROP_PUBLICATION.7.gz
2097 DROP_STATISTICS.7.gz
2098 DROP_SUBSCRIPTION.7.gz
2100 DROP_TABLESPACE.7.gz
2101 DROP_TEXT_SEARCH_CONFIGURATION.7.gz
2102 DROP_TEXT_SEARCH_DICTIONARY.7.gz
2103 DROP_TEXT_SEARCH_PARSER.7.gz
2104 DROP_TEXT_SEARCH_TEMPLATE.7.gz
2109 DROP_USER_MAPPING.7.gz
2116 IMPORT_FOREIGN_SCHEMA.7.gz
2124 PREPARE_TRANSACTION.7.gz
2126 REFRESH_MATERIALIZED_VIEW.7.gz
2128 RELEASE_SAVEPOINT.7.gz
2132 ROLLBACK_PREPARED.7.gz
2133 ROLLBACK_TO_SAVEPOINT.7.gz
2139 SET_CONSTRAINTS.7.gz
2141 SET_SESSION_AUTHORIZATION.7.gz
2142 SET_TRANSACTION.7.gz
2144 START_TRANSACTION.7.gz
2154 pg_service.conf.sample
2156 system_constraints.sql
2157 system_functions.sql
2160 [FILE:5142:manifests/plist.contrib]
2193 pg_stat_statements.so
2212 share/postgresql/extension/
2213 adminpack--1.0--1.1.sql
2215 adminpack--1.1--2.0.sql
2216 adminpack--2.0--2.1.sql
2218 amcheck--1.0--1.1.sql
2220 amcheck--1.1--1.2.sql
2221 amcheck--1.2--1.3.sql
2227 bool_plperl--1.0.sql
2229 bool_plperlu.control
2230 btree_gin--1.0--1.1.sql
2232 btree_gin--1.1--1.2.sql
2233 btree_gin--1.2--1.3.sql
2235 btree_gist--1.0--1.1.sql
2236 btree_gist--1.1--1.2.sql
2237 btree_gist--1.2--1.3.sql
2239 btree_gist--1.3--1.4.sql
2240 btree_gist--1.4--1.5.sql
2241 btree_gist--1.5--1.6.sql
2243 citext--1.0--1.1.sql
2244 citext--1.1--1.2.sql
2245 citext--1.2--1.3.sql
2246 citext--1.3--1.4.sql
2247 citext--1.4--1.5.sql
2249 citext--1.5--1.6.sql
2258 dblink--1.0--1.1.sql
2259 dblink--1.1--1.2.sql
2266 earthdistance--1.0--1.1.sql
2267 earthdistance--1.1.sql
2268 earthdistance.control
2271 fuzzystrmatch--1.0--1.1.sql
2272 fuzzystrmatch--1.1.sql
2273 fuzzystrmatch.control
2274 hstore--1.1--1.2.sql
2275 hstore--1.2--1.3.sql
2276 hstore--1.3--1.4.sql
2277 hstore--1.4--1.5.sql
2279 hstore--1.5--1.6.sql
2280 hstore--1.6--1.7.sql
2281 hstore--1.7--1.8.sql
2283 insert_username--1.0.sql
2284 insert_username.control
2285 intagg--1.0--1.1.sql
2288 intarray--1.0--1.1.sql
2289 intarray--1.1--1.2.sql
2290 intarray--1.2--1.3.sql
2292 intarray--1.3--1.4.sql
2293 intarray--1.4--1.5.sql
2306 moddatetime--1.0.sql
2308 old_snapshot--1.0.sql
2309 old_snapshot.control
2310 pageinspect--1.0--1.1.sql
2311 pageinspect--1.1--1.2.sql
2312 pageinspect--1.2--1.3.sql
2313 pageinspect--1.3--1.4.sql
2314 pageinspect--1.4--1.5.sql
2315 pageinspect--1.5--1.6.sql
2316 pageinspect--1.5.sql
2317 pageinspect--1.6--1.7.sql
2318 pageinspect--1.7--1.8.sql
2319 pageinspect--1.8--1.9.sql
2321 pg_buffercache--1.0--1.1.sql
2322 pg_buffercache--1.1--1.2.sql
2323 pg_buffercache--1.2--1.3.sql
2324 pg_buffercache--1.2.sql
2325 pg_buffercache.control
2326 pg_freespacemap--1.0--1.1.sql
2327 pg_freespacemap--1.1--1.2.sql
2328 pg_freespacemap--1.1.sql
2329 pg_freespacemap.control
2330 pg_prewarm--1.0--1.1.sql
2331 pg_prewarm--1.1--1.2.sql
2334 pg_stat_statements--1.0--1.1.sql
2335 pg_stat_statements--1.1--1.2.sql
2336 pg_stat_statements--1.2--1.3.sql
2337 pg_stat_statements--1.3--1.4.sql
2338 pg_stat_statements--1.4--1.5.sql
2339 pg_stat_statements--1.4.sql
2340 pg_stat_statements--1.5--1.6.sql
2341 pg_stat_statements--1.6--1.7.sql
2342 pg_stat_statements--1.7--1.8.sql
2343 pg_stat_statements--1.8--1.9.sql
2344 pg_stat_statements.control
2347 pg_trgm--1.0--1.1.sql
2348 pg_trgm--1.1--1.2.sql
2349 pg_trgm--1.2--1.3.sql
2350 pg_trgm--1.3--1.4.sql
2352 pg_trgm--1.4--1.5.sql
2353 pg_trgm--1.5--1.6.sql
2355 pg_visibility--1.0--1.1.sql
2356 pg_visibility--1.1--1.2.sql
2357 pg_visibility--1.1.sql
2358 pg_visibility.control
2359 pgcrypto--1.0--1.1.sql
2360 pgcrypto--1.1--1.2.sql
2361 pgcrypto--1.2--1.3.sql
2364 pgrowlocks--1.0--1.1.sql
2365 pgrowlocks--1.1--1.2.sql
2368 pgstattuple--1.0--1.1.sql
2369 pgstattuple--1.1--1.2.sql
2370 pgstattuple--1.2--1.3.sql
2371 pgstattuple--1.3--1.4.sql
2372 pgstattuple--1.4--1.5.sql
2373 pgstattuple--1.4.sql
2375 postgres_fdw--1.0--1.1.sql
2376 postgres_fdw--1.0.sql
2377 postgres_fdw.control
2386 sslinfo--1.0--1.1.sql
2387 sslinfo--1.1--1.2.sql
2394 tsm_system_rows--1.0.sql
2395 tsm_system_rows.control
2396 tsm_system_time--1.0.sql
2397 tsm_system_time.control
2398 unaccent--1.0--1.1.sql
2401 uuid-ossp--1.0--1.1.sql
2407 share/postgresql/tsearch_data/
2412 [FILE:510:manifests/plist.plperl]
2413 include/postgresql/server/
2418 bool_plperl.%%SHARED_OBJECT%%
2419 hstore_plperl.%%SHARED_OBJECT%%
2420 jsonb_plperl.%%SHARED_OBJECT%%
2421 plperl.%%SHARED_OBJECT%%
2422 share/postgresql/extension/
2423 bool_plperlu--1.0.sql
2424 hstore_plperl--1.0.sql
2425 hstore_plperl.control
2426 hstore_plperlu--1.0.sql
2427 hstore_plperlu.control
2428 jsonb_plperl--1.0.sql
2429 jsonb_plperl.control
2430 jsonb_plperlu--1.0.sql
2431 jsonb_plperlu.control
2438 [FILE:1092:manifests/plist.plpython]
2439 include/postgresql/server/
2449 plpy_subxactobject.h
2454 hstore_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2455 jsonb_plpython3.%%SHARED_OBJECT%%
2456 ltree_plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2457 plpython%%PYTHON_MAJOR_VER%%.%%SHARED_OBJECT%%
2458 lib/postgresql/pgxs/src/pl/plpython/regress-python3-mangle.mk
2459 share/postgresql/extension/
2460 hstore_plpython2u--1.0.sql
2461 hstore_plpython2u.control
2462 hstore_plpython3u--1.0.sql
2463 hstore_plpython3u.control
2464 hstore_plpythonu--1.0.sql
2465 hstore_plpythonu.control
2466 jsonb_plpython2u--1.0.sql
2467 jsonb_plpython2u.control
2468 jsonb_plpython3u--1.0.sql
2469 jsonb_plpython3u.control
2470 jsonb_plpythonu--1.0.sql
2471 jsonb_plpythonu.control
2472 ltree_plpython2u--1.0.sql
2473 ltree_plpython2u.control
2474 ltree_plpython3u--1.0.sql
2475 ltree_plpython3u.control
2476 ltree_plpythonu--1.0.sql
2477 ltree_plpythonu.control
2478 plpython%%PYTHON_MAJOR_VER%%u--1.0.sql
2479 plpython%%PYTHON_MAJOR_VER%%u.control
2482 [FILE:131:manifests/plist.pltcl]
2483 lib/postgresql/pltcl.%%SHARED_OBJECT%%
2484 share/postgresql/extension/
2491 [FILE:111:manifests/plist.docs]
2492 share/doc/postgresql/extension/
2494 insert_username.example
2499 [FILE:8541:manifests/plist.nls]
2500 share/locale/cs/LC_MESSAGES/
2502 ecpglib6-%%PGVER%%.mo
2505 pg_archivecleanup-%%PGVER%%.mo
2506 pg_basebackup-%%PGVER%%.mo
2507 pg_checksums-%%PGVER%%.mo
2508 pg_config-%%PGVER%%.mo
2509 pg_controldata-%%PGVER%%.mo
2511 pg_dump-%%PGVER%%.mo
2512 pg_resetwal-%%PGVER%%.mo
2513 pg_rewind-%%PGVER%%.mo
2514 pg_test_fsync-%%PGVER%%.mo
2515 pg_upgrade-%%PGVER%%.mo
2516 pg_waldump-%%PGVER%%.mo
2517 pgscripts-%%PGVER%%.mo
2519 plpgsql-%%PGVER%%.mo
2520 plpython-%%PGVER%%.mo
2523 share/locale/de/LC_MESSAGES/
2525 ecpglib6-%%PGVER%%.mo
2528 pg_amcheck-%%PGVER%%.mo
2529 pg_archivecleanup-%%PGVER%%.mo
2530 pg_basebackup-%%PGVER%%.mo
2531 pg_checksums-%%PGVER%%.mo
2532 pg_config-%%PGVER%%.mo
2533 pg_controldata-%%PGVER%%.mo
2535 pg_dump-%%PGVER%%.mo
2536 pg_resetwal-%%PGVER%%.mo
2537 pg_rewind-%%PGVER%%.mo
2538 pg_test_fsync-%%PGVER%%.mo
2539 pg_test_timing-%%PGVER%%.mo
2540 pg_upgrade-%%PGVER%%.mo
2541 pg_verifybackup-%%PGVER%%.mo
2542 pg_waldump-%%PGVER%%.mo
2543 pgscripts-%%PGVER%%.mo
2545 plpgsql-%%PGVER%%.mo
2546 plpython-%%PGVER%%.mo
2548 postgres-%%PGVER%%.mo
2550 share/locale/el/LC_MESSAGES/
2552 ecpglib6-%%PGVER%%.mo
2555 pg_amcheck-%%PGVER%%.mo
2556 pg_archivecleanup-%%PGVER%%.mo
2557 pg_basebackup-%%PGVER%%.mo
2558 pg_checksums-%%PGVER%%.mo
2559 pg_config-%%PGVER%%.mo
2560 pg_controldata-%%PGVER%%.mo
2562 pg_dump-%%PGVER%%.mo
2563 pg_resetwal-%%PGVER%%.mo
2564 pg_rewind-%%PGVER%%.mo
2565 pg_test_fsync-%%PGVER%%.mo
2566 pg_test_timing-%%PGVER%%.mo
2567 pg_verifybackup-%%PGVER%%.mo
2568 pg_waldump-%%PGVER%%.mo
2569 pgscripts-%%PGVER%%.mo
2571 plpgsql-%%PGVER%%.mo
2572 plpython-%%PGVER%%.mo
2575 share/locale/es/LC_MESSAGES/
2577 ecpglib6-%%PGVER%%.mo
2580 pg_amcheck-%%PGVER%%.mo
2581 pg_archivecleanup-%%PGVER%%.mo
2582 pg_basebackup-%%PGVER%%.mo
2583 pg_checksums-%%PGVER%%.mo
2584 pg_config-%%PGVER%%.mo
2585 pg_controldata-%%PGVER%%.mo
2587 pg_dump-%%PGVER%%.mo
2588 pg_resetwal-%%PGVER%%.mo
2589 pg_rewind-%%PGVER%%.mo
2590 pg_test_fsync-%%PGVER%%.mo
2591 pg_test_timing-%%PGVER%%.mo
2592 pg_upgrade-%%PGVER%%.mo
2593 pg_verifybackup-%%PGVER%%.mo
2594 pg_waldump-%%PGVER%%.mo
2595 pgscripts-%%PGVER%%.mo
2597 plpgsql-%%PGVER%%.mo
2598 plpython-%%PGVER%%.mo
2600 postgres-%%PGVER%%.mo
2602 share/locale/fr/LC_MESSAGES/
2604 ecpglib6-%%PGVER%%.mo
2607 pg_amcheck-%%PGVER%%.mo
2608 pg_archivecleanup-%%PGVER%%.mo
2609 pg_basebackup-%%PGVER%%.mo
2610 pg_checksums-%%PGVER%%.mo
2611 pg_config-%%PGVER%%.mo
2612 pg_controldata-%%PGVER%%.mo
2614 pg_dump-%%PGVER%%.mo
2615 pg_resetwal-%%PGVER%%.mo
2616 pg_rewind-%%PGVER%%.mo
2617 pg_test_fsync-%%PGVER%%.mo
2618 pg_test_timing-%%PGVER%%.mo
2619 pg_upgrade-%%PGVER%%.mo
2620 pg_verifybackup-%%PGVER%%.mo
2621 pg_waldump-%%PGVER%%.mo
2622 pgscripts-%%PGVER%%.mo
2624 plpgsql-%%PGVER%%.mo
2625 plpython-%%PGVER%%.mo
2627 postgres-%%PGVER%%.mo
2629 share/locale/he/LC_MESSAGES/pg_config-%%PGVER%%.mo
2630 share/locale/it/LC_MESSAGES/
2632 ecpglib6-%%PGVER%%.mo
2633 pg_config-%%PGVER%%.mo
2634 pg_controldata-%%PGVER%%.mo
2637 plpgsql-%%PGVER%%.mo
2638 plpython-%%PGVER%%.mo
2640 postgres-%%PGVER%%.mo
2642 share/locale/ja/LC_MESSAGES/
2644 ecpglib6-%%PGVER%%.mo
2647 pg_amcheck-%%PGVER%%.mo
2648 pg_archivecleanup-%%PGVER%%.mo
2649 pg_basebackup-%%PGVER%%.mo
2650 pg_checksums-%%PGVER%%.mo
2651 pg_config-%%PGVER%%.mo
2652 pg_controldata-%%PGVER%%.mo
2654 pg_dump-%%PGVER%%.mo
2655 pg_resetwal-%%PGVER%%.mo
2656 pg_rewind-%%PGVER%%.mo
2657 pg_test_fsync-%%PGVER%%.mo
2658 pg_test_timing-%%PGVER%%.mo
2659 pg_upgrade-%%PGVER%%.mo
2660 pg_verifybackup-%%PGVER%%.mo
2661 pg_waldump-%%PGVER%%.mo
2662 pgscripts-%%PGVER%%.mo
2664 plpgsql-%%PGVER%%.mo
2665 plpython-%%PGVER%%.mo
2667 postgres-%%PGVER%%.mo
2669 share/locale/ko/LC_MESSAGES/
2671 ecpglib6-%%PGVER%%.mo
2674 pg_archivecleanup-%%PGVER%%.mo
2675 pg_basebackup-%%PGVER%%.mo
2676 pg_checksums-%%PGVER%%.mo
2677 pg_config-%%PGVER%%.mo
2678 pg_controldata-%%PGVER%%.mo
2680 pg_dump-%%PGVER%%.mo
2681 pg_resetwal-%%PGVER%%.mo
2682 pg_test_fsync-%%PGVER%%.mo
2683 pg_upgrade-%%PGVER%%.mo
2684 pg_verifybackup-%%PGVER%%.mo
2685 pg_waldump-%%PGVER%%.mo
2686 pgscripts-%%PGVER%%.mo
2688 plpgsql-%%PGVER%%.mo
2689 plpython-%%PGVER%%.mo
2691 postgres-%%PGVER%%.mo
2693 share/locale/pl/LC_MESSAGES/
2695 ecpglib6-%%PGVER%%.mo
2696 pg_config-%%PGVER%%.mo
2697 pg_test_fsync-%%PGVER%%.mo
2699 plpgsql-%%PGVER%%.mo
2700 plpython-%%PGVER%%.mo
2702 share/locale/pt_BR/LC_MESSAGES/
2704 ecpglib6-%%PGVER%%.mo
2705 pg_config-%%PGVER%%.mo
2707 plpgsql-%%PGVER%%.mo
2708 plpython-%%PGVER%%.mo
2709 share/locale/ro/LC_MESSAGES/plperl-%%PGVER%%.mo
2710 share/locale/ru/LC_MESSAGES/
2712 ecpglib6-%%PGVER%%.mo
2715 pg_amcheck-%%PGVER%%.mo
2716 pg_archivecleanup-%%PGVER%%.mo
2717 pg_basebackup-%%PGVER%%.mo
2718 pg_checksums-%%PGVER%%.mo
2719 pg_config-%%PGVER%%.mo
2720 pg_controldata-%%PGVER%%.mo
2722 pg_dump-%%PGVER%%.mo
2723 pg_resetwal-%%PGVER%%.mo
2724 pg_rewind-%%PGVER%%.mo
2725 pg_test_fsync-%%PGVER%%.mo
2726 pg_test_timing-%%PGVER%%.mo
2727 pg_upgrade-%%PGVER%%.mo
2728 pg_verifybackup-%%PGVER%%.mo
2729 pg_waldump-%%PGVER%%.mo
2730 pgscripts-%%PGVER%%.mo
2732 plpgsql-%%PGVER%%.mo
2733 plpython-%%PGVER%%.mo
2735 postgres-%%PGVER%%.mo
2737 share/locale/sv/LC_MESSAGES/
2739 ecpglib6-%%PGVER%%.mo
2742 pg_amcheck-%%PGVER%%.mo
2743 pg_archivecleanup-%%PGVER%%.mo
2744 pg_basebackup-%%PGVER%%.mo
2745 pg_checksums-%%PGVER%%.mo
2746 pg_config-%%PGVER%%.mo
2747 pg_controldata-%%PGVER%%.mo
2749 pg_dump-%%PGVER%%.mo
2750 pg_resetwal-%%PGVER%%.mo
2751 pg_rewind-%%PGVER%%.mo
2752 pg_test_fsync-%%PGVER%%.mo
2753 pg_test_timing-%%PGVER%%.mo
2754 pg_upgrade-%%PGVER%%.mo
2755 pg_verifybackup-%%PGVER%%.mo
2756 pg_waldump-%%PGVER%%.mo
2757 pgscripts-%%PGVER%%.mo
2759 plpgsql-%%PGVER%%.mo
2760 plpython-%%PGVER%%.mo
2762 postgres-%%PGVER%%.mo
2764 share/locale/tr/LC_MESSAGES/
2766 ecpglib6-%%PGVER%%.mo
2768 pg_archivecleanup-%%PGVER%%.mo
2769 pg_basebackup-%%PGVER%%.mo
2770 pg_checksums-%%PGVER%%.mo
2771 pg_config-%%PGVER%%.mo
2772 pg_controldata-%%PGVER%%.mo
2774 pg_dump-%%PGVER%%.mo
2775 pg_resetwal-%%PGVER%%.mo
2776 pg_test_fsync-%%PGVER%%.mo
2777 pg_upgrade-%%PGVER%%.mo
2778 pg_waldump-%%PGVER%%.mo
2779 pgscripts-%%PGVER%%.mo
2781 plpgsql-%%PGVER%%.mo
2782 plpython-%%PGVER%%.mo
2785 share/locale/uk/LC_MESSAGES/
2787 ecpglib6-%%PGVER%%.mo
2790 pg_amcheck-%%PGVER%%.mo
2791 pg_archivecleanup-%%PGVER%%.mo
2792 pg_basebackup-%%PGVER%%.mo
2793 pg_checksums-%%PGVER%%.mo
2794 pg_config-%%PGVER%%.mo
2795 pg_controldata-%%PGVER%%.mo
2797 pg_dump-%%PGVER%%.mo
2798 pg_resetwal-%%PGVER%%.mo
2799 pg_rewind-%%PGVER%%.mo
2800 pg_test_fsync-%%PGVER%%.mo
2801 pg_test_timing-%%PGVER%%.mo
2802 pg_upgrade-%%PGVER%%.mo
2803 pg_verifybackup-%%PGVER%%.mo
2804 pg_waldump-%%PGVER%%.mo
2805 pgscripts-%%PGVER%%.mo
2807 plpgsql-%%PGVER%%.mo
2808 plpython-%%PGVER%%.mo
2810 postgres-%%PGVER%%.mo
2812 share/locale/vi/LC_MESSAGES/
2814 ecpglib6-%%PGVER%%.mo
2815 pg_config-%%PGVER%%.mo
2816 pg_test_fsync-%%PGVER%%.mo
2818 plpgsql-%%PGVER%%.mo
2819 plpython-%%PGVER%%.mo
2821 share/locale/zh_CN/LC_MESSAGES/
2823 ecpglib6-%%PGVER%%.mo
2826 pg_amcheck-%%PGVER%%.mo
2827 pg_archivecleanup-%%PGVER%%.mo
2828 pg_basebackup-%%PGVER%%.mo
2829 pg_checksums-%%PGVER%%.mo
2830 pg_config-%%PGVER%%.mo
2831 pg_controldata-%%PGVER%%.mo
2833 pg_dump-%%PGVER%%.mo
2834 pg_resetwal-%%PGVER%%.mo
2835 pg_rewind-%%PGVER%%.mo
2836 pg_test_fsync-%%PGVER%%.mo
2837 pg_test_timing-%%PGVER%%.mo
2838 pg_upgrade-%%PGVER%%.mo
2839 pg_verifybackup-%%PGVER%%.mo
2840 pg_waldump-%%PGVER%%.mo
2841 pgscripts-%%PGVER%%.mo
2843 plpgsql-%%PGVER%%.mo
2844 plpython-%%PGVER%%.mo
2846 postgres-%%PGVER%%.mo
2848 share/locale/zh_TW/LC_MESSAGES/ecpg-%%PGVER%%.mo
2851 [FILE:393:patches/patch-configure]
2852 --- configure.orig 2022-11-07 21:38:53 UTC
2854 @@ -12599,7 +12599,7 @@ if ac_fn_c_try_link "$LINENO"; then :
2855 # recognize dependent libraries; assume curses is needed if we didn't
2856 # find any dependency.
2858 - netbsd* | openbsd*)
2860 if test x"$pgac_lib" = x"" ; then
2861 pgac_lib=" -lcurses"
2865 [FILE:349:patches/patch-doc-Makefile]
2866 --- doc/Makefile.orig 2022-11-07 21:38:53 UTC
2868 @@ -12,5 +12,5 @@ subdir = doc
2870 include $(top_builddir)/src/Makefile.global
2872 -all distprep html man install installdirs uninstall clean distclean maintainer-clean:
2873 +all distprep man install installdirs uninstall clean distclean maintainer-clean:
2877 [FILE:1196:patches/patch-doc_src_sgml_Makefile]
2878 --- doc/src/sgml/Makefile.orig 2022-11-07 21:38:53 UTC
2879 +++ doc/src/sgml/Makefile
2882 # Make "html" the default target, since that is what most people tend
2887 # We don't need the tree-wide headers or install support here.
2888 NO_GENERATED_HEADERS=yes
2889 @@ -26,7 +26,7 @@ top_builddir = ../../..
2890 include $(top_builddir)/src/Makefile.global
2896 distprep: html distprep-man
2898 @@ -65,8 +65,6 @@ ALL_IMAGES := $(wildcard $(srcdir)/image
2902 -man distprep-man: man-stamp
2904 man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML)
2905 $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^)
2906 $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $(wordlist 1,2,$^)
2907 @@ -220,10 +218,10 @@ check: postgres.sgml $(ALLSGML) check-ta
2911 -install: install-html install-man
2912 +install: install-man
2915 - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2916 + $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2918 # If the install used a man directory shared with other applications, this will remove all files.
2922 [FILE:498:patches/patch-src-backend-Makefile]
2923 --- src/backend/Makefile.orig 2022-11-07 21:38:53 UTC
2924 +++ src/backend/Makefile
2925 @@ -116,6 +116,8 @@ endif # aix
2927 $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport
2929 +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
2932 # The postgres.o target is needed by the rule in Makefile.global that
2933 # creates the exports file when MAKE_EXPORTS = true.
2936 [FILE:863:patches/patch-src_Makefile.shlib]
2937 --- src/Makefile.shlib.orig 2022-11-07 21:38:53 UTC
2938 +++ src/Makefile.shlib
2939 @@ -166,6 +166,9 @@ ifeq ($(PORTNAME), freebsd)
2942 ifeq ($(PORTNAME), netbsd)
2943 + ifdef SO_MAJOR_VERSION
2944 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2946 LINK.shared = $(COMPILER) -shared
2948 LINK.shared += -Wl,-x,-soname,$(soname)
2949 @@ -212,6 +215,9 @@ endif
2951 ifeq ($(PORTNAME), linux)
2952 LINK.shared = $(COMPILER) -shared
2953 + ifdef SO_MAJOR_VERSION
2954 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2957 LINK.shared += -Wl,-soname,$(soname)
2959 @@ -223,6 +229,9 @@ ifeq ($(PORTNAME), linux)
2962 ifeq ($(PORTNAME), solaris)
2963 + ifdef SO_MAJOR_VERSION
2964 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2967 LINK.shared = $(COMPILER) -shared -Wl,-Bsymbolic
2971 [FILE:685:patches/patch-src_backend_utils_misc_postgresql.conf.sample]
2972 --- src/backend/utils/misc/postgresql.conf.sample.orig 2022-11-07 21:38:53 UTC
2973 +++ src/backend/utils/misc/postgresql.conf.sample
2978 +log_destination = 'syslog'
2979 #log_destination = 'stderr' # Valid values are combinations of
2980 # stderr, csvlog, syslog, and eventlog,
2981 # depending on platform. csvlog
2984 #cluster_name = '' # added to process titles if nonempty
2985 # (change requires restart)
2986 -#update_process_title = on
2988 +# On FreeBSD, this is a performance hog, so keep it off if you need speed
2989 +update_process_title = off
2992 #------------------------------------------------------------------------------
2995 [FILE:3090:files/502.pgsql.in]
2998 # Maintenance shell script to vacuum and backup database
2999 # Put this in /usr/local/etc/periodic/daily, and it will be run
3002 # Written by Palle Girgensohn <girgen@pingpong.net>
3004 # In public domain, do what you like with it,
3005 # and use it at your own risk... :)
3008 # Define these variables in either /etc/periodic.conf or
3009 # /etc/periodic.conf.local to override the default values.
3011 # daily_pgsql_backup_enable="YES" # do backup of all databases
3012 # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases
3013 # daily_pgsql_vacuum_enable="YES" # do vacuum
3015 # If there is a global system configuration file, suck it in.
3017 if [ -r /etc/defaults/periodic.conf ]
3019 . /etc/defaults/periodic.conf
3020 source_periodic_confs
3023 : ${daily_pgsql_user:="%%PG_USER%%"}
3024 : ${daily_pgsql_port:=5432}
3025 : ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"}
3026 : ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"}
3027 : ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"}
3028 # backupdir is relative to ~pgsql home directory unless it begins with a slash:
3029 : ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"}
3030 : ${daily_pgsql_savedays:="7"}
3032 # allow '~ยด in dir name
3033 eval backupdir=${daily_pgsql_backupdir}
3038 # daily_pgsql_backupdir must be writeable by user %%PG_USER%%
3039 # ~%%PG_USER%% is just that under normal circumstances,
3040 # but this might not be where you want the backups...
3041 if [ ! -d ${backupdir} ] ; then
3042 echo Creating ${backupdir}
3043 mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir}
3047 echo "PostgreSQL backups"
3052 now=`date "+%Y-%m-%dT%H:%M:%S"`
3053 file=${daily_pgsql_backupdir}/pgglobals_${now}
3054 su -l ${daily_pgsql_user} -c \
3055 "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz"
3060 file=${backupdir}/pgdump_${db}_${now}
3061 su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
3062 [ $? -gt 0 ] && rc=3
3066 if [ $rc -gt 0 ]; then
3068 echo "Errors were reported during backup."
3071 # cleaning up old data
3072 find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \
3073 -a -mtime +${daily_pgsql_savedays} -delete
3077 case "$daily_pgsql_backup_enable" in
3079 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\'"`
3080 pgsql_backup $dbnames
3090 pgsql_backup $daily_pgsql_backup_enable
3094 case "$daily_pgsql_vacuum_enable" in
3098 echo "PostgreSQL vacuum"
3099 su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}"
3103 echo "Errors were reported during vacuum."
3112 [FILE:3182:files/postgresql.in]
3115 # PROVIDE: postgresql
3119 # Add the following line to /etc/rc.conf to enable PostgreSQL:
3121 # postgresql_enable="YES"
3123 # postgresql_data="%%PREFIX%%/%%PG_USER%%/%%DATADIR%%"
3124 # postgresql_flags="-w -s -m fast"
3125 # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
3126 # postgresql_class="default"
3127 # postgresql_profiles=""
3129 # See %%PREFIX%%/share/doc/postgresql/README-server for more info
3131 # This scripts takes one of the following commands:
3133 # start stop restart reload status initdb
3135 # For postmaster startup options, edit ${postgresql_data}/postgresql.conf
3137 command=%%PREFIX%%/bin/pg_ctl
3141 load_rc_config postgresql
3144 postgresql_enable=${postgresql_enable:-"NO"}
3145 postgresql_flags=${postgresql_flags:-"-w -s -m fast"}
3146 postgresql_user=${postgresql_user:-"%%PG_USER%%"}
3147 eval postgresql_data=${postgresql_data:-"~${postgresql_user}/%%DATADIR%%"}
3148 postgresql_class=${postgresql_class:-"default"}
3149 postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"}
3152 rcvar=postgresql_enable
3153 extra_commands="reload initdb"
3155 start_cmd="postgresql_command start"
3156 stop_cmd="postgresql_command stop"
3157 restart_cmd="postgresql_command restart"
3158 reload_cmd="postgresql_command reload"
3159 status_cmd="postgresql_command status"
3161 initdb_cmd="postgresql_initdb"
3163 if [ -n "$2" ]; then
3165 if [ "x${postgresql_profiles}" != "x" ]; then
3166 eval postgresql_data="\${postgresql_${profile}_data:-}"
3167 if [ "x${postgresql_data}" = "x" ]; then
3168 echo "You must define a data directory (postgresql_${profile}_data)"
3171 eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}"
3172 eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}"
3173 eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}"
3174 eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}"
3177 if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then
3178 for profile in ${postgresql_profiles}; do
3179 eval _enable="\${postgresql_${profile}_enable}"
3180 case "x${_enable:-${postgresql_enable}}" in
3181 x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee])
3187 if test -z "$_enable"; then
3188 _var=postgresql_enable
3190 _var=postgresql_"${profile}"_enable
3193 "'${_enable:-${postgresql_enable}}'" \
3195 "Profile ${profile} skipped."
3199 echo "===> postgresql profile: ${profile}"
3200 %%PREFIX%%/etc/rc.d/postgresql $1 ${profile}
3202 if [ "0${retcode}" -ne 0 ]; then
3203 failed="${profile} (${retcode}) ${failed:-}"
3205 success="${profile} ${success:-}"
3212 command_args="-D ${postgresql_data} ${postgresql_flags}"
3214 postgresql_command()
3216 su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
3221 su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}"