openmolecules.org Forum: Functionality

Home » DataWarrior » Functionality » Postgresql connection (Parameters for connection)

Show: Today's Messages :: Polls :: Message Navigator

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

Report message to a moderator

[Message index]

		Postgresql connection By: polgia on Sat, 29 February 2020 14:53
		Re: Postgresql connection By: thomas on Sun, 01 March 2020 17:51
		Re: Postgresql connection By: polgia on Mon, 02 March 2020 17:47

Previous Topic:	Question about R-group occurences estimation
Next Topic:	tautomer & protomer display

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri May 09 19:27:48 CEST 2025

Total time taken to generate the page: 0.03591 seconds