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 g...@bx.psu.edu
___________________________________________________________ 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/
