I have installed in my Server Centos 5.2 postgresql and postgresql-server, but I have a problem when I want to create a database, this is the command I use:
su - postgres
But I dont get the user postgres loged in this is what I get:
The problem comes when I want to create the database with command: createdb "database name"
This is the output I get:
createdb: could not connect to database postgres: FATAL: missing or erroneous pg_hba.conf file
I am pretty new to Linux and working hard to get used to it, Now the question I have is should I have created the user " postgres " or this user is created
automatically when you install postgresql and postgresql-server ? I am a little confused now and really dont know what to do next in order to have this fix and
create the database I need, hope someone can help me out, thank you guys.