X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=setup%2FREADME;h=1ea78ee3a8e4c753885409591a760010b99fcef3;hb=5d9f54ab9ea4652d2a97f1d2b3d152f20f664ab8;hp=b3a08fb39c96d76e43770082b98bc613a846d7cf;hpb=0ee90f4ef95923e4282ce776eea57dfe91fa6986;p=dak.git diff --git a/setup/README b/setup/README index b3a08fb3..1ea78ee3 100644 --- a/setup/README +++ b/setup/README @@ -1,8 +1,12 @@ Initialising a dak database schema ================================== -The following packages are needed: +The following packages are needed for the database: * postgresql-9.0 postgresql-client-9.0 postgresql-plperl-9.0 postgresql-plpython-9.0 postgresql-9.0-debversion +and the following packages for dak itself: + * python-psycopg2 python-sqlalchemy python-apt gnupg dpkg-dev lintian + binutils-multiarch python-yaml less python-ldap python-pyrss2gen python-rrdtool + symlinks python-debian (the schema assumes at least postgresql 9.0; ftpmaster in Debian currently uses the squeeze postgresql 9.0 backport) @@ -37,6 +41,9 @@ Create the additional roles: # createuser -S -R -D ftpmaster # createuser -S -R -D ftpteam # createuser -S -R -D ftptrainee +# psql -d projectb -c "ALTER GROUP ftpteam ADD USER ftpmaster" +# psql -d projectb -c "ALTER GROUP ftptrainee ADD USER ftpmaster" +# psql -d projectb -c "ALTER GROUP ftptrainee ADD USER ftpteam" Create an empty database with SQL_ASCII encoding: # createdb -T template0 -E SQL_ASCII -O dak projectb