You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cannot Connect Remote Postgresql from a Oracle Cloud Infrastructure Jupyter Notebook

Question
48
Views
0
Comments
edited Feb 28, 2021 3:52PM in Database

Content

Dear All,

I'm currently testing Oracle Cloud Infrastructures technologies with Python and Postgresql (kindle see the figure herewith). So far, I managed to install my Cloud Jupyter Notebook, and ran some basic Python commands. However, when I tried to connect to my Postgresql DB or even upload csv any Data from my local machine raise this exception: 

OperationalError: (psycopg2.OperationalError) could not connect to server: Connection refused

               Is the server running on host "127.0.0.1" and accepting

               TCP/IP connections on port 5432?

(Background on this error at: http://sqlalche.me/e/13/e3q8)

Just to mention  that when reproduce the same test case on my local_host it works perfectly

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!