# Buildsheet autogenerated by ravenadm tool -- Do not edit. NAMEBASE= postgresql13 VERSION= 13.14 KEYWORDS= databases VARIANTS= standard SDESC[standard]= Powerful, open source object-relational database HOMEPAGE= https://www.postgresql.org/ CONTACT= nobody DOWNLOAD_GROUPS= main SITES[main]= PGSQL/source/v13.14 DISTFILE[1]= postgresql-13.14.tar.bz2:main DIST_SUBDIR= postgresql DF_INDEX= 1 SPKGS[standard]= complete server client contrib plperl plpython pltcl docs nls man dev OPTIONS_AVAILABLE= none OPTIONS_STANDARD= none BUILD_DEPENDS= docbook-sgml:single:standard docbook-dsssl:single:standard openjade:single:standard OpenSP:single:standard readline:dev:standard readline:primary:standard libxslt:dev:standard BUILDRUN_DEPENDS= libxslt:primary:standard B_DEPS[sunos]= ossp-uuid:dev:standard B_DEPS[linux]= ossp-uuid:dev:standard B_DEPS[darwin]= libuuid:dev:standard BR_DEPS[sunos]= ossp-uuid:primary:standard BR_DEPS[linux]= ossp-uuid:primary:standard BR_DEPS[darwin]= libuuid:primary:standard EXRUN[pltcl]= tcl EXRUN[plpython]= python EXRUN[client]= gettext:primary:standard libxslt:primary:standard readline:primary:standard zlib:primary:standard ssl EXRUN[contrib]= postgresql13:client:standard libxslt:primary:standard zlib:primary:standard gettext:primary:standard ssl EXRUN[plperl]= perl EXRUN[server]= postgresql13:client:standard USERS= pgsql GROUPS= pgsql USERGROUP_SPKG= server USES= bison gmake perl:build tcl:build ssl python:build zlib gettext cpe GNOME_COMPONENTS= libxml2 DISTNAME= postgresql-13.14 LICENSE= PostgreSQL:server LICENSE_FILE= PostgreSQL:{{WRKSRC}}/COPYRIGHT LICENSE_SCHEME= solo CPE_PRODUCT= postgresql CPE_VENDOR= postgresql FPC_EQUIVALENT= databases/postgresql13-server MUST_CONFIGURE= gnu CONFIGURE_ARGS= --with-libraries="{{PREFIX}}/lib" --with-includes="{{PREFIX}}/include:{{TCL_INCLUDEDIR}}" --with-tclconfig="{{TCL_LIBDIR}}" --with-openssl --with-libxml --with-libxslt --with-perl --with-python --with-tcl --without-gssapi --enable-nls CONFIGURE_ENV= PTHREAD_LIBS="-lpthread" TCLSH="{{TCLSH}}" pgac_cv_path_stylesheets={{PREFIX}}/share/sgml/docbook/dsssl/modular BUILD_TARGET= world MAKE_ENV= TCL_INCDIR="{{TCL_INCLUDEDIR}}" INSTALL_TARGET= install-world PLIST_SUB= PGVER=13 RC_SUBR= postgresql:server SUB_FILES= 502.pgsql SUB_LIST= PG_GROUP=pgsql PG_USER=pgsql PG_UID=60000 DATADIR=data130 LDFLAGS= -lpthread VAR_OPSYS[freebsd]= CONFIGURE_ARGS=--with-template=freebsd CONFIGURE_ARGS=--with-uuid=bsd VAR_OPSYS[sunos]= CONFIGURE_ENV=ac_cv_search_bind_textdomain_codeset=-lintl CONFIGURE_ARGS=--with-template=solaris CONFIGURE_ARGS=--with-uuid=ossp LDFLAGS=-L{{PREFIX}}/lib/ossp LDFLAGS=-Wl,-rpath,{{PREFIX}}/lib/ossp VAR_OPSYS[linux]= CONFIGURE_ARGS=--with-template=linux CONFIGURE_ARGS=--with-uuid=ossp LDFLAGS=-L{{PREFIX}}/lib/ossp LDFLAGS=-Wl,-rpath,{{PREFIX}}/lib/ossp VAR_OPSYS[darwin]= CONFIGURE_ARGS=--with-template=darwin CONFIGURE_ARGS=--with-uuid=e2fs VAR_OPSYS[netbsd]= CONFIGURE_ARGS=--with-template=netbsd CONFIGURE_ARGS=--with-uuid=bsd VAR_OPSYS[openbsd]= CONFIGURE_ARGS=--with-template=openbsd CONFIGURE_ARGS=--with-uuid=bsd VAR_OPSYS[dragonfly]= CONFIGURE_ARGS=--with-template=freebsd CONFIGURE_ARGS=--with-uuid=bsd VAR_OPSYS[midnightbsd]= CONFIGURE_ARGS=--with-template=freebsd CONFIGURE_ARGS=--with-uuid=bsd post-install: ${MKDIR} ${STAGEDIR}${PREFIX}/etc/periodic/daily ${INSTALL_SCRIPT} ${WRKDIR}/502.pgsql \ ${STAGEDIR}${PREFIX}/etc/periodic/daily # install-world doesn't strip (and install-strip won't install enough) ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/*.${LIBEXT} ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pgxs/src/test/regress/pg_regress list=$$(${LS} ${STAGEDIR}${PREFIX}/bin/* | ${GREP} -v pltcl_); \ ${STRIP_CMD} $${list} post-patch-sunos: ${REINPLACE_CMD} -e '/sqlmansect/d' \ ${WRKSRC}/src/makefiles/Makefile.solaris [FILE:1220:descriptions/desc.server] PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available anywhere. Commercial Support is also available. The original Postgres code was the effort of many graduate students, undergraduate students, and staff programmers working under the direction of Professor Michael Stonebraker at the University of California, Berkeley. In 1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query language to SQL and created a new database system which came to known as Postgres95. Many others contributed to the porting, testing, debugging and enhancement of the Postgres95 code. As the code improved, and 1995 faded into memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of developers who are now responsible for all current and future development. The development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the support mailing list (questions@PostgreSQL.ORG). This subpackage contains the PostgreSQL server. [FILE:48:descriptions/desc.client] This subpackage contains the PostgreSQL client. [FILE:60:descriptions/desc.contrib] This subpackage contains the contrib modules of PostgreSQL. [FILE:74:descriptions/desc.plperl] This subpackage contains Perl Procedural Language support for PostgreSQL. [FILE:76:descriptions/desc.plpython] This subpackage contains Python Procedural Language support for PostgreSQL. [FILE:73:descriptions/desc.pltcl] This subpackage contains Tcl Procedural Language support for PostgreSQL. [FILE:114:distinfo] b8df078551898960bd500dc5d38a177e9905376df81fe7f2b660a1407fa6a5ed 21584146 postgresql/postgresql-13.14.tar.bz2 [FILE:8062:manifests/plist.server] bin/ initdb pg_archivecleanup pg_basebackup pg_controldata pg_ctl pg_receivewal pg_recvlogical pg_resetwal pg_rewind pg_test_fsync pg_test_timing pg_upgrade pg_waldump postgres postmaster etc/periodic/daily/502.pgsql include/postgresql/server/ plperl_system.h plpython_system.h lib/postgresql/ amcheck.so cyrillic_and_mic.so dict_snowball.so euc2004_sjis2004.so euc_cn_and_mic.so euc_jp_and_sjis.so euc_kr_and_mic.so euc_tw_and_big5.so latin2_and_win1250.so latin_and_mic.so libpqwalreceiver.so pgoutput.so plpgsql.so utf8_and_big5.so utf8_and_cyrillic.so utf8_and_euc2004.so utf8_and_euc_cn.so utf8_and_euc_jp.so utf8_and_euc_kr.so utf8_and_euc_tw.so utf8_and_gb18030.so utf8_and_gbk.so utf8_and_iso8859.so utf8_and_iso8859_1.so utf8_and_johab.so utf8_and_sjis.so utf8_and_sjis2004.so utf8_and_uhc.so utf8_and_win.so share/postgresql/ information_schema.sql pg_hba.conf.sample pg_ident.conf.sample postgres.bki postgresql.conf.sample snowball_create.sql sql_features.txt system_views.sql share/postgresql/extension/ plpgsql--1.0.sql plpgsql.control share/postgresql/timezone/ CET CST6CDT Cuba EET EST EST5EDT Egypt Eire Factory GB GB-Eire GMT GMT+0 GMT-0 GMT0 Greenwich HST Hongkong Iceland Iran Israel Jamaica Japan Kwajalein Libya MET MST MST7MDT NZ NZ-CHAT Navajo PRC PST8PDT Poland Portugal ROC ROK Singapore Turkey UCT UTC Universal W-SU WET Zulu share/postgresql/timezone/Africa/ Abidjan Accra Addis_Ababa Algiers Asmara Asmera Bamako Bangui Banjul Bissau Blantyre Brazzaville Bujumbura Cairo Casablanca Ceuta Conakry Dakar Dar_es_Salaam Djibouti Douala El_Aaiun Freetown Gaborone Harare Johannesburg Juba Kampala Khartoum Kigali Kinshasa Lagos Libreville Lome Luanda Lubumbashi Lusaka Malabo Maputo Maseru Mbabane Mogadishu Monrovia Nairobi Ndjamena Niamey Nouakchott Ouagadougou Porto-Novo Sao_Tome Timbuktu Tripoli Tunis Windhoek share/postgresql/timezone/America/ Adak Anchorage Anguilla Antigua Araguaina Aruba Asuncion Atikokan Atka Bahia Bahia_Banderas Barbados Belem Belize Blanc-Sablon Boa_Vista Bogota Boise Buenos_Aires Cambridge_Bay Campo_Grande Cancun Caracas Catamarca Cayenne Cayman Chicago Chihuahua Ciudad_Juarez Coral_Harbour Cordoba Costa_Rica Creston Cuiaba Curacao Danmarkshavn Dawson Dawson_Creek Denver Detroit Dominica Edmonton Eirunepe El_Salvador Ensenada Fort_Nelson Fort_Wayne Fortaleza Glace_Bay Godthab Goose_Bay Grand_Turk Grenada Guadeloupe Guatemala Guayaquil Guyana Halifax Havana Hermosillo Indianapolis Inuvik Iqaluit Jamaica Jujuy Juneau Knox_IN Kralendijk La_Paz Lima Los_Angeles Louisville Lower_Princes Maceio Managua Manaus Marigot Martinique Matamoros Mazatlan Mendoza Menominee Merida Metlakatla Mexico_City Miquelon Moncton Monterrey Montevideo Montreal Montserrat Nassau New_York Nipigon Nome Noronha Nuuk Ojinaga Panama Pangnirtung Paramaribo Phoenix Port-au-Prince Port_of_Spain Porto_Acre Porto_Velho Puerto_Rico Punta_Arenas Rainy_River Rankin_Inlet Recife Regina Resolute Rio_Branco Rosario Santa_Isabel Santarem Santiago Santo_Domingo Sao_Paulo Scoresbysund Shiprock Sitka St_Barthelemy St_Johns St_Kitts St_Lucia St_Thomas St_Vincent Swift_Current Tegucigalpa Thule Thunder_Bay Tijuana Toronto Tortola Vancouver Virgin Whitehorse Winnipeg Yakutat Yellowknife share/postgresql/timezone/America/Argentina/ Buenos_Aires Catamarca ComodRivadavia Cordoba Jujuy La_Rioja Mendoza Rio_Gallegos Salta San_Juan San_Luis Tucuman Ushuaia share/postgresql/timezone/America/Indiana/ Indianapolis Knox Marengo Petersburg Tell_City Vevay Vincennes Winamac share/postgresql/timezone/America/Kentucky/ Louisville Monticello share/postgresql/timezone/America/North_Dakota/ Beulah Center New_Salem share/postgresql/timezone/Antarctica/ Casey Davis DumontDUrville Macquarie Mawson McMurdo Palmer Rothera South_Pole Syowa Troll Vostok share/postgresql/timezone/Arctic/Longyearbyen share/postgresql/timezone/Asia/ Aden Almaty Amman Anadyr Aqtau Aqtobe Ashgabat Ashkhabad Atyrau Baghdad Bahrain Baku Bangkok Barnaul Beirut Bishkek Brunei Calcutta Chita Choibalsan Chongqing Chungking Colombo Dacca Damascus Dhaka Dili Dubai Dushanbe Famagusta Gaza Harbin Hebron Ho_Chi_Minh Hong_Kong Hovd Irkutsk Istanbul Jakarta Jayapura Jerusalem Kabul Kamchatka Karachi Kashgar Kathmandu Katmandu Khandyga Kolkata Krasnoyarsk Kuala_Lumpur Kuching Kuwait Macao Macau Magadan Makassar Manila Muscat Nicosia Novokuznetsk Novosibirsk Omsk Oral Phnom_Penh Pontianak Pyongyang Qatar Qostanay Qyzylorda Rangoon Riyadh Saigon Sakhalin Samarkand Seoul Shanghai Singapore Srednekolymsk Taipei Tashkent Tbilisi Tehran Tel_Aviv Thimbu Thimphu Tokyo Tomsk Ujung_Pandang Ulaanbaatar Ulan_Bator Urumqi Ust-Nera Vientiane Vladivostok Yakutsk Yangon Yekaterinburg Yerevan share/postgresql/timezone/Atlantic/ Azores Bermuda Canary Cape_Verde Faeroe Faroe Jan_Mayen Madeira Reykjavik South_Georgia St_Helena Stanley share/postgresql/timezone/Australia/ ACT Adelaide Brisbane Broken_Hill Canberra Currie Darwin Eucla Hobart LHI Lindeman Lord_Howe Melbourne NSW North Perth Queensland South Sydney Tasmania Victoria West Yancowinna share/postgresql/timezone/Brazil/ Acre DeNoronha East West share/postgresql/timezone/Canada/ Atlantic Central Eastern Mountain Newfoundland Pacific Saskatchewan Yukon share/postgresql/timezone/Chile/ Continental EasterIsland share/postgresql/timezone/Etc/ GMT GMT+0 GMT+1 GMT+10 GMT+11 GMT+12 GMT+2 GMT+3 GMT+4 GMT+5 GMT+6 GMT+7 GMT+8 GMT+9 GMT-0 GMT-1 GMT-10 GMT-11 GMT-12 GMT-13 GMT-14 GMT-2 GMT-3 GMT-4 GMT-5 GMT-6 GMT-7 GMT-8 GMT-9 GMT0 Greenwich UCT UTC Universal Zulu share/postgresql/timezone/Europe/ Amsterdam Andorra Astrakhan Athens Belfast Belgrade Berlin Bratislava Brussels Bucharest Budapest Busingen Chisinau Copenhagen Dublin Gibraltar Guernsey Helsinki Isle_of_Man Istanbul Jersey Kaliningrad Kiev Kirov Kyiv Lisbon Ljubljana London Luxembourg Madrid Malta Mariehamn Minsk Monaco Moscow Nicosia Oslo Paris Podgorica Prague Riga Rome Samara San_Marino Sarajevo Saratov Simferopol Skopje Sofia Stockholm Tallinn Tirane Tiraspol Ulyanovsk Uzhgorod Vaduz Vatican Vienna Vilnius Volgograd Warsaw Zagreb Zaporozhye Zurich share/postgresql/timezone/Indian/ Antananarivo Chagos Christmas Cocos Comoro Kerguelen Mahe Maldives Mauritius Mayotte Reunion share/postgresql/timezone/Mexico/ BajaNorte BajaSur General share/postgresql/timezone/Pacific/ Apia Auckland Bougainville Chatham Chuuk Easter Efate Enderbury Fakaofo Fiji Funafuti Galapagos Gambier Guadalcanal Guam Honolulu Johnston Kanton Kiritimati Kosrae Kwajalein Majuro Marquesas Midway Nauru Niue Norfolk Noumea Pago_Pago Palau Pitcairn Pohnpei Ponape Port_Moresby Rarotonga Saipan Samoa Tahiti Tarawa Tongatapu Truk Wake Wallis Yap share/postgresql/timezone/US/ Alaska Aleutian Arizona Central East-Indiana Eastern Hawaii Indiana-Starke Michigan Mountain Pacific Samoa share/postgresql/timezonesets/ Africa.txt America.txt Antarctica.txt Asia.txt Atlantic.txt Australia Australia.txt Default Etc.txt Europe.txt India Indian.txt Pacific.txt share/postgresql/tsearch_data/ danish.stop dutch.stop english.stop finnish.stop french.stop german.stop hungarian.stop hunspell_sample.affix hunspell_sample_long.affix hunspell_sample_long.dict hunspell_sample_num.affix hunspell_sample_num.dict ispell_sample.affix ispell_sample.dict italian.stop nepali.stop norwegian.stop portuguese.stop russian.stop spanish.stop swedish.stop synonym_sample.syn thesaurus_sample.ths turkish.stop [FILE:648:manifests/plist.client] %%ONLY-DARWIN%%lib/ libecpg.so.6.11 libecpg_compat.so.3.11 libpgtypes.so.3.11 libpq.so.5.11 bin/ clusterdb createdb createuser dropdb dropuser ecpg pg_checksums pg_config pg_dump pg_dumpall pg_isready pg_restore pg_verifybackup pgbench psql reindexdb vacuumdb lib/ libecpg.so.6 libecpg_compat.so.3 libpgtypes.so.3 libpq.so.5 lib/postgresql/pgxs/config/ install-sh missing lib/postgresql/pgxs/src/ Makefile.global Makefile.port Makefile.shlib nls-global.mk lib/postgresql/pgxs/src/makefiles/pgxs.mk lib/postgresql/pgxs/src/test/regress/pg_regress share/postgresql/ errcodes.txt pg_service.conf.sample psqlrc.sample [FILE:4788:manifests/plist.contrib] bin/ oid2name pg_standby vacuumlo lib/postgresql/ _int.so adminpack.so auth_delay.so auto_explain.so autoinc.so bloom.so btree_gin.so btree_gist.so citext.so cube.so dblink.so dict_int.so dict_xsyn.so earthdistance.so file_fdw.so fuzzystrmatch.so hstore.so insert_username.so isn.so lo.so ltree.so moddatetime.so pageinspect.so passwordcheck.so pg_buffercache.so pg_freespacemap.so pg_prewarm.so pg_stat_statements.so pg_trgm.so pg_visibility.so pgcrypto.so pgrowlocks.so pgstattuple.so pgxml.so postgres_fdw.so refint.so seg.so sslinfo.so tablefunc.so tcn.so test_decoding.so tsm_system_rows.so tsm_system_time.so unaccent.so uuid-ossp.so share/postgresql/extension/ adminpack--1.0--1.1.sql adminpack--1.0.sql adminpack--1.1--2.0.sql adminpack--2.0--2.1.sql adminpack.control amcheck--1.0--1.1.sql amcheck--1.0.sql amcheck--1.1--1.2.sql amcheck.control autoinc--1.0.sql autoinc.control bloom--1.0.sql bloom.control bool_plperl--1.0.sql bool_plperl.control bool_plperlu.control btree_gin--1.0--1.1.sql btree_gin--1.0.sql btree_gin--1.1--1.2.sql btree_gin--1.2--1.3.sql btree_gin.control btree_gist--1.0--1.1.sql btree_gist--1.1--1.2.sql btree_gist--1.2--1.3.sql btree_gist--1.2.sql btree_gist--1.3--1.4.sql btree_gist--1.4--1.5.sql btree_gist.control citext--1.0--1.1.sql citext--1.1--1.2.sql citext--1.2--1.3.sql citext--1.3--1.4.sql citext--1.4--1.5.sql citext--1.4.sql citext--1.5--1.6.sql citext.control cube--1.0--1.1.sql cube--1.1--1.2.sql cube--1.2--1.3.sql cube--1.2.sql cube--1.3--1.4.sql cube.control dblink--1.0--1.1.sql dblink--1.1--1.2.sql dblink--1.2.sql dblink.control dict_int--1.0.sql dict_int.control dict_xsyn--1.0.sql dict_xsyn.control earthdistance--1.0--1.1.sql earthdistance--1.1.sql earthdistance.control file_fdw--1.0.sql file_fdw.control fuzzystrmatch--1.0--1.1.sql fuzzystrmatch--1.1.sql fuzzystrmatch.control hstore--1.0--1.1.sql hstore--1.1--1.2.sql hstore--1.2--1.3.sql hstore--1.3--1.4.sql hstore--1.4--1.5.sql hstore--1.4.sql hstore--1.5--1.6.sql hstore--1.6--1.7.sql hstore.control insert_username--1.0.sql insert_username.control intagg--1.0--1.1.sql intagg--1.1.sql intagg.control intarray--1.0--1.1.sql intarray--1.1--1.2.sql intarray--1.2--1.3.sql intarray--1.2.sql intarray.control isn--1.0--1.1.sql isn--1.1--1.2.sql isn--1.1.sql isn.control lo--1.0--1.1.sql lo--1.1.sql lo.control ltree--1.0--1.1.sql ltree--1.1--1.2.sql ltree--1.1.sql ltree.control moddatetime--1.0.sql moddatetime.control pageinspect--1.0--1.1.sql pageinspect--1.1--1.2.sql pageinspect--1.2--1.3.sql pageinspect--1.3--1.4.sql pageinspect--1.4--1.5.sql pageinspect--1.5--1.6.sql pageinspect--1.5.sql pageinspect--1.6--1.7.sql pageinspect--1.7--1.8.sql pageinspect.control pg_buffercache--1.0--1.1.sql pg_buffercache--1.1--1.2.sql pg_buffercache--1.2--1.3.sql pg_buffercache--1.2.sql pg_buffercache.control pg_freespacemap--1.0--1.1.sql pg_freespacemap--1.1--1.2.sql pg_freespacemap--1.1.sql pg_freespacemap.control pg_prewarm--1.0--1.1.sql pg_prewarm--1.1--1.2.sql pg_prewarm--1.1.sql pg_prewarm.control pg_stat_statements--1.0--1.1.sql pg_stat_statements--1.1--1.2.sql pg_stat_statements--1.2--1.3.sql pg_stat_statements--1.3--1.4.sql pg_stat_statements--1.4--1.5.sql pg_stat_statements--1.4.sql pg_stat_statements--1.5--1.6.sql pg_stat_statements--1.6--1.7.sql pg_stat_statements--1.7--1.8.sql pg_stat_statements.control pg_trgm--1.0--1.1.sql pg_trgm--1.1--1.2.sql pg_trgm--1.2--1.3.sql pg_trgm--1.3--1.4.sql pg_trgm--1.3.sql pg_trgm--1.4--1.5.sql pg_trgm.control pg_visibility--1.0--1.1.sql pg_visibility--1.1--1.2.sql pg_visibility--1.1.sql pg_visibility.control pgcrypto--1.0--1.1.sql pgcrypto--1.1--1.2.sql pgcrypto--1.2--1.3.sql pgcrypto--1.3.sql pgcrypto.control pgrowlocks--1.0--1.1.sql pgrowlocks--1.1--1.2.sql pgrowlocks--1.2.sql pgrowlocks.control pgstattuple--1.0--1.1.sql pgstattuple--1.1--1.2.sql pgstattuple--1.2--1.3.sql pgstattuple--1.3--1.4.sql pgstattuple--1.4--1.5.sql pgstattuple--1.4.sql pgstattuple.control postgres_fdw--1.0.sql postgres_fdw.control refint--1.0.sql refint.control seg--1.0--1.1.sql seg--1.1--1.2.sql seg--1.1.sql seg--1.2--1.3.sql seg.control sslinfo--1.0--1.1.sql sslinfo--1.1--1.2.sql sslinfo--1.2.sql sslinfo.control tablefunc--1.0.sql tablefunc.control tcn--1.0.sql tcn.control tsm_system_rows--1.0.sql tsm_system_rows.control tsm_system_time--1.0.sql tsm_system_time.control unaccent--1.0--1.1.sql unaccent--1.1.sql unaccent.control uuid-ossp--1.0--1.1.sql uuid-ossp--1.1.sql uuid-ossp.control xml2--1.0--1.1.sql xml2--1.1.sql xml2.control share/postgresql/tsearch_data/ unaccent.rules xsyn_sample.rules [FILE:385:manifests/plist.plperl] lib/postgresql/ bool_plperl.so hstore_plperl.so jsonb_plperl.so plperl.so share/postgresql/extension/ bool_plperlu--1.0.sql hstore_plperl--1.0.sql hstore_plperl.control hstore_plperlu--1.0.sql hstore_plperlu.control jsonb_plperl--1.0.sql jsonb_plperl.control jsonb_plperlu--1.0.sql jsonb_plperlu.control plperl--1.0.sql plperl.control plperlu--1.0.sql plperlu.control [FILE:794:manifests/plist.plpython] lib/postgresql/ hstore_plpython%%PYTHON_MAJOR_VER%%.so jsonb_plpython3.so ltree_plpython%%PYTHON_MAJOR_VER%%.so plpython%%PYTHON_MAJOR_VER%%.so lib/postgresql/pgxs/src/pl/plpython/regress-python3-mangle.mk share/postgresql/extension/ hstore_plpython2u--1.0.sql hstore_plpython2u.control hstore_plpython3u--1.0.sql hstore_plpython3u.control hstore_plpythonu--1.0.sql hstore_plpythonu.control jsonb_plpython2u--1.0.sql jsonb_plpython2u.control jsonb_plpython3u--1.0.sql jsonb_plpython3u.control jsonb_plpythonu--1.0.sql jsonb_plpythonu.control ltree_plpython2u--1.0.sql ltree_plpython2u.control ltree_plpython3u--1.0.sql ltree_plpython3u.control ltree_plpythonu--1.0.sql ltree_plpythonu.control plpython%%PYTHON_MAJOR_VER%%u--1.0.sql plpython%%PYTHON_MAJOR_VER%%u.control [FILE:131:manifests/plist.pltcl] lib/postgresql/pltcl.%%SHARED_OBJECT%% share/postgresql/extension/ pltcl--1.0.sql pltcl.control pltclu--1.0.sql pltclu.control [FILE:111:manifests/plist.docs] share/doc/postgresql/extension/ autoinc.example insert_username.example moddatetime.example refint.example [FILE:8244:manifests/plist.nls] share/locale/cs/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/de/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_verifybackup-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/es/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_verifybackup-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/fr/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_verifybackup-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/he/LC_MESSAGES/pg_config-%%PGVER%%.mo share/locale/it/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/ja/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_verifybackup-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/ko/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_verifybackup-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/pl/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo share/locale/pt_BR/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo share/locale/ro/LC_MESSAGES/plperl-%%PGVER%%.mo share/locale/ru/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_verifybackup-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/sv/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_verifybackup-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/tr/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/uk/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_verifybackup-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/vi/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo share/locale/zh_CN/LC_MESSAGES/ ecpg-%%PGVER%%.mo ecpglib6-%%PGVER%%.mo initdb-%%PGVER%%.mo libpq5-%%PGVER%%.mo pg_archivecleanup-%%PGVER%%.mo pg_basebackup-%%PGVER%%.mo pg_checksums-%%PGVER%%.mo pg_config-%%PGVER%%.mo pg_controldata-%%PGVER%%.mo pg_ctl-%%PGVER%%.mo pg_dump-%%PGVER%%.mo pg_resetwal-%%PGVER%%.mo pg_rewind-%%PGVER%%.mo pg_test_fsync-%%PGVER%%.mo pg_test_timing-%%PGVER%%.mo pg_upgrade-%%PGVER%%.mo pg_verifybackup-%%PGVER%%.mo pg_waldump-%%PGVER%%.mo pgscripts-%%PGVER%%.mo plperl-%%PGVER%%.mo plpgsql-%%PGVER%%.mo plpython-%%PGVER%%.mo pltcl-%%PGVER%%.mo postgres-%%PGVER%%.mo psql-%%PGVER%%.mo share/locale/zh_TW/LC_MESSAGES/ecpg-%%PGVER%%.mo [FILE:6073:manifests/plist.man] share/man/man1/ clusterdb.1.gz createdb.1.gz createuser.1.gz dropdb.1.gz dropuser.1.gz ecpg.1.gz initdb.1.gz oid2name.1.gz pg_archivecleanup.1.gz pg_basebackup.1.gz pg_checksums.1.gz pg_config.1.gz pg_controldata.1.gz pg_ctl.1.gz pg_dump.1.gz pg_dumpall.1.gz pg_isready.1.gz pg_receivewal.1.gz pg_recvlogical.1.gz pg_resetwal.1.gz pg_restore.1.gz pg_rewind.1.gz pg_standby.1.gz pg_test_fsync.1.gz pg_test_timing.1.gz pg_upgrade.1.gz pg_verifybackup.1.gz pg_waldump.1.gz pgbench.1.gz postgres.1.gz postmaster.1.gz psql.1.gz reindexdb.1.gz vacuumdb.1.gz vacuumlo.1.gz share/man/man3/ SPI_commit.3.gz SPI_commit_and_chain.3.gz SPI_connect.3.gz SPI_connect_ext.3.gz SPI_copytuple.3.gz SPI_cursor_close.3.gz SPI_cursor_fetch.3.gz SPI_cursor_find.3.gz SPI_cursor_move.3.gz SPI_cursor_open.3.gz SPI_cursor_open_with_args.3.gz SPI_cursor_open_with_paramlist.3.gz SPI_exec.3.gz SPI_execp.3.gz SPI_execute.3.gz SPI_execute_plan.3.gz SPI_execute_plan_with_paramlist.3.gz SPI_execute_with_args.3.gz SPI_finish.3.gz SPI_fname.3.gz SPI_fnumber.3.gz SPI_freeplan.3.gz SPI_freetuple.3.gz SPI_freetuptable.3.gz SPI_getargcount.3.gz SPI_getargtypeid.3.gz SPI_getbinval.3.gz SPI_getnspname.3.gz SPI_getrelname.3.gz SPI_gettype.3.gz SPI_gettypeid.3.gz SPI_getvalue.3.gz SPI_is_cursor_plan.3.gz SPI_keepplan.3.gz SPI_modifytuple.3.gz SPI_palloc.3.gz SPI_pfree.3.gz SPI_prepare.3.gz SPI_prepare_cursor.3.gz SPI_prepare_params.3.gz SPI_register_relation.3.gz SPI_register_trigger_data.3.gz SPI_repalloc.3.gz SPI_result_code_string.3.gz SPI_returntuple.3.gz SPI_rollback.3.gz SPI_rollback_and_chain.3.gz SPI_saveplan.3.gz SPI_scroll_cursor_fetch.3.gz SPI_scroll_cursor_move.3.gz SPI_start_transaction.3.gz SPI_unregister_relation.3.gz dblink.3.gz dblink_build_sql_delete.3.gz dblink_build_sql_insert.3.gz dblink_build_sql_update.3.gz dblink_cancel_query.3.gz dblink_close.3.gz dblink_connect.3.gz dblink_connect_u.3.gz dblink_disconnect.3.gz dblink_error_message.3.gz dblink_exec.3.gz dblink_fetch.3.gz dblink_get_connections.3.gz dblink_get_notify.3.gz dblink_get_pkey.3.gz dblink_get_result.3.gz dblink_is_busy.3.gz dblink_open.3.gz dblink_send_query.3.gz share/man/man7/ ABORT.7.gz ALTER_AGGREGATE.7.gz ALTER_COLLATION.7.gz ALTER_CONVERSION.7.gz ALTER_DATABASE.7.gz ALTER_DEFAULT_PRIVILEGES.7.gz ALTER_DOMAIN.7.gz ALTER_EVENT_TRIGGER.7.gz ALTER_EXTENSION.7.gz ALTER_FOREIGN_DATA_WRAPPER.7.gz ALTER_FOREIGN_TABLE.7.gz ALTER_FUNCTION.7.gz ALTER_GROUP.7.gz ALTER_INDEX.7.gz ALTER_LANGUAGE.7.gz ALTER_LARGE_OBJECT.7.gz ALTER_MATERIALIZED_VIEW.7.gz ALTER_OPERATOR.7.gz ALTER_OPERATOR_CLASS.7.gz ALTER_OPERATOR_FAMILY.7.gz ALTER_POLICY.7.gz ALTER_PROCEDURE.7.gz ALTER_PUBLICATION.7.gz ALTER_ROLE.7.gz ALTER_ROUTINE.7.gz ALTER_RULE.7.gz ALTER_SCHEMA.7.gz ALTER_SEQUENCE.7.gz ALTER_SERVER.7.gz ALTER_STATISTICS.7.gz ALTER_SUBSCRIPTION.7.gz ALTER_SYSTEM.7.gz ALTER_TABLE.7.gz ALTER_TABLESPACE.7.gz ALTER_TEXT_SEARCH_CONFIGURATION.7.gz ALTER_TEXT_SEARCH_DICTIONARY.7.gz ALTER_TEXT_SEARCH_PARSER.7.gz ALTER_TEXT_SEARCH_TEMPLATE.7.gz ALTER_TRIGGER.7.gz ALTER_TYPE.7.gz ALTER_USER.7.gz ALTER_USER_MAPPING.7.gz ALTER_VIEW.7.gz ANALYZE.7.gz BEGIN.7.gz CALL.7.gz CHECKPOINT.7.gz CLOSE.7.gz CLUSTER.7.gz COMMENT.7.gz COMMIT.7.gz COMMIT_PREPARED.7.gz COPY.7.gz CREATE_ACCESS_METHOD.7.gz CREATE_AGGREGATE.7.gz CREATE_CAST.7.gz CREATE_COLLATION.7.gz CREATE_CONVERSION.7.gz CREATE_DATABASE.7.gz CREATE_DOMAIN.7.gz CREATE_EVENT_TRIGGER.7.gz CREATE_EXTENSION.7.gz CREATE_FOREIGN_DATA_WRAPPER.7.gz CREATE_FOREIGN_TABLE.7.gz CREATE_FUNCTION.7.gz CREATE_GROUP.7.gz CREATE_INDEX.7.gz CREATE_LANGUAGE.7.gz CREATE_MATERIALIZED_VIEW.7.gz CREATE_OPERATOR.7.gz CREATE_OPERATOR_CLASS.7.gz CREATE_OPERATOR_FAMILY.7.gz CREATE_POLICY.7.gz CREATE_PROCEDURE.7.gz CREATE_PUBLICATION.7.gz CREATE_ROLE.7.gz CREATE_RULE.7.gz CREATE_SCHEMA.7.gz CREATE_SEQUENCE.7.gz CREATE_SERVER.7.gz CREATE_STATISTICS.7.gz CREATE_SUBSCRIPTION.7.gz CREATE_TABLE.7.gz CREATE_TABLESPACE.7.gz CREATE_TABLE_AS.7.gz CREATE_TEXT_SEARCH_CONFIGURATION.7.gz CREATE_TEXT_SEARCH_DICTIONARY.7.gz CREATE_TEXT_SEARCH_PARSER.7.gz CREATE_TEXT_SEARCH_TEMPLATE.7.gz CREATE_TRANSFORM.7.gz CREATE_TRIGGER.7.gz CREATE_TYPE.7.gz CREATE_USER.7.gz CREATE_USER_MAPPING.7.gz CREATE_VIEW.7.gz DEALLOCATE.7.gz DECLARE.7.gz DELETE.7.gz DISCARD.7.gz DO.7.gz DROP_ACCESS_METHOD.7.gz DROP_AGGREGATE.7.gz DROP_CAST.7.gz DROP_COLLATION.7.gz DROP_CONVERSION.7.gz DROP_DATABASE.7.gz DROP_DOMAIN.7.gz DROP_EVENT_TRIGGER.7.gz DROP_EXTENSION.7.gz DROP_FOREIGN_DATA_WRAPPER.7.gz DROP_FOREIGN_TABLE.7.gz DROP_FUNCTION.7.gz DROP_GROUP.7.gz DROP_INDEX.7.gz DROP_LANGUAGE.7.gz DROP_MATERIALIZED_VIEW.7.gz DROP_OPERATOR.7.gz DROP_OPERATOR_CLASS.7.gz DROP_OPERATOR_FAMILY.7.gz DROP_OWNED.7.gz DROP_POLICY.7.gz DROP_PROCEDURE.7.gz DROP_PUBLICATION.7.gz DROP_ROLE.7.gz DROP_ROUTINE.7.gz DROP_RULE.7.gz DROP_SCHEMA.7.gz DROP_SEQUENCE.7.gz DROP_SERVER.7.gz DROP_STATISTICS.7.gz DROP_SUBSCRIPTION.7.gz DROP_TABLE.7.gz DROP_TABLESPACE.7.gz DROP_TEXT_SEARCH_CONFIGURATION.7.gz DROP_TEXT_SEARCH_DICTIONARY.7.gz DROP_TEXT_SEARCH_PARSER.7.gz DROP_TEXT_SEARCH_TEMPLATE.7.gz DROP_TRANSFORM.7.gz DROP_TRIGGER.7.gz DROP_TYPE.7.gz DROP_USER.7.gz DROP_USER_MAPPING.7.gz DROP_VIEW.7.gz END.7.gz EXECUTE.7.gz EXPLAIN.7.gz FETCH.7.gz GRANT.7.gz IMPORT_FOREIGN_SCHEMA.7.gz INSERT.7.gz LISTEN.7.gz LOAD.7.gz LOCK.7.gz MOVE.7.gz NOTIFY.7.gz PREPARE.7.gz PREPARE_TRANSACTION.7.gz REASSIGN_OWNED.7.gz REFRESH_MATERIALIZED_VIEW.7.gz REINDEX.7.gz RELEASE_SAVEPOINT.7.gz RESET.7.gz REVOKE.7.gz ROLLBACK.7.gz ROLLBACK_PREPARED.7.gz ROLLBACK_TO_SAVEPOINT.7.gz SAVEPOINT.7.gz SECURITY_LABEL.7.gz SELECT.7.gz SELECT_INTO.7.gz SET.7.gz SET_CONSTRAINTS.7.gz SET_ROLE.7.gz SET_SESSION_AUTHORIZATION.7.gz SET_TRANSACTION.7.gz SHOW.7.gz START_TRANSACTION.7.gz TABLE.7.gz TRUNCATE.7.gz UNLISTEN.7.gz UPDATE.7.gz VACUUM.7.gz VALUES.7.gz WITH.7.gz [FILE:13704:manifests/plist.dev] include/ ecpg_config.h ecpg_informix.h ecpgerrno.h ecpglib.h ecpgtype.h libpq-events.h libpq-fe.h pg_config.h pg_config_ext.h pg_config_manual.h pg_config_os.h pgtypes.h pgtypes_date.h pgtypes_error.h pgtypes_interval.h pgtypes_numeric.h pgtypes_timestamp.h postgres_ext.h sql3types.h sqlca.h sqlda-compat.h sqlda-native.h sqlda.h include/libpq/libpq-fs.h include/postgresql/informix/esql/ datetime.h decimal.h sqltypes.h include/postgresql/internal/ c.h libpq-int.h port.h postgres_fe.h pqexpbuffer.h include/postgresql/internal/libpq/pqcomm.h include/postgresql/server/ c.h fmgr.h funcapi.h getaddrinfo.h getopt_long.h miscadmin.h pg_config.h pg_config_ext.h pg_config_manual.h pg_config_os.h pg_getopt.h pg_trace.h pgstat.h pgtar.h pgtime.h plperl.h plperl_helpers.h plpgsql.h plpy_cursorobject.h plpy_elog.h plpy_exec.h plpy_main.h plpy_planobject.h plpy_plpymodule.h plpy_procedure.h plpy_resultobject.h plpy_spi.h plpy_subxactobject.h plpy_typeio.h plpy_util.h plpython.h port.h postgres.h postgres_ext.h postgres_fe.h ppport.h rusagestub.h windowapi.h include/postgresql/server/access/ amapi.h amvalidate.h attmap.h attnum.h brin.h brin_internal.h brin_page.h brin_pageops.h brin_revmap.h brin_tuple.h brin_xlog.h bufmask.h clog.h commit_ts.h detoast.h genam.h generic_xlog.h gin.h gin_private.h ginblock.h ginxlog.h gist.h gist_private.h gistscan.h gistxlog.h hash.h hash_xlog.h heapam.h heapam_xlog.h heaptoast.h hio.h htup.h htup_details.h itup.h multixact.h nbtree.h nbtxlog.h parallel.h printsimple.h printtup.h relation.h reloptions.h relscan.h rewriteheap.h rmgr.h rmgrlist.h sdir.h session.h skey.h slru.h spgist.h spgist_private.h spgxlog.h stratnum.h subtrans.h sysattr.h table.h tableam.h timeline.h toast_helper.h toast_internals.h transam.h tsmapi.h tupconvert.h tupdesc.h tupdesc_details.h tupmacs.h twophase.h twophase_rmgr.h valid.h visibilitymap.h visibilitymapdefs.h xact.h xlog.h xlog_internal.h xlogarchive.h xlogdefs.h xloginsert.h xlogreader.h xlogrecord.h xlogutils.h include/postgresql/server/bootstrap/bootstrap.h include/postgresql/server/catalog/ binary_upgrade.h catalog.h catversion.h dependency.h genbki.h heap.h index.h indexing.h namespace.h objectaccess.h objectaddress.h opfam_internal.h partition.h pg_aggregate.h pg_aggregate_d.h pg_am.h pg_am_d.h pg_amop.h pg_amop_d.h pg_amproc.h pg_amproc_d.h pg_attrdef.h pg_attrdef_d.h pg_attribute.h pg_attribute_d.h pg_auth_members.h pg_auth_members_d.h pg_authid.h pg_authid_d.h pg_cast.h pg_cast_d.h pg_class.h pg_class_d.h pg_collation.h pg_collation_d.h pg_constraint.h pg_constraint_d.h pg_control.h pg_conversion.h pg_conversion_d.h pg_database.h pg_database_d.h pg_db_role_setting.h pg_db_role_setting_d.h pg_default_acl.h pg_default_acl_d.h pg_depend.h pg_depend_d.h pg_description.h pg_description_d.h pg_enum.h pg_enum_d.h pg_event_trigger.h pg_event_trigger_d.h pg_extension.h pg_extension_d.h pg_foreign_data_wrapper.h pg_foreign_data_wrapper_d.h pg_foreign_server.h pg_foreign_server_d.h pg_foreign_table.h pg_foreign_table_d.h pg_index.h pg_index_d.h pg_inherits.h pg_inherits_d.h pg_init_privs.h pg_init_privs_d.h pg_language.h pg_language_d.h pg_largeobject.h pg_largeobject_d.h pg_largeobject_metadata.h pg_largeobject_metadata_d.h pg_namespace.h pg_namespace_d.h pg_opclass.h pg_opclass_d.h pg_operator.h pg_operator_d.h pg_opfamily.h pg_opfamily_d.h pg_partitioned_table.h pg_partitioned_table_d.h pg_policy.h pg_policy_d.h pg_proc.h pg_proc_d.h pg_publication.h pg_publication_d.h pg_publication_rel.h pg_publication_rel_d.h pg_range.h pg_range_d.h pg_replication_origin.h pg_replication_origin_d.h pg_rewrite.h pg_rewrite_d.h pg_seclabel.h pg_seclabel_d.h pg_sequence.h pg_sequence_d.h pg_shdepend.h pg_shdepend_d.h pg_shdescription.h pg_shdescription_d.h pg_shseclabel.h pg_shseclabel_d.h pg_statistic.h pg_statistic_d.h pg_statistic_ext.h pg_statistic_ext_d.h pg_statistic_ext_data.h pg_statistic_ext_data_d.h pg_subscription.h pg_subscription_d.h pg_subscription_rel.h pg_subscription_rel_d.h pg_tablespace.h pg_tablespace_d.h pg_transform.h pg_transform_d.h pg_trigger.h pg_trigger_d.h pg_ts_config.h pg_ts_config_d.h pg_ts_config_map.h pg_ts_config_map_d.h pg_ts_dict.h pg_ts_dict_d.h pg_ts_parser.h pg_ts_parser_d.h pg_ts_template.h pg_ts_template_d.h pg_type.h pg_type_d.h pg_user_mapping.h pg_user_mapping_d.h schemapg.h storage.h storage_xlog.h toasting.h include/postgresql/server/commands/ alter.h async.h cluster.h collationcmds.h comment.h conversioncmds.h copy.h createas.h dbcommands.h dbcommands_xlog.h defrem.h discard.h event_trigger.h explain.h extension.h lockcmds.h matview.h policy.h portalcmds.h prepare.h proclang.h progress.h publicationcmds.h schemacmds.h seclabel.h sequence.h subscriptioncmds.h tablecmds.h tablespace.h trigger.h typecmds.h user.h vacuum.h variable.h view.h include/postgresql/server/common/ archive.h base64.h checksum_helper.h config_info.h connect.h controldata_utils.h fe_memutils.h file_perm.h file_utils.h hashfn.h int.h int128.h ip.h jsonapi.h keywords.h kwlookup.h link-canary.h logging.h md5.h openssl.h pg_lzcompress.h relpath.h restricted_token.h saslprep.h scram-common.h sha2.h shortest_dec.h string.h unicode_combining_table.h unicode_norm.h unicode_norm_table.h unicode_normprops_table.h username.h include/postgresql/server/datatype/timestamp.h include/postgresql/server/executor/ execExpr.h execParallel.h execPartition.h execdebug.h execdesc.h executor.h functions.h hashjoin.h instrument.h nodeAgg.h nodeAppend.h nodeBitmapAnd.h nodeBitmapHeapscan.h nodeBitmapIndexscan.h nodeBitmapOr.h nodeCtescan.h nodeCustom.h nodeForeignscan.h nodeFunctionscan.h nodeGather.h nodeGatherMerge.h nodeGroup.h nodeHash.h nodeHashjoin.h nodeIncrementalSort.h nodeIndexonlyscan.h nodeIndexscan.h nodeLimit.h nodeLockRows.h nodeMaterial.h nodeMergeAppend.h nodeMergejoin.h nodeModifyTable.h nodeNamedtuplestorescan.h nodeNestloop.h nodeProjectSet.h nodeRecursiveunion.h nodeResult.h nodeSamplescan.h nodeSeqscan.h nodeSetOp.h nodeSort.h nodeSubplan.h nodeSubqueryscan.h nodeTableFuncscan.h nodeTidscan.h nodeUnique.h nodeValuesscan.h nodeWindowAgg.h nodeWorktablescan.h spi.h spi_priv.h tablefunc.h tqueue.h tstoreReceiver.h tuptable.h include/postgresql/server/extension/cube/cubedata.h include/postgresql/server/extension/hstore/hstore.h include/postgresql/server/extension/isn/isn.h include/postgresql/server/extension/ltree/ltree.h include/postgresql/server/extension/seg/segdata.h include/postgresql/server/fe_utils/ archive.h cancel.h conditional.h mbprint.h print.h psqlscan.h psqlscan_int.h recovery_gen.h simple_list.h string_utils.h include/postgresql/server/foreign/ fdwapi.h foreign.h include/postgresql/server/jit/ jit.h llvmjit.h llvmjit_emit.h include/postgresql/server/lib/ binaryheap.h bipartite_match.h bloomfilter.h dshash.h hyperloglog.h ilist.h integerset.h knapsack.h pairingheap.h qunique.h rbtree.h simplehash.h stringinfo.h include/postgresql/server/libpq/ auth.h be-fsstubs.h be-gssapi-common.h crypt.h hba.h ifaddr.h libpq-be.h libpq-fs.h libpq.h pqcomm.h pqformat.h pqmq.h pqsignal.h scram.h include/postgresql/server/mb/ pg_wchar.h stringinfo_mb.h include/postgresql/server/nodes/ bitmapset.h execnodes.h extensible.h lockoptions.h makefuncs.h memnodes.h nodeFuncs.h nodes.h params.h parsenodes.h pathnodes.h pg_list.h plannodes.h primnodes.h print.h readfuncs.h replnodes.h supportnodes.h tidbitmap.h value.h include/postgresql/server/optimizer/ appendinfo.h clauses.h cost.h geqo.h geqo_copy.h geqo_gene.h geqo_misc.h geqo_mutation.h geqo_pool.h geqo_random.h geqo_recombination.h geqo_selection.h inherit.h joininfo.h optimizer.h orclauses.h paramassign.h pathnode.h paths.h placeholder.h plancat.h planmain.h planner.h prep.h restrictinfo.h subselect.h tlist.h include/postgresql/server/parser/ analyze.h gram.h gramparse.h kwlist.h parse_agg.h parse_clause.h parse_coerce.h parse_collate.h parse_cte.h parse_enr.h parse_expr.h parse_func.h parse_node.h parse_oper.h parse_param.h parse_relation.h parse_target.h parse_type.h parse_utilcmd.h parser.h parsetree.h scanner.h scansup.h include/postgresql/server/partitioning/ partbounds.h partdefs.h partdesc.h partprune.h include/postgresql/server/port/ aix.h atomics.h cygwin.h darwin.h freebsd.h hpux.h linux.h netbsd.h openbsd.h pg_bitutils.h pg_bswap.h pg_crc32c.h solaris.h win32.h win32_port.h include/postgresql/server/port/atomics/ arch-arm.h arch-hppa.h arch-ia64.h arch-ppc.h arch-x86.h fallback.h generic-acc.h generic-gcc.h generic-msvc.h generic-sunpro.h generic.h include/postgresql/server/port/win32/ dlfcn.h grp.h netdb.h pwd.h include/postgresql/server/port/win32/arpa/inet.h include/postgresql/server/port/win32/netinet/in.h include/postgresql/server/port/win32/sys/ socket.h wait.h include/postgresql/server/port/win32_msvc/ dirent.h unistd.h utime.h include/postgresql/server/port/win32_msvc/sys/ file.h param.h time.h include/postgresql/server/portability/ instr_time.h mem.h include/postgresql/server/postmaster/ autovacuum.h bgworker.h bgworker_internals.h bgwriter.h fork_process.h interrupt.h pgarch.h postmaster.h startup.h syslogger.h walwriter.h include/postgresql/server/regex/ regcustom.h regerrs.h regex.h regexport.h regguts.h include/postgresql/server/replication/ backup_manifest.h basebackup.h decode.h logical.h logicallauncher.h logicalproto.h logicalrelation.h logicalworker.h message.h origin.h output_plugin.h pgoutput.h reorderbuffer.h slot.h snapbuild.h syncrep.h walreceiver.h walsender.h walsender_private.h worker_internal.h include/postgresql/server/rewrite/ prs2lock.h rewriteDefine.h rewriteHandler.h rewriteManip.h rewriteRemove.h rewriteSupport.h rowsecurity.h include/postgresql/server/snowball/header.h include/postgresql/server/snowball/libstemmer/ api.h header.h stem_ISO_8859_1_danish.h stem_ISO_8859_1_dutch.h stem_ISO_8859_1_english.h stem_ISO_8859_1_finnish.h stem_ISO_8859_1_french.h stem_ISO_8859_1_german.h stem_ISO_8859_1_indonesian.h stem_ISO_8859_1_irish.h stem_ISO_8859_1_italian.h stem_ISO_8859_1_norwegian.h stem_ISO_8859_1_porter.h stem_ISO_8859_1_portuguese.h stem_ISO_8859_1_spanish.h stem_ISO_8859_1_swedish.h stem_ISO_8859_2_hungarian.h stem_ISO_8859_2_romanian.h stem_KOI8_R_russian.h stem_UTF_8_arabic.h stem_UTF_8_danish.h stem_UTF_8_dutch.h stem_UTF_8_english.h stem_UTF_8_finnish.h stem_UTF_8_french.h stem_UTF_8_german.h stem_UTF_8_greek.h stem_UTF_8_hungarian.h stem_UTF_8_indonesian.h stem_UTF_8_irish.h stem_UTF_8_italian.h stem_UTF_8_lithuanian.h stem_UTF_8_nepali.h stem_UTF_8_norwegian.h stem_UTF_8_porter.h stem_UTF_8_portuguese.h stem_UTF_8_romanian.h stem_UTF_8_russian.h stem_UTF_8_spanish.h stem_UTF_8_swedish.h stem_UTF_8_tamil.h stem_UTF_8_turkish.h include/postgresql/server/statistics/ extended_stats_internal.h statistics.h include/postgresql/server/storage/ backendid.h barrier.h block.h buf.h buf_internals.h buffile.h bufmgr.h bufpage.h checksum.h checksum_impl.h condition_variable.h copydir.h dsm.h dsm_impl.h fd.h freespace.h fsm_internals.h indexfsm.h ipc.h item.h itemid.h itemptr.h large_object.h latch.h lmgr.h lock.h lockdefs.h lwlock.h lwlocknames.h md.h off.h pg_sema.h pg_shmem.h pmsignal.h predicate.h predicate_internals.h proc.h procarray.h proclist.h proclist_types.h procsignal.h reinit.h relfilenode.h s_lock.h sharedfileset.h shm_mq.h shm_toc.h shmem.h sinval.h sinvaladt.h smgr.h spin.h standby.h standbydefs.h sync.h include/postgresql/server/tcop/ cmdtag.h cmdtaglist.h deparse_utility.h dest.h fastpath.h pquery.h tcopprot.h utility.h include/postgresql/server/tsearch/ ts_cache.h ts_locale.h ts_public.h ts_type.h ts_utils.h include/postgresql/server/tsearch/dicts/ regis.h spell.h include/postgresql/server/utils/ acl.h aclchk_internal.h array.h arrayaccess.h ascii.h attoptcache.h builtins.h bytea.h cash.h catcache.h combocid.h date.h datetime.h datum.h dsa.h dynahash.h elog.h errcodes.h evtcache.h expandeddatum.h expandedrecord.h float.h fmgroids.h fmgrprotos.h fmgrtab.h formatting.h freepage.h geo_decls.h guc.h guc_tables.h help_config.h hsearch.h index_selfuncs.h inet.h int8.h inval.h json.h jsonb.h jsonfuncs.h jsonpath.h logtape.h lsyscache.h memdebug.h memutils.h numeric.h palloc.h partcache.h pg_crc.h pg_locale.h pg_lsn.h pg_rusage.h pidfile.h plancache.h portal.h probes.h ps_status.h queryenvironment.h rangetypes.h regproc.h rel.h relcache.h relfilenodemap.h relmapper.h relptr.h reltrigger.h resowner.h resowner_private.h rls.h ruleutils.h sampling.h selfuncs.h sharedtuplestore.h snapmgr.h snapshot.h sortsupport.h spccache.h syscache.h timeout.h timestamp.h tuplesort.h tuplestore.h typcache.h tzparser.h uuid.h varbit.h varlena.h xid8.h xml.h lib/ libecpg.a libecpg.so libecpg_compat.a libecpg_compat.so libpgcommon.a libpgcommon_shlib.a libpgfeutils.a libpgport.a libpgport_shlib.a libpgtypes.a libpgtypes.so libpq.a libpq.so lib/pkgconfig/ libecpg.pc libecpg_compat.pc libpgtypes.pc libpq.pc [FILE:393:patches/patch-configure] --- configure.orig 2023-11-06 22:10:12 UTC +++ configure @@ -12300,7 +12300,7 @@ if ac_fn_c_try_link "$LINENO"; then : # recognize dependent libraries; assume curses is needed if we didn't # find any dependency. case $host_os in - netbsd* | openbsd*) + xxxxxx*) if test x"$pgac_lib" = x"" ; then pgac_lib=" -lcurses" fi ;; [FILE:349:patches/patch-doc-Makefile] --- doc/Makefile.orig 2023-11-06 22:10:12 UTC +++ doc/Makefile @@ -12,5 +12,5 @@ subdir = doc top_builddir = .. include $(top_builddir)/src/Makefile.global -all distprep html man install installdirs uninstall clean distclean maintainer-clean: +all distprep man install installdirs uninstall clean distclean maintainer-clean: $(MAKE) -C src $@ [FILE:1196:patches/patch-doc_src_sgml_Makefile] --- doc/src/sgml/Makefile.orig 2023-11-06 22:10:12 UTC +++ doc/src/sgml/Makefile @@ -15,7 +15,7 @@ # Make "html" the default target, since that is what most people tend # to want to use. -html: +man: # We don't need the tree-wide headers or install support here. NO_GENERATED_HEADERS=yes @@ -26,7 +26,7 @@ top_builddir = ../../.. include $(top_builddir)/src/Makefile.global -all: html man +all: man distprep: html distprep-man @@ -69,8 +69,6 @@ ALL_IMAGES := $(wildcard $(srcdir)/image ## Man pages ## -man distprep-man: man-stamp - man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML) $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^) $(XSLTPROC) $(XMLINCLUDE) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $(wordlist 1,2,$^) @@ -224,10 +222,10 @@ check: postgres.sgml $(ALLSGML) check-ta ## Install ## -install: install-html install-man +install: install-man installdirs: - $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum)) + $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum)) # If the install used a man directory shared with other applications, this will remove all files. uninstall: [FILE:498:patches/patch-src-backend-Makefile] --- src/backend/Makefile.orig 2023-11-06 22:10:12 UTC +++ src/backend/Makefile @@ -116,6 +116,8 @@ endif # aix $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport +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 + # The postgres.o target is needed by the rule in Makefile.global that # creates the exports file when MAKE_EXPORTS = true. [FILE:863:patches/patch-src_Makefile.shlib] --- src/Makefile.shlib.orig 2023-11-06 22:10:12 UTC +++ src/Makefile.shlib @@ -166,6 +166,9 @@ ifeq ($(PORTNAME), freebsd) endif ifeq ($(PORTNAME), netbsd) + ifdef SO_MAJOR_VERSION + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION) + endif LINK.shared = $(COMPILER) -shared ifdef soname LINK.shared += -Wl,-x,-soname,$(soname) @@ -212,6 +215,9 @@ endif ifeq ($(PORTNAME), linux) LINK.shared = $(COMPILER) -shared + ifdef SO_MAJOR_VERSION + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION) + endif ifdef soname LINK.shared += -Wl,-soname,$(soname) endif @@ -223,6 +229,9 @@ ifeq ($(PORTNAME), linux) endif ifeq ($(PORTNAME), solaris) + ifdef SO_MAJOR_VERSION + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION) + endif ifeq ($(GCC), yes) LINK.shared = $(COMPILER) -shared -Wl,-Bsymbolic else [FILE:685:patches/patch-src_backend_utils_misc_postgresql.conf.sample] --- src/backend/utils/misc/postgresql.conf.sample.orig 2023-11-06 22:10:12 UTC +++ src/backend/utils/misc/postgresql.conf.sample @@ -423,6 +423,7 @@ # - Where to Log - +log_destination = 'syslog' #log_destination = 'stderr' # Valid values are combinations of # stderr, csvlog, syslog, and eventlog, # depending on platform. csvlog @@ -569,7 +570,9 @@ #cluster_name = '' # added to process titles if nonempty # (change requires restart) -#update_process_title = on + +# On FreeBSD, this is a performance hog, so keep it off if you need speed +update_process_title = off #------------------------------------------------------------------------------ [FILE:3090:files/502.pgsql.in] #!/bin/sh # # Maintenance shell script to vacuum and backup database # Put this in /usr/local/etc/periodic/daily, and it will be run # every night # # Written by Palle Girgensohn # # In public domain, do what you like with it, # and use it at your own risk... :) # # Define these variables in either /etc/periodic.conf or # /etc/periodic.conf.local to override the default values. # # daily_pgsql_backup_enable="YES" # do backup of all databases # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # daily_pgsql_vacuum_enable="YES" # do vacuum # If there is a global system configuration file, suck it in. # if [ -r /etc/defaults/periodic.conf ] then . /etc/defaults/periodic.conf source_periodic_confs fi : ${daily_pgsql_user:="%%PG_USER%%"} : ${daily_pgsql_port:=5432} : ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"} : ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"} : ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"} # backupdir is relative to ~pgsql home directory unless it begins with a slash: : ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"} : ${daily_pgsql_savedays:="7"} # allow '~´ in dir name eval backupdir=${daily_pgsql_backupdir} rc=0 pgsql_backup() { # daily_pgsql_backupdir must be writeable by user %%PG_USER%% # ~%%PG_USER%% is just that under normal circumstances, # but this might not be where you want the backups... if [ ! -d ${backupdir} ] ; then echo Creating ${backupdir} mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir} fi echo echo "PostgreSQL backups" # Protect the data umask 077 rc=$? now=`date "+%Y-%m-%dT%H:%M:%S"` file=${daily_pgsql_backupdir}/pgglobals_${now} su -l ${daily_pgsql_user} -c \ "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz" db=$1 while shift; do echo -n " $db" file=${backupdir}/pgdump_${db}_${now} su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 db=$1 done if [ $rc -gt 0 ]; then echo echo "Errors were reported during backup." fi # cleaning up old data find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \ -a -mtime +${daily_pgsql_savedays} -delete echo } case "$daily_pgsql_backup_enable" in [Yy][Ee][Ss]) 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\'"` pgsql_backup $dbnames ;; [Nn][Oo]) ;; "") ;; *) pgsql_backup $daily_pgsql_backup_enable ;; esac case "$daily_pgsql_vacuum_enable" in [Yy][Ee][Ss]) echo echo "PostgreSQL vacuum" su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}" if [ $? -gt 0 ] then echo echo "Errors were reported during vacuum." rc=3 fi ;; esac exit $rc [FILE:3182:files/postgresql.in] #!/bin/sh # PROVIDE: postgresql # REQUIRE: sshd # KEYWORD: shutdown # # Add the following line to /etc/rc.conf to enable PostgreSQL: # # postgresql_enable="YES" # # optional # postgresql_data="%%PREFIX%%/%%PG_USER%%/%%DATADIR%%" # postgresql_flags="-w -s -m fast" # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C" # postgresql_class="default" # postgresql_profiles="" # # See %%PREFIX%%/share/doc/postgresql/README-server for more info # # This scripts takes one of the following commands: # # start stop restart reload status initdb # # For postmaster startup options, edit ${postgresql_data}/postgresql.conf command=%%PREFIX%%/bin/pg_ctl . /etc/rc.subr load_rc_config postgresql # set defaults postgresql_enable=${postgresql_enable:-"NO"} postgresql_flags=${postgresql_flags:-"-w -s -m fast"} postgresql_user=${postgresql_user:-"%%PG_USER%%"} eval postgresql_data=${postgresql_data:-"~${postgresql_user}/%%DATADIR%%"} postgresql_class=${postgresql_class:-"default"} postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"} name=postgresql rcvar=postgresql_enable extra_commands="reload initdb" start_cmd="postgresql_command start" stop_cmd="postgresql_command stop" restart_cmd="postgresql_command restart" reload_cmd="postgresql_command reload" status_cmd="postgresql_command status" initdb_cmd="postgresql_initdb" if [ -n "$2" ]; then profile="$2" if [ "x${postgresql_profiles}" != "x" ]; then eval postgresql_data="\${postgresql_${profile}_data:-}" if [ "x${postgresql_data}" = "x" ]; then echo "You must define a data directory (postgresql_${profile}_data)" exit 1 fi eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}" eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}" eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}" eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}" fi else if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then for profile in ${postgresql_profiles}; do eval _enable="\${postgresql_${profile}_enable}" case "x${_enable:-${postgresql_enable}}" in x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee]) continue ;; x[Yy][Ee][Ss]) ;; *) if test -z "$_enable"; then _var=postgresql_enable else _var=postgresql_"${profile}"_enable fi echo "Bad value" \ "'${_enable:-${postgresql_enable}}'" \ "for ${_var}. " \ "Profile ${profile} skipped." continue ;; esac echo "===> postgresql profile: ${profile}" %%PREFIX%%/etc/rc.d/postgresql $1 ${profile} retcode="$?" if [ "0${retcode}" -ne 0 ]; then failed="${profile} (${retcode}) ${failed:-}" else success="${profile} ${success:-}" fi done exit 0 fi fi command_args="-D ${postgresql_data} ${postgresql_flags}" postgresql_command() { su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}" } postgresql_initdb() { su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}" } run_rc_command "$1"