By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,541 Members | 1,455 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,541 IT Pros & Developers. It's quick & easy.

Cannot createdb

P: n/a
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

Nov 11 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 11 '05 #2

P: n/a
> 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

Nov 11 '05 #3

P: n/a

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

Nov 11 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.