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: | 14539729.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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, 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2007-12-29 20:09:48 | Re: Fatal error: role "postgres" no login! |
Previous Message | Raymond O'Donnell | 2007-12-29 16:24:35 | Re: Fatal error: role "postgres" no login! |