The root does not have the permission to execute a createdb command.
for that login as $su - postgres (password: mypassword)
Moreover, form the beg. :
1. /etc/rc.d/init.d/postgresql start
2. initdb (path for ur dbase)
3. su - postgres
4. postmaster -p 5432 [-D (path)] -i
5. createdb (database)
6. psql (database)
OR
6. export display +
7. pgaccess (database)
psql/pgaccess are frontends for postgreSQL.
pgaccess has a GUI whereas psql is like CREATE TABLE etc..
Hope i have the sequence in correct order...sumone correct me if I am
wrong...
Life is 10% what happens what happens to us and 90% how we react to it.
** Shashank Teotia**
BTech (MME)
Room no. 361
Hall - 2
IIT Kanpur.
On Sun, 18 Nov 2001, Sriram Ganapathy wrote:
> Hello all,
> When I execute the 'createdb' command from the prompt I get the
> following error. What should I do ?
>
> #psql : FATAL 1 :SetUserID: user 'netadmin' is not in 'pg_shadow'
> #createdb: database creation failed
>
> Thanks for your time,
>
> G.Sriram.
>
>
>
>
>
> _______________________________________________
> linux-india-help mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/linux-india-help
>
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
