From: Major Services <services.major@gmail.com>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: password authentication failed for user postgres
Date: Wed, 3 Mar 2010 22:41:47 +0530
Message-ID: <375c2da1003030911o526a14f0hb9ee1cfcf99db6fa@mail.gmail.com> (raw)
In-Reply-To: <1267629985.17535.175.camel@deimos>
References: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com>
<1267521253.2942.55.camel@deimos>
<375c2da1003030637k6c3ffca6ma65651f1927c02eb@mail.gmail.com>
<1267629985.17535.175.camel@deimos>
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
<imartinez@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@gmail.com>
> To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
> Cc: pgsql-admin@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ñigo Martinez Lasala
> <imartinez@vectorsf.com> wrote:
>> In order to lauch createuser you don't need to modify listen_address since
>> you can use unix sockets. But anyway it's a requirement if you are goint
>> to
>> access remotely.
>>
>> Add this line in first place to your pg_hba.conf
>> local all postgres ident sameuser
>>
>>
>> Reload postgresql and launch createuser as postgres user.
>>
>>
>> -----Original Message-----
>> From: Major Services <services.major@gmail.com>
>> To: pgsql-admin@postgresql.org
>> Subject: [ADMIN] password authentication failed for user postgres
>> Date: Tue, 2 Mar 2010 14:13:10 +0530
>>
>> Hi,
>>
>> 1. I have added listen_addresses = '*' ; in postgresql.conf
>>
>> 2. And have made the following changes to pg_hba.conf
>>
>> local DATABASE USER METHOD
>> local samegroup all password
>> host DATABASE USER CIDR-ADDRESS METHOD [OPTION]
>>
>
>> hostssl all all 0.0.0.0/0 md5
>>
>> 3. Have restarted the server
>>
>> 4. I can login to the server as user postgres.
>>
>> But while trying to createuser I get the following message :
>> 'createuser: could not connect to database postgres: FATAL :
>> password authentication failed for user "postgres"
>>
>> This is on Redhat running Plesk also.
>>
>> I am new to Linux as well as PostgreSQL. Help would be much appreciated.
>>
>> Thanks
>> Viv
>>
>>
>>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: services.major@gmail.com, imartinez@vectorsf.com
Subject: Re: password authentication failed for user postgres
In-Reply-To: <375c2da1003030911o526a14f0hb9ee1cfcf99db6fa@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox