Index: head/databases/postgresql-plproxy/Makefile =================================================================== --- head/databases/postgresql-plproxy/Makefile (revision 470228) +++ head/databases/postgresql-plproxy/Makefile (revision 470229) @@ -1,29 +1,25 @@ # Created by: Sergey Skvortsov # $FreeBSD$ PORTNAME= plproxy DISTVERSIONPREFIX= ${PORTNAME}_ DISTVERSION= 2_8 CATEGORIES= databases PKGNAMEPREFIX= postgresql- -MAINTAINER= ports@FreeBSD.org -COMMENT= PL/Proxy - database partitioning system +MAINTAINER= sunpoet@FreeBSD.org +COMMENT= PL/Proxy - Function-based sharding for PostgreSQL LICENSE= ISCL LICENSE_FILE= ${WRKSRC}/COPYRIGHT USES= bison gmake pgsql - USE_GITHUB= yes -.include - post-patch: - @${REINPLACE_CMD} -e \ - '/^#ifdef/s| SYS_| HAVE_SYS_|' ${WRKSRC}/src/execute.c + @${REINPLACE_CMD} -e '/^#ifdef/ s| SYS_| HAVE_SYS_|' ${WRKSRC}/src/execute.c post-install: ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/plproxy.so -.include +.include Index: head/databases/postgresql-plproxy/pkg-descr =================================================================== --- head/databases/postgresql-plproxy/pkg-descr (revision 470228) +++ head/databases/postgresql-plproxy/pkg-descr (revision 470229) @@ -1,8 +1,11 @@ -PL/Proxy is a proxy language used for remote database procedure calls -and data partitioning between databases based on hashing field values. +PL/Proxy is a PostgreSQL procedural language (PL) handler that allows to do +remote procedure calls between PostgreSQL databases, with optional sharding. -Main idea is that proxy function will be created with same signature as -remote function to be called, so only destination info needs to be -specified inside proxy function body. +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. WWW: https://plproxy.github.io/