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 17:48:16
Message-ID: (view raw or whole thread)
Lists: pgadmin-support

Raymond O'Donnell wrote:
> There's your problem - if you're trying to connect to the database from 
> a different machine, then you need to add another "host" line to allow it.
> What you have here looks like the default pg_hba.conf that's created on 
> installation - you haven't edited it at all, and so it's only allowing 
> connections from the machine on which Postgres is running.
> If you want to allow user "postgres" to connect to all databases from, 
> say, with a netmask of, you need to add:
>    host    all    postgres    md5
> PgAdmin (or any other client) should then prompt for the password for 
> user "postgres", and the password will be md5-encrypted before being 
> passed over the wire.
> Ray.

Thank you for reply, but I have not resolved, again......

That error gives me, because I modify ROLE of postgres user in NOT LOG

How can i to restore my settings?

View this message in context:
Sent from the PostgreSQL - pgadmin support mailing list archive at

In response to


pgadmin-support by date

Next:From: Raymond O'DonnellDate: 2007-12-29 20:09:48
Subject: Re: Fatal error: role "postgres" no login!
Previous:From: Raymond O'DonnellDate: 2007-12-29 16:24:35
Subject: Re: Fatal error: role "postgres" no login!

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