Обсуждение: user authentication failed.....
This is really daft but i cant think what i have missed I've got 1 postgres machine thats running the DB and 1 development machine that connects to the backend on the DB machine and plays ball nicley. I've just come to add a new devlopment machine , same flavour of linux same postgres release (6.4.2) i came to run a straight forward test program and i keep getting user authentication failed the ports are the same, the user has been added for psql even when i use an exsisting name and password i get grief ... any ideas ... Stuart +-=-=-=-=-=-+ Too much coffee not enough sleep.
Hi Stuart, Did you check the pg_hba on the new machine? Just my .02 $ On Thu, 10 Jun 1999, StOo wrote: > > This is really daft but i cant think what i have missed > > I've got 1 postgres machine thats running the DB and 1 development > machine that connects to the backend on the DB machine and > plays ball nicley. > > I've just come to add a new devlopment machine , same flavour of linux > same postgres release (6.4.2) i came to run a straight forward test > program and i keep getting > > user authentication failed > > the ports are the same, the user has been added for psql even when i > use an exsisting name and password i get grief ... any ideas ... > > Stuart > > +-=-=-=-=-=-+ > > Too much coffee not enough sleep. > Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)
run postmaster with -i parameter and give access to clients in the file $PGDATA/pg_hba.conf StOo ha scritto: > This is really daft but i cant think what i have missed > > I've got 1 postgres machine thats running the DB and 1 development > machine that connects to the backend on the DB machine and > plays ball nicley. > > I've just come to add a new devlopment machine , same flavour of linux > same postgres release (6.4.2) i came to run a straight forward test > program and i keep getting > > user authentication failed > > the ports are the same, the user has been added for psql even when i > use an exsisting name and password i get grief ... any ideas ... > > Stuart > > +-=-=-=-=-=-+ > > Too much coffee not enough sleep. -- ______________________________________________________________ PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Jose'