Re: problem with postgres

[Alberto Cabello Sanchez <alberto@unex.es>]

You can try 

postgres:~$ psql
blablabla
template1=> create user somebody createdb ;
postgres:~$ su - somebody
Password:
somebody:~$psql
template1=> create database something;
....

I hope this help...
> 
> i try to install postgreSQL on debian testing, but i have problem :
> 
> >
> > ~$ createuser nlamirault
> > Shall the new user be allowed to create databases? (y/n) y
> > Shall the new user be allowed to create more new users? (y/n) y
> > CREATE USER
> > postgres@lam:~$ exit
> > logout
> > [ lam : root ] exit
> > logout
> > < lam : nlamirault > whoami
> > nlamirault
> > < lam : nlamirault > createdb exemple
> > psql: Peer authentication failed for user 'nlamirault'
> > createdb: database creation failed
> >
> 
> -- 
> Nicolas Lamirault
> CVF Bordeaux 22 quai de Bacalan
> 33000 BORDEAUX


-- 
---------------------------------------------------
Alberto Cabello Sánchez <alberto@unex.es>
924 289 351 - 924 298 352 - Servicio de Informática
Universidad de Extremadura - España - Spain
Debian Potato - GNU/Linux 2.2.19
---------------------------------------------------