ANTFARM/General/Commands

From Wikibooks, open books for an open world
Jump to navigation Jump to search

The following needs to be done in order to use the Postgresql database in Antfarm:

   sudo apt-get install postgresql postgresql-client postgresql-client-common postgresql-server-dev-8.3
   sudo su - postgres
   $ createuser <user name>
   Shall the new role be a superuser? (y/n) y
   $ exit

The user that you create will be the user who is associated with all of the antfarm files and must have permission to all Antfarm files, that is why they will be considered a superuser in this aspect.

For each environment used, the following commands are used to set up your database.

   createdb <environment name> (this only needs to be done once per environment)
   antfarm -e <environment name> db—migrate (this is used to create the tables)
   antfarm -e <environment name> db—reset (this is used to prepare the tables to be filled)