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/v15.3
13 DISTFILE[1]= postgresql-15.3.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]= postgresql15:client:standard
53 libxslt:primary:standard
55 gettext:primary:standard
58 EXRUN[server]= postgresql15:client:standard
62 USERGROUP_SPKG= server
64 USES= bison gmake perl:build tcl:build ssl python:build
66 GNOME_COMPONENTS= libxml2
68 DISTNAME= postgresql-15.3
70 LICENSE= PostgreSQL:server
71 LICENSE_FILE= PostgreSQL:{{WRKSRC}}/COPYRIGHT
74 CPE_PRODUCT= postgresql
75 CPE_VENDOR= postgresql
76 FPC_EQUIVALENT= databases/postgresql15-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 ffc7d4891f00ffbf5c3f4eab7fbbced8460b8c0ee63c5a5167133b9e6599d932 22819107 postgresql/postgresql-15.3.tar.bz2
194 [FILE:8106:manifests/plist.server]
211 etc/periodic/daily/502.pgsql
214 basebackup_to_shell.so
223 latin2_and_win1250.so
239 utf8_and_iso8859_1.so
246 information_schema.sql
250 postgresql.conf.sample
254 share/postgresql/extension/
255 pg_walinspect--1.0.sql
256 pg_walinspect.control
259 share/postgresql/timezone/
305 share/postgresql/timezone/Africa/
360 share/postgresql/timezone/America/
503 share/postgresql/timezone/America/Argentina/
517 share/postgresql/timezone/America/Indiana/
526 share/postgresql/timezone/America/Kentucky/
529 share/postgresql/timezone/America/North_Dakota/
533 share/postgresql/timezone/Antarctica/
546 share/postgresql/timezone/Arctic/Longyearbyen
547 share/postgresql/timezone/Asia/
647 share/postgresql/timezone/Atlantic/
660 share/postgresql/timezone/Australia/
684 share/postgresql/timezone/Brazil/
689 share/postgresql/timezone/Canada/
698 share/postgresql/timezone/Chile/
701 share/postgresql/timezone/Etc/
737 share/postgresql/timezone/Europe/
802 share/postgresql/timezone/Indian/
814 share/postgresql/timezone/Mexico/
818 share/postgresql/timezone/Pacific/
863 share/postgresql/timezone/US/
876 share/postgresql/timezonesets/
890 share/postgresql/tsearch_data/
898 hunspell_sample.affix
899 hunspell_sample_long.affix
900 hunspell_sample_long.dict
901 hunspell_sample_num.affix
902 hunspell_sample_num.dict
917 [FILE:785:manifests/plist.client]
920 libecpg_compat.so.3.11
947 lib/postgresql/pgxs/config/
950 lib/postgresql/pgxs/src/
955 lib/postgresql/pgxs/src/makefiles/pgxs.mk
956 lib/postgresql/pgxs/src/test/isolation/
959 lib/postgresql/pgxs/src/test/regress/pg_regress
962 pg_service.conf.sample
964 system_constraints.sql
968 [FILE:5260:manifests/plist.contrib]
1001 pg_stat_statements.so
1020 share/postgresql/extension/
1021 adminpack--1.0--1.1.sql
1023 adminpack--1.1--2.0.sql
1024 adminpack--2.0--2.1.sql
1026 amcheck--1.0--1.1.sql
1028 amcheck--1.1--1.2.sql
1029 amcheck--1.2--1.3.sql
1035 bool_plperl--1.0.sql
1037 bool_plperlu.control
1038 btree_gin--1.0--1.1.sql
1040 btree_gin--1.1--1.2.sql
1041 btree_gin--1.2--1.3.sql
1043 btree_gist--1.0--1.1.sql
1044 btree_gist--1.1--1.2.sql
1045 btree_gist--1.2--1.3.sql
1047 btree_gist--1.3--1.4.sql
1048 btree_gist--1.4--1.5.sql
1049 btree_gist--1.5--1.6.sql
1050 btree_gist--1.6--1.7.sql
1052 citext--1.0--1.1.sql
1053 citext--1.1--1.2.sql
1054 citext--1.2--1.3.sql
1055 citext--1.3--1.4.sql
1056 citext--1.4--1.5.sql
1058 citext--1.5--1.6.sql
1067 dblink--1.0--1.1.sql
1068 dblink--1.1--1.2.sql
1075 earthdistance--1.0--1.1.sql
1076 earthdistance--1.1.sql
1077 earthdistance.control
1080 fuzzystrmatch--1.0--1.1.sql
1081 fuzzystrmatch--1.1.sql
1082 fuzzystrmatch.control
1083 hstore--1.1--1.2.sql
1084 hstore--1.2--1.3.sql
1085 hstore--1.3--1.4.sql
1086 hstore--1.4--1.5.sql
1088 hstore--1.5--1.6.sql
1089 hstore--1.6--1.7.sql
1090 hstore--1.7--1.8.sql
1092 insert_username--1.0.sql
1093 insert_username.control
1094 intagg--1.0--1.1.sql
1097 intarray--1.0--1.1.sql
1098 intarray--1.1--1.2.sql
1099 intarray--1.2--1.3.sql
1101 intarray--1.3--1.4.sql
1102 intarray--1.4--1.5.sql
1115 moddatetime--1.0.sql
1117 old_snapshot--1.0.sql
1118 old_snapshot.control
1119 pageinspect--1.0--1.1.sql
1120 pageinspect--1.1--1.2.sql
1121 pageinspect--1.10--1.11.sql
1122 pageinspect--1.2--1.3.sql
1123 pageinspect--1.3--1.4.sql
1124 pageinspect--1.4--1.5.sql
1125 pageinspect--1.5--1.6.sql
1126 pageinspect--1.5.sql
1127 pageinspect--1.6--1.7.sql
1128 pageinspect--1.7--1.8.sql
1129 pageinspect--1.8--1.9.sql
1130 pageinspect--1.9--1.10.sql
1132 pg_buffercache--1.0--1.1.sql
1133 pg_buffercache--1.1--1.2.sql
1134 pg_buffercache--1.2--1.3.sql
1135 pg_buffercache--1.2.sql
1136 pg_buffercache.control
1137 pg_freespacemap--1.0--1.1.sql
1138 pg_freespacemap--1.1--1.2.sql
1139 pg_freespacemap--1.1.sql
1140 pg_freespacemap.control
1141 pg_prewarm--1.0--1.1.sql
1142 pg_prewarm--1.1--1.2.sql
1145 pg_stat_statements--1.0--1.1.sql
1146 pg_stat_statements--1.1--1.2.sql
1147 pg_stat_statements--1.2--1.3.sql
1148 pg_stat_statements--1.3--1.4.sql
1149 pg_stat_statements--1.4--1.5.sql
1150 pg_stat_statements--1.4.sql
1151 pg_stat_statements--1.5--1.6.sql
1152 pg_stat_statements--1.6--1.7.sql
1153 pg_stat_statements--1.7--1.8.sql
1154 pg_stat_statements--1.8--1.9.sql
1155 pg_stat_statements--1.9--1.10.sql
1156 pg_stat_statements.control
1159 pg_trgm--1.0--1.1.sql
1160 pg_trgm--1.1--1.2.sql
1161 pg_trgm--1.2--1.3.sql
1162 pg_trgm--1.3--1.4.sql
1164 pg_trgm--1.4--1.5.sql
1165 pg_trgm--1.5--1.6.sql
1167 pg_visibility--1.0--1.1.sql
1168 pg_visibility--1.1--1.2.sql
1169 pg_visibility--1.1.sql
1170 pg_visibility.control
1171 pgcrypto--1.0--1.1.sql
1172 pgcrypto--1.1--1.2.sql
1173 pgcrypto--1.2--1.3.sql
1176 pgrowlocks--1.0--1.1.sql
1177 pgrowlocks--1.1--1.2.sql
1180 pgstattuple--1.0--1.1.sql
1181 pgstattuple--1.1--1.2.sql
1182 pgstattuple--1.2--1.3.sql
1183 pgstattuple--1.3--1.4.sql
1184 pgstattuple--1.4--1.5.sql
1185 pgstattuple--1.4.sql
1187 postgres_fdw--1.0--1.1.sql
1188 postgres_fdw--1.0.sql
1189 postgres_fdw.control
1198 sslinfo--1.0--1.1.sql
1199 sslinfo--1.1--1.2.sql
1206 tsm_system_rows--1.0.sql
1207 tsm_system_rows.control
1208 tsm_system_time--1.0.sql
1209 tsm_system_time.control
1210 unaccent--1.0--1.1.sql
1213 uuid-ossp--1.0--1.1.sql
1219 share/postgresql/tsearch_data/
1224 [FILE:385:manifests/plist.plperl]
1230 share/postgresql/extension/
1231 bool_plperlu--1.0.sql
1232 hstore_plperl--1.0.sql
1233 hstore_plperl.control
1234 hstore_plperlu--1.0.sql
1235 hstore_plperlu.control
1236 jsonb_plperl--1.0.sql
1237 jsonb_plperl.control
1238 jsonb_plperlu--1.0.sql
1239 jsonb_plperlu.control
1246 [FILE:416:manifests/plist.plpython]
1248 hstore_plpython%%PYTHON_MAJOR_VER%%.so
1250 ltree_plpython%%PYTHON_MAJOR_VER%%.so
1251 plpython%%PYTHON_MAJOR_VER%%.so
1252 share/postgresql/extension/
1253 hstore_plpython3u--1.0.sql
1254 hstore_plpython3u.control
1255 jsonb_plpython3u--1.0.sql
1256 jsonb_plpython3u.control
1257 ltree_plpython3u--1.0.sql
1258 ltree_plpython3u.control
1259 plpython%%PYTHON_MAJOR_VER%%u--1.0.sql
1260 plpython%%PYTHON_MAJOR_VER%%u.control
1263 [FILE:131:manifests/plist.pltcl]
1264 lib/postgresql/pltcl.%%SHARED_OBJECT%%
1265 share/postgresql/extension/
1272 [FILE:111:manifests/plist.docs]
1273 share/doc/postgresql/extension/
1275 insert_username.example
1280 [FILE:9336:manifests/plist.nls]
1281 share/locale/cs/LC_MESSAGES/
1283 ecpglib6-%%PGVER%%.mo
1285 pg_archivecleanup-%%PGVER%%.mo
1286 pg_config-%%PGVER%%.mo
1287 pg_controldata-%%PGVER%%.mo
1289 pg_dump-%%PGVER%%.mo
1290 pg_resetwal-%%PGVER%%.mo
1291 pg_upgrade-%%PGVER%%.mo
1292 pgscripts-%%PGVER%%.mo
1294 plpgsql-%%PGVER%%.mo
1295 plpython-%%PGVER%%.mo
1298 share/locale/de/LC_MESSAGES/
1300 ecpglib6-%%PGVER%%.mo
1303 pg_amcheck-%%PGVER%%.mo
1304 pg_archivecleanup-%%PGVER%%.mo
1305 pg_basebackup-%%PGVER%%.mo
1306 pg_checksums-%%PGVER%%.mo
1307 pg_config-%%PGVER%%.mo
1308 pg_controldata-%%PGVER%%.mo
1310 pg_dump-%%PGVER%%.mo
1311 pg_resetwal-%%PGVER%%.mo
1312 pg_rewind-%%PGVER%%.mo
1313 pg_test_fsync-%%PGVER%%.mo
1314 pg_test_timing-%%PGVER%%.mo
1315 pg_upgrade-%%PGVER%%.mo
1316 pg_verifybackup-%%PGVER%%.mo
1317 pg_waldump-%%PGVER%%.mo
1318 pgscripts-%%PGVER%%.mo
1320 plpgsql-%%PGVER%%.mo
1321 plpython-%%PGVER%%.mo
1323 postgres-%%PGVER%%.mo
1325 share/locale/el/LC_MESSAGES/
1327 ecpglib6-%%PGVER%%.mo
1330 pg_amcheck-%%PGVER%%.mo
1331 pg_archivecleanup-%%PGVER%%.mo
1332 pg_basebackup-%%PGVER%%.mo
1333 pg_checksums-%%PGVER%%.mo
1334 pg_config-%%PGVER%%.mo
1335 pg_controldata-%%PGVER%%.mo
1337 pg_dump-%%PGVER%%.mo
1338 pg_resetwal-%%PGVER%%.mo
1339 pg_rewind-%%PGVER%%.mo
1340 pg_test_fsync-%%PGVER%%.mo
1341 pg_test_timing-%%PGVER%%.mo
1342 pg_verifybackup-%%PGVER%%.mo
1343 pg_waldump-%%PGVER%%.mo
1344 pgscripts-%%PGVER%%.mo
1346 plpgsql-%%PGVER%%.mo
1347 plpython-%%PGVER%%.mo
1350 share/locale/es/LC_MESSAGES/
1352 ecpglib6-%%PGVER%%.mo
1355 pg_amcheck-%%PGVER%%.mo
1356 pg_archivecleanup-%%PGVER%%.mo
1357 pg_basebackup-%%PGVER%%.mo
1358 pg_checksums-%%PGVER%%.mo
1359 pg_config-%%PGVER%%.mo
1360 pg_controldata-%%PGVER%%.mo
1362 pg_dump-%%PGVER%%.mo
1363 pg_resetwal-%%PGVER%%.mo
1364 pg_rewind-%%PGVER%%.mo
1365 pg_test_fsync-%%PGVER%%.mo
1366 pg_test_timing-%%PGVER%%.mo
1367 pg_upgrade-%%PGVER%%.mo
1368 pg_verifybackup-%%PGVER%%.mo
1369 pg_waldump-%%PGVER%%.mo
1370 pgscripts-%%PGVER%%.mo
1372 plpgsql-%%PGVER%%.mo
1373 plpython-%%PGVER%%.mo
1375 postgres-%%PGVER%%.mo
1377 share/locale/fr/LC_MESSAGES/
1379 ecpglib6-%%PGVER%%.mo
1382 pg_amcheck-%%PGVER%%.mo
1383 pg_archivecleanup-%%PGVER%%.mo
1384 pg_basebackup-%%PGVER%%.mo
1385 pg_checksums-%%PGVER%%.mo
1386 pg_config-%%PGVER%%.mo
1387 pg_controldata-%%PGVER%%.mo
1389 pg_dump-%%PGVER%%.mo
1390 pg_resetwal-%%PGVER%%.mo
1391 pg_rewind-%%PGVER%%.mo
1392 pg_test_fsync-%%PGVER%%.mo
1393 pg_test_timing-%%PGVER%%.mo
1394 pg_upgrade-%%PGVER%%.mo
1395 pg_verifybackup-%%PGVER%%.mo
1396 pg_waldump-%%PGVER%%.mo
1397 pgscripts-%%PGVER%%.mo
1399 plpgsql-%%PGVER%%.mo
1400 plpython-%%PGVER%%.mo
1402 postgres-%%PGVER%%.mo
1404 share/locale/he/LC_MESSAGES/pg_config-%%PGVER%%.mo
1405 share/locale/it/LC_MESSAGES/
1407 ecpglib6-%%PGVER%%.mo
1410 pg_amcheck-%%PGVER%%.mo
1411 pg_archivecleanup-%%PGVER%%.mo
1412 pg_basebackup-%%PGVER%%.mo
1413 pg_checksums-%%PGVER%%.mo
1414 pg_config-%%PGVER%%.mo
1415 pg_controldata-%%PGVER%%.mo
1417 pg_dump-%%PGVER%%.mo
1418 pg_resetwal-%%PGVER%%.mo
1419 pg_rewind-%%PGVER%%.mo
1420 pg_test_fsync-%%PGVER%%.mo
1421 pg_test_timing-%%PGVER%%.mo
1422 pg_upgrade-%%PGVER%%.mo
1423 pg_verifybackup-%%PGVER%%.mo
1424 pg_waldump-%%PGVER%%.mo
1425 pgscripts-%%PGVER%%.mo
1427 plpgsql-%%PGVER%%.mo
1428 plpython-%%PGVER%%.mo
1430 postgres-%%PGVER%%.mo
1432 share/locale/ja/LC_MESSAGES/
1434 ecpglib6-%%PGVER%%.mo
1437 pg_amcheck-%%PGVER%%.mo
1438 pg_archivecleanup-%%PGVER%%.mo
1439 pg_basebackup-%%PGVER%%.mo
1440 pg_checksums-%%PGVER%%.mo
1441 pg_config-%%PGVER%%.mo
1442 pg_controldata-%%PGVER%%.mo
1444 pg_dump-%%PGVER%%.mo
1445 pg_resetwal-%%PGVER%%.mo
1446 pg_rewind-%%PGVER%%.mo
1447 pg_test_fsync-%%PGVER%%.mo
1448 pg_test_timing-%%PGVER%%.mo
1449 pg_upgrade-%%PGVER%%.mo
1450 pg_verifybackup-%%PGVER%%.mo
1451 pg_waldump-%%PGVER%%.mo
1452 pgscripts-%%PGVER%%.mo
1454 plpgsql-%%PGVER%%.mo
1455 plpython-%%PGVER%%.mo
1457 postgres-%%PGVER%%.mo
1459 share/locale/ka/LC_MESSAGES/
1461 ecpglib6-%%PGVER%%.mo
1464 pg_amcheck-%%PGVER%%.mo
1465 pg_archivecleanup-%%PGVER%%.mo
1466 pg_basebackup-%%PGVER%%.mo
1467 pg_checksums-%%PGVER%%.mo
1468 pg_config-%%PGVER%%.mo
1469 pg_controldata-%%PGVER%%.mo
1471 pg_dump-%%PGVER%%.mo
1472 pg_resetwal-%%PGVER%%.mo
1473 pg_rewind-%%PGVER%%.mo
1474 pg_test_fsync-%%PGVER%%.mo
1475 pg_test_timing-%%PGVER%%.mo
1476 pg_upgrade-%%PGVER%%.mo
1477 pg_verifybackup-%%PGVER%%.mo
1478 pg_waldump-%%PGVER%%.mo
1479 pgscripts-%%PGVER%%.mo
1481 plpgsql-%%PGVER%%.mo
1482 plpython-%%PGVER%%.mo
1485 share/locale/ko/LC_MESSAGES/
1487 ecpglib6-%%PGVER%%.mo
1490 pg_amcheck-%%PGVER%%.mo
1491 pg_archivecleanup-%%PGVER%%.mo
1492 pg_basebackup-%%PGVER%%.mo
1493 pg_checksums-%%PGVER%%.mo
1494 pg_config-%%PGVER%%.mo
1495 pg_controldata-%%PGVER%%.mo
1497 pg_dump-%%PGVER%%.mo
1498 pg_resetwal-%%PGVER%%.mo
1499 pg_rewind-%%PGVER%%.mo
1500 pg_test_fsync-%%PGVER%%.mo
1501 pg_test_timing-%%PGVER%%.mo
1502 pg_upgrade-%%PGVER%%.mo
1503 pg_verifybackup-%%PGVER%%.mo
1504 pg_waldump-%%PGVER%%.mo
1505 pgscripts-%%PGVER%%.mo
1507 plpgsql-%%PGVER%%.mo
1508 plpython-%%PGVER%%.mo
1510 postgres-%%PGVER%%.mo
1512 share/locale/pl/LC_MESSAGES/
1514 ecpglib6-%%PGVER%%.mo
1515 pg_config-%%PGVER%%.mo
1517 plpgsql-%%PGVER%%.mo
1518 plpython-%%PGVER%%.mo
1520 share/locale/pt_BR/LC_MESSAGES/
1522 ecpglib6-%%PGVER%%.mo
1524 pg_archivecleanup-%%PGVER%%.mo
1525 pg_checksums-%%PGVER%%.mo
1526 pg_config-%%PGVER%%.mo
1527 pg_controldata-%%PGVER%%.mo
1529 pg_resetwal-%%PGVER%%.mo
1530 pg_test_fsync-%%PGVER%%.mo
1531 pg_test_timing-%%PGVER%%.mo
1532 pgscripts-%%PGVER%%.mo
1534 plpgsql-%%PGVER%%.mo
1535 plpython-%%PGVER%%.mo
1537 share/locale/ru/LC_MESSAGES/
1539 ecpglib6-%%PGVER%%.mo
1542 pg_amcheck-%%PGVER%%.mo
1543 pg_archivecleanup-%%PGVER%%.mo
1544 pg_basebackup-%%PGVER%%.mo
1545 pg_checksums-%%PGVER%%.mo
1546 pg_config-%%PGVER%%.mo
1547 pg_controldata-%%PGVER%%.mo
1549 pg_dump-%%PGVER%%.mo
1550 pg_resetwal-%%PGVER%%.mo
1551 pg_rewind-%%PGVER%%.mo
1552 pg_test_fsync-%%PGVER%%.mo
1553 pg_test_timing-%%PGVER%%.mo
1554 pg_upgrade-%%PGVER%%.mo
1555 pg_verifybackup-%%PGVER%%.mo
1556 pg_waldump-%%PGVER%%.mo
1557 pgscripts-%%PGVER%%.mo
1559 plpgsql-%%PGVER%%.mo
1560 plpython-%%PGVER%%.mo
1562 postgres-%%PGVER%%.mo
1564 share/locale/sv/LC_MESSAGES/
1566 ecpglib6-%%PGVER%%.mo
1569 pg_amcheck-%%PGVER%%.mo
1570 pg_archivecleanup-%%PGVER%%.mo
1571 pg_basebackup-%%PGVER%%.mo
1572 pg_checksums-%%PGVER%%.mo
1573 pg_config-%%PGVER%%.mo
1574 pg_controldata-%%PGVER%%.mo
1576 pg_dump-%%PGVER%%.mo
1577 pg_resetwal-%%PGVER%%.mo
1578 pg_rewind-%%PGVER%%.mo
1579 pg_test_fsync-%%PGVER%%.mo
1580 pg_test_timing-%%PGVER%%.mo
1581 pg_upgrade-%%PGVER%%.mo
1582 pg_verifybackup-%%PGVER%%.mo
1583 pg_waldump-%%PGVER%%.mo
1584 pgscripts-%%PGVER%%.mo
1586 plpgsql-%%PGVER%%.mo
1587 plpython-%%PGVER%%.mo
1589 postgres-%%PGVER%%.mo
1591 share/locale/tr/LC_MESSAGES/
1593 ecpglib6-%%PGVER%%.mo
1594 pg_archivecleanup-%%PGVER%%.mo
1595 pg_config-%%PGVER%%.mo
1596 pg_controldata-%%PGVER%%.mo
1598 pg_dump-%%PGVER%%.mo
1599 pgscripts-%%PGVER%%.mo
1601 plpgsql-%%PGVER%%.mo
1602 plpython-%%PGVER%%.mo
1604 share/locale/uk/LC_MESSAGES/
1606 ecpglib6-%%PGVER%%.mo
1609 pg_amcheck-%%PGVER%%.mo
1610 pg_archivecleanup-%%PGVER%%.mo
1611 pg_basebackup-%%PGVER%%.mo
1612 pg_checksums-%%PGVER%%.mo
1613 pg_config-%%PGVER%%.mo
1614 pg_controldata-%%PGVER%%.mo
1616 pg_dump-%%PGVER%%.mo
1617 pg_resetwal-%%PGVER%%.mo
1618 pg_rewind-%%PGVER%%.mo
1619 pg_test_fsync-%%PGVER%%.mo
1620 pg_test_timing-%%PGVER%%.mo
1621 pg_upgrade-%%PGVER%%.mo
1622 pg_verifybackup-%%PGVER%%.mo
1623 pg_waldump-%%PGVER%%.mo
1624 pgscripts-%%PGVER%%.mo
1626 plpgsql-%%PGVER%%.mo
1627 plpython-%%PGVER%%.mo
1629 postgres-%%PGVER%%.mo
1631 share/locale/vi/LC_MESSAGES/
1633 ecpglib6-%%PGVER%%.mo
1634 pg_config-%%PGVER%%.mo
1636 plpgsql-%%PGVER%%.mo
1637 plpython-%%PGVER%%.mo
1639 share/locale/zh_CN/LC_MESSAGES/
1641 ecpglib6-%%PGVER%%.mo
1644 pg_amcheck-%%PGVER%%.mo
1645 pg_archivecleanup-%%PGVER%%.mo
1646 pg_config-%%PGVER%%.mo
1647 pg_controldata-%%PGVER%%.mo
1649 pg_dump-%%PGVER%%.mo
1650 pg_resetwal-%%PGVER%%.mo
1651 pg_rewind-%%PGVER%%.mo
1652 pg_test_timing-%%PGVER%%.mo
1653 pg_upgrade-%%PGVER%%.mo
1654 pg_verifybackup-%%PGVER%%.mo
1655 pgscripts-%%PGVER%%.mo
1657 plpgsql-%%PGVER%%.mo
1658 plpython-%%PGVER%%.mo
1660 postgres-%%PGVER%%.mo
1662 share/locale/zh_TW/LC_MESSAGES/ecpg-%%PGVER%%.mo
1665 [FILE:6199:manifests/plist.man]
1676 pg_archivecleanup.1.gz
1693 pg_verifybackup.1.gz
1704 SPI_commit_and_chain.3.gz
1706 SPI_connect_ext.3.gz
1708 SPI_cursor_close.3.gz
1709 SPI_cursor_fetch.3.gz
1710 SPI_cursor_find.3.gz
1711 SPI_cursor_move.3.gz
1712 SPI_cursor_open.3.gz
1713 SPI_cursor_open_with_args.3.gz
1714 SPI_cursor_open_with_paramlist.3.gz
1715 SPI_cursor_parse_open.3.gz
1719 SPI_execute_extended.3.gz
1720 SPI_execute_plan.3.gz
1721 SPI_execute_plan_extended.3.gz
1722 SPI_execute_plan_with_paramlist.3.gz
1723 SPI_execute_with_args.3.gz
1729 SPI_freetuptable.3.gz
1730 SPI_getargcount.3.gz
1731 SPI_getargtypeid.3.gz
1738 SPI_is_cursor_plan.3.gz
1740 SPI_modifytuple.3.gz
1744 SPI_prepare_cursor.3.gz
1745 SPI_prepare_extended.3.gz
1746 SPI_prepare_params.3.gz
1747 SPI_register_relation.3.gz
1748 SPI_register_trigger_data.3.gz
1750 SPI_result_code_string.3.gz
1751 SPI_returntuple.3.gz
1753 SPI_rollback_and_chain.3.gz
1755 SPI_scroll_cursor_fetch.3.gz
1756 SPI_scroll_cursor_move.3.gz
1757 SPI_start_transaction.3.gz
1758 SPI_unregister_relation.3.gz
1760 dblink_build_sql_delete.3.gz
1761 dblink_build_sql_insert.3.gz
1762 dblink_build_sql_update.3.gz
1763 dblink_cancel_query.3.gz
1766 dblink_connect_u.3.gz
1767 dblink_disconnect.3.gz
1768 dblink_error_message.3.gz
1771 dblink_get_connections.3.gz
1772 dblink_get_notify.3.gz
1773 dblink_get_pkey.3.gz
1774 dblink_get_result.3.gz
1777 dblink_send_query.3.gz
1780 ALTER_AGGREGATE.7.gz
1781 ALTER_COLLATION.7.gz
1782 ALTER_CONVERSION.7.gz
1784 ALTER_DEFAULT_PRIVILEGES.7.gz
1786 ALTER_EVENT_TRIGGER.7.gz
1787 ALTER_EXTENSION.7.gz
1788 ALTER_FOREIGN_DATA_WRAPPER.7.gz
1789 ALTER_FOREIGN_TABLE.7.gz
1794 ALTER_LARGE_OBJECT.7.gz
1795 ALTER_MATERIALIZED_VIEW.7.gz
1797 ALTER_OPERATOR_CLASS.7.gz
1798 ALTER_OPERATOR_FAMILY.7.gz
1800 ALTER_PROCEDURE.7.gz
1801 ALTER_PUBLICATION.7.gz
1808 ALTER_STATISTICS.7.gz
1809 ALTER_SUBSCRIPTION.7.gz
1812 ALTER_TABLESPACE.7.gz
1813 ALTER_TEXT_SEARCH_CONFIGURATION.7.gz
1814 ALTER_TEXT_SEARCH_DICTIONARY.7.gz
1815 ALTER_TEXT_SEARCH_PARSER.7.gz
1816 ALTER_TEXT_SEARCH_TEMPLATE.7.gz
1820 ALTER_USER_MAPPING.7.gz
1830 COMMIT_PREPARED.7.gz
1832 CREATE_ACCESS_METHOD.7.gz
1833 CREATE_AGGREGATE.7.gz
1835 CREATE_COLLATION.7.gz
1836 CREATE_CONVERSION.7.gz
1837 CREATE_DATABASE.7.gz
1839 CREATE_EVENT_TRIGGER.7.gz
1840 CREATE_EXTENSION.7.gz
1841 CREATE_FOREIGN_DATA_WRAPPER.7.gz
1842 CREATE_FOREIGN_TABLE.7.gz
1843 CREATE_FUNCTION.7.gz
1846 CREATE_LANGUAGE.7.gz
1847 CREATE_MATERIALIZED_VIEW.7.gz
1848 CREATE_OPERATOR.7.gz
1849 CREATE_OPERATOR_CLASS.7.gz
1850 CREATE_OPERATOR_FAMILY.7.gz
1852 CREATE_PROCEDURE.7.gz
1853 CREATE_PUBLICATION.7.gz
1857 CREATE_SEQUENCE.7.gz
1859 CREATE_STATISTICS.7.gz
1860 CREATE_SUBSCRIPTION.7.gz
1862 CREATE_TABLESPACE.7.gz
1863 CREATE_TABLE_AS.7.gz
1864 CREATE_TEXT_SEARCH_CONFIGURATION.7.gz
1865 CREATE_TEXT_SEARCH_DICTIONARY.7.gz
1866 CREATE_TEXT_SEARCH_PARSER.7.gz
1867 CREATE_TEXT_SEARCH_TEMPLATE.7.gz
1868 CREATE_TRANSFORM.7.gz
1872 CREATE_USER_MAPPING.7.gz
1879 DROP_ACCESS_METHOD.7.gz
1883 DROP_CONVERSION.7.gz
1886 DROP_EVENT_TRIGGER.7.gz
1888 DROP_FOREIGN_DATA_WRAPPER.7.gz
1889 DROP_FOREIGN_TABLE.7.gz
1894 DROP_MATERIALIZED_VIEW.7.gz
1896 DROP_OPERATOR_CLASS.7.gz
1897 DROP_OPERATOR_FAMILY.7.gz
1901 DROP_PUBLICATION.7.gz
1908 DROP_STATISTICS.7.gz
1909 DROP_SUBSCRIPTION.7.gz
1911 DROP_TABLESPACE.7.gz
1912 DROP_TEXT_SEARCH_CONFIGURATION.7.gz
1913 DROP_TEXT_SEARCH_DICTIONARY.7.gz
1914 DROP_TEXT_SEARCH_PARSER.7.gz
1915 DROP_TEXT_SEARCH_TEMPLATE.7.gz
1920 DROP_USER_MAPPING.7.gz
1927 IMPORT_FOREIGN_SCHEMA.7.gz
1936 PREPARE_TRANSACTION.7.gz
1938 REFRESH_MATERIALIZED_VIEW.7.gz
1940 RELEASE_SAVEPOINT.7.gz
1944 ROLLBACK_PREPARED.7.gz
1945 ROLLBACK_TO_SAVEPOINT.7.gz
1951 SET_CONSTRAINTS.7.gz
1953 SET_SESSION_AUTHORIZATION.7.gz
1954 SET_TRANSACTION.7.gz
1956 START_TRANSACTION.7.gz
1966 [FILE:14552:manifests/plist.dev]
1991 include/libpq/libpq-fs.h
1992 include/postgresql/informix/esql/
1996 include/postgresql/internal/
2003 include/postgresql/internal/libpq/pqcomm.h
2004 include/postgresql/server/
2032 plpy_subxactobject.h
2043 include/postgresql/server/access/
2130 include/postgresql/server/bootstrap/bootstrap.h
2131 include/postgresql/server/catalog/
2173 pg_db_role_setting.h
2174 pg_db_role_setting_d.h
2184 pg_event_trigger_d.h
2187 pg_foreign_data_wrapper.h
2188 pg_foreign_data_wrapper_d.h
2190 pg_foreign_server_d.h
2192 pg_foreign_table_d.h
2203 pg_largeobject_metadata.h
2204 pg_largeobject_metadata_d.h
2214 pg_parameter_acl_d.h
2215 pg_partitioned_table.h
2216 pg_partitioned_table_d.h
2223 pg_publication_namespace.h
2224 pg_publication_namespace_d.h
2225 pg_publication_rel.h
2226 pg_publication_rel_d.h
2229 pg_replication_origin.h
2230 pg_replication_origin_d.h
2240 pg_shdescription_d.h
2246 pg_statistic_ext_d.h
2247 pg_statistic_ext_data.h
2248 pg_statistic_ext_data_d.h
2251 pg_subscription_rel.h
2252 pg_subscription_rel_d.h
2262 pg_ts_config_map_d.h
2278 include/postgresql/server/commands/
2315 include/postgresql/server/common/
2349 unicode_combining_table.h
2350 unicode_east_asian_fw_table.h
2352 unicode_norm_hashfunc.h
2353 unicode_norm_table.h
2354 unicode_normprops_table.h
2356 include/postgresql/server/datatype/timestamp.h
2357 include/postgresql/server/executor/
2371 nodeBitmapHeapscan.h
2372 nodeBitmapIndexscan.h
2383 nodeIncrementalSort.h
2393 nodeNamedtuplestorescan.h
2396 nodeRecursiveunion.h
2417 include/postgresql/server/extension/cube/cubedata.h
2418 include/postgresql/server/extension/hstore/hstore.h
2419 include/postgresql/server/extension/isn/isn.h
2420 include/postgresql/server/extension/ltree/ltree.h
2421 include/postgresql/server/extension/seg/segdata.h
2422 include/postgresql/server/fe_utils/
2437 include/postgresql/server/foreign/
2440 include/postgresql/server/jit/
2444 include/postgresql/server/lib/
2459 include/postgresql/server/libpq/
2475 include/postgresql/server/mb/
2478 include/postgresql/server/nodes/
2500 include/postgresql/server/optimizer/
2511 geqo_recombination.h
2528 include/postgresql/server/parser/
2553 include/postgresql/server/partitioning/
2558 include/postgresql/server/port/
2577 include/postgresql/server/port/atomics/
2589 include/postgresql/server/port/win32/
2594 include/postgresql/server/port/win32/arpa/inet.h
2595 include/postgresql/server/port/win32/netinet/in.h
2596 include/postgresql/server/port/win32/sys/
2599 include/postgresql/server/port/win32_msvc/
2603 include/postgresql/server/port/win32_msvc/sys/
2607 include/postgresql/server/portability/
2610 include/postgresql/server/postmaster/
2614 bgworker_internals.h
2623 include/postgresql/server/regex/
2629 include/postgresql/server/replication/
2648 include/postgresql/server/rewrite/
2654 rewriteSearchCycle.h
2657 include/postgresql/server/snowball/header.h
2658 include/postgresql/server/snowball/libstemmer/
2661 stem_ISO_8859_1_basque.h
2662 stem_ISO_8859_1_catalan.h
2663 stem_ISO_8859_1_danish.h
2664 stem_ISO_8859_1_dutch.h
2665 stem_ISO_8859_1_english.h
2666 stem_ISO_8859_1_finnish.h
2667 stem_ISO_8859_1_french.h
2668 stem_ISO_8859_1_german.h
2669 stem_ISO_8859_1_indonesian.h
2670 stem_ISO_8859_1_irish.h
2671 stem_ISO_8859_1_italian.h
2672 stem_ISO_8859_1_norwegian.h
2673 stem_ISO_8859_1_porter.h
2674 stem_ISO_8859_1_portuguese.h
2675 stem_ISO_8859_1_spanish.h
2676 stem_ISO_8859_1_swedish.h
2677 stem_ISO_8859_2_hungarian.h
2678 stem_ISO_8859_2_romanian.h
2679 stem_KOI8_R_russian.h
2681 stem_UTF_8_armenian.h
2683 stem_UTF_8_catalan.h
2686 stem_UTF_8_english.h
2687 stem_UTF_8_finnish.h
2692 stem_UTF_8_hungarian.h
2693 stem_UTF_8_indonesian.h
2695 stem_UTF_8_italian.h
2696 stem_UTF_8_lithuanian.h
2698 stem_UTF_8_norwegian.h
2700 stem_UTF_8_portuguese.h
2701 stem_UTF_8_romanian.h
2702 stem_UTF_8_russian.h
2703 stem_UTF_8_serbian.h
2704 stem_UTF_8_spanish.h
2705 stem_UTF_8_swedish.h
2707 stem_UTF_8_turkish.h
2708 stem_UTF_8_yiddish.h
2709 include/postgresql/server/statistics/
2710 extended_stats_internal.h
2712 include/postgresql/server/storage/
2723 condition_variable.h
2749 predicate_internals.h
2769 include/postgresql/server/tcop/
2778 include/postgresql/server/tsearch/
2784 include/postgresql/server/tsearch/dicts/
2787 include/postgresql/server/utils/
2903 [FILE:393:patches/patch-configure]
2904 --- configure.orig 2023-05-08 21:13:20 UTC
2906 @@ -12767,7 +12767,7 @@ if ac_fn_c_try_link "$LINENO"; then :
2907 # recognize dependent libraries; assume curses is needed if we didn't
2908 # find any dependency.
2910 - netbsd* | openbsd*)
2912 if test x"$pgac_lib" = x"" ; then
2913 pgac_lib=" -lcurses"
2917 [FILE:349:patches/patch-doc-Makefile]
2918 --- doc/Makefile.orig 2023-05-08 21:13:20 UTC
2920 @@ -12,5 +12,5 @@ subdir = doc
2922 include $(top_builddir)/src/Makefile.global
2924 -all distprep html man install installdirs uninstall clean distclean maintainer-clean:
2925 +all distprep man install installdirs uninstall clean distclean maintainer-clean:
2929 [FILE:1196:patches/patch-doc_src_sgml_Makefile]
2930 --- doc/src/sgml/Makefile.orig 2023-05-08 21:13:20 UTC
2931 +++ doc/src/sgml/Makefile
2934 # Make "html" the default target, since that is what most people tend
2939 # We don't need the tree-wide headers or install support here.
2940 NO_GENERATED_HEADERS=yes
2941 @@ -26,7 +26,7 @@ top_builddir = ../../..
2942 include $(top_builddir)/src/Makefile.global
2948 distprep: html distprep-man
2950 @@ -69,8 +69,6 @@ ALL_IMAGES := $(wildcard $(srcdir)/image
2954 -man distprep-man: man-stamp
2956 man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML)
2957 $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^)
2958 $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $(wordlist 1,2,$^)
2959 @@ -224,10 +222,10 @@ check: postgres.sgml $(ALLSGML) check-ta
2963 -install: install-html install-man
2964 +install: install-man
2967 - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2968 + $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
2970 # If the install used a man directory shared with other applications, this will remove all files.
2974 [FILE:498:patches/patch-src-backend-Makefile]
2975 --- src/backend/Makefile.orig 2023-05-08 21:13:20 UTC
2976 +++ src/backend/Makefile
2977 @@ -117,6 +117,8 @@ endif # aix
2979 $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport
2981 +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
2984 # The postgres.o target is needed by the rule in Makefile.global that
2985 # creates the exports file when MAKE_EXPORTS = true.
2988 [FILE:863:patches/patch-src_Makefile.shlib]
2989 --- src/Makefile.shlib.orig 2023-05-08 21:13:20 UTC
2990 +++ src/Makefile.shlib
2991 @@ -166,6 +166,9 @@ ifeq ($(PORTNAME), freebsd)
2994 ifeq ($(PORTNAME), netbsd)
2995 + ifdef SO_MAJOR_VERSION
2996 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
2998 LINK.shared = $(COMPILER) -shared
3000 LINK.shared += -Wl,-x,-soname,$(soname)
3001 @@ -212,6 +215,9 @@ endif
3003 ifeq ($(PORTNAME), linux)
3004 LINK.shared = $(COMPILER) -shared
3005 + ifdef SO_MAJOR_VERSION
3006 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
3009 LINK.shared += -Wl,-soname,$(soname)
3011 @@ -223,6 +229,9 @@ ifeq ($(PORTNAME), linux)
3014 ifeq ($(PORTNAME), solaris)
3015 + ifdef SO_MAJOR_VERSION
3016 + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
3019 LINK.shared = $(COMPILER) -shared -Wl,-Bsymbolic
3023 [FILE:686:patches/patch-src_backend_utils_misc_postgresql.conf.sample]
3024 --- src/backend/utils/misc/postgresql.conf.sample.orig 2023-05-08 21:13:20 UTC
3025 +++ src/backend/utils/misc/postgresql.conf.sample
3030 +log_destination = 'syslog'
3031 #log_destination = 'stderr' # Valid values are combinations of
3032 # stderr, csvlog, jsonlog, syslog, and
3033 # eventlog, depending on platform.
3036 #cluster_name = '' # added to process titles if nonempty
3037 # (change requires restart)
3038 -#update_process_title = on
3040 +# On FreeBSD, this is a performance hog, so keep it off if you need speed
3041 +update_process_title = off
3044 #------------------------------------------------------------------------------
3047 [FILE:3090:files/502.pgsql.in]
3050 # Maintenance shell script to vacuum and backup database
3051 # Put this in /usr/local/etc/periodic/daily, and it will be run
3054 # Written by Palle Girgensohn <girgen@pingpong.net>
3056 # In public domain, do what you like with it,
3057 # and use it at your own risk... :)
3060 # Define these variables in either /etc/periodic.conf or
3061 # /etc/periodic.conf.local to override the default values.
3063 # daily_pgsql_backup_enable="YES" # do backup of all databases
3064 # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases
3065 # daily_pgsql_vacuum_enable="YES" # do vacuum
3067 # If there is a global system configuration file, suck it in.
3069 if [ -r /etc/defaults/periodic.conf ]
3071 . /etc/defaults/periodic.conf
3072 source_periodic_confs
3075 : ${daily_pgsql_user:="%%PG_USER%%"}
3076 : ${daily_pgsql_port:=5432}
3077 : ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"}
3078 : ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"}
3079 : ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"}
3080 # backupdir is relative to ~pgsql home directory unless it begins with a slash:
3081 : ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"}
3082 : ${daily_pgsql_savedays:="7"}
3084 # allow '~ยด in dir name
3085 eval backupdir=${daily_pgsql_backupdir}
3090 # daily_pgsql_backupdir must be writeable by user %%PG_USER%%
3091 # ~%%PG_USER%% is just that under normal circumstances,
3092 # but this might not be where you want the backups...
3093 if [ ! -d ${backupdir} ] ; then
3094 echo Creating ${backupdir}
3095 mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir}
3099 echo "PostgreSQL backups"
3104 now=`date "+%Y-%m-%dT%H:%M:%S"`
3105 file=${daily_pgsql_backupdir}/pgglobals_${now}
3106 su -l ${daily_pgsql_user} -c \
3107 "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz"
3112 file=${backupdir}/pgdump_${db}_${now}
3113 su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
3114 [ $? -gt 0 ] && rc=3
3118 if [ $rc -gt 0 ]; then
3120 echo "Errors were reported during backup."
3123 # cleaning up old data
3124 find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \
3125 -a -mtime +${daily_pgsql_savedays} -delete
3129 case "$daily_pgsql_backup_enable" in
3131 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\'"`
3132 pgsql_backup $dbnames
3142 pgsql_backup $daily_pgsql_backup_enable
3146 case "$daily_pgsql_vacuum_enable" in
3150 echo "PostgreSQL vacuum"
3151 su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}"
3155 echo "Errors were reported during vacuum."
3164 [FILE:3182:files/postgresql.in]
3167 # PROVIDE: postgresql
3171 # Add the following line to /etc/rc.conf to enable PostgreSQL:
3173 # postgresql_enable="YES"
3175 # postgresql_data="%%PREFIX%%/%%PG_USER%%/%%DATADIR%%"
3176 # postgresql_flags="-w -s -m fast"
3177 # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
3178 # postgresql_class="default"
3179 # postgresql_profiles=""
3181 # See %%PREFIX%%/share/doc/postgresql/README-server for more info
3183 # This scripts takes one of the following commands:
3185 # start stop restart reload status initdb
3187 # For postmaster startup options, edit ${postgresql_data}/postgresql.conf
3189 command=%%PREFIX%%/bin/pg_ctl
3193 load_rc_config postgresql
3196 postgresql_enable=${postgresql_enable:-"NO"}
3197 postgresql_flags=${postgresql_flags:-"-w -s -m fast"}
3198 postgresql_user=${postgresql_user:-"%%PG_USER%%"}
3199 eval postgresql_data=${postgresql_data:-"~${postgresql_user}/%%DATADIR%%"}
3200 postgresql_class=${postgresql_class:-"default"}
3201 postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"}
3204 rcvar=postgresql_enable
3205 extra_commands="reload initdb"
3207 start_cmd="postgresql_command start"
3208 stop_cmd="postgresql_command stop"
3209 restart_cmd="postgresql_command restart"
3210 reload_cmd="postgresql_command reload"
3211 status_cmd="postgresql_command status"
3213 initdb_cmd="postgresql_initdb"
3215 if [ -n "$2" ]; then
3217 if [ "x${postgresql_profiles}" != "x" ]; then
3218 eval postgresql_data="\${postgresql_${profile}_data:-}"
3219 if [ "x${postgresql_data}" = "x" ]; then
3220 echo "You must define a data directory (postgresql_${profile}_data)"
3223 eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}"
3224 eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}"
3225 eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}"
3226 eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}"
3229 if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then
3230 for profile in ${postgresql_profiles}; do
3231 eval _enable="\${postgresql_${profile}_enable}"
3232 case "x${_enable:-${postgresql_enable}}" in
3233 x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee])
3239 if test -z "$_enable"; then
3240 _var=postgresql_enable
3242 _var=postgresql_"${profile}"_enable
3245 "'${_enable:-${postgresql_enable}}'" \
3247 "Profile ${profile} skipped."
3251 echo "===> postgresql profile: ${profile}"
3252 %%PREFIX%%/etc/rc.d/postgresql $1 ${profile}
3254 if [ "0${retcode}" -ne 0 ]; then
3255 failed="${profile} (${retcode}) ${failed:-}"
3257 success="${profile} ${success:-}"
3264 command_args="-D ${postgresql_data} ${postgresql_flags}"
3266 postgresql_command()
3268 su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
3273 su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}"