From: | Terry Fielder <terry(at)ashtonwoodshomes(dot)com> |
---|---|
To: | Bryce Nesbitt <bryce1(at)obviously(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org, Judith <jaltamirano(at)correolux(dot)com(dot)mx> |
Subject: | Re: Authentification failed |
Date: | 2007-08-14 11:40:27 |
Message-ID: | 46C194AB.2040802@ashtonwoodshomes.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Connecting as root may be ill advised (doing stuff as root is a bad
idea unless one HAS to).
All that notwithstanding, you need to setup the correct permissions to
allow the connections you want in pg_hba.conf, usually is
/var/lib/pgsql/data/pg_hba.conf
Terry
Terry Fielder
terry(at)greatgulfhomes(dot)com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Bryce Nesbitt wrote:
> Judith wrote:
>
>> Hello everybody!!
>>
>> I'm trying in SUSE to connect to a postgres db and this is the error:
>>
>> Ident Authentification failed for user <<root>>
>>
>> I'm already created the user with createuser root, but the error
>> persist, I would aprecciate some help, thanks in advanced
>>
> ...or just cheat and get in as the postgres root user:
> psql -U postgres
> Which on SUSE has no password.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Hevia | 2007-08-14 13:59:37 | Re: Best Fit SQL query statement |
Previous Message | Bryce Nesbitt | 2007-08-14 08:30:47 | Re: Authentification failed |