Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support

Raymond O'Donnell wrote:
> I'm not sure that I understand 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:
FATAL: role..................................

is there a way for restored it?
can i to reset my data directory to resolv my

Thank you very much and sorry sorry my english!
View this message in context:
Sent from the PostgreSQL - pgadmin support mailing list archive at

In response to

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group