1 Initialising a dak database schema
2 ==================================
4 The following packages are needed:
5 * postgresql-9.0 postgresql-client-9.0 postgresql-plperl-9.0 postgresql-plpython-9.0 postgresql-9.0-debversion
7 (the schema assumes at least postgresql 9.0; ftpmaster in Debian currently uses
8 the squeeze postgresql 9.0 backport)
10 The following roles are assumed to exist:
11 * dak: database superuser: needs to be an actual user
12 * ftpmaster: role which should be given to archive administrators
13 * ftpteam: people who can do NEW processing, overrides, removals, etc
14 * ftptrainee: people who can add notes to packages in NEW
17 sudo -u postgres createuser -s dak
22 Create the additional roles:
23 createuser -S -R -D ftpmaster
24 createuser -S -R -D ftpteam
25 createuser -S -R -D ftptrainee
27 Create an empty database with SQL_ASCII encoding:
28 createdb -T template0 -E SQL_ASCII -O dak projectb
31 psql -f current_schema.sql -d projectb
33 TODO: Directory creation