# 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/