> Hi there I'm Dr. Azmir from Kuala Lumpur. > I'm using RH 9.0 with postgresql intalled in it. > My problem is I can't createuser and createdb with it. > The error message "psql: FATAL: user "name" does not exist > createdb: database creation failed"
You should create database as postgres user Do the following steps Start the postmaster before creating the database # useradd postgres # su - postgres $ createdb <database name> CREATE DATABASE $ thanks --mathan --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 6/18/2003 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings