pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 



view thread (8+ messages)  latest in thread

Message-ID: <20060328225152.2573.qmail@web30806.mail.mud.yahoo.com>
Permalink:  ../20060328225152.2573.qmail@web30806.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20060328225152.2573.qmail@web30806.mail.mud.yahoo.com

 · 

reply

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