dannon.ba...@gmail.com
To: Paniagua, Eric epani...@cshl.edu
Cc: galaxy-dev@lists.bx.psu.edu galaxy-dev@lists.bx.psu.edu
Subject: Re: [galaxy-dev] Problem using Galaxy with a PostgreSQL
database on a remote host
Message-ID:
cagn_wzn7wkihvyidhlovl0j4cbu_xeem02n1fkggo8bcnyc...@mail.gmail.com
Hey Eric,
It looks like you have connection info for both tcp/ip connections and unix
sockets in the connection strings. If you're logging in using psql -h
wigserv5.cshl.edu snip, then you only want the tcp/ip connection info.
Drop the ?host=tmp off the third option you listed and I think
is now completely empty. Have you ever seen this before?
Thanks,
Eric
From: Dannon Baker [dannon.ba...@gmail.com]
Sent: Tuesday, May 27, 2014 7:40 AM
To: Paniagua, Eric
Cc: galaxy-dev@lists.bx.psu.edu
Subject: Re: [galaxy-dev] Problem using Galaxy with a PostgreSQL
On Tue, May 27, 2014 at 11:26 AM, Paniagua, Eric epani...@cshl.edu wrote:
Thanks for pointing that out! I missed it. I am now connecting to the
remote database. I ran sh manage_db.sh upgrade and it upgraded from
schema 114 to 118 without error messages. I then ran sh
in...
From: Dannon Baker [dannon.ba...@gmail.com]
Sent: Tuesday, May 27, 2014 11:43 AM
To: Paniagua, Eric
Cc: galaxy-dev@lists.bx.psu.edu
Subject: Re: [galaxy-dev] Problem using Galaxy with a PostgreSQL database on a
remote host
On Tue, May 27, 2014 at 11:26 AM, Paniagua
in...
From: Dannon Baker [dannon.ba...@gmail.com]
Sent: Tuesday, May 27, 2014 11:43 AM
To: Paniagua, Eric
Cc: galaxy-dev@lists.bx.psu.edu
Subject: Re: [galaxy-dev] Problem using Galaxy with a PostgreSQL database
on a remote host
On Tue, May 27, 2014 at 11:26 AM, Paniagua
@lists.bx.psu.edu
Subject: Re: [galaxy-dev] Problem using Galaxy with a PostgreSQL database on a
remote host
On Tue, May 27, 2014 at 11:26 AM, Paniagua, Eric
epani...@cshl.edumailto:epani...@cshl.edumailto:epani...@cshl.edumailto:epani...@cshl.edu
wrote:
Thanks for pointing that out! I missed it. I am now
: galaxy-dev@lists.bx.psu.edu
Subject: RE: [galaxy-dev] Problem using Galaxy with a PostgreSQL database on a
remote host
I have created a fresh dump with
$ pg_dump -U galaxyprod galaxyprod
This time the import proceeded cleanly.
Further, using PostgreSQL 9.1, I no longer get the error regarding
Dear Galaxy Developers,
I've been banging my head against this one for a few days now.
I have two Galaxy instances. One resides on a server called genomics, which
also hosts the corresponding PostgreSQL installation. The second also resides
on genomics, but its database is hosted on