Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

devpi-postgresql: a PostgreSQL storage backend for devpi-server

Project Description

devpi-postgresql: a PostgreSQL storage backend for devpi-server

Warning

This plugin is considered experimental!

This plugin adds a PostgreSQL storage backend for devpi-server.

Installation

devpi-postgresql needs to be installed alongside devpi-server.

You can install it with:

pip install devpi-postgresql

Usage

When using the PostgreSQL storage, devpi-server expects an empty database. You have to create one like this: createdb devpi Depending on your PostgreSQL setup you have to create a user and grant it permissions on the new database like this:

CREATE ROLE devpi WITH LOGIN;
GRANT CREATE, CONNECT ON DATABASE devpi TO devpi;

Upon first initialization of devpi-server use --storage pg8000 to select the PostgreSQL backend.

By default it’ll use the devpi database on localhost port 5432. To change that, use storage pg8000:host=example.com,port=5433,database=devpi_prod. The possible settings are: database, host, port, unix_sock, user and password

All user/index files and metadata of devpi-server are stored in the database. A few things and settings are still stored as files in the directory specified by --serverdir.

Plugins like devpi-web don’t or can’t use the storage backend. They still handle their own storage.

Changelog

0.2.0 (2018-01-17)

Bug Fixes

  • Use advisory locks to serialize writes.

0.1.1 (2017-12-12)

  • Add unix_sock, user and password to possible connection options. Thanks to Szabolcs Rumi for the patch.

0.1.0 (2016-02-11)

  • initial release

Release History

This version
History Node

0.2.0

History Node

0.1.1

History Node

0.1.0

Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, Size & Hash SHA256 Hash Help File Type Python Version Upload Date
devpi_postgresql-0.2.0-py2.py3-none-any.whl
(9.3 kB) Copy SHA256 Hash SHA256
Wheel 2.7 Jan 17, 2018
devpi-postgresql-0.2.0.tar.gz
(7.2 kB) Copy SHA256 Hash SHA256
Source None Jan 17, 2018

Supported By

Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Google Google Cloud Servers DreamHost DreamHost Log Hosting