From: | Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com> |
---|---|
To: | Major Services <services(dot)major(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: password authentication failed for user postgres |
Date: | 2010-03-02 09:14:13 |
Message-ID: | 1267521253.2942.55.camel@deimos |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
In order to lauch createuser you don't need to modify listen_address
since you can use unix sockets. But anyway it's a requirement if you are
goint to access remotely.
Add this line in first place to your pg_hba.conf
local all postgres ident sameuser
Reload postgresql and launch createuser as postgres user.
-----Original Message-----
From: Major Services <services(dot)major(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] password authentication failed for user postgres
Date: Tue, 2 Mar 2010 14:13:10 +0530
Hi,
1. I have added listen_addresses = '*' ; in postgresql.conf
2. And have made the following changes to pg_hba.conf
local DATABASE USER METHOD
local samegroup all password
host DATABASE USER CIDR-ADDRESS METHOD [OPTION]
host all all 0.0.0.0/0 md5
hostssl all all 0.0.0.0/0 md5
3. Have restarted the server
4. I can login to the server as user postgres.
But while trying to createuser I get the following message :
'createuser: could not connect to database postgres: FATAL :
password authentication failed for user "postgres"
This is on Redhat running Plesk also.
I am new to Linux as well as PostgreSQL. Help would be much appreciated.
Thanks
Viv
From | Date | Subject | |
---|---|---|---|
Next Message | Major Services | 2010-03-02 11:00:29 | Fwd: password authentication failed for user postgres |
Previous Message | Major Services | 2010-03-02 08:43:10 | password authentication failed for user postgres |