Re: Cannot createdb

From: "mathan" <mathan(at)hotpop(dot)com>
To: "Dr(dot) Azmir" <drazmir(at)tm(dot)net(dot)my>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cannot createdb
Date: 2003-09-08 03:42:39
Message-ID: 008f01c375bb$4a106b30$250110ac@MAMCO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-08 04:06:47 Re: Unix domain instead of TCP socket connections with JDBC.
Previous Message Andrew L. Gould 2003-09-08 03:14:21 Re: Cannot createdb