Re: Newbie problem

From: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
To: David <david(at)cnb(dot)uam(dot)es>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Newbie problem
Date: 2002-11-28 16:00:23
Message-ID: BA0BEE17.C802%a.witney@sghms.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


creatuser is the shell command to create a user, in psql you have to use
CREATE USER ....

Take a look here for more details

http://developer.postgresql.org/docs/postgres/user-manag.html

adam

> Hello everybody:
> i can´t work with my Postgresql installation ( under Linux ), here
> are my steps:
>
> [shell]# mkdir /usr/local/pgsql/data
> [shell]# chown postgres /usr/local/pgsql/data
>
> [shell]# su - postgres
> [shell]$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
> and then
>
> [shell]$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
>
> OK? well... if i try
>
> template1=# createuser "check";
>
> ERROR: parser: parse error at or near "createuser"
> ERROR: parser: parse error at or near "createuser"
>
> what is the problem??? thank you very much!!!
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Henshall, Stuart - Design & Print 2002-11-28 16:30:44 Re: system cataloge?
Previous Message David 2002-11-28 15:56:07 Newbie problem