On Dec 7, 2012, at 6:05 PM, Coldren, Christopher D wrote:

> 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

Hi Chris,

You're a field off in your URL, try this:

postgres://galaxy_prod_role4:milkweed@127.0.0.1:5432/galaxy_prod4

--nate

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


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

Reply via email to