Cannot createdb

[Dr. Azmir]

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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Andrew L. Gould]

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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[mathan]

> 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

[Paul Thomas]

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 |
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings