Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!

From: lmyho <lm_yho(at)yahoo(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Date: 2006-03-28 22:51:52
Message-ID: 20060328225152.2573.qmail@web30806.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin

> > 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 

In response to

Responses

pgsql-admin by date

Next:From: Rafael MartinezDate: 2006-03-28 23:05:59
Subject: Re: Bloated pg_shdepend_depender_index
Previous:From: Salem BerhanuDate: 2006-03-28 22:26:45
Subject: postgres and persistant connections (using Apache::DBI)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group