devpi-postgresql 1.0.0

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

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

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

Requirements

At least PostgreSQL 9.5 is required for ON CONFLICT support.

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

1.0.0 (2019-04-26)

Deprecations and Removals

• Requires at least PostgreSQL 9.5 for ON CONFLICT support.

• Dropped support for Python 2.x and PyPy2.

0.3.0 (2018-09-08)

Bug Fixes

• Fixes required for bug fixes devpi-server 4.7.0.

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