BSD Ports

databases/postgresql-plproxy 2.10.0 MidnightBSD

Function-based sharding for PostgreSQL

System
MidnightBSD
Repository
mports
Maintainer
[email protected]
Port added
Last update
Commit
29f48d9a2a
License
iscl
Categories
databases

Description

PL/Proxy is a PostgreSQL procedural language (PL) handler that allows to do remote procedure calls between PostgreSQL databases, with optional sharding.

PL/Proxy was developed in Skype as a scalability solution for PostgreSQL database. At first it was very thin PL component that connected to C++ server that handled all sharding decisions. This proved to be too complex setup and in version 2 it was re-written to current archtecture of PL that handles sharding and generic pooler process (PgBouncer) that is able to handle large amount of standard PostgreSQL connections that the PL makes.

In the other systems

SystemPortVersion
MidnightBSDdatabases/postgresql-plproxy2.10.0
FreeBSDdatabases/postgresql-plproxy2.12.0
DragonFlydatabases/postgresql-plproxy2.10.0
HardenedBSDdatabases/postgresql-plproxy2.12.0
GhostBSDdatabases/postgresql-plproxy2.11.0

Install

Binary package:

mport install postgresql-plproxy

From mports:

cd /usr/mports/databases/postgresql-plproxy && make install clean

To depend on this port in another port's Makefile:

RUN_DEPENDS=	postgresql-plproxy>0:databases/postgresql-plproxy

Dependencies

No port depends on this one.

Configuration

No options to configure.

USES
bison gmake pgsql
Service scripts
none

Files

pkg-plist 10
  • lib/postgresql/plproxy.so
  • share/postgresql/extension/plproxy--2.10.0.sql
  • share/postgresql/extension/plproxy--2.3.0--2.10.0.sql
  • share/postgresql/extension/plproxy--2.4.0--2.10.0.sql
  • share/postgresql/extension/plproxy--2.5.0--2.10.0.sql
  • share/postgresql/extension/plproxy--2.6.0--2.10.0.sql
  • share/postgresql/extension/plproxy--2.7.0--2.10.0.sql
  • share/postgresql/extension/plproxy--2.8.0--2.10.0.sql
  • share/postgresql/extension/plproxy--2.9.0--2.10.0.sql
  • share/postgresql/extension/plproxy.control
distinfo 1
FileSizeSHA256
plproxy-2.10.0.tar.gz776532b7eac566bb476fb73185951d1d73c1255c027013d3d9670f8ac7dbe55c4560d
Master sites 1
  • https://plproxy.github.io/downloads/files/2.10.0/

Commit history 2

DateCommitCreditsLog message
29f48d9a2a Lucas Holt databases/postgresql-plproxy: fix fake-stage strip path (#1516)
Fix Magus run 648 failure for port ID 2261554. Avoid applying the staging root twice in post-install. Validation: patch, build, fake, and package completed; git diff --check passed. Portlint: no fatal errors. ## Summary by Sourcery Bug Fixes: - Correct the post-install stripping path for the PostgreSQL PL/Proxy shared library to prevent the staging root from being applied twice during fake-stage packaging. Signed-off-by: Lucas Holt <[email protected]>
43c28f8bd0 Lucas Holt Add PostgreSQL 15-18 ports and update database ports
Import the missing PostgreSQL version families and extensions, extend pgsql version selection, and update PostgreSQL 14, JDBC, and libpqxx. AI-Assisted-by: OpenAI Codex <[email protected]> Signed-off-by: Lucas Holt <[email protected]>