From: Major Services <services.major@gmail.com>
To: pgsql-admin@postgresql.org
Subject: password authentication failed for user postgres
Date: Tue, 2 Mar 2010 14:13:10 +0530
Message-ID: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com> (raw)
Hi,
1. I have added listen_addresses = '*' ; in postgresql.conf
2. And have made the following changes to pg_hba.conf
local DATABASE USER METHOD
local samegroup all password
host DATABASE USER CIDR-ADDRESS METHOD [OPTION]
host all all 0.0.0.0/0 md5
hostssl all all 0.0.0.0/0 md5
3. Have restarted the server
4. I can login to the server as user postgres.
But while trying to createuser I get the following message :
'createuser: could not connect to database postgres: FATAL :
password authentication failed for user "postgres"
This is on Redhat running Plesk also.
I am new to Linux as well as PostgreSQL. Help would be much appreciated.
Thanks
Viv
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: services.major@gmail.com
Subject: Re: password authentication failed for user postgres
In-Reply-To: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@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