pgserver

What it is and what it does

pgserver packages PostgreSQL binaries and the pgvector extension into a pip-installable Python package, letting you ship database-backed applications without requiring users to install PostgreSQL separately. It handles cross-platform binary distribution (macOS, Linux, Windows) and provides Python convenience methods to initialize, start, and manage the server lifecycle—including edge cases like running in Docker, on machines without root access, or in Google Colab.

The package wraps low-level PostgreSQL tools (initdb, pg_ctl, psql, pg_config) and manages process cleanup automatically: when your application exits, the server shuts down, and if multiple processes share the same data directory, the server stays alive until the last process ends. This makes it practical for both production applications and test fixtures.

Use it for

• Ship a Python application with embedded PostgreSQL so end users need only `pip install` your app, with no separate database setup.
• Quickly prototype or develop a Postgres-backed application locally without installing system PostgreSQL.
• Run integration tests in pytest with temporary, isolated PostgreSQL instances that clean up automatically.
• Deploy Python applications in containerized environments (Docker, Kubernetes) where you want to avoid separate database services.
• Build RAG (retrieval-augmented generation) applications that use pgvector for vector similarity search without external dependencies.

Worth the install?

AI-flagged interpretation of the facts on this page. Verify before relying on it.

Install

pgserver on PyPI

Before you install

Medium install friction due to platform-specific compiled wheels (cp39–cp312 across macOS, Linux, Windows). Dormant maintenance status: last release 2024-06-08, no commits since then, though the repository remains active and has 100 stars. Three lightweight runtime dependencies (fasteners, platformdirs, psutil) add minimal overhead.

Requires Python >=3.9. On systems with an existing PostgreSQL server on the default port, pgserver will handle port conflicts, but verify your environment does not have permission restrictions that prevent running a second database instance.

License in practice

License treatment is unclear—no SPDX identifier or raw license text provided. Verify the actual license before using in proprietary or copyleft-sensitive projects.

Quickstart

import pgserver

db = pgserver.get_server('/path/to/pgdata')
db.psql('create extension vector')
db_uri = db.get_uri()
# Use db_uri with sqlalchemy or psycopg

Package facts

Evidence: pgserver-0.1.4-cp310-cp310-macosx_10_9_x86_64.whl; pgserver-0.1.4-cp310-cp310-macosx_11_0_arm64.whl; pgserver-0.1.4-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl; pgserver-0.1.4-cp310-cp310-win_amd64.whl; pgserver-0.1.4-cp311-cp311-macosx_10_9_x86_64.whl; pgserver-0.1.4-cp311-cp311-macosx_11_0_arm64.whl; pgserver-0.1.4-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl; pgserver-0.1.4-cp311-cp311-win_amd64.whl; pgserver-0.1.4-cp312-cp312-macosx_10_9_x86_64.whl; pgserver-0.1.4-cp312-cp312-macosx_11_0_arm64.whl; pgserver-0.1.4-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl; pgserver-0.1.4-cp312-cp312-win_amd64.whl; pgserver-0.1.4-cp39-cp39-macosx_10_9_x86_64.whl; pgserver-0.1.4-cp39-cp39-macosx_11_0_arm64.whl; pgserver-0.1.4-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl; pgserver-0.1.4-cp39-cp39-win_amd64.whl

Tags

More Database packages

See also pg0-embedded · vecs · pgvector · PyPgConfig · llama-index-vector-stores-postgres · apache-airflow-providers-pgvector · py-pglite · pgvecto-rs · pgdb · etcd-distro