0

Hi i am using postgresql .

my

Postgres User : postgres 
Passwprd : abc123

but when i type root@xxxx:~#psql -U postgres -W

it says 

   root@xxxx:~#   Ident authentication failed for user "root"

but when i su postgres cd and then type following command 

#psql -U postgres -W

it is working correctly and i can access to all databases .

when i try to access my site it gives me the error in posstgres error log

password authentication failed for user "postgres"

why is this happening , please help me , thanks in advance

UPDATE

my pg_hba.conf

# Database administrative login by Unix domain socket
local   all             postgres                                trust

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               md5
Kanishka Panamaldeniya
  • 16,046
  • 27
  • 109
  • 185

1 Answers1

3

You have to create a role name root

create role root login
Vivek S.
  • 15,777
  • 6
  • 54
  • 78
  • Hi now the page is reloading again and again , i checked the postgres error .log it says permission denied for relation ezuser , actually it is permission denied for all relations , but when i type SELECT contentobject_id, login, email, password_hash, password_hash_type FROM ezuser in console it is working perfectly / – Kanishka Panamaldeniya Aug 08 '14 at 10:03