Re: Cannot createdb

From: "Andrew L(dot) Gould" <algould(at)datawok(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:14:21
Message-ID: 200309072214.21135.algould@datawok.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mathan 2003-09-08 03:42:39 Re: Cannot createdb
Previous Message Tom Lane 2003-09-08 02:41:31 Re: Can I use PostgreSQL to develop a self-organizing database system?