| From: | Keith Yanase <keith(dot)yanase(at)soterawireless(dot)com> |
|---|---|
| To: | Clemens Ladisch <clemens(at)ladisch(dot)de> |
| Cc: | "Bhavika Padidala (MINDTREE LIMITED)" <v-bhpadi(at)microsoft(dot)com>, "Prashanth Reddy Kalvakuntla (MINDTREE LIMITED)" <v-prkalv(at)microsoft(dot)com>, "Vikram Ramagiri (MINDTREE LIMITED)" <v-virama(at)microsoft(dot)com>, pgsql-odbc(at)postgresql(dot)org, support <support(at)mail(dot)support(dot)microsoft(dot)com> |
| Subject: | Re: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to postgreSQL server |
| Date: | 2020-01-20 01:20:45 |
| Message-ID: | CADxFd5=BkeO1pCf6zSjtvTp-inPvseK54NGyN0uMjuCqQtDzmA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
The PostgreSQL server runs on amazon cloud server (RDS). Jupyter hosts the
SSH tunnel.
I tried the following:
ssh -L localhost:5432:127.0.01:5432 jupyter
Still getting this error when attempting to connect to localhost:5432 in
psqlODBC.
channel 3: open failed: connect failed: Connection refused
The database resides in amazon, which is accessed on my computer through an
SSH tunnel hosted on jupyter.
I don't have access to the database configurations, but is there a way I
can find out what the database is configured to listen on?
On Sun, Jan 19, 2020 at 12:41 PM Clemens Ladisch <clemens(at)ladisch(dot)de> wrote:
> Keith Yanase wrote:
> > I ran the command and when I tel psqlODBC to connect to localhost:5432 I
> get this message in the terminal:
> > Channel 3: open failed: connect failed: connection refused
>
> Does the PostgreSQL server run on the "jupyter" host?
>
> Is the database configured to listen on "localhost" or "127.0.0.1"?
> In the latter case, use "ssh -L localhost:5432:127.0.0.1:5432 jupyter".
>
>
> Regards,
> Clemens
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan-Peter Seifert | 2020-01-22 12:44:42 | Changing configuration options at runtime possible? |
| Previous Message | Clemens Ladisch | 2020-01-19 20:40:43 | Re: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to postgreSQL server |