Hi Cal, Did you comment out this line?
# By default, Galaxy uses a SQLite database found here #database_file = database/universe.sqlite Also, I assume you following reference: > in Galaxy configuration file, use postgresql > postgres:///galaxy_db?user=ubuntu&host=/var/run/postgresql actually looks like this in your config file: database_connection = postgres:///galaxy_db?user=ubuntu&host=/var/run/postgresql Greg Von Kuster On Apr 23, 2012, at 2:03 PM, zhengqiu cai wrote: > 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/
___________________________________________________________ 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/
