Re: password authentication failed for user postgres

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 <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@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 <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>
> > >
> > *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 <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 = '*' ; 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
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >