devpi-postgresql: a PostgreSQL storage backend for devpi-server
Project description
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for devpi_postgresql-1.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 87fd55e71d927328f9868c9a99b039d27d7bf647b42e2aadb6000b979347a1f7 |
|
MD5 | c613ee57c9937e6625d57d60ec391743 |
|
BLAKE2b-256 | ebb79dd2ae1452224be5f578828dd17dbf963a98036ed4c4225aaee771e2abaf |