Luciano,

You only need to create the database instance itself, you do not need to manually create any tables.  When you have created the database instance, configure the path to it using the database_connection setting in universe_wsgi.ini, something like:

database_connection = postgres:///galaxy_dbt?user=postgres&password=postgres

This is all you need to do.  Then start up the Galaxy server with:

sh run.sh

and Galaxy will automatically create all of the necessary tables for you.

Greg Von Kuster

On Oct 20, 2011, at 7:44 PM, Luciano Cosme wrote:

Hi,
   I am sorry about the trivial questions. I am following this guide http://wiki.g2.bx.psu.edu/Admin/Config/Upload%20via%20FTP to set up a ftp server to upload data to my local instance of galaxy. I am getting a error when I am configuring the database server:

postgres@aedes:~$ createuser -SDR galaxyftp
postgres@aedes:~$ psql galaxydb
psql (9.1.1)
Type "help" for help.

galaxydb=# ALTER ROLE galaxyftp PASSWORD 'dbpassword';
ALTER ROLE
galaxydb=# GRANT SELECT ON galaxy_user TO galaxyftp;
ERROR:  relation "galaxy_user" does not exist
galaxydb=#


It might be something pretty simple, but I am new to it and any help will be appreciated. I create the user galaxy_user already.

Thank you.
Luciano

___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:

 http://lists.bx.psu.edu/

Greg Von Kuster

Galaxy Development Team

greg@bx.psu.edu