Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 6513A632D33 for ; Tue, 2 Mar 2010 09:50:01 -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 91322-02 for ; Tue, 2 Mar 2010 13:49:42 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 11D58632416 for ; Tue, 2 Mar 2010 09:49:49 -0400 (AST) Received: by wya21 with SMTP id 21so139160wya.19 for ; Tue, 02 Mar 2010 05:49:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=oqvFv14zXQ8JIsusajOmQSrGFwC2eWLRKOeldHPUXT8=; b=BhupLXhWG3gv7lz9507Wna4AUFIzS4bqyfWZNHj3QFgq5TnTYKiEzrovybedoqIHUP 55WHmMJ2EV4PAzst1+VjvIgHyu5FWNDrvp5CF//RHknOn08n6UQmmOjnBCFqjWPgdWQO byEzwB2msuFizeeA+k5sbsdK+08bqScKBbEkg= 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; b=hyBjnX0wbe6KxxAXcnpORzy5bHd3hnHN0hvjxBRhsWnx6wMb5WEL9WPOJB/xlpjKtN nouMEUIVimw2DHz1AMX65BH994bO79pZy7LRCAtMcn+4je984fqN5+JgLk0qhsCUatBq eHRb+GkUpJME9fUVhV9kQPc31vOwb28RIpXhk= MIME-Version: 1.0 Received: by 10.216.90.202 with SMTP id e52mr4027208wef.150.1267537787865; Tue, 02 Mar 2010 05:49:47 -0800 (PST) In-Reply-To: <1267532738.2942.116.camel@deimos> References: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com> <1267521253.2942.55.camel@deimos> <375c2da1003020233oa934b97xb478f577f0606969@mail.gmail.com> <1267527741.2942.113.camel@deimos> <375c2da1003020310s230b28a3g8c4b5e6d3e264490@mail.gmail.com> <1267532738.2942.116.camel@deimos> Date: Tue, 2 Mar 2010 19:19:47 +0530 Message-ID: <375c2da1003020549g74a31027l6d38f5f154005d5b@mail.gmail.com> Subject: Re: password authentication failed for user postgres From: Major Services To: =?ISO-8859-1?Q?I=F1igo_Martinez_Lasala?= Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0016e6d7ee5795d2a40480d1a3cc X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5 tests=AWL=-0.001, BAYES_00=-2.599, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 201003/10 X-Sequence-Number: 33809 --0016e6d7ee5795d2a40480d1a3cc Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable pgstartup.log: The files belonging to this database system will be owned by user "postgres". .... .... Success. You can now start the database server using: /usr/bin/postmaster -D /var/lib/pgsql/data or /usr/bin/pg_ctl -D /var/lib/pgsql/data -1 logfile start FATAL: lock file "postmaster.pid"already exists HINT:Is another postmaster (PID 3300) running in data directory"b/pgsql/data"? LOG: logger shutting down runuser: cannot set groups: Operation not permitted LOG: logger shutting down FATAL: syntax error in file "/var/lib/pgsql/data/postgresql.conf", near token "," Now, in the "/var/lib/pgsql/data/postgresql.conf" the only change I have made is in listen_addresses; viz listen_addresses =3D 'localhost', '*' Let me know how to move ahead. Thanks. On Tue, Mar 2, 2010 at 5:55 PM, I=F1igo Martinez Lasala < imartinez@vectorsf.com> wrote: > Ah... ok. > In /var/lib/pgsql you will find a file called pgstartup.log > Could you post here last lines of this file ? > > > > -----Original Message----- > *From*: Major Services > > > *To*: I=F1igo Martinez Lasala > > > *Cc*: pgsql-admin@postgresql.org > *Subject*: Re: [ADMIN] password authentication failed for user postgres > *Date*: Tue, 2 Mar 2010 16:40:47 +0530 > > But the server restart has failed; I am yet to make the changes suggested > by you in the first instance. > > > > > On Tue, Mar 2, 2010 at 4:32 PM, I=F1igo Martinez Lasala < > imartinez@vectorsf.com> wrote: > > Try with these parameters in pg_hba.conf. Perhaps your postgres-redhat > compilation does not have ident enabled... > > local all postgres trust > > > > > -----Original Message----- > *From*: Major Services > > > > > *To*: I=F1igo Martinez Lasala > > > *Subject*: Re: [ADMIN] password authentication failed for user postgres > *Date*: Tue, 2 Mar 2010 16:03:59 +0530 > > Thank you for your message. But am in another problem now. > In between I also tried to restart the server with 'service postgresql > restart' > It stopped the server, but then *server start failed*. > Had restarted earlier also, without a problem. > > What should I do? > > 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 > since > > you can use unix sockets. But anyway it's a requirement if you are goin= t > to > > access remotely. > > > > Add this line in first place to your pg_hba.conf > > local all postgres ident sameuser > > > > > > Reload postgresql and launch createuser as postgres user. > > > > > > -----Original Message----- > > From: Major Services > > 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 > > > > > > > > > > > > --0016e6d7ee5795d2a40480d1a3cc Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable pgstartup.log:

The files belonging to this database system will be o= wned by user "postgres".
....
....

Success. You can = now start the database server using:
/usr/bin/postmaster -D /var/lib/pgs= ql/data
or
/usr/bin/pg_ctl -D /var/lib/pgsql/data -1 logfile start
FATAL: lo= ck file "postmaster.pid"already exists
HINT:Is another postmas= ter (PID 3300) running in data directory"b/pgsql/data"?
LOG:= =A0 logger shutting down
runuser: cannot set groups: Operation not permitted
LOG:=A0 logger shutt= ing down
FATAL: syntax error in file "/var/lib/pgsql/data/postgresq= l.conf", near token ","


Now, in the "/var/li= b/pgsql/data/postgresql.conf" the only change I have made is in listen= _addresses; viz
listen_addresses =3D 'localhost', '*'

Let me know ho= w to move ahead.
Thanks.

On Tue, Mar 2= , 2010 at 5:55 PM, I=F1igo Martinez Lasala <imartinez@vectorsf.com> wrote= :
=20 =20
Ah... ok.
In /var/lib/pgsql you will find a file called pgstartup.log
Could you post here last lines of this file ?



-----Original Message-----
From: Major Services <services.major@gmail.com>= ;
To: I=F1igo Martinez Lasala <imartinez@vectorsf.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] password authentication failed for user postgre= s
Date: Tue, 2 Mar 2010 16:40:= 47 +0530

But the server restart has failed; I am yet to make the changes suggested b= y you in the first instance.




On Tue, Mar 2, 2010 at 4:32 PM, I=F1igo Martinez Lasala <imartinez@vectorsf.com>= wrote:
Try with these parameters in pg_hba.conf. Perhaps your postgres-redhat = compilation does not have ident enabled...

local all postgres trust



-----Original Message-----
From: Major Services <services.major@gmail.com>


To: I=F1igo Martinez Lasala <imartinez@vectorsf.com>
Subject: Re: [ADMIN] password authentication failed for user pos= tgres
Date: Tue, 2 Mar 2010 16:03:59 +0530

Thank you for your message. But am in another problem now.
In between I also tried to restart the server with 'service postgre= sql restart'
It stopped the server, but then server start failed.
Had restarted earlier also, without a problem.

What should I do?

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_a= ddress since
> 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<= br> > Date: Tue, 2 Mar 2010 14:13:10 +0530
>
> Hi,
>
> 1. I have added =A0listen_addresses =3D '*' ; in =A0postgr= esql.conf
>
> 2. And have made the following changes to pg_hba.conf
>
> local =A0 DATABASE =A0 =A0USER =A0 METHOD
> local =A0 =A0samegroup =A0 =A0 =A0all =A0 =A0 =A0password
> host =A0 =A0DATABASE =A0 =A0USER =A0 =A0CIDR-ADDRESS =A0METHOD =A0= [OPTION]
> host =A0 =A0 =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 all = =A0 =A0 =A0 0.0.0.0/0 = =A0 =A0 =A0 =A0 =A0 =A0 md5
> hostssl =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 all =A0 =A0= =A0 0.0.0.0/0 =A0 =A0 = =A0 =A0 =A0 =A0md5
>
> 3. Have restarted the server
>
> 4. I can login to the server as user postgres.
>
> But =A0while trying to createuser I get the following message =A0:=
> 'createuser: could not connect to database postgres: =A0FATAL = :
> 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 apprec= iated.
>
> Thanks
> Viv
>
>
>






--0016e6d7ee5795d2a40480d1a3cc--