Hi All, I want to use postgresql instead of sqlite, and below is how I did the settings:
I am running Galaxy under the user ubuntu, so first I create the ubuntu user sudo -u postgres createuser -D -A -P ubuntu Then I create the database named galaxy_db sudo -u postgres createdb -O ubuntu galaxy_db in Galaxy configuration file, use postgresql postgres:///galaxy_db?user=ubuntu&host=/var/run/postgresql When I start Galaxy, sqlite dialect, not postgresql is selected. I am pasting part of the log below: galaxy.model.migrate.check DEBUG 2012-04-23 17:59:52,676 pysqlite>=2 egg successfully loaded for sqlite dialect galaxy.model.migrate.check INFO 2012-04-23 17:59:52,707 At database version 93 galaxy.tool_shed.migrate.check DEBUG 2012-04-23 17:59:52,718 pysqlite>=2 egg successfully loaded for sqlite dialect galaxy.tool_shed.migrate.check INFO 2012-04-23 17:59:52,730 At migrate_tools version 1 galaxy.model.custom_types DEBUG 2012-04-23 17:59:52,735 pysqlite>=2 egg successfully loaded for sqlite dialect Is there anything wrong with my configuration? Thank you. Cai ___________________________________________________________ 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/
