X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=setup%2FREADME;h=1ea78ee3a8e4c753885409591a760010b99fcef3;hb=5d9f54ab9ea4652d2a97f1d2b3d152f20f664ab8;hp=9d5103c19e4ef8e043ef5d7cbb2c676a12cd9911;hpb=0ca34d3d3ba917f3a1b1573534589da1fac25306;p=dak.git

diff --git a/setup/README b/setup/README
index 9d5103c1..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,12 +41,16 @@ 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
 
-Import the schema:
-# psql -f current_schema.sql -d projectb
+Import the schema.  We redirect STDOUT to /dev/null as otherwise it's
+impossible to see if something fails.
+# psql -1 -f current_schema.sql -d projectb >/dev/null
 
 Set up some core data in projectb to get started (read the init_vars file if
 you wish to customise various aspects):