On Thu, 2005-04-28 at 09:51, ElayaRaja S wrote:
> After login as su postgres
> I am unable to create the db;
>
>
> $ createdb -E utf8 -U system myDB;
> ERROR: permission denied to create database
> createdb: database creation failed: ERROR: permission denied to create
> database
What's with the -U system in there?
As the postgres user, (i.e. either leave out the -U system or make it -U
postgres) it should work fine. Oh, and you MAY want to just stick to
lower case names for databases, tables, fields etc... It's easier in the
long run.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
