Postgresql connection [message #789] |
Sat, 29 February 2020 14:53 |
polgia
Messages: 2 Registered: February 2020 Location: italy
|
Junior Member |
|
|
Hello,
I am trying to retrive a table from a Postgresql (v12) database installed on a local host. As connecting string, I am using the following : postgresql://127.0.0.1:50036/chemicals
because 127.0.0.1 is my local IP;, 50036 is the port; chemicals is the name of the database. In the SQL string, I put: SELECT * FROM pure_components; because I want to retrive the whole table named "pure_components".
If I use the same parameters, I can connect and retrive the table in python, so it seems they are correct. However, when I use them in Datawarrior via "Run Data from SQl-Database...", the software allows to dial user and password ( I use: postgres and mypassword) but then it freezes. No way to start it again and I have to stop the process. I suppose some parameters are supplied in a wrong way. My setup is quite common in a local installation. Any suggestion?
Thanks
|
|
|
|
Re: Postgresql connection [message #795 is a reply to message #790] |
Mon, 02 March 2020 17:47 |
polgia
Messages: 2 Registered: February 2020 Location: italy
|
Junior Member |
|
|
Hi Thomas, thanks for answer.
I finally foound a solution by myself ( I am using Win 10). The problem was the port. For some reasons the port I have used was reserved to PGAdmin. Using the standard one: 5432 evethings works fine with the syntax you suggest. Thanks again.
Gianmarco
|
|
|