Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 866EE6332DC for ; Tue, 2 Mar 2010 10:28:10 -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 97513-03 for ; Tue, 2 Mar 2010 14:27:51 +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 5ACFC633206 for ; Tue, 2 Mar 2010 10:27:59 -0400 (AST) Received: by wwa36 with SMTP id 36so159643wwa.19 for ; Tue, 02 Mar 2010 06:27:57 -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=t7PpAfI2D/4J0nQr+1/3kiBa6oar14ICWEhAg8kFqbk=; b=QyWfX6oqbX9/zHQYuUItvlaFCdI3JD5dijktmDdR8x3Alxuyx6cJZdfiqpAlJ7f+qf u3HVQ9BoWoSXdYLxltudR3qK4Lc2+JvKNNumMT94ocKgQZTQDIyjH6BUe7b+lvN6HXa1 Ss6Nv8sgbTkc7w+uj+02wUpYRTs42I6fesTQg= 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=L4miHydcU1ZrMLRuibpB1DSoiRF8aLFyI0Ye3AufiBHRehqUrZfAYBayEddj/NvnrP 2QqDjfWgtkMO8z7aDy7UoMVN2s38xhHhlKHMIe2eee2yysXFPoZcEXHas9NsmP3pQ5Le XU7jQT53OhxG/bCe23mPWFEwuterw18xO+9i4= MIME-Version: 1.0 Received: by 10.216.90.202 with SMTP id e52mr4055128wef.150.1267540077233; Tue, 02 Mar 2010 06:27:57 -0800 (PST) In-Reply-To: <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> <20100302135725.GY19562@it.is.rice.edu> Date: Tue, 2 Mar 2010 19:57:57 +0530 Message-ID: <375c2da1003020627x75d53cd6nfebbb406f9b380f4@mail.gmail.com> Subject: Re: password authentication failed for user postgres From: Major Services To: Kenneth Marshall Cc: "I?igo Martinez Lasala" , pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0016e6d7ee570ac6d50480d22c6a X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5 tests=AWL=-0.000, BAYES_00=-2.599, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 201003/12 X-Sequence-Number: 33811 --0016e6d7ee570ac6d50480d22c6a Content-Type: text/plain; charset=ISO-8859-1 Ok, made it listen_addresses = '*' Now, can you please help me start the server. ( As I mentioned in earlier post, 'service postgresql restart' had stopped the server but *server start failed*.) Step wise list of commands to be given would be great! Do I need to login as postgres? Thanks On Tue, Mar 2, 2010 at 7:27 PM, Kenneth Marshall wrote: > 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 Major%20Services%20%3cservices.major@gmail.com > %3e> > > > > > > > *To*: I?igo Martinez Lasala 3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez@vectorsf.com<3d%253fISO-8859-1%253fQ%253fI%253dF1igo%253f%253d%2520Martinez%2520Lasala%2520%253cimartinez@vectorsf.com> > %3e> > > > > > > > *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 Major%20Services%20%3cservices.major@gmail.com > %3e> > > > > > > > > > > > > > *To*: I?igo Martinez Lasala 3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez@vectorsf.com<3d%253fISO-8859-1%253fQ%253fI%253dF1igo%253f%253d%2520Martinez%2520Lasala%2520%253cimartinez@vectorsf.com> > %3e> > > > > > > > *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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --0016e6d7ee570ac6d50480d22c6a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Ok, made it
listen_addresses =3D '*'

Now, can you please= help me start the server. ( As I mentioned in earlier post,=A0 'servic= e postgresql restart' had stopped the server but=A0 *server start faile= d*.)

Step wise list of commands to be given would be great!
Do I need to = login as postgres?

Thanks
On Tue, Mar = 2, 2010 at 7:27 PM, Kenneth Marshall <ktm@rice.edu> wrote:
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: =A0logger shutting down
> runuser: cannot set groups: Operation not permitted
> LOG: =A0logger shutting down
> FATAL: syntax error in file "/var/lib/pgsql/data/postgresql.conf&= quot;, near
> token ","
>
>
> Now, in the "/var/lib/pgsql/data/postgresql.conf" the only c= hange 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?igo Martinez Lasala <
> imartinez@= vectorsf.com> wrote:
>
> > =A0Ah... 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<Major%20Services= %20%3cservices.major@gmail.com%3e>
> > >
> > *To*: I?igo Martinez Lasala <imartinez@vectorsf.com<%3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20= %3cimartinez@vectorsf.com%3e>
> > >
> > *Cc*: pgsql-admin@p= ostgresql.org
> > *Subject*: Re: [ADMIN] password authentication failed for user po= stgres
> > *Date*: Tue, 2 Mar 2010 16:40:47 +0530
> >
> > But the server restart has failed; I am yet to make the changes s= uggested
> > by you in the first instance.
> >
> >
> >
> >
> > On Tue, Mar 2, 2010 at 4:32 PM, I?igo Martinez Lasala <<= br>
> > imart= inez@vectorsf.com> wrote:
> >
> > Try with these parameters in pg_hba.conf. Perhaps your postgres-r= edhat
> > compilation does not have ident enabled...
> >
> > local all postgres trust
> >
> >
> >
> >
> > -----Original Message-----
> > *From*: Major Services <services.major@gmail.com<Major%20Services= %20%3cservices.major@gmail.com%3e>
> > >
> >
> >
> > =A0*To*: I?igo Martinez Lasala <imartinez@vectorsf.com<%3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala= %20%3cimartinez@vectorsf.com%3e>
> > >
> > *Subject*: Re: [ADMIN] password authentication failed for user po= stgres
> > *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 p= ostgresql
> > 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 <<= br>
> > imartinez@vectorsf.com> wrote:
> > > In order to lauch createuser you don't need to modify li= sten_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 =A0 all =A0 =A0 =A0 =A0 postgres =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0ident sameuser
> > >
> > >
> > > Reload postgresql and launch createuser as postgres user. > > >
> > >
> > > -----Original Message-----
> > > From: Major Services <services.major@gmail.com>
> > > To: pgsql-admi= n@postgresql.org
> > > Subject: [ADMIN] password authentication failed for user pos= tgres
> > > Date: Tue, 2 Mar 2010 14:13:10 +0530
> > >
> > > Hi,
> > >
> > > 1. I have added =A0listen_addresses =3D '*' ; in =A0= postgresql.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 =A0METH= OD =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 messag= e =A0:
> > > 'createuser: could not connect to database postgres: =A0= 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
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >

--0016e6d7ee570ac6d50480d22c6a--