From: Major Services <services.major@gmail.com>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: password authentication failed for user postgres
Date: Tue, 2 Mar 2010 19:19:47 +0530
Message-ID: <375c2da1003020549g74a31027l6d38f5f154005d5b@mail.gmail.com> (raw)
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>
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
> >
> >
> >
>
>
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: services.major@gmail.com, imartinez@vectorsf.com
Subject: Re: password authentication failed for user postgres
In-Reply-To: <375c2da1003020549g74a31027l6d38f5f154005d5b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox