From your 2 replies I can either conclude that:
- you did not use copy/paste to reproduce exactly the error message (that’s a mistake you should really not do anymore, always paste from your console to get an exact error message)
- or you really mistyped localhost in your configuration
whatever, what is needed is to be sure that your postgres configuration is correct outside of Plone before going further.
From old config file I am grabbing this:
sudo -u postgres psql -h localhost -U -d -W
I can’t remember what this is meaning exactly, but did you actually do this test ?
In python I have also this snippet:
c=psycopg2.connect(“host=localhost dbname=mydbname user=myuser password=mypwd”)
changing user and password and using the python setup for plone, of course
You should have all this working before posting about SqlAlchemy on this forum because if all this is not functional this is not a Plone problem.