Problem on PostgreSQL - creating database

[Marius Andreiana]

On Tue, 2004-08-17 at 12:28 +0300, Jarkko Elfving wrote:
> I've created a database cluster with initdb and it was succesfully
> created. After that I tried to create a database with createdb -command,
> but it replys like this:
> 
> jarelf]$ createdb -D /home/jarelf/dbCluster/mydb -O jarelf
> 
> createdb: could not connect to database template1: FATAL:  user "jarelf"
> does not exist
> 
> What am I doing wrong?
Error message is clear: user "jarelf" does not exist

detail:
[marius at marte tables]$ createdb --help
createdb creates a PostgreSQL database.
 
Usage:
  createdb [OPTION]... [DBNAME] [DESCRIPTION]
 
Options:
  -O, --owner=OWNER         database user to own the new database

solution:
as root:
su - postgres
createuser jarelf


-- 
Marius Andreiana
Galuna - Solutii Linux in Romania
http://www.galuna.ro