From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits)) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id 17A6D158042 for ; Mon, 28 Oct 2024 13:49:12 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 929C2E07D9; Mon, 28 Oct 2024 13:49:06 +0000 (UTC) Received: from smtp.gentoo.org (woodpecker.gentoo.org [140.211.166.183]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 57FDEE07C9 for ; Mon, 28 Oct 2024 13:49:06 +0000 (UTC) Message-ID: <7eb6a37e-bd6a-434b-b97a-21eacdbed981@gentoo.org> Date: Mon, 28 Oct 2024 14:49:01 +0100 Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@lists.gentoo.org Reply-to: gentoo-dev@lists.gentoo.org X-Auto-Response-Suppress: DR, RN, NRN, OOF, AutoReply MIME-Version: 1.0 User-Agent: Mozilla Thunderbird To: gentoo-dev@lists.gentoo.org Content-Language: en-US From: Patrick Lauer Subject: [gentoo-dev] RFC: New PostgreSQL categories Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Archives-Salt: 82493eae-d349-40c4-85cd-1ed15f7e9da9 X-Archives-Hash: 2a9a63c5be2c1847ff40fb80a699cad1 Hello everyone, I've just returned from the pgconf.eu conference, and this has motivated me to try to improve the packaging situation for all things PostgreSQL in Gentoo. Right now everything just goes into dev-db/ category. That's not inherently wrong, but it feels a bit overloaded to me. So I'd like to add two new categories. I'm relatively indifferent about the naming, good suggestions welcome, but locally I ended up naming them "pg-tools" and "pg-extensions". As the name suggests, one category is tools around PostgreSQL, and the other is extensions. (Or maybe it makes sense to put all of it into a dev-postgres category?) A good amount of things are in-tree already, a lot of other things I've accumulated in a local repository. Most of it is very boring (i.e. most extensions 'just' use a plain Makefile) and has low rate of change. The packages involved are: - extensions, in-tree: dev-db/plr dev-db/pgrouting dev-db/citus dev-db/pgtap dev-db/postgis dev-db/slony1 dev-db/pglogical dev-db/timescaledb - extensions, new packages: pg-extensions/clickhouse_fdw | Clickhouse ForeignDataWrapper for PostgreSQL pg-extensions/icu_ext | An extension to expose functionality from ICU to PostgreSQL applications. pg-extensions/lantern | Vector similarity search for Postgresql pg-extensions/mongo_fdw | MongoDB foreign data wrapper for Postgresql pg-extensions/mysql_fdw | MySQL/MariaDB foreign data wrapper for Postgresql pg-extensions/odbc_fdw | ODBC FDW for PostgreSQL pg-extensions/pg_auto_failover | Monitors and manage automated failover for Postgres clusters pg-extensions/pg_crash | Reliably crash PostgreSQL pg-extensions/pg_cron | simple cron-based job scheduler for PostgreSQL pg-extensions/pg_embedding | Hierarchical Navigable Small World (HNSW) for vector similarity search pg-extensions/pg_failover_slots | Failover for replication slots pg-extensions/pg_globalxact | tools for distributed transactions within PostgreSQL pg-extensions/pg_hint_plan | tweak PostgreSQL execution plans with hints pg-extensions/pg_ivm | Incremental View Maintenance for PostgreSQL pg-extensions/pg_jobmon | Autonomous logging capabilities for PostgreSQL transactions/functions pg-extensions/pg_partman | PostgreSQL Partition Manager pg-extensions/pg_profile | find the most resource intensive activities in PostgreSQL pg-extensions/pg_qualstats | statistics on predicates found in WHERE statements and JOIN clauses pg-extensions/pg_stat_kcache | Gathers statistics about real reads and writes done by the filesystem layer pg-extensions/pg_wait_sampling | sampling based statistics of wait events in PostgreSQL pg-extensions/pgfaceting | Vector similarity search for Postgresql pg-extensions/pgroonga | Fast FullTextSearch for PostgreSQL pg-extensions/pgsphere | PostgreSQL extension for spherical geometry pg-extensions/pgsql-ogr-fdw | OGR FDW for PostgreSQL pg-extensions/pgvector | Vector similarity search for Postgresql pg-extensions/pgvectorscale | enhanced ML/vector extension pg-extensions/pllua | Embeds Lua into PostgreSQL as a procedural language module. pg-extensions/postgres-tde-ext | experimental encrypted access method pg-extensions/postgresql-unit | SI Units for PostgreSQL pg-extensions/rum | RUM access method pg-extensions/tds_fdw | TabularDataStream foreign data wrapper The tools are: - in tree: dev-db/barman dev-db/pg_top dev-db/pgagent dev-db/pgbouncer dev-db/pgcli dev-db/pgmodeler dev-db/pgpool2 dev-db/pgxnclient dev-db/phppgadmin dev-db/pspg dev-db/psqlodbc dev-db/repmgr dev-db/slony1 - new packages: pg-tools/patroni | PostgreSQL HA with ZooKeeper, etcd or Consul pg-tools/pg_catcheck | Postgres system catalog check tool pg-tools/pg_checksums_ext | Postgres data checksum tool pg-tools/pg_timetable | Advanced scheduling for PostgreSQL pg-tools/pgbackrest | Simple, reliable, scalable backup solution to postgres pg-tools/pgcopydb | Postgres DB copy tool pg-tools/pgloader | loads data into PostgreSQL pg-tools/pgroll | Zero-downtime, reversible, schema migrations for Postgres pg-tools/sqlpage | A SQL-only web application framework. Takes .sql files and formats the query result using pre-made configurable professional-looking components. pg-tools/vip-manager | Manages a virtual IP based on state kept in etcd or Consul pg-tools/wal-g | archival restoration tool for PostgreSQL, MySQL/MariaDB, and MS SQL Server Have fun, Patrick