CreateUser error
I am trying to get PostgreSQL 8.1.4 up and running on fedora core 5. Upon trying to add a user (I had to use the createuser command) I recieved this error:
[root@pc-00076 postgresql-8.1.4]# createuser postgres
Shall the new role be a superuser? (y/n) y
createuser: could not connect to database postgres: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I have read some other posts about SElinux having something to do with this error. However, I do not know what that is, or how to disable it. Can someone please give me some help?? thanks
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
jonathan harvey <jonathanharv@yahoo.com> writes:
I am trying to get PostgreSQL 8.1.4 up and running on fedora core 5.
Have you started the service? If "ps auxww | grep postgres" doesn't
show some postgres-owned processes, you need
sudo /sbin/service postgresql start
You probably also want
sudo /sbin/chkconfig postgresql on
but that just fixes things so that future reboots will automatically
start the database, it doesn't make it run now.
regards, tom lane