Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s9vFl-0062Lj-AG for pgsql-announce@arkaria.postgresql.org; Wed, 22 May 2024 23:20:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s9vFl-005AMn-B8 for pgsql-announce@arkaria.postgresql.org; Wed, 22 May 2024 23:20:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s9vFk-005AMP-74 for pgsql-announce@lists.postgresql.org; Wed, 22 May 2024 23:20:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s9vFe-001WjD-Aq for pgsql-announce@lists.postgresql.org; Wed, 22 May 2024 23:20:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Dv3EARLOAdXBLp3gm5tvLiNeBUAdkmgPT1IRffAJtEk=; b=jk9qj28N18cx1nl9+QVFO3i4Kn h8gCeh4Kb2OdikrFRLp2zFGySpL+Sln+XVFd9v0EnhYjEp01Wqhh+NLlBxAyZ0LdsZcdooHpPsmMR Af4/p/84IdK0hKD6R+jh+5utoaNMs3Q/XsqZxEgNKDXwSAxslskzotFuDriVuIyHck+2CnEb5rjZr 4OXl2slqMfNsMbQq4Zcf/NHbhE/RRlH7W2vBX/z5eDNr+uoh9EbKBP2IqGazdyVmsEEbitLG4TKnc mc2CWRGoEgmW02JDW30YGM69r9/AyfdYAx9UDtve+Qm3xI/msDZcKBkk3Tu775zhYHummUH2681Wa GPGKqoXg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s9vFd-004o6C-6V for pgsql-announce@lists.postgresql.org; Wed, 22 May 2024 23:20:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s9vFa-008V1J-Lf for pgsql-announce@lists.postgresql.org; Wed, 22 May 2024 23:20:03 +0000 Content-Type: multipart/mixed; boundary="===============5415213564296118892==" MIME-Version: 1.0 Subject: Pigsty v2.7 Released, free RDS PG with 255 extensions available To: PostgreSQL Announce From: Pigsty via PostgreSQL Announce Reply-To: rh@vonng.com Date: Wed, 22 May 2024 23:19:28 +0000 Message-ID: <171641996850.2021727.15617397522742722095@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 59068591f25d5d46314cdac4ffc0c4caf37ebe0bcc1882e11e328cc2d734dff7 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5415213564296118892== Content-Type: multipart/alternative; boundary="===============0296845401569792617==" MIME-Version: 1.0 --===============0296845401569792617== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable The [Pigsty](https://pigsty.io/) community is thrilled to announce Pigsty [= v2.7.0](https://github.com/Vonng/pigsty/releases/tag/v2.7.0), which has [25= 5](https://pigsty.io/docs/reference/extension/) unique extensions available= , to the free PostgreSQL distribution and RDS alternative. We also have int= roduced some new docker-compose templates for [Odoo](https://github.com/Von= ng/pigsty/tree/master/app/odoo), [Jupyter](https://github.com/Vonng/pigsty/= tree/master/app/jupyter), [PolarDB](https://github.com/Vonng/pigsty/tree/ma= ster/app/polardb), and GA [Supabase](https://github.com/Vonng/pigsty/tree/m= aster/app/supabase). ## About Pigsty Pigsty is a Battery-included, local-first PostgreSQL Distribution as a Free= RDS alternative. **Links**: [Website](https://pigsty.io/) | [GitHub](https://github.com/Vonn= g/pigsty) | [Demo](https://demo.pigsty.cc/) | [Blog](https://pigsty.io/blog= ) | [Install](https://pigsty.io/docs/setup/install/) | [Feature](https://pi= gsty.io/docs/about/feature/) **Images**: [Introduction](https://pigsty.io/img/pigsty/banner.en.jpg) | [E= xtensions](https://pigsty.io/img/pigsty/extension.png) | [Architecture](htt= ps://pigsty.io/img/pigsty/ha.png) | [Dashboards](https://pigsty.io/img/pigs= ty/dashboard.jpg) [Getting Started](https://pigsty.io/docs/setup/install/) with the latest [v= 2.7.0](https://github.com/Vonng/pigsty/releases/tag/v2.7.0) release with: `= curl -L https://get.pigsty.cc/install | bash` ## Pigsty v2.7: Extension Overwhelming I wrote a popular article last month - [*Postgres is eating the database wo= rld*](https://pigsty.io/blog/pg/pg-eat-db-world/), explaining why extension= s matter to the PostgreSQL ecosystem.=20 Based on this idea, we've packaged **20** brand-new extensions in v2.7. Wit= h these extensions added, Pigsty offers **157** non-contrib extensions for = [EL Distros](https://pigsty.io/docs/reference/extension/#rpm-extension) and= **116** for [Debian/Ubuntu Distros](https://pigsty.io/docs/reference/exten= sion/#deb-extension). Combined with **73** built-in [Contrib extensions](ht= tps://pigsty.io/docs/reference/extension/#contrib-extension), Pigsty now ha= s a total of **255** unique extensions available, which takes PostgreSQL's = versatility to a whole new level! > [Complete list of available extensions](https://pigsty.io/docs/reference/= extension/): https://pigsty.io/docs/reference/extension/ ## v2.7.0 Release Note ### **Highlight** Adding numerous new extensions written in `rust` & `pgrx`: - [pg_search](https://github.com/paradedb/paradedb/tree/dev/pg_search) v0.7= .0 : Full text search over SQL tables using the BM25 algorithm - [pg_lakehouse](https://github.com/paradedb/paradedb/tree/dev/pg_lakehouse= ) v0.7.0 : Query engine over object stores like S3 and table formats like D= elta Lake - [pg_analytics](https://github.com/paradedb/pg_analytics) v0.6.1 : Acceler= ates analytical query processing inside Postgres - [pg_graphql](https://github.com/supabase/pg_graphql) v1.5.4 : GraphQL sup= port to your PostgreSQL database. - [pg_jsonschema](https://github.com/supabase/pg_jsonschema) v0.3.1 : Postg= reSQL extension providing JSON Schema validation - [wrappers](https://github.com/supabase/wrappers) v0.3.1 : Postgres Foreig= n Data Wrappers Collections by Supabase - [pgmq](https://github.com/tembo-io/pgmq) v1.5.2 : A lightweight message q= ueue. Like AWS SQS and RSMQ but on Postgres. - [pg_tier](https://github.com/tembo-io/pg_tier) v0.0.3 : Postgres Extensio= n written in Rust, to enable data tiering to AWS S3 - [pg_vectorize](https://github.com/tembo-io/pg_vectorize) v0.15.0 : The si= mplest way to orchestrate vector search on Postgres - [pg_later](https://github.com/tembo-io/pg_later) v0.1.0 : Execute SQL now= and get the results later. - [pg_idkit](https://github.com/VADOSWARE/pg_idkit) v0.2.3 : Generating man= y popular types of identifiers - [plprql](https://github.com/kaspermarstal/plprql) v0.1.0 : Use PRQL in Po= stgreSQL - [pgsmcrypto](https://github.com/zhuobie/pgsmcrypto) v0.1.0 : PostgreSQL S= M Algorithm Extension - [pg_tiktoken](https://github.com/kelvich/pg_tiktoken) v0.0.1 : OpenAI tik= token tokenizer for PostgreSQL - [pgdd](https://github.com/rustprooflabs/pgdd) v0.5.2 : Access Data Dictio= nary metadata with pure SQL And some new extensions in plain C & C++: - [parquet_s3_fdw](https://github.com/pgspider/parquet_s3_fdw) 1.1.0 : Parq= uetS3 Foreign Data Wrapper for PostgreSQL - [plv8](https://github.com/plv8/plv8) 3.2.2 : V8 Engine Javascript Procedu= ral Language add-on for PostgreSQL - [md5hash](https://github.com/tvondra/md5hash) 1.0.1 : Custom data type fo= r storing MD5 hashes rather than text - [pg_tde](https://github.com/Percona-Lab/pg_tde) 1.0 alpha: Experimental e= ncrypted access method for PostgreSQL - [pg_dirtyread](https://github.com/df7cb/pg_dirtyread) 2.6 : Read dead but= unvacuumed tuples from a PostgreSQL relation - New deb PGDG extensions: `pg_roaringbitmap`, `pgfaceting`, `mobilitydb`, = `pgsql-http`, `pg_hint_plan`, `pg_statviz`, `pg_rrule` - New rpm PGDG extensions: `pg_profile`, `pg_show_plans`, use PGDG's `pgsql= _http`, `pgsql_gzip`, `pg_net`, `pg_bigm` instead of Pigsty RPM.=20 ### **New Features** - Prepare arm64 packages for infra & pgsql packages for el & deb distros. - New installation script to download from Cloudflare, and more hints. - New monitoring dashboard PGSQL PITR to assist the PITR procedure.=20 - Make preparations for running pigsty inside docker VM containers - Add a [fool-proof design](https://github.com/Vonng/pigsty/issues/402) for= running pgsql.yml on a node that is not managed by Pigsty - Add separated template for each OS distro: el7, el8, el9, debian11, debia= n12, ubuntu20, ubuntu22 ### **New Docker Application** - [Odoo](https://github.com/Vonng/pigsty/tree/master/app/odoo): launch open= -source ERP over PostgreSQL. - [Jupyter](https://github.com/Vonng/pigsty/tree/master/app/jupyter): Run J= upyter notebook containers and expose the HTTP service. - [PolarDB](https://github.com/Vonng/pigsty/tree/master/app/polardb): run t= he demo playground for the shared-storage version of OSS PG. - [supabase](https://github.com/Vonng/pigsty/tree/master/app/supabase): bum= p to the latest GA version. - [bytebase](https://github.com/Vonng/pigsty/tree/master/app/bytebase): use= the `latest` tag instead of the ad hoc version. - [pg_exporter](https://github.com/Vonng/pigsty/tree/master/app/pg_exporter= ): update docker image example ### **Software Upgrade** - **PostgreSQL 16.3, 15.7, 14.12, 13.15, 12.19** - Patroni 3.3.0 - pgBackRest 2.51 - vip-manager v2.5.0 - Haproxy 2.9.7 - Grafana 10.4.2 - Prometheus 2.51 - Loki & Promtail: 3.0.0 (breaking changes!) - Alertmanager 0.27.0 - BlackBox Exporter 0.25.0 - Node Exporter 1.8.0 - pgBackrest Exporter 0.17.0 - duckdb 0.10.2 - etcd 3.5.13 - minio-20240510014138 / mcli-20240509170424 - pev2 v1.8.0 =E2=86=92 v1.11.0 - **pgvector** 0.6.1 =E2=86=92 0.7.0 - pg_tle: v1.3.4 =E2=86=92 v1.4.0 - hydra: v1.1.1 =E2=86=92 v1.1.2 - duckdb_fdw: v1.1.0 recompile with libduckdb 0.10.2 - pg_bm25 0.5.6 =E2=86=92 pg_search 0.7.0 - pg_analytics: 0.5.6 =E2=86=92 0.6.1 - pg_graphql: 1.5.0 =E2=86=92 1.5.4 - pg_net 0.8.0 =E2=86=92 0.9.1 - pg_sparse (deprecated due to pgvector 0.7) ### **Fixed Issues** - Fix role pg_exporters white space in variable templates - Fix `minio_cluster` not commented in global variables - Fix the non-existent `postgis34` package name in the `el7` config template - Fix EL8 `python3.11-cryptography` deps to `python3-cryptography` accordin= g to upstream - Fix `/pg/bin/pg-role` can not get OS user name from environ in non-intera= ct mode - Fix `/pg/bin/pg-pitr` can not hint `-X` `-P` flag properly ### **API Change** - New parameter `node_write_etc_hosts` to control whether to write `/etc/ho= sts` file on target nodes. - Relocatable prometheus target directory with new parameter `prometheus_sd= _dir`. - Add `-x|--proxy` flag to enable and use the value of global proxy env by = @waitingsong in https://github.com/Vonng/pigsty/pull/405 - No longer parse infra nginx log details since it brings too many labels t= o the log. - Use alertmanager API Version `v2` instead of `v1` in prometheus config. - Use `/pg/cert/ca.crt` instead of `/etc/pki/ca.crt` in role `pgsql`. ## Acknowledgment A huge thank you to all our users who contributed patches reported bugs and= proposed new features.=20 Pigsty thrives on community contributions. We warmly welcome your ideas, fe= ature requests, or patches. Please share your contributions on our [GitHub = page](https://github.com/Vonng/pigsty/). We look forward to your feedback o= n Pigsty 2.7 and your continued support in making Pigsty even better. Best regards, Ruohang Feng (@vonng), rh@vonng.com , The Pigsty Community --===============0296845401569792617== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Pigsty v2.7 Released, free RDS PG with 255 extensions available<= /title> <style> @media only screen and (max-width: 620px) { table[class=3Dbody] h1 { font-size: 28px !important; margin-bottom: 10px !important; } table[class=3Dbody] p, table[class=3Dbody] ul, table[class=3Dbody] ol, table[class=3Dbody] td, table[class=3Dbody] span, table[class=3Dbody] a { font-size: 16px !important; } table[class=3Dbody] .wrapper, table[class=3Dbody] .article { padding: 10px !important; } table[class=3Dbody] .content { padding: 0 !important; } table[class=3Dbody] .container { padding: 0 !important; width: 100% !important; } table[class=3Dbody] .main { border-left-width: 0 !important; border-radius: 0 !important; border-right-width: 0 !important; } table[class=3Dbody] .btn table { width: 100% !important; } table[class=3Dbody] .btn a { width: 100% !important; } table[class=3Dbody] .img-responsive { height: auto !important; max-width: 100% !important; width: auto !important; } } @media all { .ExternalClass { width: 100%; } .ExternalClass, .ExternalClass p, .ExternalClass span, .ExternalClass font, .ExternalClass td, .ExternalClass div { line-height: 100%; } .apple-link a { color: inherit !important; font-family: inherit !important; font-size: inherit !important; font-weight: inherit !important; line-height: inherit !important; text-decoration: none !important; } #MessageViewBody a { color: inherit; text-decoration: none; font-size: inherit; font-family: inherit; font-weight: inherit; line-height: inherit; } .btn-primary table td:hover { background-color: #34495e !important; } .btn-primary a:hover { background-color: #34495e !important; border-color: #34495e !important; } } </style> </head> <body class=3D"" style=3D"background-color: #f6f6f6; font-family: sans-se= rif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4= ; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adju= st: 100%;"> <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" class=3D"body" = style=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace= : 0pt; width: 100%; background-color: #f6f6f6;"> <tr> <td style=3D"font-family: sans-serif; font-size: 14px; vertical-ali= gn: top;"> </td> <td class=3D"container" style=3D"font-family: sans-serif; font-size= : 14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580= px; padding: 10px; width: 580px;"> <div class=3D"content" style=3D"box-sizing: border-box; display: = block; Margin: 0 auto; max-width: 580px; padding: 10px;"> <span class=3D"preheader" style=3D"color: transparent; display:= none; height: 0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden= ; mso-hide: all; visibility: hidden; width: 0;"></span> <table class=3D"main" style=3D"border-collapse: separate; mso-t= able-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: #ffffff; = border-radius: 3px;"> <tr> <td class=3D"wrapper" style=3D"font-family: sans-serif; fon= t-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;"> <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" s= tyle=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace:= 0pt; width: 100%;"> <tr> <td style=3D"font-family: sans-serif; font-size: 14px= ; vertical-align: top;"> <div> <h1 style=3D"color: #000; font-family: sans-serif; line-height: 1.4; margin= : 0; margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: ce= nter">Pigsty v2.7 Released, free RDS PG with 255 extensions available</h1> </div> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px">The <a href=3D"https://pigsty.io/" style=3D= "color: #3498db; text-decoration: underline">Pigsty</a> community is thrill= ed to announce Pigsty <a href=3D"https://github.com/Vonng/pigsty/releases/t= ag/v2.7.0" style=3D"color: #3498db; text-decoration: underline">v2.7.0</a>,= which has <a href=3D"https://pigsty.io/docs/reference/extension/" style=3D= "color: #3498db; text-decoration: underline">255</a> unique extensions avai= lable, to the free PostgreSQL distribution and RDS alternative. We also hav= e introduced some new docker-compose templates for <a href=3D"https://githu= b.com/Vonng/pigsty/tree/master/app/odoo" style=3D"color: #3498db; text-deco= ration: underline">Odoo</a>, <a href=3D"https://github.com/Vonng/pigsty/tre= e/master/app/jupyter" style=3D"color: #3498db; text-decoration: underline">= Jupyter</a>, <a href=3D"https://github.com/Vonng/pigsty/tree/master/app/pol= ardb" style=3D"color: #3498db; text-decoration: underline">PolarDB</a>, and= GA <a href=3D"https://github.com/Vonng/pigsty/tree/master/app/supabase" st= yle=3D"color: #3498db; text-decoration: underline">Supabase</a>.</p> <h2 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h= eight: 1.4; margin: 0; margin-bottom: 30px">About Pigsty</h2> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px">Pigsty is a Battery-included, local-first P= ostgreSQL Distribution as a Free RDS alternative.</p> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px"><strong>Links</strong>: <a href=3D"https://= pigsty.io/" style=3D"color: #3498db; text-decoration: underline">Website</a= > | <a href=3D"https://github.com/Vonng/pigsty" style=3D"color: #3498db; te= xt-decoration: underline">GitHub</a> | <a href=3D"https://demo.pigsty.cc/" = style=3D"color: #3498db; text-decoration: underline">Demo</a> | <a href=3D"= https://pigsty.io/blog" style=3D"color: #3498db; text-decoration: underline= ">Blog</a> | <a href=3D"https://pigsty.io/docs/setup/install/" style=3D"col= or: #3498db; text-decoration: underline">Install</a> | <a href=3D"https://p= igsty.io/docs/about/feature/" style=3D"color: #3498db; text-decoration: und= erline">Feature</a></p> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px"><strong>Images</strong>: <a href=3D"https:/= /pigsty.io/img/pigsty/banner.en.jpg" style=3D"color: #3498db; text-decorati= on: underline">Introduction</a> | <a href=3D"https://pigsty.io/img/pigsty/e= xtension.png" style=3D"color: #3498db; text-decoration: underline">Extensio= ns</a> | <a href=3D"https://pigsty.io/img/pigsty/ha.png" style=3D"color: #3= 498db; text-decoration: underline">Architecture</a> | <a href=3D"https://pi= gsty.io/img/pigsty/dashboard.jpg" style=3D"color: #3498db; text-decoration:= underline">Dashboards</a></p> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px"><a href=3D"https://pigsty.io/docs/setup/ins= tall/" style=3D"color: #3498db; text-decoration: underline">Getting Started= </a> with the latest <a href=3D"https://github.com/Vonng/pigsty/releases/ta= g/v2.7.0" style=3D"color: #3498db; text-decoration: underline">v2.7.0</a> r= elease with: <code>curl -L https://get.pigsty.cc/install | bash</code></p> <h2 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h= eight: 1.4; margin: 0; margin-bottom: 30px">Pigsty v2.7: Extension Overwhel= ming</h2> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px">I wrote a popular article last month - <a h= ref=3D"https://pigsty.io/blog/pg/pg-eat-db-world/" style=3D"color: #3498db;= text-decoration: underline"><em>Postgres is eating the database world</em>= </a>, explaining why extensions matter to the PostgreSQL ecosystem. </p> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px">Based on this idea, we've packaged <strong>= 20</strong> brand-new extensions in v2.7. With these extensions added, Pigs= ty offers <strong>157</strong> non-contrib extensions for <a href=3D"https:= //pigsty.io/docs/reference/extension/#rpm-extension" style=3D"color: #3498d= b; text-decoration: underline">EL Distros</a> and <strong>116</strong> for = <a href=3D"https://pigsty.io/docs/reference/extension/#deb-extension" style= =3D"color: #3498db; text-decoration: underline">Debian/Ubuntu Distros</a>. = Combined with <strong>73</strong> built-in <a href=3D"https://pigsty.io/doc= s/reference/extension/#contrib-extension" style=3D"color: #3498db; text-dec= oration: underline">Contrib extensions</a>, Pigsty now has a total of <stro= ng>255</strong> unique extensions available, which takes PostgreSQL's versa= tility to a whole new level!</p> <blockquote> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px"><a href=3D"https://pigsty.io/docs/reference= /extension/" style=3D"color: #3498db; text-decoration: underline">Complete = list of available extensions</a>: https://pigsty.io/docs/reference/extensio= n/</p> </blockquote> <h2 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h= eight: 1.4; margin: 0; margin-bottom: 30px">v2.7.0 Release Note</h2> <h3 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h= eight: 1.4; margin: 0; margin-bottom: 30px"><strong>Highlight</strong></h3> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px">Adding numerous new extensions written in <= code>rust</code> & <code>pgrx</code>:</p> <ul style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal;= margin: 0; margin-bottom: 15px"> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/paradedb/paradedb/tree/dev/pg_search" style=3D"color: #3498d= b; text-decoration: underline">pg_search</a> v0.7.0 : Full text search over= SQL tables using the BM25 algorithm</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/paradedb/paradedb/tree/dev/pg_lakehouse" style=3D"color: #34= 98db; text-decoration: underline">pg_lakehouse</a> v0.7.0 : Query engine ov= er object stores like S3 and table formats like Delta Lake</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/paradedb/pg_analytics" style=3D"color: #3498db; text-decorat= ion: underline">pg_analytics</a> v0.6.1 : Accelerates analytical query proc= essing inside Postgres</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/supabase/pg_graphql" style=3D"color: #3498db; text-decoratio= n: underline">pg_graphql</a> v1.5.4 : GraphQL support to your PostgreSQL da= tabase.</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/supabase/pg_jsonschema" style=3D"color: #3498db; text-decora= tion: underline">pg_jsonschema</a> v0.3.1 : PostgreSQL extension providing = JSON Schema validation</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/supabase/wrappers" style=3D"color: #3498db; text-decoration:= underline">wrappers</a> v0.3.1 : Postgres Foreign Data Wrappers Collection= s by Supabase</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/tembo-io/pgmq" style=3D"color: #3498db; text-decoration: und= erline">pgmq</a> v1.5.2 : A lightweight message queue. Like AWS SQS and RSM= Q but on Postgres.</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/tembo-io/pg_tier" style=3D"color: #3498db; text-decoration: = underline">pg_tier</a> v0.0.3 : Postgres Extension written in Rust, to enab= le data tiering to AWS S3</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/tembo-io/pg_vectorize" style=3D"color: #3498db; text-decorat= ion: underline">pg_vectorize</a> v0.15.0 : The simplest way to orchestrate = vector search on Postgres</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/tembo-io/pg_later" style=3D"color: #3498db; text-decoration:= underline">pg_later</a> v0.1.0 : Execute SQL now and get the results later= .</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/VADOSWARE/pg_idkit" style=3D"color: #3498db; text-decoration= : underline">pg_idkit</a> v0.2.3 : Generating many popular types of identif= iers</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/kaspermarstal/plprql" style=3D"color: #3498db; text-decorati= on: underline">plprql</a> v0.1.0 : Use PRQL in PostgreSQL</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/zhuobie/pgsmcrypto" style=3D"color: #3498db; text-decoration= : underline">pgsmcrypto</a> v0.1.0 : PostgreSQL SM Algorithm Extension</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/kelvich/pg_tiktoken" style=3D"color: #3498db; text-decoratio= n: underline">pg_tiktoken</a> v0.0.1 : OpenAI tiktoken tokenizer for Postgr= eSQL</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/rustprooflabs/pgdd" style=3D"color: #3498db; text-decoration= : underline">pgdd</a> v0.5.2 : Access Data Dictionary metadata with pure SQ= L</li> </ul> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px">And some new extensions in plain C & C+= +:</p> <ul style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal;= margin: 0; margin-bottom: 15px"> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/pgspider/parquet_s3_fdw" style=3D"color: #3498db; text-decor= ation: underline">parquet_s3_fdw</a> 1.1.0 : ParquetS3 Foreign Data Wrapper= for PostgreSQL</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/plv8/plv8" style=3D"color: #3498db; text-decoration: underli= ne">plv8</a> 3.2.2 : V8 Engine Javascript Procedural Language add-on for Po= stgreSQL</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/tvondra/md5hash" style=3D"color: #3498db; text-decoration: u= nderline">md5hash</a> 1.0.1 : Custom data type for storing MD5 hashes rathe= r than text</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/Percona-Lab/pg_tde" style=3D"color: #3498db; text-decoration= : underline">pg_tde</a> 1.0 alpha: Experimental encrypted access method for= PostgreSQL</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/df7cb/pg_dirtyread" style=3D"color: #3498db; text-decoration= : underline">pg_dirtyread</a> 2.6 : Read dead but unvacuumed tuples from a = PostgreSQL relation</li> <li style=3D"list-style-position: inside; margin-left: 5px">New deb PGDG ex= tensions: <code>pg_roaringbitmap</code>, <code>pgfaceting</code>, <code>mob= ilitydb</code>, <code>pgsql-http</code>, <code>pg_hint_plan</code>, <code>p= g_statviz</code>, <code>pg_rrule</code></li> <li style=3D"list-style-position: inside; margin-left: 5px">New rpm PGDG ex= tensions: <code>pg_profile</code>, <code>pg_show_plans</code>, use PGDG's <= code>pgsql_http</code>, <code>pgsql_gzip</code>, <code>pg_net</code>, <code= >pg_bigm</code> instead of Pigsty RPM. </li> </ul> <h3 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h= eight: 1.4; margin: 0; margin-bottom: 30px"><strong>New Features</strong></= h3> <ul style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal;= margin: 0; margin-bottom: 15px"> <li style=3D"list-style-position: inside; margin-left: 5px">Prepare arm64 p= ackages for infra & pgsql packages for el & deb distros.</li> <li style=3D"list-style-position: inside; margin-left: 5px">New installatio= n script to download from Cloudflare, and more hints.</li> <li style=3D"list-style-position: inside; margin-left: 5px">New monitoring = dashboard PGSQL PITR to assist the PITR procedure. </li> <li style=3D"list-style-position: inside; margin-left: 5px">Make preparatio= ns for running pigsty inside docker VM containers</li> <li style=3D"list-style-position: inside; margin-left: 5px">Add a <a href= =3D"https://github.com/Vonng/pigsty/issues/402" style=3D"color: #3498db; te= xt-decoration: underline">fool-proof design</a> for running pgsql.yml on a = node that is not managed by Pigsty</li> <li style=3D"list-style-position: inside; margin-left: 5px">Add separated t= emplate for each OS distro: el7, el8, el9, debian11, debian12, ubuntu20, ub= untu22</li> </ul> <h3 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h= eight: 1.4; margin: 0; margin-bottom: 30px"><strong>New Docker Application<= /strong></h3> <ul style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal;= margin: 0; margin-bottom: 15px"> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/Vonng/pigsty/tree/master/app/odoo" style=3D"color: #3498db; = text-decoration: underline">Odoo</a>: launch open-source ERP over PostgreSQ= L.</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/Vonng/pigsty/tree/master/app/jupyter" style=3D"color: #3498d= b; text-decoration: underline">Jupyter</a>: Run Jupyter notebook containers= and expose the HTTP service.</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/Vonng/pigsty/tree/master/app/polardb" style=3D"color: #3498d= b; text-decoration: underline">PolarDB</a>: run the demo playground for the= shared-storage version of OSS PG.</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/Vonng/pigsty/tree/master/app/supabase" style=3D"color: #3498= db; text-decoration: underline">supabase</a>: bump to the latest GA version= .</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/Vonng/pigsty/tree/master/app/bytebase" style=3D"color: #3498= db; text-decoration: underline">bytebase</a>: use the <code>latest</code> t= ag instead of the ad hoc version.</li> <li style=3D"list-style-position: inside; margin-left: 5px"><a href=3D"http= s://github.com/Vonng/pigsty/tree/master/app/pg_exporter" style=3D"color: #3= 498db; text-decoration: underline">pg_exporter</a>: update docker image exa= mple</li> </ul> <h3 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h= eight: 1.4; margin: 0; margin-bottom: 30px"><strong>Software Upgrade</stron= g></h3> <ul style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal;= margin: 0; margin-bottom: 15px"> <li style=3D"list-style-position: inside; margin-left: 5px"><strong>Postgre= SQL 16.3, 15.7, 14.12, 13.15, 12.19</strong></li> <li style=3D"list-style-position: inside; margin-left: 5px">Patroni 3.3.0</= li> <li style=3D"list-style-position: inside; margin-left: 5px">pgBackRest 2.51= </li> <li style=3D"list-style-position: inside; margin-left: 5px">vip-manager v2.= 5.0</li> <li style=3D"list-style-position: inside; margin-left: 5px">Haproxy 2.9.7</= li> <li style=3D"list-style-position: inside; margin-left: 5px">Grafana 10.4.2<= /li> <li style=3D"list-style-position: inside; margin-left: 5px">Prometheus 2.51= </li> <li style=3D"list-style-position: inside; margin-left: 5px">Loki & Prom= tail: 3.0.0 (breaking changes!)</li> <li style=3D"list-style-position: inside; margin-left: 5px">Alertmanager 0.= 27.0</li> <li style=3D"list-style-position: inside; margin-left: 5px">BlackBox Export= er 0.25.0</li> <li style=3D"list-style-position: inside; margin-left: 5px">Node Exporter 1= .8.0</li> <li style=3D"list-style-position: inside; margin-left: 5px">pgBackrest Expo= rter 0.17.0</li> <li style=3D"list-style-position: inside; margin-left: 5px">duckdb 0.10.2</= li> <li style=3D"list-style-position: inside; margin-left: 5px">etcd 3.5.13</li> <li style=3D"list-style-position: inside; margin-left: 5px">minio-202405100= 14138 / mcli-20240509170424</li> <li style=3D"list-style-position: inside; margin-left: 5px">pev2 v1.8.0 =E2= =86=92 v1.11.0</li> <li style=3D"list-style-position: inside; margin-left: 5px"><strong>pgvecto= r</strong> 0.6.1 =E2=86=92 0.7.0</li> <li style=3D"list-style-position: inside; margin-left: 5px">pg_tle: v1.3.4 = =E2=86=92 v1.4.0</li> <li style=3D"list-style-position: inside; margin-left: 5px">hydra: v1.1.1 = =E2=86=92 v1.1.2</li> <li style=3D"list-style-position: inside; margin-left: 5px">duckdb_fdw: v1.= 1.0 recompile with libduckdb 0.10.2</li> <li style=3D"list-style-position: inside; margin-left: 5px">pg_bm25 0.5.6 = =E2=86=92 pg_search 0.7.0</li> <li style=3D"list-style-position: inside; margin-left: 5px">pg_analytics: 0= .5.6 =E2=86=92 0.6.1</li> <li style=3D"list-style-position: inside; margin-left: 5px">pg_graphql: 1.5= .0 =E2=86=92 1.5.4</li> <li style=3D"list-style-position: inside; margin-left: 5px">pg_net 0.8.0 = =E2=86=92 0.9.1</li> <li style=3D"list-style-position: inside; margin-left: 5px">pg_sparse (depr= ecated due to pgvector 0.7)</li> </ul> <h3 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h= eight: 1.4; margin: 0; margin-bottom: 30px"><strong>Fixed Issues</strong></= h3> <ul style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal;= margin: 0; margin-bottom: 15px"> <li style=3D"list-style-position: inside; margin-left: 5px">Fix role pg_exp= orters white space in variable templates</li> <li style=3D"list-style-position: inside; margin-left: 5px">Fix <code>minio= _cluster</code> not commented in global variables</li> <li style=3D"list-style-position: inside; margin-left: 5px">Fix the non-exi= stent <code>postgis34</code> package name in the <code>el7</code> config te= mplate</li> <li style=3D"list-style-position: inside; margin-left: 5px">Fix EL8 <code>p= ython3.11-cryptography</code> deps to <code>python3-cryptography</code> acc= ording to upstream</li> <li style=3D"list-style-position: inside; margin-left: 5px">Fix <code>/pg/b= in/pg-role</code> can not get OS user name from environ in non-interact mod= e</li> <li style=3D"list-style-position: inside; margin-left: 5px">Fix <code>/pg/b= in/pg-pitr</code> can not hint <code>-X</code> <code>-P</code> flag properl= y</li> </ul> <h3 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h= eight: 1.4; margin: 0; margin-bottom: 30px"><strong>API Change</strong></h3> <ul style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal;= margin: 0; margin-bottom: 15px"> <li style=3D"list-style-position: inside; margin-left: 5px">New parameter <= code>node_write_etc_hosts</code> to control whether to write <code>/etc/hos= ts</code> file on target nodes.</li> <li style=3D"list-style-position: inside; margin-left: 5px">Relocatable pro= metheus target directory with new parameter <code>prometheus_sd_dir</code>.= </li> <li style=3D"list-style-position: inside; margin-left: 5px">Add <code>-x|--= proxy</code> flag to enable and use the value of global proxy env by @waiti= ngsong in https://github.com/Vonng/pigsty/pull/405</li> <li style=3D"list-style-position: inside; margin-left: 5px">No longer parse= infra nginx log details since it brings too many labels to the log.</li> <li style=3D"list-style-position: inside; margin-left: 5px">Use alertmanage= r API Version <code>v2</code> instead of <code>v1</code> in prometheus conf= ig.</li> <li style=3D"list-style-position: inside; margin-left: 5px">Use <code>/pg/c= ert/ca.crt</code> instead of <code>/etc/pki/ca.crt</code> in role <code>pgs= ql</code>.</li> </ul> <h2 style=3D"color: #000; font-family: sans-serif; font-weight: 400; line-h= eight: 1.4; margin: 0; margin-bottom: 30px">Acknowledgment</h2> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px">A huge thank you to all our users who contr= ibuted patches reported bugs and proposed new features. </p> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px">Pigsty thrives on community contributions. = We warmly welcome your ideas, feature requests, or patches. Please share yo= ur contributions on our <a href=3D"https://github.com/Vonng/pigsty/" style= =3D"color: #3498db; text-decoration: underline">GitHub page</a>. We look fo= rward to your feedback on Pigsty 2.7 and your continued support in making P= igsty even better.</p> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px">Best regards,</p> <p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; = margin: 0; margin-bottom: 15px">Ruohang Feng (@vonng), rh@vonng.com , The P= igsty Community</p> </td> </tr> </table> </td> </tr> </table> <div class=3D"footer" style=3D"clear: both; Margin-top: 10px; t= ext-align: center; width: 100%;"> <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" style= =3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt= ; width: 100%;"> <tr> <td class=3D"content-block" style=3D"font-family: sans-se= rif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-siz= e: 12px; color: #999999; text-align: center;"> <span class=3D"apple-link" style=3D"color: #999999; fon= t-size: 12px; text-align: center;"> This email was sent to you from Pigsty. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Pigsty. </span> <br><br> You were sent this email as a subscriber of the <em>pgsql-announce</em> mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit <a href=3D"https://lists.postgresql.org/unsubscribe/" style=3D"color: #3498= db; text-decoration: underline">https://lists.postgresql.org/unsubscribe/</= a>. </td> </tr> </table> </div> </div> </td> <td style=3D"font-family: sans-serif; font-size: 14px; vertical-ali= gn: top;"> </td> </tr> </table> </body> </html> --===============0296845401569792617==-- --===============5415213564296118892==--