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:
Greg Von Kuster Galaxy Development Team greg@bx.psu.edu