> > 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
