Search Postgresql Archives

Re: Psycopg2 : error message.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 05/16/2014 08:41 AM, image wrote:
Dear all,

Thank you for your replies.Before taking into account your last proposals, I
would like to tell you : I noticed that i don't get error message when i use
the default user (postgres). But when i use my new user account (laurent), i
get the error message.

Did you set up a password for laurent?


With pgadmin3 i would like edit the authorization for the database (recalled
web_service). But when i try to add permissions, i can't click on "ok"
because it's neutralized (grayed").

At a guess you logged in as laurent not as the database superuser postgres. This assumes laurent is not a superuser. This would explain why you do not have rights to grant permissions.


On the following screen shot (pgadmin), below, we notice the defalut value
(TC) for the 'public' role. Here the role seems to be meaning the windows
account and not the postgres role?

No it would be the Postgres role.


SS_permissions.JPG
<http://postgresql.1045698.n5.nabble.com/file/n5804240/SS_permissions.JPG>

May be i have to do edit something into the pghba.conf in order to authorize
connection for the new role laurent? For information, i'm working under
'laurent' windows session.

Can you show your pg_hba.conf file?


Thank you to throw light for me.

Regards.



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Psycopg2-error-message-tp5804197p5804240.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux