Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id DC137632245
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  2 Mar 2010 04:43:22 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 41862-03 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  2 Mar 2010 08:43:08 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ww0-f46.google.com (mail-ww0-f46.google.com
 [74.125.82.46])
	by mail.postgresql.org (Postfix) with ESMTP id 1FD7B632903
	for <pgsql-admin@postgresql.org>; Tue,  2 Mar 2010 04:43:11 -0400 (AST)
Received: by wwa36 with SMTP id 36so2851wwa.19
	for <pgsql-admin@postgresql.org>; Tue, 02 Mar 2010 00:43:10 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=+jbaJ4Eb7107Rrqss436jbx7uEvO5dU4C3ph7Ohop0Y=;
	b=uHxivWhK/gmt66xr+Lv/XNAM4Vur+tpR1FWnNOomZceDHff7odJSBYEivVmmvmTTKy
	7EkqoPN72eOq1wUqd7xjUtPPtk58pLZn0p7AlLi8Wx5f73gzOog0YKaFIGM4YdI9g/ZK
	u9UxQ1VdgzEnXxiFIWaUgchH9BMCMDd5whpZc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=EAttYIe1L6U0+9J0+rysiPkK4ytHrr9BDkS/y69BWj249tzwGAC/bOTXpt9dut3Xy9
	rSKL87AW2CFkVwX0pNPC6Yoo4LXm7B3QL2Ui9ieT7WdOiBs37A3OkOlgJJyjMGROpxvt
	GTpb80dZJSxNz+mROcISZrp8Epd+ao30SUU0s=
MIME-Version: 1.0
Received: by 10.216.86.7 with SMTP id v7mr2629079wee.137.1267519390467; Tue,
	02 Mar 2010 00:43:10 -0800 (PST)
Date: Tue, 2 Mar 2010 14:13:10 +0530
Message-ID: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com>
Subject: password authentication failed for user postgres
From: Major Services <services.major@gmail.com>
To: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/5
X-Sequence-Number: 33804

Hi,

1. I have added  listen_addresses = '*' ; in  postgresql.conf

2. And have made the following changes to pg_hba.conf

local   DATABASE    USER   METHOD
local    samegroup      all      password
host    DATABASE    USER    CIDR-ADDRESS  METHOD  [OPTION]
host          all                 all       0.0.0.0/0             md5
hostssl      all                 all       0.0.0.0/0            md5

3. Have restarted the server

4. I can login to the server as user postgres.

But  while trying to createuser I get the following message  :
'createuser: could not connect to database postgres:  FATAL :
password authentication failed for user "postgres"

This is on Redhat running Plesk also.

I am new to Linux as well as PostgreSQL. Help would be much appreciated.

Thanks
Viv