- Oct 11, 2000
- 56,336
- 11
- 0
Maybe I'm doing something wrong, but all I'm doing is trying to create a user and create a database. WTF!?
On CentOS 4.8, after installing postgresql-server, postgresql, and postgresql-libs, I start the PostgreSQL server (starts fine):
Next I connect:
I create a user that can create databases but not other users (which works):
I then attempt to create a database as that user (which fails):
Here is the error:
I've Google'd around and found several people suggesting changing the pg_hba.conf file which I've tried to no avail. I've disabled the iptables firewall completely and still no luck. WTF am I doing wrong? It shouldn't be this hard.
On CentOS 4.8, after installing postgresql-server, postgresql, and postgresql-libs, I start the PostgreSQL server (starts fine):
Code:
/etc/init.d/postgresql start
Code:
su postgres
Code:
createuser -A -d -E -P testuser
Code:
createdb -U testuser -W testdb
Code:
createdb: could not connect to database template1: FATAL: IDENT authentication failed for user "testuser"