DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=xAqYGNfsugcVoq+cQxMlnc8fOkstCgPI8tnS6gMycbVb4T7F6mDytMlGkrvJHlPOBy
	/3t3M1Yy2Odb+IrRu9IuXtpz6Ajd3N8hTDB3qfldLjtfExEYfJcgTOspalpAQh2rwDcE
	9Ke7pFa1QPSB/8B7TuI3yZwsSDbGJi7tgjXfE=
MIME-Version: 1.0
In-Reply-To: <1267521253.2942.55.camel@deimos>
References: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com>
	<1267521253.2942.55.camel@deimos>
Date: Wed, 3 Mar 2010 20:07:23 +0530
Message-ID: <375c2da1003030637k6c3ffca6ma65651f1927c02eb@mail.gmail.com>
Subject: Re: password authentication failed for user postgres
From: Major Services <services.major@gmail.com>
To: =?ISO-8859-1?Q?I=F1igo_Martinez_Lasala?= <imartinez@vectorsf.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Finally, I am able to create a user.

Now when I try to connect to the server through DBWebAdmin (in
Parallels Plesk Panel); I get the following :
Error: FATAL: Ident authentication failed for user "postgres"

(earlier, with this link I could reach the login screen for PgAdmin )

 Do I need to remove the following from pg_hba.conf now?
 local   all         postgres                          ident sameuser


On Tue, Mar 2, 2010 at 2:44 PM, I=F1igo Martinez Lasala
<imartinez@vectorsf.com> wrote:
> In order to lauch createuser you don't need to modify listen_address sinc=
e
> you can use unix sockets. But anyway it's a requirement if you are goint =
to
> access remotely.
>
> Add this line in first place to your pg_hba.conf
> local=A0=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 postgres=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 ident sameuser
>
>
> Reload postgresql and launch createuser as postgres user.
>
>
> -----Original Message-----
> From: Major Services <services.major@gmail.com>
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] password authentication failed for user postgres
> Date: Tue, 2 Mar 2010 14:13:10 +0530
>
> Hi,
>
> 1. I have added  listen_addresses =3D '*' ; 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
>
>
>