Re: Cannot createdb - Mailing list pgsql-general

From mathan
Subject Re: Cannot createdb
Date
Msg-id 008f01c375bb$4a106b30$250110ac@MAMCO
Whole thread Raw
In response to Cannot createdb  ("Dr. Azmir" <drazmir@tm.net.my>)
List pgsql-general
> 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


pgsql-general by date:

Previous
From: "Andrew L. Gould"
Date:
Subject: Re: Cannot createdb
Next
From: Tom Lane
Date:
Subject: Re: Unix domain instead of TCP socket connections with JDBC.