Re: password authentication failed for user postgres

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 <ktm(at)rice(dot)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: 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(at)vectorsf(dot)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(dot)major(at)gmail(dot)com<
> Major%20Services%20%3cservices(dot)major(at)gmail(dot)com<Major%2520Services%2520%253cservices(dot)major(at)gmail(dot)com>
> %3e>
> > > >
> > > *To*: I?igo Martinez Lasala <imartinez(at)vectorsf(dot)com<%
> 3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez(at)vectorsf(dot)com<3d%253fISO-8859-1%253fQ%253fI%253dF1igo%253f%253d%2520Martinez%2520Lasala%2520%253cimartinez(at)vectorsf(dot)com>
> %3e>
> > > >
> > > *Cc*: pgsql-admin(at)postgresql(dot)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(at)vectorsf(dot)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(dot)major(at)gmail(dot)com<
> Major%20Services%20%3cservices(dot)major(at)gmail(dot)com<Major%2520Services%2520%253cservices(dot)major(at)gmail(dot)com>
> %3e>
> > > >
> > >
> > >
> > > *To*: I?igo Martinez Lasala <imartinez(at)vectorsf(dot)com<%
> 3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez(at)vectorsf(dot)com<3d%253fISO-8859-1%253fQ%253fI%253dF1igo%253f%253d%2520Martinez%2520Lasala%2520%253cimartinez(at)vectorsf(dot)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(at)vectorsf(dot)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(dot)major(at)gmail(dot)com>
> > > > To: pgsql-admin(at)postgresql(dot)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
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
>