Postgres Pro
Downloads
Home   >   mailing lists

Thread: Cannot createdb

Cannot createdb

From
"Dr. Azmir"
Date:
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

Re: Cannot createdb

From
"Andrew L. Gould"
Date:
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

Re: Cannot createdb

From
"mathan"
Date:
> 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

Re: Cannot createdb

From
Paul Thomas
Date:
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   |
+------------------------------+---------------------------------------------+