Hi there,
TI've been tying to connect to a local PostgreSQL data base, with no luck so far.
--
---
You received this message because you are subscribed to the Google Groups "sofastatistics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sofastatistic...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Yes the server is definitely running. I'm using QGis to tap into my database (and I'm planning to use SOFA to do some data analysis).
I'll give Python 3.5 a try. ..we'll see what happens:)
I'll be away for a few days but will get onto it when I'm back.
Thanks, Andreas
You received this message because you are subscribed to a topic in the Google Groups "sofastatistics" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sofastatistics/gkxfsxT6HKM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sofastatistic...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
.- -. -.. .-. . .- ... -- .- .... -.
Andreas Mahn
Wellington, NZ
menta...@gmail.com
04 3899423
021 375 165
Yes the server is definitely running. I'm using QGis to tap into my database (and I'm planning to use SOFA to do some data analysis).
I'll give Python 3.5 a try. ..we'll see what happens:)
I'll be away for a few days but will get onto it when I'm back.
so I'm intrigued to hear the connection was successful without and explicit setting of the port to 5433.The basic connection parameters are:
dbname
– the database name (only in the dsn string)database
– the database name (only as keyword argument)user
– user name used to authenticatepassword
– password used to authenticatehost
– database host address (defaults to UNIX socket if not provided)port
– connection port number (defaults to 5432 if not provided)
con_dets_pgsql = {"host": pgsql_host, "user": pgsql_user, "password": pgsql_pwd}
is replaced with:
Hi Grant,
me again...sigh...
Still no luck.
The script works if I add the port. I've worked out that I need to run that script in the Python shell...sorry newbie error on my behalf. So when I hit F5 in IDLE without the port number, (ie as you sent the script) I get the same error message as I get in SOFA when I try try to connect to my data base. When I add the port number, the shell just prints =============RESTART ===========. Presumably that's good.
Then I've altered dbe_postgresql.py as you suggested. Then, when I then enter the Projects Settings dialog it won't let me confirm that dialog by clicking Update. (The button is not inactive, simply nothing happens when I press it). I guess con_dets_pgsql doesn't expect a fourth parameter? Just a guess...
I've also tried to make my database listen to port 5432. Also without luck - all the evidence points to a configuration file (postgresql.conf), and a batch file (pg_env.bat) which are supposed to set the port being listened to. Except in my case it seems that port 5433 is hard wired somewhere else.
Maybe I'll just wait until you release 1.4.6;)