Thread: password authentication failed for user "postgres"

dear friends,

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

ramon

---

Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail Beta.

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

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.

http://www.postgresql.org/docs/8.1/interactive/client-authentication.html#AUTH-PG-HBA-CONF
http://www.postgresql.org/docs/8.1/interactive/client-authentication-problems.html

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

Regards,

Richard Broersma Jr.

Richard Broersma Jr <rabroersma@yahoo.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
> query.

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.

http://www.postgresql.org/docs/8.1/interactive/client-authentication.html#AUTH-PG-HBA-CONF
http://www.postgresql.org/docs/8.1/interactive/client-authentication-problems.html

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

Regards,

Richard Broersma Jr.


thanks Richard,

 changed  ident  to trust in pg_hba and no password is needed. i will study later the characterestics of the authentications.

thanks again

mon

---------------------------(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
http://mail.yahoo.com