pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Travers <chris@travelamericas.com>
To: lmyho <lm_yho@yahoo.com>
Cc: Richard Broersma Jr <rabroersma@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Date: Tue, 28 Mar 2006 15:54:42 -0800
Message-ID: <4429CCC2.50407@travelamericas.com> (raw)
In-Reply-To: <20060328225152.2573.qmail@web30806.mail.mud.yahoo.com>
References: <20060328225152.2573.qmail@web30806.mail.mud.yahoo.com>

lmyho wrote:

>  
>
>>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.:))
>  
>
The authentication methods are handled between the libraries (libpq and 
libpxx) and the server.  They are transparent to the application.

identd sameuser means use the identd service to require look up the 
owner of the process and log him/her in accordingly.  This means that 
you cannot change your login name but don't require a password (if you 
are on the DB server-- do not trust it remotely).

For remote connections kerberos can be used instead, though this takes 
more setup and knowledge of Kerberos as a system.

>  
>
>>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.:)
>  
>
Right.  But passwords are ineffective with trust authentication.  If you 
need them you will need to use password, md5, or the like instead.

Best Wishes,
Chris Travers
Metatron Technology Consulting



view thread (8+ messages)  latest in thread

Message-ID: <4429CCC2.50407@travelamericas.com>
Permalink:  ../4429CCC2.50407@travelamericas.com/
Also on:    postgresql.org/message-id/4429CCC2.50407@travelamericas.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: chris@travelamericas.com, lm_yho@yahoo.com, rabroersma@yahoo.com
  Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
  In-Reply-To: <4429CCC2.50407@travelamericas.com>
  References: <20060328225152.2573.qmail@web30806.mail.mud.yahoo.com> <4429CCC2.50407@travelamericas.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