# Dspace-postgres-pgcrypto

Dspace-postgres-pgcrypto is a PostgreSQL database container image for DSpace that preloads the pgcrypto extension to protect sensitive digital collection metadata in self-hosted DSpace installations. It is open source and self-hosted, installable on Docker Hub.

Canonical page: https://ourlocalhost.com/app/5375/dspace-postgres-pgcrypto

## Description

Dspace-postgres-pgcrypto is a PostgreSQL database container image for DSpace that preloads the pgcrypto extension to protect sensitive digital collection metadata in self-hosted DSpace installations.

## Platform availability

Available on 0 of 10 platforms.

## Health score

69/100 (Good), based on 4 of 4 factors.
- Maintained: 100 (last commit 17 days ago)
- Popular: 61 (1,107 GitHub stars)
- Easy to install: 25 (0 install platforms, install notes, Docker image)
- Light to run: 60 (2 GB minimum RAM, runs on ARM)

## Links

- Docker Hub: https://hub.docker.com/r/dspace/dspace-postgres-pgcrypto
- GitHub: https://github.com/DSpace/DSpace
- Official website: https://wiki.lyrasis.org/spaces/DSDOC10x/

## Common questions

### How do I fix the DSpace 7.4 error saying the pgcrypto extension is not installed?

Run CREATE EXTENSION pgcrypto in the DSpace database, and make sure the connection search_path includes the pgcrypto extension. Without that search_path setting, the command alone will not work.

### Can DSpace run without pgcrypto if I use Postgres 13 or newer?

The source does not give a final answer. It calls for testing whether DSpace can work out of the box without pgcrypto on Postgres 13+, or whether DSpace code needs to be fixed to support removing it.

### For self-hosted Postgres using pgcrypto, should the database extension or the application handle encryption?

It depends on your threat model and any regulations you must meet. One view is that pgcrypto can be clunky and that the application should handle encryption and decryption using Fernet or libsodium bindings.

---
Source: Our Local Host (https://ourlocalhost.com/app/5375/dspace-postgres-pgcrypto), the self-hosted and open-source app directory.
