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

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, 192.168.1.25 with a netmask of 255.255.255.0, you need to add:
> 
>    host    all    postgres    192.168.1.25/24    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
IN........

How can i to restore my settings?


-- 
View this message in context:
http://www.nabble.com/Fatal-error%3A-role-%22postgres%22-no-login%21-tp14537100p14539729.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.