Hi at all..
I have a big problem...:/
I don't able to log in in my database by pgAdmin3
It get me error:
ERROR CONNECTING TO THE SERVER:
FATAL: role"postgres" is not permitted to log in
Can someone help me?
Thanks and sorry my english!
--
View this message in context:
http://www.
On 29/12/2007 12:24, Salvator*eL*arosa wrote:
ERROR CONNECTING TO THE SERVER:
FATAL: role"postgres" is not permitted to log in
Have you a line in your server's pg_hba.conf file allowing remote
connections by the role "postgres"? Something like:
host all postgres 192.168.1.25/24
Raymond O'Donnell wrote:
>
> On 29/12/2007 12:24, Salvator*eL*arosa wrote:
>> ERROR CONNECTING TO THE SERVER:
>> FATAL: role"postgres" is not permitted to log in
>
> Have you a line in your server's pg_hba.conf file allowing remote
> connections by the role "postgres"? Something like:
>
>
On 29/12/2007 15:37, Salvator*eL*arosa wrote:
My pg_hba.conf is:
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
hostall all
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
On 29/12/2007 17:48, Salvator*eL*arosa wrote:
That error gives me, because I modify ROLE of postgres user in NOT LOG
IN
I'm not sure that I understand youdo you mean that you removed the
CONNECT permission from the postgres user to the database to which you
want to connect?
Can
Raymond O'Donnell wrote:
>
>
> I'm not sure that I understand youdo 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?
>
> R
