On 05/19/2014 06:17 AM, image wrote:
Dear all, Thank you again for your replies. So regarding my issue with my 'laurent' user account, i remove double quote and i add punctuation between the parameters. But it's always the same result. I succeed in connecting to my pg database with the postgres user. But i have the same problem with 'laurent' user, same error message. The problem seems to come from the laurent account.
So what happens when you try to use the command line program psql or pgAdmin to connect as laurent?
Below i past my pg_hba.conf. I just add a line allowing all connections (trust) for anyone user. pg_hba.sample <http://postgresql.1045698.n5.nabble.com/file/n5804474/pg_hba.sample>
That is not the pg_hba.conf file you want. That is the template file Postgres uses to build a pg_hba.conf when it does an initdb.
I tried to re run services . I think that postgres services were down beacause when i try to run services, a message appears saying : -------------------------------------- postgresql x64 9.3 service. Postgre sql server has started , then has stopped. Some services stop automatically when it are not used by other serices or programs. -------------------------------------- Do you know the cause of this trouble? this message appears even if the file is raw, unmodified
Not sure. You will need to provide more information. Looking in the Postgres logs would be a good start, as well as the Windows system logs.
I have to edit anything into my pg_hba.conf?
Possibly, though not the pg_hba.conf you show above. pgAdmin should allow you to edit the correct file.
Thanks. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Psycopg2-error-message-tp5804197p5804474.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
