Setting up your PostgreSQL server

With the release of version 4.0 we no longer ship the database in a container. Instead customers should use their own instance of Postgres to host the database.

Getting the latest version of the CSD Database

Contact support@ccdc.cam.ac.uk for assistance in getting the postgres database / databases you need. They will be able to provide you with a link to download the databases to your infrastructure.

Restore database

Restore the databases you have downloaded into your new environment:

pg_restore -C -d <<database name>> < downloaded_database_name.dump

If you are unable to perform a database backup as described above, please contact support@ccdc.cam.ac.uk for assistance.

Point services to use the postgres databases

The best way to do this is to update the .env file as part of your installation. The connection string is held within the CSD_DB_CONNECTIONSTRING parameter.

CSD_DB_CONNECTIONSTRING=Server=database-server;Port=5432;Database=csd-database;User Id=postgres;Password=passwordhere