Re: Fatal error: role "postgres" no login!

From: Salvator*eL*arosa <s_larosa(at)libero(dot)it>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: Fatal error: role "postgres" no login!
Date: 2007-12-29 21:37:15
Message-ID: 14541715.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Raymond O'Donnell wrote:
>
>
> I'm not sure that I understand you....do you mean that you removed the
> CONNECT permission from the postgres user to the database to which you
> want to connect?
>
> Can you describe *exactly* the steps you take, and the error messages
> you get back?
>
> Ray.
>
>
>

In pgAdminIII in my connection server (localhost), i have modified
the ROLE of superuser (postgres) from LOGIN to NOT LOGIN...that's all!!
So, when i want connect (localhost) it get back me error:
ERROR CONNECTING TO THE SERVER:
FATAL: role..................................
...............

is there a way for restored it?
can i to reset my data directory to resolv my
problem???(/usr/local/pgsql/data)

Thank you very much and sorry sorry my english!
--
View this message in context: http://www.nabble.com/Fatal-error%3A-role-%22postgres%22-no-login%21-tp14537100p14541715.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Edward Leung 2007-12-30 16:55:34 Double-quoted table name, why ?
Previous Message Raymond O'Donnell 2007-12-29 20:09:48 Re: Fatal error: role "postgres" no login!