PostgreSQL Discussion

Author

Help

ElayaRaja S

2005-04-28, 11:23 am

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

--
Warm Regards,

S.ElayaRaja
Mobile: (+91) 98450 59540
E-Mail: elayaraja.s@gmail.com
raja_nk@hotmail.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Scott Marlowe

2005-04-28, 11:23 am

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

Sponsored Links