From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | image <lcelati(at)latitude-geosystems(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Psycopg2 : error message. |
Date: | 2014-05-19 13:44:18 |
Message-ID: | 537A0AB2.3000703@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Kane | 2014-05-19 15:14:52 | Re: materialised views vs unlogged table (also, ize vs ise) |
Previous Message | image | 2014-05-19 13:17:57 | Re: Psycopg2 : error message. |