password authentication failed for user postgres

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

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Major Services [ Di, 02 März 2010 09:43 ] [ ID #2033776 ]

Re: password authentication failed for user postgres

--=-f/253faVEqsqqB+tv4be
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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 [at] gmail.com>
To: pgsql-admin [at] 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

--=-f/253faVEqsqqB+tv4be
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
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 <<A HREF="mailto:Major%20Services%20%3cservices.major [at] gmail.com%3e">services.major [at] gmail.com</A>> 
To: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A> 
Subject: [ADMIN] password authentication failed for user postgres 
Date: Tue, 2 Mar 2010 14:13:10 +0530 
 
<PRE>
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

</PRE>
 
</BODY>
</HTML>

--=-f/253faVEqsqqB+tv4be--

imartinez [ Di, 02 März 2010 10:14 ] [ ID #2033777 ]

Fwd: password authentication failed for user postgres

--0016e649849a197da20480cf4674
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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=F1igo Martinez Lasala <
imartinez [at] vectorsf.com> wrote:
> In order to lauch createuser you don't need to modify listen_address sinc=
e
> 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 [at] gmail.com>
> To: pgsql-admin [at] 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 =3D '*' ; 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
>
>
>

--0016e649849a197da20480cf4674
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div class=3D"gmail_quote">Thank you for your message. But am in another pr=
oblem now. In between I also tried to restart the server with 'servi=
ce postgresql restart' It stopped the server, but then server sta=
rt failed. 
Had restarted earlier also, without a problem. 
 What should I do?<div><div></div><div class=3D"h5"> On Tue, Mar =
2, 2010 at 2:44 PM, I=F1igo Martinez Lasala <<a href=3D"mailto:imartinez=
[at] vectorsf.com" target=3D"_blank">imartinez [at] vectorsf.com</a>> wrote: &=
gt; In order to lauch createuser you don't need to modify listen_addres=
s since 

> you can use unix sockets. But anyway it's a requirement if you are=
goint to > access remotely. > > Add this line in first p=
lace to your pg_hba.conf > local=A0=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 po=
stgres=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=
=A0=A0 ident sameuser 

> > > Reload postgresql and launch createuser as postgres us=
er. > > > -----Original Message----- > From: Major =
Services <<a href=3D"mailto:services.major [at] gmail.com" target=3D"_blank">=
services.major [at] gmail.com</a>> 

> To: <a href=3D"mailto:pgsql-admin [at] postgresql.org" target=3D"_blank">pg=
sql-admin [at] postgresql.org</a> > Subject: [ADMIN] password authenticati=
on failed for user postgres > Date: Tue, 2 Mar 2010 14:13:10 +0530<br=
>
> > Hi, 
> > 1. I have added =A0listen_addresses =3D '*' ; in =A0po=
stgresql.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 =A0METHOD =A0[OPT=
ION] > host =A0 =A0 =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 al=
l =A0 =A0 =A0 <a href=3D"http://0.0.0.0/0" target=3D"_blank">0.0.0.0/0</a> =
=A0 =A0 =A0 =A0 =A0 =A0 md5 > hostssl =A0 =A0 =A0all =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 all =A0 =A0 =A0 <a href=3D"http://0.0.0.0/0" target=3D"_bla=
nk">0.0.0.0/0</a> =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 create=
user I get the following message =A0: > 'createuser: could not co=
nnect to database postgres: =A0FATAL : 

> password authentication failed for user "postgres" ><b=
r>> This is on Redhat running Plesk also. > > I am new to Li=
nux as well as PostgreSQL. Help would be much appreciated. > 
> Thanks 
> Viv > > > 
</div></div></div> 

--0016e649849a197da20480cf4674--

Major Services [ Di, 02 März 2010 12:00 ] [ ID #2033778 ]

Re: password authentication failed for user postgres

--0016e6d7ee57eb7e250480cf6ade
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

But the server restart has failed; I am yet to make the changes suggested b=
y
you in the first instance.

On Tue, Mar 2, 2010 at 4:32 PM, I=F1igo Martinez Lasala <
imartinez [at] 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 [at] gmail.com<Major%20Services%20%3cse=
rvices.major [at] gmail.com%3e>
> >
> *To*: I=F1igo Martinez Lasala <imartinez [at] vectorsf.com<%3d%3fISO-8859-1%3f=
Q%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vecto rsf.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=F1igo Martinez Lasala <
> imartinez [at] 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 goin=
t
> 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 [at] gmail.com>
> > To: pgsql-admin [at] 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 =3D '*' ; 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
> >
> >
> >
>
>
>

--0016e6d7ee57eb7e250480cf6ade
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

But the server restart has failed; I am yet to make the changes suggested b=
y you in the first instance. <div class=3D"gmail_quote">=
On Tue, Mar 2, 2010 at 4:32 PM, I=F1igo Martinez Lasala &=
lt;<a href=3D"mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</a>>=
 wrote: 
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

<div>
Try with these parameters in pg_hba.conf. Perhaps your postgres-redhat comp=
ilation does not have ident enabled... 
 
local all postgres trust<div class=3D"im"> 
 
 
-----Original Message----- 
From: Major Services <<a href=3D"mailto:Major%20Services%20%3cser=
vices.major [at] gmail.com%3e" target=3D"_blank">services.major [at] gmail.com</a>>=
; 
</div><div><div></div><div class=3D"h5">To: I=F1igo Martinez Lasala =
<<a href=3D"mailto:%3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20L=
asala%20%3cimartinez [at] vectorsf.com%3e" target=3D"_blank">imartinez [at] vectorsf.=
com</a>> 

Subject: Re: [ADMIN] password authentication failed for user postgre=
s 
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=F1igo Martinez Lasala <<a href=3D"mail=
to:imartinez [at] vectorsf.com" target=3D"_blank">imartinez [at] vectorsf.com</a>>=
wrote: 
> In order to lauch createuser you don't need to modify listen_addre=
ss 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=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 postgres=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 ident sameuser 
> 
> 
> Reload postgresql and launch createuser as postgres user. 
> 
> 
> -----Original Message----- 
> From: Major Services <<a href=3D"mailto:services.major [at] gmail.com" t=
arget=3D"_blank">services.major [at] gmail.com</a>> 
> To: <a href=3D"mailto:pgsql-admin [at] postgresql.org" target=3D"_blank">pg=
sql-admin [at] postgresql.org</a> 
> Subject: [ADMIN] password authentication failed for user postgres 
> Date: Tue, 2 Mar 2010 14:13:10 +0530 
> 
> Hi, 
> 
> 1. I have added =A0listen_addresses =3D '*' ; in =A0postgresql=
..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 =A0METHOD =A0[OPT=
ION] 
> host =A0 =A0 =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 all =A0 =
=A0 =A0 <a href=3D"http://0.0.0.0/0" target=3D"_blank">0.0.0.0/0</a> =A0 =
=A0 =A0 =A0 =A0 =A0 md5 
> hostssl =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 all =A0 =A0 =A0=
<a href=3D"http://0.0.0.0/0" target=3D"_blank">0.0.0.0/0</a> =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 message =A0: 
> 'createuser: could not connect to database postgres: =A0FATAL :<br=
>
> 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 appreciate=
d. 
> 
> Thanks 
> Viv 
> 
> 
> 
 
 
</div></div></div>

</blockquote></div> 

--0016e6d7ee57eb7e250480cf6ade--

Major Services [ Di, 02 März 2010 12:10 ] [ ID #2033779 ]

Re: password authentication failed for user postgres

--=-dTZDZLY/Fv7J2lQjQOKG
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 [at] gmail.com>
To: I=C3=B1igo Martinez Lasala <imartinez [at] vectorsf.com>
Cc: pgsql-admin [at] 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=C3=B1igo Martinez Lasala
<imartinez [at] 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 [at] gmail.com>

To: I=C3=B1igo Martinez Lasala <imartinez [at] vectorsf.com>
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=C3=B1igo Martinez Lasala
<imartinez [at] 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 [at] gmail.com>
> To: pgsql-admin [at] 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 =3D '*' ; 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
>
>
>

--=-dTZDZLY/Fv7J2lQjQOKG
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
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 <<A HREF="mailto:Major%20Services%20%3cservices.major [at] gmail.com%3e">services.major [at] gmail.com</A>> 
To: Iñigo Martinez Lasala <<A HREF="mailto:%3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vectorsf.com%3e">imartinez [at] vectorsf.com</A>> 
Cc: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A> 
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 <<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>> wrote:
<BLOCKQUOTE>
Try with these parameters in pg_hba.conf. Perhaps your postgres-redhat compilation does not have ident enabled... 
 
local all postgres trust
</BLOCKQUOTE>
<BLOCKQUOTE>
 
 
 
-----Original Message----- 
From: Major Services <<A HREF="mailto:Major%20Services%20%3cservices.major [at] gmail.com%3e">services.major [at] gmail.com</A>> 
 
</BLOCKQUOTE>
<BLOCKQUOTE>
 
</BLOCKQUOTE>
<BLOCKQUOTE>
To: Iñigo Martinez Lasala <<A HREF="mailto:%3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vectorsf.com%3e">imartinez [at] vectorsf.com</A>> 
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 <<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>> 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 <<A HREF="mailto:services.major [at] gmail.com">services.major [at] gmail.com</A>> 
> To: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A> 
> 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 <A HREF="http://0.0.0.0/0">0.0.0.0/0</A> md5 
> hostssl all all <A HREF="http://0.0.0.0/0">0.0.0.0/0</A> 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 
> 
> 
> 
 
 
 
</BLOCKQUOTE>
 
 
</BODY>
</HTML>

--=-dTZDZLY/Fv7J2lQjQOKG--

imartinez [ Di, 02 März 2010 13:25 ] [ ID #2033780 ]

Re: password authentication failed for user postgres

--0016e6d7ee5795d2a40480d1a3cc
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 =3D 'localhost', '*'

Let me know how to move ahead.
Thanks.

On Tue, Mar 2, 2010 at 5:55 PM, I=F1igo Martinez Lasala <
imartinez [at] 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 [at] gmail.com<Major%20Services%20%3cse=
rvices.major [at] gmail.com%3e>
> >
> *To*: I=F1igo Martinez Lasala <imartinez [at] vectorsf.com<%3d%3fISO-8859-1%3f=
Q%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vecto rsf.com%3e>
> >
> *Cc*: pgsql-admin [at] 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=F1igo Martinez Lasala <
> imartinez [at] 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 [at] gmail.com<Major%20Services%20%3cse=
rvices.major [at] gmail.com%3e>
> >
>
>
> *To*: I=F1igo Martinez Lasala <imartinez [at] vectorsf.com<%3d%3fISO-8859-1%3=
fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vect orsf.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=F1igo Martinez Lasala <
> imartinez [at] 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 goin=
t
> 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 [at] gmail.com>
> > To: pgsql-admin [at] 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 =3D '*' ; 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
> >
> >
> >
>
>
>
>
>
>

--0016e6d7ee5795d2a40480d1a3cc
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

pgstartup.log: The files belonging to this database system will be o=
wned by user "postgres". .... .... Success. You can =
now start the database server using: /usr/bin/postmaster -D /var/lib/pgs=
ql/data 
or /usr/bin/pg_ctl -D /var/lib/pgsql/data -1 logfile start FATAL: lo=
ck file "postmaster.pid"already exists HINT:Is another postmas=
ter (PID 3300) running in data directory"b/pgsql/data"? LOG:=
=A0 logger shutting down 
runuser: cannot set groups: Operation not permitted LOG:=A0 logger shutt=
ing down FATAL: syntax error in file "/var/lib/pgsql/data/postgresq=
l.conf", near token "," Now, in the "/var/li=
b/pgsql/data/postgresql.conf" the only change I have made is in listen=
_addresses; viz 
listen_addresses =3D 'localhost', '*' Let me know ho=
w to move ahead. Thanks. <div class=3D"gmail_quote">On Tue, Mar 2=
, 2010 at 5:55 PM, I=F1igo Martinez Lasala <<a href=3D=
"mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</a>> wrote=
: 
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

<div>
Ah... ok. 
In /var/lib/pgsql you will find a file called pgstartup.log 
Could you post here last lines of this file ?<div class=3D"im"> 
 
 
-----Original Message----- 
From: Major Services <<a href=3D"mailto:Major%20Services%20%3cser=
vices.major [at] gmail.com%3e" target=3D"_blank">services.major [at] gmail.com</a>>=
; 
To: I=F1igo Martinez Lasala <<a href=3D"mailto:%3d%3fISO-8859-1%3=
fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vect orsf.com%3e" ta=
rget=3D"_blank">imartinez [at] vectorsf.com</a>> 
</div><div class=3D"im">Cc: <a href=3D"mailto:pgsql-admin [at] postgresql=
..org" target=3D"_blank">pgsql-admin [at] postgresql.org</a> 
Subject: Re: [ADMIN] password authentication failed for user postgre=
s 
</div><div><div></div><div class=3D"h5">Date: Tue, 2 Mar 2010 16:40:=
47 +0530 
 
But the server restart has failed; I am yet to make the changes suggested b=
y you in the first instance. 
 
 
 
 
On Tue, Mar 2, 2010 at 4:32 PM, I=F1igo Martinez Lasala <<a href=3D"mail=
to:imartinez [at] vectorsf.com" target=3D"_blank">imartinez [at] vectorsf.com</a>>=
wrote:
<blockquote>
Try with these parameters in pg_hba.conf. Perhaps your postgres-redhat =
compilation does not have ident enabled... 
 
local all postgres trust
</blockquote>
<blockquote>
 
 
 
-----Original Message----- 
From: Major Services <<a href=3D"mailto:Major%20Services%20%3=
cservices.major [at] gmail.com%3e" target=3D"_blank">services.major [at] gmail.com</a=
>> 
 
</blockquote>
<blockquote>
 
</blockquote>
<blockquote>
To: I=F1igo Martinez Lasala <<a href=3D"mailto:%3d%3fISO-8859=
-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vectorsf.com%3e=
" target=3D"_blank">imartinez [at] vectorsf.com</a>> 
Subject: Re: [ADMIN] password authentication failed for user pos=
tgres 
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 postgre=
sql 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=F1igo Martinez Lasala <<a href=3D"=
mailto:imartinez [at] vectorsf.com" target=3D"_blank">imartinez [at] vectorsf.com</a>=
> wrote: 
> In order to lauch createuser you don't need to modify listen_a=
ddress 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=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 postgres=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 ident sameuser<br=
>
> 
> 
> Reload postgresql and launch createuser as postgres user. 
> 
> 
> -----Original Message----- 
> From: Major Services <<a href=3D"mailto:services.major [at] gmail.co=
m" target=3D"_blank">services.major [at] gmail.com</a>> 
> To: <a href=3D"mailto:pgsql-admin [at] postgresql.org" target=3D"_blank=
">pgsql-admin [at] postgresql.org</a> 
> Subject: [ADMIN] password authentication failed for user postgres<=
br>
> Date: Tue, 2 Mar 2010 14:13:10 +0530 
> 
> Hi, 
> 
> 1. I have added =A0listen_addresses =3D '*' ; in =A0postgr=
esql.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 =A0METHOD =A0=
[OPTION] 
> host =A0 =A0 =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 all =
=A0 =A0 =A0 <a href=3D"http://0.0.0.0/0" target=3D"_blank">0.0.0.0/0</a> =
=A0 =A0 =A0 =A0 =A0 =A0 md5 
> hostssl =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 all =A0 =A0=
=A0 <a href=3D"http://0.0.0.0/0" target=3D"_blank">0.0.0.0/0</a> =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 message =A0:=
 
> 'createuser: could not connect to database postgres: =A0FATAL =
: 
> 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 apprec=
iated. 
> 
> Thanks 
> Viv 
> 
> 
> 
 
 
 
</blockquote>
 
 
</div></div></div>

</blockquote></div> 

--0016e6d7ee5795d2a40480d1a3cc--

Major Services [ Di, 02 März 2010 14:49 ] [ ID #2033781 ]

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 [at] 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 [at] gmail.com<Major%20Services%20%3cservices.major [at] gmail.com%3e>
> > >
> > *To*: I?igo Martinez Lasala <imartinez [at] vectorsf.com<%3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vectorsf.com%3e>
> > >
> > *Cc*: pgsql-admin [at] 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 [at] 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 [at] gmail.com<Major%20Services%20%3cservices.major [at] gmail.com%3e>
> > >
> >
> >
> > *To*: I?igo Martinez Lasala <imartinez [at] vectorsf.com<%3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] 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 [at] 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 [at] gmail.com>
> > > To: pgsql-admin [at] 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
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Kenneth Marshall [ Di, 02 März 2010 14:57 ] [ ID #2033782 ]

Re: password authentication failed for user postgres

--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 <ktm [at] 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: 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.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 [at] gmail.com<
> Major%20Services%20%3cservices.major [at] gmail.com<Major%2520Services%2520%253cservices.major [at] gmail.com>
> %3e>
> > > >
> > > *To*: I?igo Martinez Lasala <imartinez [at] vectorsf.com<%
> 3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20 %3cimartinez [at] vectorsf.com<3d%253fISO-8859-1%253fQ%253fI%253dF1igo%253f%253d%2520Martinez%2520Lasala%2520%253cimartinez [at] vectorsf.com>
> %3e>
> > > >
> > > *Cc*: pgsql-admin [at] 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 [at] 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 [at] gmail.com<
> Major%20Services%20%3cservices.major [at] gmail.com<Major%2520Services%2520%253cservices.major [at] gmail.com>
> %3e>
> > > >
> > >
> > >
> > > *To*: I?igo Martinez Lasala <imartinez [at] vectorsf.com<%
> 3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20 %3cimartinez [at] vectorsf.com<3d%253fISO-8859-1%253fQ%253fI%253dF1igo%253f%253d%2520Martinez%2520Lasala%2520%253cimartinez [at] 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 [at] 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 [at] gmail.com>
> > > > To: pgsql-admin [at] 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 <div class=3D"gmail_quote">On Tue, Mar =
2, 2010 at 7:27 PM, Kenneth Marshall <<a href=3D"mailt=
o:ktm [at] rice.edu">ktm [at] rice.edu</a>> wrote: 
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">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 
<div class=3D"im"> 
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. 
> 
</div>> On Tue, Mar 2, 2010 at 5:55 PM, I?igo Martinez Lasala < 
<div class=3D"im">> <a href=3D"mailto:imartinez [at] vectorsf.com">imartinez [at] =
vectorsf.com</a>> 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----- 
</div><div class=3D"im">> > *From*: Major Services <<a href=3D"mai=
lto:services.major [at] gmail.com">services.major [at] gmail.com</a><<a href=3D"ma=
ilto:Major%2520Services%2520%253cservices.major [at] gmail.com">M ajor%20Services=
%20%3cservices.major [at] gmail.com</a>%3e> 

> > > 
> > *To*: I?igo Martinez Lasala <<a href=3D"mailto:imartinez [at] vecto=
rsf.com">imartinez [at] vectorsf.com</a><%<a href=3D"mailto:3d%253fISO-8859-1=
%253fQ%253fI%253dF1igo%253f%253d%2520Martinez%2520Lasala%252 0%253cimartinez=
[at] vectorsf.com">3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Marti nez%20Lasala%20=
%3cimartinez [at] vectorsf.com</a>%3e> 

> > > 
> > *Cc*: <a href=3D"mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] p=
ostgresql.org</a> 
> > *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. 
> > 
> > 
> > 
> > 
</div>> > On Tue, Mar 2, 2010 at 4:32 PM, I?igo Martinez Lasala <<=
br>
<div class=3D"im">> > <a href=3D"mailto:imartinez [at] vectorsf.com">imart=
inez [at] vectorsf.com</a>> 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----- 
</div><div class=3D"im">> > *From*: Major Services <<a href=3D"mai=
lto:services.major [at] gmail.com">services.major [at] gmail.com</a><<a href=3D"ma=
ilto:Major%2520Services%2520%253cservices.major [at] gmail.com">M ajor%20Services=
%20%3cservices.major [at] gmail.com</a>%3e> 

> > > 
> > 
> > 
> > =A0*To*: I?igo Martinez Lasala <<a href=3D"mailto:imartinez [at] ve=
ctorsf.com">imartinez [at] vectorsf.com</a><%<a href=3D"mailto:3d%253fISO-885=
9-1%253fQ%253fI%253dF1igo%253f%253d%2520Martinez%2520Lasala% 2520%253cimarti=
nez [at] vectorsf.com">3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Ma rtinez%20Lasala=
%20%3cimartinez [at] vectorsf.com</a>%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? 
> > 
</div>> > On Tue, Mar 2, 2010 at 2:44 PM, I?igo Martinez Lasala <<=
br>
<div><div></div><div class=3D"h5">> > <a href=3D"mailto:imartinez [at] vec=
torsf.com">imartinez [at] vectorsf.com</a>> 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.<br=
>
> > > 
> > > 
> > > -----Original Message----- 
> > > From: Major Services <<a href=3D"mailto:services.major [at] gm=
ail.com">services.major [at] gmail.com</a>> 
> > > To: <a href=3D"mailto:pgsql-admin [at] postgresql.org">pgsql-admi=
n [at] postgresql.org</a> 
> > > 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<br=
>
> > > 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 <a href=3D"http://0.0.0.0/0" target=3D"_blank">0.0.0.0/0</a=
> =A0 =A0 =A0 =A0 =A0 =A0 md5 
> > > hostssl =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 all =
=A0 =A0 =A0 <a href=3D"http://0.0.0.0/0" target=3D"_blank">0.0.0.0/0</a> =
=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 
> > > 
> > > 
> > > 
> > 
> > 
> > 
> > 
> > 
> > 
</div></div></blockquote></div> 

--0016e6d7ee570ac6d50480d22c6a--

Major Services [ Di, 02 März 2010 15:27 ] [ ID #2033783 ]

Re: password authentication failed for user postgres

Finally, I am able to create a user.

Now when I try to connect to the server through DBWebAdmin (in
Parallels Plesk Panel); I get the following :
Error: FATAL: Ident authentication failed for user "postgres"

(earlier, with this link I could reach the login screen for PgAdmin )

Do I need to remove the following from pg_hba.conf now?
local all postgres ident sameuser

On Tue, Mar 2, 2010 at 2:44 PM, I=F1igo Martinez Lasala
<imartinez [at] 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=A0=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 postgres=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 ident sameuser
>
>
> Reload postgresql and launch createuser as postgres user.
>
>
> -----Original Message-----
> From: Major Services <services.major [at] gmail.com>
> To: pgsql-admin [at] 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 =3D '*' ; 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
>
>
>

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Major Services [ Mi, 03 März 2010 15:37 ] [ ID #2033906 ]

Re: password authentication failed for user postgres

--=-P++OglFBp09Qr+EeWRW5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Great. You managed to start server. :-)

You are using user postgres and you shoudn't use it.I suggest you to
create your own dbadmin...

In your linux box, as root user:

su - postgres
createuser -s dbadmin -P

You will create a new user called dbadmin. It will ask you for a
password for this user and some extra options. Response YES to all.

Now you can connect remotely with this dbadmin user.

-----Original Message-----
From: Major Services <services.major [at] gmail.com>
To: I=C3=B1igo Martinez Lasala <imartinez [at] vectorsf.com>
Cc: pgsql-admin [at] postgresql.org
Subject: Re: [ADMIN] password authentication failed for user postgres
Date: Wed, 3 Mar 2010 20:07:23 +0530

Finally, I am able to create a user.

Now when I try to connect to the server through DBWebAdmin (in
Parallels Plesk Panel); I get the following :
Error: FATAL: Ident authentication failed for user "postgres"

(earlier, with this link I could reach the login screen for PgAdmin )

Do I need to remove the following from pg_hba.conf now?
local all postgres ident sameuser

On Tue, Mar 2, 2010 at 2:44 PM, I=C3=B1igo Martinez Lasala
<imartinez [at] vectorsf.com> wrote:
> In order to lauch createuser you don't need to modify listen_address si=
nce
> you can use unix sockets. But anyway it's a requirement if you are goin=
t 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 [at] gmail.com>
> To: pgsql-admin [at] 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 =3D '*' ; 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]
>

> 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
>
>
>

--=-P++OglFBp09Qr+EeWRW5
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
Great. You managed to start server. :-) 
 
You are using user postgres and you shoudn't use it.I suggest you to create your own dbadmin... 
 
In your linux box, as root user: 
 
su - postgres 
createuser -s dbadmin -P 
 
You will create a new user called dbadmin. It will ask you for a password for this user and some extra options. Response YES to all. 
 
Now you can connect remotely with this dbadmin user. 
 
 
 
-----Original Message----- 
From: Major Services <<A HREF="mailto:Major%20Services%20%3cservices.major [at] gmail.com%3e">services.major [at] gmail.com</A>> 
To: Iñigo Martinez Lasala <<A HREF="mailto:%3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vectorsf.com%3e">imartinez [at] vectorsf.com</A>> 
Cc: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A> 
Subject: Re: [ADMIN] password authentication failed for user postgres 
Date: Wed, 3 Mar 2010 20:07:23 +0530 
 
<PRE>
Finally, I am able to create a user.

Now when I try to connect to the server through DBWebAdmin (in
Parallels Plesk Panel); I get the following :
Error: FATAL: Ident authentication failed for user "postgres"

(earlier, with this link I could reach the login screen for PgAdmin )

Do I need to remove the following from pg_hba.conf now?
local all postgres ident sameuser

On Tue, Mar 2, 2010 at 2:44 PM, Iñigo Martinez Lasala
<<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>> 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 <<A HREF="mailto:services.major [at] gmail.com">services.major [at] gmail.com</A>>
> To: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A>
> 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]
>

> 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
>
>
>
</PRE>
 
</BODY>
</HTML>

--=-P++OglFBp09Qr+EeWRW5--

imartinez [ Mi, 03 März 2010 16:26 ] [ ID #2033908 ]

Re: password authentication failed for user postgres

Thanks.
I already have created a user.
And can connect to the server through the PgAdmin on my local system.

My query now is :
Now when I try to connect to the server through DBWebAdmin (in
Parallels Plesk Panel); I get the following :
Error: FATAL: Ident authentication failed for user "postgres"

(earlier, with this link I could reach the login screen for PgAdmin )

Do I need to remove the following from pg_hba.conf now?
local all postgres ident sameuser

Thanks for all your help & support.

On Wed, Mar 3, 2010 at 8:56 PM, I=F1igo Martinez Lasala
<imartinez [at] vectorsf.com> wrote:
> Great. You managed to start server. :-)
>
> You are using user postgres and you shoudn't use it.I suggest you to crea=
te
> your own dbadmin...
>
> In your linux box, as root user:
>
> su - postgres
> createuser -s dbadmin -P
>
> You will create a new user called dbadmin. It will ask you for a password
> for this user and some extra options. Response YES to all.
>
> Now you can connect remotely with this dbadmin user.
>
>
>
> -----Original Message-----
> From: Major Services <services.major [at] gmail.com>
> To: I=F1igo Martinez Lasala <imartinez [at] vectorsf.com>
> Cc: pgsql-admin [at] postgresql.org
> Subject: Re: [ADMIN] password authentication failed for user postgres
> Date: Wed, 3 Mar 2010 20:07:23 +0530
>
>
> Finally, I am able to create a user.
>
> Now when I try to connect to the server through DBWebAdmin (in
> Parallels Plesk Panel); I get the following :
> Error: FATAL: Ident authentication failed for user "postgres"
>
> (earlier, with this link I could reach the login screen for PgAdmin )
>
> Do I need to remove the following from pg_hba.conf now?
> local all postgres ident sameuser
>
>
>
>
>
> On Tue, Mar 2, 2010 at 2:44 PM, I=F1igo Martinez Lasala
> <imartinez [at] vectorsf.com> wrote:
>> In order to lauch createuser you don't need to modify listen_address sin=
ce
>> 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=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 postgres=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 ident sameuser
>>
>>
>> Reload postgresql and launch createuser as postgres user.
>>
>>
>> -----Original Message-----
>> From: Major Services <services.major [at] gmail.com>
>> To: pgsql-admin [at] 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 =3D '*' ; 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]
>>
>
>> 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
>>
>>
>>
>
>

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Major Services [ Mi, 03 März 2010 18:11 ] [ ID #2033909 ]

Re: password authentication failed for user postgres

--=-2ry2w3vcpRj/vTXXah/P
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

OK, it's a web app installed locally...

Modify config file for this app (I don't know about it, so you will have
to search by yourserlf) and point to 127.0.0.1 instead of use unix
sockets, and also change use postgres for user dbadmin.

Or modify your pg_hba.conf like this
local all postgres trust

I don't suggest to revert to "local all postgres password" since you
will have to enter password for any local operation in your server, but
anyway, it's your decision.

-----Original Message-----
From: Major Services <services.major [at] gmail.com>
To: I=C3=B1igo Martinez Lasala <imartinez [at] vectorsf.com>
Cc: pgsql-admin [at] postgresql.org
Subject: Re: [ADMIN] password authentication failed for user postgres
Date: Wed, 3 Mar 2010 22:41:47 +0530

Thanks.
I already have created a user.
And can connect to the server through the PgAdmin on my local system.

My query now is :
Now when I try to connect to the server through DBWebAdmin (in
Parallels Plesk Panel); I get the following :
Error: FATAL: Ident authentication failed for user "postgres"

(earlier, with this link I could reach the login screen for PgAdmin )

Do I need to remove the following from pg_hba.conf now?
local all postgres ident sameuser

Thanks for all your help & support.

On Wed, Mar 3, 2010 at 8:56 PM, I=C3=B1igo Martinez Lasala
<imartinez [at] vectorsf.com> wrote:
> Great. You managed to start server. :-)
>
> You are using user postgres and you shoudn't use it.I suggest you to cr=
eate
> your own dbadmin...
>
> In your linux box, as root user:
>
> su - postgres
> createuser -s dbadmin -P
>
> You will create a new user called dbadmin. It will ask you for a passwo=
rd
> for this user and some extra options. Response YES to all.
>
> Now you can connect remotely with this dbadmin user.
>
>
>
> -----Original Message-----
> From: Major Services <services.major [at] gmail.com>
> To: I=C3=B1igo Martinez Lasala <imartinez [at] vectorsf.com>
> Cc: pgsql-admin [at] postgresql.org
> Subject: Re: [ADMIN] password authentication failed for user postgres
> Date: Wed, 3 Mar 2010 20:07:23 +0530
>
>
> Finally, I am able to create a user.
>
> Now when I try to connect to the server through DBWebAdmin (in
> Parallels Plesk Panel); I get the following :
> Error: FATAL: Ident authentication failed for user "postgres"
>
> (earlier, with this link I could reach the login screen for PgAdmin )
>
> Do I need to remove the following from pg_hba.conf now?
> local all postgres ident sameuser
>
>
>
>
>
> On Tue, Mar 2, 2010 at 2:44 PM, I=C3=B1igo Martinez Lasala
> <imartinez [at] vectorsf.com> wrote:
>> In order to lauch createuser you don't need to modify listen_address s=
ince
>> you can use unix sockets. But anyway it's a requirement if you are goi=
nt
>> 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 [at] gmail.com>
>> To: pgsql-admin [at] 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 =3D '*' ; 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]
>>
>
>> 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 appreciate=
d.
>>
>> Thanks
>> Viv
>>
>>
>>
>
>

--=-2ry2w3vcpRj/vTXXah/P
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
OK, it's a web app installed locally... 
 
Modify config file for this app (I don't know about it, so you will have to search by yourserlf) and point to 127.0.0.1 instead of use unix sockets, and also change use postgres for user dbadmin. 
 
Or modify your pg_hba.conf like this 
local all postgres trust 
 
I don't suggest to revert to "local all postgres password" since you will have to enter password for any local operation in your server, but anyway, it's your decision. 
 
-----Original Message----- 
From: Major Services <<A HREF="mailto:Major%20Services%20%3cservices.major [at] gmail.com%3e">services.major [at] gmail.com</A>> 
To: Iñigo Martinez Lasala <<A HREF="mailto:%3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vectorsf.com%3e">imartinez [at] vectorsf.com</A>> 
Cc: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A> 
Subject: Re: [ADMIN] password authentication failed for user postgres 
Date: Wed, 3 Mar 2010 22:41:47 +0530 
 
<PRE>
Thanks.
I already have created a user.
And can connect to the server through the PgAdmin on my local system.

My query now is :
Now when I try to connect to the server through DBWebAdmin (in
Parallels Plesk Panel); I get the following :
Error: FATAL: Ident authentication failed for user "postgres"

(earlier, with this link I could reach the login screen for PgAdmin )

Do I need to remove the following from pg_hba.conf now?
local all postgres ident sameuser

Thanks for all your help & support.

On Wed, Mar 3, 2010 at 8:56 PM, Iñigo Martinez Lasala
<<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>> wrote:
> Great. You managed to start server. :-)
>
> You are using user postgres and you shoudn't use it.I suggest you to create
> your own dbadmin...
>
> In your linux box, as root user:
>
> su - postgres
> createuser -s dbadmin -P
>
> You will create a new user called dbadmin. It will ask you for a password
> for this user and some extra options. Response YES to all.
>
> Now you can connect remotely with this dbadmin user.
>
>
>
> -----Original Message-----
> From: Major Services <<A HREF="mailto:services.major [at] gmail.com">services.major [at] gmail.com</A>>
> To: Iñigo Martinez Lasala <<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>>
> Cc: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A>
> Subject: Re: [ADMIN] password authentication failed for user postgres
> Date: Wed, 3 Mar 2010 20:07:23 +0530
>
>
> Finally, I am able to create a user.
>
> Now when I try to connect to the server through DBWebAdmin (in
> Parallels Plesk Panel); I get the following :
> Error: FATAL: Ident authentication failed for user "postgres"
>
> (earlier, with this link I could reach the login screen for PgAdmin )
>
> Do I need to remove the following from pg_hba.conf now?
> local all postgres ident sameuser
>
>
>
>
>
> On Tue, Mar 2, 2010 at 2:44 PM, Iñigo Martinez Lasala
> <<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>> 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 <<A HREF="mailto:services.major [at] gmail.com">services.major [at] gmail.com</A>>
>> To: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A>
>> 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]
>>
>
>> 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
>>
>>
>>
>
>
</PRE>
 
</BODY>
</HTML>

--=-2ry2w3vcpRj/vTXXah/P--

imartinez [ Mi, 03 März 2010 18:19 ] [ ID #2033910 ]

Re: password authentication failed for user postgres

When I try to login as dbadmin through shell, I get 'access denied'.

What could be wrong?

On Wed, Mar 3, 2010 at 10:49 PM, I=F1igo Martinez Lasala
<imartinez [at] vectorsf.com> wrote:
> OK, it's a web app installed locally...
>
> Modify config file for this app (I don't know about it, so you will have =
to
> search by yourserlf) and point to 127.0.0.1 instead of use unix sockets, =
and
> also change use postgres for user dbadmin.
>
> Or modify your pg_hba.conf like this
> local=A0=A0=A0=A0 all=A0=A0=A0=A0 postgres=A0=A0=A0=A0 trust
>
> I don't suggest to revert to "local all postgres password" since you will
> have to enter password for any local operation in your server, but anyway,
> it's your decision.
>
> -----Original Message-----
> From: Major Services <services.major [at] gmail.com>
> To: I=F1igo Martinez Lasala <imartinez [at] vectorsf.com>
> Cc: pgsql-admin [at] postgresql.org
> Subject: Re: [ADMIN] password authentication failed for user postgres
> Date: Wed, 3 Mar 2010 22:41:47 +0530
>
> Thanks.
> I already have created a user.
> And can connect to the server through the PgAdmin on my local system.
>
> My query now is :
> Now when I try to connect to the server through DBWebAdmin (in
> Parallels Plesk Panel); I get the following :
> Error: FATAL: Ident authentication failed for user "postgres"
>
> (earlier, with this link I could reach the login screen for PgAdmin )
>
> Do I need to remove the following from pg_hba.conf now?
> local all postgres ident sameuser
>
> Thanks for all your help & support.
>
>
>
> On Wed, Mar 3, 2010 at 8:56 PM, I=F1igo Martinez Lasala
> <imartinez [at] vectorsf.com> wrote:
>> Great. You managed to start server. :-)
>>
>> You are using user postgres and you shoudn't use it.I suggest you to
>> create
>> your own dbadmin...
>>
>> In your linux box, as root user:
>>
>> su - postgres
>> createuser -s dbadmin -P
>>
>> You will create a new user called dbadmin. It will ask you for a password
>> for this user and some extra options. Response YES to all.
>>
>> Now you can connect remotely with this dbadmin user.
>>
>>
>>
>> -----Original Message-----
>> From: Major Services <services.major [at] gmail.com>
>> To: I=F1igo Martinez Lasala <imartinez [at] vectorsf.com>
>> Cc: pgsql-admin [at] postgresql.org
>> Subject: Re: [ADMIN] password authentication failed for user postgres
>> Date: Wed, 3 Mar 2010 20:07:23 +0530
>>
>>
>> Finally, I am able to create a user.
>>
>> Now when I try to connect to the server through DBWebAdmin (in
>> Parallels Plesk Panel); I get the following :
>> Error: FATAL: Ident authentication failed for user "postgres"
>>
>> (earlier, with this link I could reach the login screen for PgAdmin )
>>
>> Do I need to remove the following from pg_hba.conf now?
>> local all postgres ident sameuser
>>
>>
>>
>>
>>
>> On Tue, Mar 2, 2010 at 2:44 PM, I=F1igo Martinez Lasala
>> <imartinez [at] 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=A0=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 postgres=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 ident sameuser
>>>
>>>
>>> Reload postgresql and launch createuser as postgres user.
>>>
>>>
>>> -----Original Message-----
>>> From: Major Services <services.major [at] gmail.com>
>>> To: pgsql-admin [at] 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 =3D '*' ; 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]
>>>
>>
>>> 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
>>>
>>>
>>>
>>
>>
>
>

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Major Services [ Mi, 03 März 2010 19:10 ] [ ID #2033913 ]

Re: password authentication failed for user postgres

--=-rwkI6eit3C0/g1sErbwS
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

dbadmin is a database user, not a Linux user.
You cannot use dbadmin in order to get logged to your machine. Only to
access database.

Why are you using dbadmin to login to unix? Use root.

Configure your web app using your root user to login to postgresql with
dbadmin. You will have to modify a config file somewhere in the path of
this app. Read INSTALL or README files of your web app.

Use phppgadmin as alternative. It's also free and it will be probably at
RedHat/CentOS repos. "yum install phppgadmin" or "up2date install
phppgadmin"
Or webmin if you want to admin all server without having to use command
line. http://www.webmin.com/

-----Original Message-----
From: Major Services <services.major [at] gmail.com>
To: I=C3=B1igo Martinez Lasala <imartinez [at] vectorsf.com>
Cc: pgsql-admin [at] postgresql.org
Subject: Re: [ADMIN] password authentication failed for user postgres
Date: Wed, 3 Mar 2010 23:40:39 +0530

When I try to login as dbadmin through shell, I get 'access denied'.

What could be wrong?

On Wed, Mar 3, 2010 at 10:49 PM, I=C3=B1igo Martinez Lasala
<imartinez [at] vectorsf.com> wrote:
> OK, it's a web app installed locally...
>
> Modify config file for this app (I don't know about it, so you will hav=
e to
> search by yourserlf) and point to 127.0.0.1 instead of use unix sockets=
, and
> also change use postgres for user dbadmin.
>
> Or modify your pg_hba.conf like this
> local all postgres trust
>
> I don't suggest to revert to "local all postgres password" since you wi=
ll
> have to enter password for any local operation in your server, but anyw=
ay,
> it's your decision.
>
> -----Original Message-----
> From: Major Services <services.major [at] gmail.com>
> To: I=C3=B1igo Martinez Lasala <imartinez [at] vectorsf.com>
> Cc: pgsql-admin [at] postgresql.org
> Subject: Re: [ADMIN] password authentication failed for user postgres
> Date: Wed, 3 Mar 2010 22:41:47 +0530
>
> Thanks.
> I already have created a user.
> And can connect to the server through the PgAdmin on my local system.
>
> My query now is :
> Now when I try to connect to the server through DBWebAdmin (in
> Parallels Plesk Panel); I get the following :
> Error: FATAL: Ident authentication failed for user "postgres"
>
> (earlier, with this link I could reach the login screen for PgAdmin )
>
> Do I need to remove the following from pg_hba.conf now?
> local all postgres ident sameuser
>
> Thanks for all your help & support.
>
>
>
> On Wed, Mar 3, 2010 at 8:56 PM, I=C3=B1igo Martinez Lasala
> <imartinez [at] vectorsf.com> wrote:
>> Great. You managed to start server. :-)
>>
>> You are using user postgres and you shoudn't use it.I suggest you to
>> create
>> your own dbadmin...
>>
>> In your linux box, as root user:
>>
>> su - postgres
>> createuser -s dbadmin -P
>>
>> You will create a new user called dbadmin. It will ask you for a passw=
ord
>> for this user and some extra options. Response YES to all.
>>
>> Now you can connect remotely with this dbadmin user.
>>
>>
>>
>> -----Original Message-----
>> From: Major Services <services.major [at] gmail.com>
>> To: I=C3=B1igo Martinez Lasala <imartinez [at] vectorsf.com>
>> Cc: pgsql-admin [at] postgresql.org
>> Subject: Re: [ADMIN] password authentication failed for user postgres
>> Date: Wed, 3 Mar 2010 20:07:23 +0530
>>
>>
>> Finally, I am able to create a user.
>>
>> Now when I try to connect to the server through DBWebAdmin (in
>> Parallels Plesk Panel); I get the following :
>> Error: FATAL: Ident authentication failed for user "postgres"
>>
>> (earlier, with this link I could reach the login screen for PgAdmin )
>>
>> Do I need to remove the following from pg_hba.conf now?
>> local all postgres ident sameuser
>>
>>
>>
>>
>>
>> On Tue, Mar 2, 2010 at 2:44 PM, I=C3=B1igo Martinez Lasala
>> <imartinez [at] 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 go=
int
>>> 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 [at] gmail.com>
>>> To: pgsql-admin [at] 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 =3D '*' ; 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]
>>>
>>
>>> 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 appreciat=
ed.
>>>
>>> Thanks
>>> Viv
>>>
>>>
>>>
>>
>>
>
>

--=-rwkI6eit3C0/g1sErbwS
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
dbadmin is a database user, not a Linux user. 
You cannot use dbadmin in order to get logged to your machine. Only to access database. 
 
Why are you using dbadmin to login to unix? Use root. 
 
Configure your web app using your root user to login to postgresql with dbadmin. You will have to modify a config file somewhere in the path of this app. Read INSTALL or README files of your web app. 
 
Use phppgadmin as alternative. It's also free and it will be probably at RedHat/CentOS repos. "yum install phppgadmin" or "up2date install phppgadmin" 
Or webmin if you want to admin all server without having to use command line. <A HREF="http://www.webmin.com/">http://www.webmin.com/</A> 
 
 
 
 
-----Original Message----- 
From: Major Services <<A HREF="mailto:Major%20Services%20%3cservices.major [at] gmail.com%3e">services.major [at] gmail.com</A>> 
To: Iñigo Martinez Lasala <<A HREF="mailto:%3d%3fISO-8859-1%3fQ%3fI%3dF1igo%3f%3d%20Martinez%20Lasala%20%3cimartinez [at] vectorsf.com%3e">imartinez [at] vectorsf.com</A>> 
Cc: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A> 
Subject: Re: [ADMIN] password authentication failed for user postgres 
Date: Wed, 3 Mar 2010 23:40:39 +0530 
 
<PRE>
When I try to login as dbadmin through shell, I get 'access denied'.

What could be wrong?

On Wed, Mar 3, 2010 at 10:49 PM, Iñigo Martinez Lasala
<<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>> wrote:
> OK, it's a web app installed locally...
>
> Modify config file for this app (I don't know about it, so you will have to
> search by yourserlf) and point to 127.0.0.1 instead of use unix sockets, and
> also change use postgres for user dbadmin.
>
> Or modify your pg_hba.conf like this
> local all postgres trust
>
> I don't suggest to revert to "local all postgres password" since you will
> have to enter password for any local operation in your server, but anyway,
> it's your decision.
>
> -----Original Message-----
> From: Major Services <<A HREF="mailto:services.major [at] gmail.com">services.major [at] gmail.com</A>>
> To: Iñigo Martinez Lasala <<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>>
> Cc: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A>
> Subject: Re: [ADMIN] password authentication failed for user postgres
> Date: Wed, 3 Mar 2010 22:41:47 +0530
>
> Thanks.
> I already have created a user.
> And can connect to the server through the PgAdmin on my local system.
>
> My query now is :
> Now when I try to connect to the server through DBWebAdmin (in
> Parallels Plesk Panel); I get the following :
> Error: FATAL: Ident authentication failed for user "postgres"
>
> (earlier, with this link I could reach the login screen for PgAdmin )
>
> Do I need to remove the following from pg_hba.conf now?
> local all postgres ident sameuser
>
> Thanks for all your help & support.
>
>
>
> On Wed, Mar 3, 2010 at 8:56 PM, Iñigo Martinez Lasala
> <<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>> wrote:
>> Great. You managed to start server. :-)
>>
>> You are using user postgres and you shoudn't use it.I suggest you to
>> create
>> your own dbadmin...
>>
>> In your linux box, as root user:
>>
>> su - postgres
>> createuser -s dbadmin -P
>>
>> You will create a new user called dbadmin. It will ask you for a password
>> for this user and some extra options. Response YES to all.
>>
>> Now you can connect remotely with this dbadmin user.
>>
>>
>>
>> -----Original Message-----
>> From: Major Services <<A HREF="mailto:services.major [at] gmail.com">services.major [at] gmail.com</A>>
>> To: Iñigo Martinez Lasala <<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>>
>> Cc: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A>
>> Subject: Re: [ADMIN] password authentication failed for user postgres
>> Date: Wed, 3 Mar 2010 20:07:23 +0530
>>
>>
>> Finally, I am able to create a user.
>>
>> Now when I try to connect to the server through DBWebAdmin (in
>> Parallels Plesk Panel); I get the following :
>> Error: FATAL: Ident authentication failed for user "postgres"
>>
>> (earlier, with this link I could reach the login screen for PgAdmin )
>>
>> Do I need to remove the following from pg_hba.conf now?
>> local all postgres ident sameuser
>>
>>
>>
>>
>>
>> On Tue, Mar 2, 2010 at 2:44 PM, Iñigo Martinez Lasala
>> <<A HREF="mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</A>> 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 <<A HREF="mailto:services.major [at] gmail.com">services.major [at] gmail.com</A>>
>>> To: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A>
>>> 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]
>>>
>>
>>> 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
>>>
>>>
>>>
>>
>>
>
>
</PRE>
 
</BODY>
</HTML>

--=-rwkI6eit3C0/g1sErbwS--

imartinez [ Do, 04 März 2010 09:24 ] [ ID #2034025 ]

Re: password authentication failed for user postgres

--0016e6d77fa04efd350480f7f36a
Content-Type: multipart/alternative; boundary=0016e6d77fa04efd300480f7f369

--0016e6d77fa04efd300480f7f369
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I see.

I have pgAdmin III on my local system and have been able to create database
and tables through it. I hope this is fine?

Thanks once again; though I am sure I'll be back with some query for you an=
d
the community.[?]

On Thu, Mar 4, 2010 at 1:54 PM, I=F1igo Martinez Lasala <
imartinez [at] vectorsf.com> wrote:
> dbadmin is a database user, not a Linux user.
> You cannot use dbadmin in order to get logged to your machine. Only to
> access database.
>
> Why are you using dbadmin to login to unix? Use root.
>
> Configure your web app using your root user to login to postgresql with
> dbadmin. You will have to modify a config file somewhere in the path of
this
> app. Read INSTALL or README files of your web app.
>
> Use phppgadmin as alternative. It's also free and it will be probably at
> RedHat/CentOS repos. "yum install phppgadmin" or "up2date install
> phppgadmin"
> Or webmin if you want to admin all server without having to use command
> line. http://www.webmin.com/
>
>
>
>
> -----Original Message-----
> From: Major Services <services.major [at] gmail.com>
> To: I=F1igo Martinez Lasala <imartinez [at] vectorsf.com>
> Cc: pgsql-admin [at] postgresql.org
> Subject: Re: [ADMIN] password authentication failed for user postgres
> Date: Wed, 3 Mar 2010 23:40:39 +0530
>
> When I try to login as dbadmin through shell, I get 'access denied'.
>
> What could be wrong?
>
> On Wed, Mar 3, 2010 at 10:49 PM, I=F1igo Martinez Lasala
> <imartinez [at] vectorsf.com> wrote:
>> OK, it's a web app installed locally...
>>
>> Modify config file for this app (I don't know about it, so you will have
>> to
>> search by yourserlf) and point to 127.0.0.1 instead of use unix sockets,
>> and
>> also change use postgres for user dbadmin.
>>
>> Or modify your pg_hba.conf like this
>> local all postgres trust
>>
>> I don't suggest to revert to "local all postgres password" since you wil=
l
>> have to enter password for any local operation in your server, but
anyway,
>> it's your decision.
>>
>> -----Original Message-----
>> From: Major Services <services.major [at] gmail.com>
>> To: I=F1igo Martinez Lasala <imartinez [at] vectorsf.com>
>> Cc: pgsql-admin [at] postgresql.org
>> Subject: Re: [ADMIN] password authentication failed for user postgres
>> Date: Wed, 3 Mar 2010 22:41:47 +0530
>>
>> Thanks.
>> I already have created a user.
>> And can connect to the server through the PgAdmin on my local system.
>>
>> My query now is :
>> Now when I try to connect to the server through DBWebAdmin (in
>> Parallels Plesk Panel); I get the following :
>> Error: FATAL: Ident authentication failed for user "postgres"
>>
>> (earlier, with this link I could reach the login screen for PgAdmin )
>>
>> Do I need to remove the following from pg_hba.conf now?
>> local all postgres ident sameuser
>>
>> Thanks for all your help & support.
>>
>>
>>
>> On Wed, Mar 3, 2010 at 8:56 PM, I=F1igo Martinez Lasala
>> <imartinez [at] vectorsf.com> wrote:
>>> Great. You managed to start server. :-)
>>>
>>> You are using user postgres and you shoudn't use it.I suggest you to
>>> create
>>> your own dbadmin...
>>>
>>> In your linux box, as root user:
>>>
>>> su - postgres
>>> createuser -s dbadmin -P
>>>
>>> You will create a new user called dbadmin. It will ask you for a
password
>>> for this user and some extra options. Response YES to all.
>>>
>>> Now you can connect remotely with this dbadmin user.
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: Major Services <services.major [at] gmail.com>
>>> To: I=F1igo Martinez Lasala <imartinez [at] vectorsf.com>
>>> Cc: pgsql-admin [at] postgresql.org
>>> Subject: Re: [ADMIN] password authentication failed for user postgres
>>> Date: Wed, 3 Mar 2010 20:07:23 +0530
>>>
>>>
>>> Finally, I am able to create a user.
>>>
>>> Now when I try to connect to the server through DBWebAdmin (in
>>> Parallels Plesk Panel); I get the following :
>>> Error: FATAL: Ident authentication failed for user "postgres"
>>>
>>> (earlier, with this link I could reach the login screen for PgAdmin )
>>>
>>> Do I need to remove the following from pg_hba.conf now?
>>> local all postgres ident sameuser
>>>
>>>
>>>
>>>
>>>
>>> On Tue, Mar 2, 2010 at 2:44 PM, I=F1igo Martinez Lasala
>>> <imartinez [at] 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 [at] gmail.com>
>>>> To: pgsql-admin [at] 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 =3D '*' ; 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]
>>>>
>>>
>>>> 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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

--0016e6d77fa04efd300480f7f369
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I see. I have pgAdmin III on my local system and have been able to =
create database and tables through it. I hope this is fine? Thanks =
once again; though I am sure I'll be back with some query for you and t=
he community.<img goomoji=3D"330" style=3D"margin: 0pt 0.2ex; vertical-alig=
n: middle;" src=3D"cid:330 [at] goomoji.gmail"> 
 On Thu, Mar 4, 2010 at 1:54 PM, I=F1igo Martinez Lasala <=
;<a href=3D"mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.com</a>> w=
rote: > dbadmin is a database user, not a Linux user. > You can=
not use dbadmin in order to get logged to your machine. Only to 
> access database. > > Why are you using dbadmin to login to=
unix? Use root. > > Configure your web app using your root use=
r to login to postgresql with > dbadmin. You will have to modify a co=
nfig file somewhere in the path of this 
> app. Read INSTALL or README files of your web app. > > Use=
phppgadmin as alternative. It's also free and it will be probably at<b=
r>> RedHat/CentOS repos. "yum install phppgadmin" or "up2=
date install 
> phppgadmin" > Or webmin if you want to admin all server wit=
hout having to use command > line. <a href=3D"http://www.webmin.com/"=
>http://www.webmin.com/</a> > > > > > -----Or=
iginal Message----- 
> From: Major Services <<a href=3D"mailto:services.major [at] gmail.com">s=
ervices.major [at] gmail.com</a>> > To: I=F1igo Martinez Lasala <<a =
href=3D"mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.co m</a>> &g=
t; Cc: <a href=3D"mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql=
..org</a> 
> Subject: Re: [ADMIN] password authentication failed for user postgres<=
br>> Date: Wed, 3 Mar 2010 23:40:39 +0530 > > When I try to =
login as dbadmin through shell, I get 'access denied'. > 
> What could be wrong? > > On Wed, Mar 3, 2010 at 10:49 PM, =
I=F1igo Martinez Lasala > <<a href=3D"mailto:imartinez [at] vectorsf.co=
m">imartinez [at] vectorsf.com</a>> wrote: >> OK, it's a web app=
installed locally... 
>> >> Modify config file for this app (I don't know abou=
t it, so you will have >> to >> search by yourserlf) and =
point to 127.0.0.1 instead of use unix sockets, >> and >>=
also change use postgres for user dbadmin. 
>> >> Or modify your pg_hba.conf like this >> local=
=A0=A0=A0=A0 all=A0=A0=A0=A0 postgres=A0=A0=A0=A0 trust >> >=
> I don't suggest to revert to "local all postgres password&quo=
t; since you will 
>> have to enter password for any local operation in your server, but=
anyway, >> it's your decision. >> >> -----O=
riginal Message----- >> From: Major Services <<a href=3D"mailto=
:services.major [at] gmail.com">services.major [at] gmail.com</a>> 
>> To: I=F1igo Martinez Lasala <<a href=3D"mailto:imartinez [at] vector=
sf.com">imartinez [at] vectorsf.com</a>> >> Cc: <a href=3D"mailto:pg=
sql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</a> >> Subjec=
t: Re: [ADMIN] password authentication failed for user postgres 
>> Date: Wed, 3 Mar 2010 22:41:47 +0530 >> >> Thank=
s. >> I already have created a user. >> And can connect t=
o the server through the PgAdmin on my local system. >> >>=
; My query now is : 
>> Now when I try to connect to the server through DBWebAdmin (in =
>> =A0Parallels Plesk Panel); I get the following : >> =A0Er=
ror: FATAL: Ident authentication failed for user "postgres" &g=
t;> 
>> =A0(earlier, with this link I could reach the login screen for PgA=
dmin ) >> >> =A0 Do I need to remove the following from p=
g_hba.conf now? >> =A0 local =A0 all =A0 =A0 =A0 =A0 postgres =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0ident sameuser 
>> >> Thanks for all your help & support. >><br=
>>> >> >> On Wed, Mar 3, 2010 at 8:56 PM, I=F1igo M=
artinez Lasala >> <<a href=3D"mailto:imartinez [at] vectorsf.com">im=
artinez [at] vectorsf.com</a>> wrote: 
>>> Great. You managed to start server. :-) >>> >=
;>> You are using user postgres and you shoudn't use it.I suggest=
you to >>> create >>> your own dbadmin... >&=
gt;> 
>>> In your linux box, as root user: >>> >>&g=
t; su - postgres >>> createuser -s dbadmin -P >>><b=
r>>>> You will create a new user called dbadmin. It will ask you f=
or a password 
>>> for this user and some extra options. Response YES to all. =
>>> >>> Now you can connect remotely with this dbadmin=
user. >>> >>> >>> >>> ----=
-Original Message----- 
>>> From: Major Services <<a href=3D"mailto:services.major [at] gmai=
l.com">services.major [at] gmail.com</a>> >>> To: I=F1igo Martine=
z Lasala <<a href=3D"mailto:imartinez [at] vectorsf.com">imartinez [at] vectorsf.c=
om</a>> 
>>> Cc: <a href=3D"mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] =
postgresql.org</a> >>> Subject: Re: [ADMIN] password authentica=
tion failed for user postgres >>> Date: Wed, 3 Mar 2010 20:07:2=
3 +0530 
>>> >>> >>> Finally, I am able to create a=
user. >>> >>> Now when I try to connect to the ser=
ver through DBWebAdmin (in >>> Parallels Plesk Panel); I get th=
e following : 
>>> Error: FATAL: Ident authentication failed for user "postg=
res" >>> >>> (earlier, with this link I could =
reach the login screen for PgAdmin ) >>> >>> =A0Do =
I need to remove the following from pg_hba.conf now? 
>>> =A0local =A0 all =A0 =A0 =A0 =A0 postgres =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0ident sameuser >>> >>&g=
t; >>> >>> >>> >>> On Tue, =
Mar 2, 2010 at 2:44 PM, I=F1igo Martinez Lasala 
>>> <<a href=3D"mailto:imartinez [at] vectorsf.com">imartinez [at] vector=
sf.com</a>> wrote: >>>> In order to lauch createuser you =
don't need to modify listen_address >>>> since >&g=
t;>> you can use unix sockets. But anyway it's a requirement if y=
ou are goint 
>>>> to >>>> access remotely. >>>>=
; >>>> Add this line in first place to your pg_hba.conf &=
gt;>>> local=A0=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 postgres=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0 ident sa=
meuser 
>>>> >>>> >>>> Reload postgresql =
and launch createuser as postgres user. >>>> >>>=
> >>>> -----Original Message----- >>>> Fro=
m: Major Services <<a href=3D"mailto:services.major [at] gmail.com">services.=
major [at] gmail.com</a>> 
>>>> To: <a href=3D"mailto:pgsql-admin [at] postgresql.org">pgsql-ad=
min [at] postgresql.org</a> >>>> Subject: [ADMIN] password authen=
tication failed for user postgres >>>> Date: Tue, 2 Mar 2010=
14:13:10 +0530 
>>>> >>>> Hi, >>>> >>>=
;> 1. I have added =A0listen_addresses =3D '*' ; in =A0postgresq=
l.conf >>>> >>>> 2. And have made the followi=
ng changes to pg_hba.conf 
>>>> >>>> local =A0 DATABASE =A0 =A0USER =A0 MET=
HOD >>>> local =A0 =A0samegroup =A0 =A0 =A0all =A0 =A0 =A0pa=
ssword >>>> host =A0 =A0DATABASE =A0 =A0USER =A0 =A0CIDR-ADD=
RESS =A0METHOD =A0[OPTION] >>>> 
>>> >>>> hostssl =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0=
=A0 =A0 =A0 all =A0 =A0 =A0 <a href=3D"http://0.0.0.0/0">0.0.0.0/0</a> =A0=
=A0 =A0 =A0 =A0 =A0md5 >>>> >>>> 3. Have res=
tarted the server >>>> 
>>>> 4. I can login to the server as user postgres. >>=
>> >>>> But =A0while trying to createuser I get the fo=
llowing message =A0: >>>> 'createuser: could not connect=
to database postgres: =A0FATAL : 
>>>> password authentication failed for user "postgres&quo=
t; >>>> >>>> This is on Redhat running Plesk =
also. >>>> >>>> I am new to Linux as well as =
PostgreSQL. Help would be much appreciated. 
>>>> >>>> Thanks >>>> Viv >=
>>> >>>> >>>> >>> >=
;>> >> >> > > 

--0016e6d77fa04efd300480f7f369--
--0016e6d77fa04efd350480f7f36a
Content-Type: image/gif; name="330.gif"
Content-Transfer-Encoding: base64
X-Attachment-Id: 330 [at] goomoji.gmail
Content-ID: <330 [at] goomoji.gmail>

R0lGODlhDAAMAKIFAF5LAP/zxAAAANyuAP/gaP///wAAAAAAACH5BAEAAAUA LAAAAAAMAAwAAAMl
WLPcGjDKFYi9lxKBOaGcF35DhWHamZUW0K4mAbiwWtuf0uxFAgA7
--0016e6d77fa04efd350480f7f36a--

Major Services [ Do, 04 März 2010 12:32 ] [ ID #2034026 ]

Datenbanken » gmane.comp.db.postgresql.admin » password authentication failed for user postgres

Vorheriges Thema: PostgreSQL Active-Active Configuration
Nächstes Thema: --with-wal-segsize in-effective?