> > 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
> > Do you mean I should change the "ident sameuser" at the end to "trust"?
> Below is a snippet from:
> 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
>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
> 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
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
In response to
pgsql-admin by date
|Next:||From: Rafael Martinez||Date: 2006-03-28 23:05:59|
|Subject: Re: Bloated pg_shdepend_depender_index|
|Previous:||From: Salem Berhanu||Date: 2006-03-28 22:26:45|
|Subject: postgres and persistant connections (using Apache::DBI)|