> > How should I do this? The current auto-generated pg_hba.conf file read as:
> > "local all postgres ident sameuser"
> > on the first line, and the first line also after the # TYPE DATABASE....METHOD
> line.
> >
> >
> > Do you mean I should change the "ident sameuser" at the end to "trust"?
>
> Below is a snippet from:
>
>
http://www.postgresql.org/docs/8.0/static/client-authentication.html#EXAMPLE-PG-HBA.CONF
>
> Some examples of pg_hba.conf entries are shown in Example 19-1. See the next
> section for details on the different authentication methods.
>
Thank you Richard!! I've made the changes and can login to the DBs through pgAdmin
now!:) Really appreciated your help!!! I am starting to learn about the postgresql
now.:))
>I can't remember what type of connect pgadmin uses. It might be "TYPE" host.
>If it is you will need to add another line to the conf file for that type.
Seems like the pgAdmin3 uses also the Unix socket pipe. I left only the first line
in the pg_hba.conf enabled as "local all postgres trust" and pgAdmin3 was able to
login.:)
> Also, there
> is another postgres conf (I can't remember which on off the top of my head) file
> that will need the optional "-I" set to allow you to connect from remote IP
> addresses. i.e. pgadmin. If all else fails, read the help docs; the beginning
sections are newbie friendly.
>
I am checking on this.;) If you got any more hints, please let me know. THANK
YOU!!!
leo
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com