Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote: > i'm using fedorca core 4 with the default postgres 8 default in it. i also installed pgadminIII
> versiion 1.4.3. i run postgres in the console with a password, initialized it with initdb
> --pgdata=/var/lib/pgsql/data, created a database and was able to create and insert table and
> records respectively. i used sql command select * from table and successfully retrieved the
> data. i also exited successfully.
> however when i used the pgadminIII to connect to the server i am always comfronted with the
> password authentication problem although i am also using the same pasword similar to the one
> used in my console postgres entry.
> what must be the problem and resolution here? thank you for the kind attention given to this
There is a config file that you will need to take a look at.
pg_hba.conf -- to configure how postgresql will authenticate client connections like the one from
pg admin 3.
If you spend about 15-20 minutes reading the document you should be abot to correct the parameters
in this conf file to allow you to recieve connections from clients.
Also, one the changes to the conf file are made, I believe that you will need to restart
Richard Broersma Jr.
changed ident to trust in pg_hba and no password is needed. i will study later the characterestics of the authentications.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
In response to
pgsql-novice by date
|Next:||From: Roger Rasmussen||Date: 2006-08-16 07:30:05|
|Subject: Re: Optimal Postgres Development Process, Software|
|Previous:||From: Harpreet Dhaliwal||Date: 2006-08-16 06:59:23|
|Subject: Re: [NOVICE] DB insert Error|