Hi
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:
-bash-3.2.$
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. :-(
Creating Database Problem
-
- Retired Moderator
- Posts: 18276
- Joined: 2006/12/13 20:15:34
- Location: Tidewater, Virginia, North America
- Contact:
Re: Creating Database Problem
I'm not a database guy so no direct suggestions; however, if help is not forthcoming here you might try posting to the centos-users list
http://lists.centos.org/mailman/listinfo/centos
Have seen quite a lot of postgresql threads there.
http://lists.centos.org/mailman/listinfo/centos
Have seen quite a lot of postgresql threads there.
-
- Posts: 1478
- Joined: 2006/05/29 16:50:11
- Location: San Francisco, CA
Creating Database Problem
Just so we don't overlook the glaringly obvious.... does the configuration file pg_hba.conf exist? If not, how about creating one? Is the postgresql server running?
Have you read any of the postgresql documentation?
Have you read any of the postgresql documentation?
Re: Creating Database Problem
HI Guys
I have solved the problem, pschaff thank you for your sugestion, I checked there but could not find the solution,
michaelnel
does the configuration file pg_hba.conf exist?
Is the postgresql server running?
Have you read any of the postgresql documentation?
michaelnel
Yes the pg_hba.conf exists, Yes the postgresql server running, Oh you beat I have read lots and lots of postgresql documentation, this finally got solved:
The bash config files got corrupted so I fixed them by copying the default over.
There were 2 bad entries in the /var/lib/pgsql/data/pg_hba.conf file. I commented them.
And that solved the problem, thank you guys for your help.
I have solved the problem, pschaff thank you for your sugestion, I checked there but could not find the solution,
michaelnel
does the configuration file pg_hba.conf exist?
Is the postgresql server running?
Have you read any of the postgresql documentation?
michaelnel
Yes the pg_hba.conf exists, Yes the postgresql server running, Oh you beat I have read lots and lots of postgresql documentation, this finally got solved:
The bash config files got corrupted so I fixed them by copying the default over.
There were 2 bad entries in the /var/lib/pgsql/data/pg_hba.conf file. I commented them.
And that solved the problem, thank you guys for your help.