reatedb: database creation failed on mydb - Mailing list pgsql-general

Hi!

I'm a new member and new to postgres.

beside postgrest user I would also want my student to create their own
database in their own home directory.

first I issue (under postgrest user)
    createuser user_id
then under that user_id I run
    initlocation ~/sql/data
then I run
    createdb -D ~/sql/data mydb

at this stage I get an error msg as below:
    ERROR:  Unable to create database directory ~/sql/data/base/mydb
    createdb: database creation failed on mydb.

what should I do now? I tried to find it in archives but i can't find it.
FYI I'm using postgres v 6.3 running under RedHat.

Thanks in advance.