Cannot createdb

On Sunday 07 September 2003 05:59 am, Dr. Azmir wrote:

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"

will pop up.

Why?

Kindly help me

Thanks

Have you:

1. Executed "initdb" as user postgres successfully? (If you can't login as
postgres, login as root and su to postgres.)
2. Started the postmaster service?
3. As postgres, create a database user with createdb permissions?

Let us know,

Andrew L. Gould

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

On 07/09/2003 11:59 Dr. Azmir wrote:

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"

will pop up.

Why?

You need to be user postgres to create at least one user. The way I do it
is, from root, su postgres, create a user with createuser which can also
create databases and other users. On my development machines, I use my
unix user name so its really easy to create databases and other users
without su'ing around. On production machines, I set up a dba user.

HTH

-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller 
Business |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+