Content-Type: multipart/alternative; boundary="_000_2C84FA4CA630AD43BD2D247BD978355543B85C81YUWEXCPM24yuadu_" --_000_2C84FA4CA630AD43BD2D247BD978355543B85C81YUWEXCPM24yuadu_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Susan, I don't run PostgresSQL, but an example in the driver lists URL as jdbc:postgresql: //localhost:5432/testdb (note that the last separator is a slash, not a colon). HTH, -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Harold & Muriel Block Institute for Clinical & Translational Research at Ei= nstein and Montefiore Albert Einstein College of Medicine 1300 Morris Park Ave, Bronx, NY 10461 (718) 430-2440 (Mo, Tu, Th, Fr) (718) 920-4885 (We) [cid:12484356-C28B-4ABB-97E2-62B3475CF0CB] From: Susan Cassidy [mailto:susan.cassidy@decisionsciencescorp.com] Sent: Friday, January 17, 2014 5:30 PM To: squirrel-sql-users@lists.sourceforge.net Subject: [Squirrel-sql-users] Connecting to Postgres; getting "Unable to cr= eate connection. Check your URL." I have set up an alias like this: jdbc:postgresql://localhost:5432:testdb But I get Unable to create connection. Check your URL. If I just run psql from the command-line, it works fine. This is Scientific Linux. Any ideas? I've also tried using the IP address of the system, with the sa= me result. Thanks in advance for any advice. I am very new to Squirrel, just trying t= o get started. Susan --_000_2C84FA4CA630AD43BD2D247BD978355543B85C81YUWEXCPM24yuadu_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Susan,<= /p>

I don’t run Postgre= sSQL, but an example in the driver lists URL as

 <= /p>

jdbc:postgresql: //localh= ost:5432/testdb

 <= /p>

(note that the last separ= ator is a slash, not a colon).

HTH,

--

Alexandre Peshansky, MS

Senior Bioinformatics Ana= lyst, Research Informatics Core (RIC)

Harold & Muriel Block I= nstitute for Clinical & Translational Research at Einstein and Montefio= re

Albert Einstein College o= f Medicine

1300 Morris Park Ave, Bro= nx, NY 10461

(718) 430-2440 (Mo, Tu, T= h, Fr)  (718) 920-4885 (We)

 <= /p>

From: Susan Ca= ssidy [mailto:susan.cassidy@decisionsciencescorp.com]
Sent: Friday, January 17, 2014 5:30 PM
To: squirrel-sql-users@lists.sourceforge.net
Subject: [Squirrel-sql-users] Connecting to Postgres; getting "= Unable to create connection. Check your URL."

 

I have set up an alia= s like this:

jdbc:postgresql://localhost:5432:testdb

But I get Unable to c= reate connection. Check your URL.

If I just run psql fr= om the command-line, it works fine.

This is Scientific Linux.

Any ideas?  I've= also tried using the IP address of the system, with the same result.<= /o:p>

Thanks in advance for= any advice.  I am very new to Squirrel, just trying to get started.

Susan

--_000_2C84FA4CA630AD43BD2D247BD978355543B85C81YUWEXCPM24yuadu_--