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 > > [EMAIL PROTECTED]:~$ 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 <[EMAIL PROTECTED]> 924 289 351 - 924 298 352 - Servicio de Informática Universidad de Extremadura - España - Spain Debian Potato - GNU/Linux 2.2.19 ---------------------------------------------------
