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

--------------+----------+----------+-------------+-------------+------------------------------

: galaxy=CTc/galaxy

: galaxy_prod_role=CTc/galaxy

: galaxy=CTc/galaxy

: galaxy_prod_role4=CTc/galaxy

: postgres=CTc/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: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.