[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] README.development: extend PostgreSQL setup

[Holger Levsen]

Holger Levsen pushed to branch master at Debian QA / jenkins.debian.net


Commits:
576a8703 by Jelle van der Waa at 2019-06-14T10:39:44Z
README.development: extend PostgreSQL setup

Add more documentation about setting up the PostgreSQL database for
development.

Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -


1 changed file:

- README.development


Changes:

=====================================
README.development
=====================================
@@ -43,11 +43,25 @@ Additional, give user jenkins write access to the root $JENKINSGIT directory and
 
 ==== Database
 
-Get a recent copy of the database from:
+The reproducible build setup uses a PostgreSQL database to store the results, scheduling and status. The schema view here https://tests.reproducible-builds.org/reproducibledb.html
+
+Create a PostgreSQL database named 'reproducibledb' then either import a backup
+from tests.reproducible-builds.org:
+
 ----
 wget https://tests.reproducible-builds.org/reproducible.sql.xz
+xz -d reproducible.sql.xz
+psql reproducibledb < reproducible.sql
 ----
 
+Or create an empty database with only a bare schema:
+
+-----
+python3 bin/reproducible_db_maintenance.py
+-----
+
+If the database model changes, a migration should be created in the maintenance script called 'reproducible_db_maintenance.py'
+
 The database is kept using PostgreSQL and initialised by running /srv/jenkins/bin/reproducible_db_maintenance.py manually as the jenkins user.
 
 ==== Websites scripts



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/576a870310c4a1da678045dd73e602d01c10a3b3

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/576a870310c4a1da678045dd73e602d01c10a3b3
You're receiving this email because of your account on salsa.debian.org.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20190614/d794c62f/attachment.html>