Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 83D6C9F99D6
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 14 Aug 2007 08:43:58 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 38494-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 14 Aug 2007 08:43:51 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mail.greatgulfhomes.com (mail.greatgulfhomes.com
	[216.191.52.66])
	by postgresql.org (Postfix) with ESMTP id 356079F999C
	for <pgsql-sql@postgresql.org>; Tue, 14 Aug 2007 08:43:51 -0300 (ADT)
Received: from [10.243.102.72] ([216.191.52.74]) (authenticated bits=0)
	by mail.greatgulfhomes.com (8.13.8/8.13.8) with ESMTP id l7EBhhap007684;
	Tue, 14 Aug 2007 07:43:43 -0400
Message-ID: <46C194AB.2040802@ashtonwoodshomes.com>
Date: Tue, 14 Aug 2007 07:40:27 -0400
From: Terry Fielder <terry@ashtonwoodshomes.com>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
To: Bryce Nesbitt <bryce1@obviously.com>
CC: pgsql-sql@postgresql.org, Judith <jaltamirano@correolux.com.mx>
Subject: Re: Authentification failed
References: <46B0F8C6.3070601@correolux.com.mx>
	<46C16837.7020608@obviously.com>
In-Reply-To: <46C16837.7020608@obviously.com>
Content-Type: multipart/alternative;
	boundary="------------010901080001060506080407"
X-Greylist: Sender succeeded SMTP AUTH authentication, not delayed by
	milter-greylist-3.0 (mail.greatgulfhomes.com [216.191.52.66]);
	Tue, 14 Aug 2007 07:43:44 -0400 (EDT)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.232 tagged_above=0 required=5 tests=AWL=0.230,
	BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200708/123
X-Sequence-Number: 29061

This is a multi-part message in MIME format.
--------------010901080001060506080407
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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@greatgulfhomes.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.
>
>   

--------------010901080001060506080407
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Connecting as root may be ill advised  (doing stuff as root is a
bad idea unless one HAS to).<br>
<br>
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<br>
<br>
Terry<br>
<br>
</tt>
<pre class="moz-signature" cols="72">Terry Fielder
<a class="moz-txt-link-abbreviated" href="mailto:terry@greatgulfhomes.com">terry@greatgulfhomes.com</a>
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085</pre>
<br>
<br>
Bryce Nesbitt wrote:
<blockquote cite="mid46C16837.7020608@obviously.com" type="cite">
  <pre wrap="">Judith wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Hello everybody!!

I'm trying in SUSE to connect to a postgres db and this is the error:

    Ident Authentification failed for user &lt;&lt;root&gt;&gt;

I'm already created the user with createuser root, but the error
persist, I would aprecciate some help, thanks in advanced 
    </pre>
  </blockquote>
  <pre wrap=""><!---->...or just cheat and get in as the postgres root user:
    psql -U postgres
Which on SUSE has no password.

  </pre>
</blockquote>
</body>
</html>

--------------010901080001060506080407--