[galaxy-dev] Postgres renaming to postgresql

2013-07-17 Thread Nikos Sidiropoulos
Hi all After updating to the last stable galaxy when I'm trying to upgrade the database I'm getting the following message: /steno-internal/projects/galaxy/galaxy-dist/eggs/SQLAlchemy-0.7.9-py2.6-linux-x86_64-ucs4.egg/sqlalchemy/engine/url.py:105: SADeprecationWarning: The SQLAlchemy PostgreSQL

Re: [galaxy-dev] postgres connection

2012-12-10 Thread Coldren, Christopher D
That worked perfectly! Thanks Nate! Chris Galaxy dev: I'm installing a local galaxy instance (Dec 4, 2012 vintage) and it is running well under mySQL, but I'm having trouble getting it to work with a postgres database. I've done the following to create the db and provide

[galaxy-dev] postgres connection

2012-12-07 Thread Coldren, Christopher D
Galaxy dev: I'm installing a local galaxy instance (Dec 4, 2012 vintage) and it is running well under mySQL, but I'm having trouble getting it to work with a postgres database. I've done the following to create the db and provide permissions: $ whoami galaxy $ createdb galaxy_prod4 $ psql

Re: [galaxy-dev] postgres

2012-03-09 Thread christin weinberg
Hi, thanks for the answer. I have one more question. Is there one main table (in the database), which creates one key for one job and this key is allocated over other tables? Thank you! Best, Christin Am 08.03.2012 16:40, schrieb Björn Grüning: Hi Christin, I would like to clarify

Re: [galaxy-dev] postgres

2012-03-09 Thread Dannon Baker
Yes, see the table 'job'. You may or may not find this helpful, but here's a big database schema from our wiki: http://wiki.g2.bx.psu.edu/DataModel?action=AttachFiledo=viewtarget=galaxy_schema.png -Dannon On Mar 9, 2012, at 8:00 AM, christin weinberg wrote: Hi, thanks for the answer. I

Re: [galaxy-dev] postgres

2012-03-08 Thread Björn Grüning
Hi Christin, I would like to clarify whether we have understood something about the database correctly. Is is right that all calculations with galaxy are stored as a link in the database. And the data are stored somewhereelse? Yes, kind of :) Is it possible to store the data only in the

[galaxy-dev] postgres user change problem

2012-01-20 Thread Holger Klein
Dear all, due to some work on the user management of our servers we had to rename the user galaxy runs as. Up to now we used ident as postgres authentication method, meaning that here postgres expects unix username galaxy to have permissions of galaxy postgres user. The entry in