Re: Psycopg2 : error message. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Psycopg2 : error message.
Date
Msg-id 537A0AB2.3000703@aklaver.com
Whole thread Raw
In response to Re: Psycopg2 : error message.  (image <lcelati@latitude-geosystems.com>)
List 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.klaver@aklaver.com


pgsql-general by date:

Previous
From: image
Date:
Subject: Re: Psycopg2 : error message.
Next
From: Tim Kane
Date:
Subject: Re: materialised views vs unlogged table (also, ize vs ise)