From: lmyho <lm_yho@yahoo.com>
To: Richard Broersma Jr <rabroersma@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Date: Tue, 28 Mar 2006 14:51:52 -0800 (PST)
Message-ID: <20060328225152.2573.qmail@web30806.mail.mud.yahoo.com> (raw)
In-Reply-To: <20060328182128.59189.qmail@web31805.mail.mud.yahoo.com>
> > 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: lm_yho@yahoo.com, rabroersma@yahoo.com
Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
In-Reply-To: <20060328225152.2573.qmail@web30806.mail.mud.yahoo.com>
References: <20060328182128.59189.qmail@web31805.mail.mud.yahoo.com> <20060328225152.2573.qmail@web30806.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox