Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3C7AA632D33 for ; Tue, 2 Mar 2010 09:55:07 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92783-05 for ; Tue, 2 Mar 2010 13:54:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from is.rice.edu (is.rice.edu [128.42.42.24]) by mail.postgresql.org (Postfix) with ESMTP id CA783632416 for ; Tue, 2 Mar 2010 09:54:56 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by is.rice.edu (Postfix) with ESMTP id 15F104181C; Tue, 2 Mar 2010 07:57:31 -0600 (CST) Received: from is.rice.edu ([127.0.0.1]) by localhost (it.is.rice.edu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27851-01; Tue, 2 Mar 2010 07:57:26 -0600 (CST) Received: by is.rice.edu (Postfix, from userid 18612) id DCE1141819; Tue, 2 Mar 2010 07:57:25 -0600 (CST) Date: Tue, 2 Mar 2010 07:57:25 -0600 From: Kenneth Marshall To: Major Services Cc: I?igo Martinez Lasala , pgsql-admin@postgresql.org Subject: Re: password authentication failed for user postgres Message-ID: <20100302135725.GY19562@it.is.rice.edu> 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> <375c2da1003020549g74a31027l6d38f5f154005d5b@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <375c2da1003020549g74a31027l6d38f5f154005d5b@mail.gmail.com> User-Agent: Mutt/1.5.16 (2007-06-09) X-Virus-Scanned: by amavis-2.2.1 at is.rice.edu 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/11 X-Sequence-Number: 33810 You cannot have a '*' in listen_addresses with anything else. That already means bind to EVERY available interface. When you added localhost, it tried to re-bind localhost twice. Try just using '*'. Cheers, Ken On Tue, Mar 02, 2010 at 07:19:47PM +0530, Major Services wrote: > 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 = 'localhost', '*' > > Let me know how to move ahead. > Thanks. > > On Tue, Mar 2, 2010 at 5:55 PM, I?igo 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?igo 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?igo 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?igo 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?igo 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 goint > > 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 = '*' ; 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 > > > > > > > > > > > > > > > > > > > > >