Postgres Pro
Downloads
Home   >   mailing lists

Thread: FATAL 1

FATAL 1

From
Wim Vanweersch
Date:
Hello,

What goes wrong?


[wim@vanweersch wim]$ createuser
Enter name of user to add: anja
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
psql: FATAL 1:  user "wim" does not exist
createuser: creation of user "anja" failed
[wim@vanweersch wim]$ createdb test -U postgres
psql: FATAL 1:  IDENT authentication failed for user "postgres"

createdb: database creation failed

What must I do to get on with PostgreSQL?




Greets,



Wim.

Re: FATAL 1

From
Jeff Eckermann
Date:
--- Wim Vanweersch <n.vanweersch@hccnet.nl> wrote:
> Hello,
>
> What goes wrong?
>
>
> [wim@vanweersch wim]$ createuser
> Enter name of user to add: anja
> Shall the new user be allowed to create databases?
> (y/n) n
> Shall the new user be allowed to create more new
> users? (y/n) n
> psql: FATAL 1:  user "wim" does not exist
> createuser: creation of user "anja" failed
> [wim@vanweersch wim]$ createdb test -U postgres
> psql: FATAL 1:  IDENT authentication failed for user
> "postgres"
>
> createdb: database creation failed
>
> What must I do to get on with PostgreSQL?

Check your pg_hba.conf file: this sets out the
authentication requirements for connections to
PostgreSQL.  You may need to temporarily reset these
in order to get started.

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

Re: FATAL 1

From
"A.Bhuvaneswaran"
Date:
> [wim@vanweersch wim]$ createuser
> Enter name of user to add: anja
> Shall the new user be allowed to create databases? (y/n) n
> Shall the new user be allowed to create more new users? (y/n) n
> psql: FATAL 1:  user "wim" does not exist
> createuser: creation of user "anja" failed

In the first place, you have not created the user 'wim'. You create him as
a super user and he must be able to create other users like anja.

> [wim@vanweersch wim]$ createdb test -U postgres
> psql: FATAL 1:  IDENT authentication failed for user "postgres"

By default, the authentication method is ident. It needs an identd server
and $PGDATA/pg_ident.conf, i suppose. You can change the authentication
method by editing pg_hba.conf. Edit and set it to trust or md5. The same
file contains the description about all possible authentication methods.

regards,
bhuvaneswaran