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 galaxy_prod4
psql (8.4.13)
Type "help" for help.
galaxy_prod4=# CREATE ROLE galaxy_prod_role4 WITH PASSWORD 'milkweed';
CREATE ROLE
galaxy_prod4=# GRANT ALL PRIVILEGES ON DATABASE galaxy_prod4 to
galaxy_prod_role4;
GRANT
galaxy_prod4=# ALTER ROLE galaxy_prod_role4 LOGIN;
ALTER ROLE
galaxy_prod4=# \du
List of roles
Role name | Attributes | Member of
-------------------+--------------+-----------
galaxy | Superuser | {}
: Create role
: Create DB
galaxy_prod_role | Cannot login | {}
galaxy_prod_role4 | | {}
mydb_role | Cannot login | {}
mydb_user | | {}
postgres | Superuser | {}
: Create role
: Create DB
galaxy_prod4=# \l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access
privileges
--------------+----------+----------+-------------+-------------+------------------------------
galaxy_prod3 | galaxy | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/galaxy
:
galaxy=CTc/galaxy
:
galaxy_prod_role=CTc/galaxy
galaxy_prod4 | galaxy | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/galaxy
:
galaxy=CTc/galaxy
:
galaxy_prod_role4=CTc/galaxy
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
:
postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
:
postgres=CTc/postgres
(5 rows)
Looks promising, right?
My universe_wsgi.ini has the following entry:
database_connection =
postgres:///galaxy_prod_role4:milkweed@127.0.0.1:5432/galaxy_prod4
and started the application, but it failed with:
OperationalError: (OperationalError) FATAL: database
"galaxy_prod_role4:milkweed@127.0.0.1<mailto:milkweed@127.0.0.1>:5432/galaxy_prod4"
does not exist
commenting the database_connection line out allows galaxy to start, using mySQL
I presume. Any ideas? This is my first time configuring something like this.
Thank you!
Chris
___________________________________________________________
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/
