Thread: Newbie problem

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!!!

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.