i try to install postgreSQL on debian testing, but i have problem : > $> dpkg -l | grep postgre > ii postgresql 7.1.3-4 Object-relational SQL database, descended fr > ii postgresql-cli 7.1.3-4 Front-end programs for PostgreSQL > ii postgresql-con 7.1.3-4 Additional facilities for PostgreSQL > > $> whoami > nlamirault > > $> su - > Password: > > $] whoami > root > > $] su - postgres > > ~$ 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 > > > $> ps aux | grep postmaster > postgres 294 0.0 0.6 8160 1584 ? S 16:41 0:00 > /usr/lib/postgresql/bin/postmaster -D /var/lib/postgres/data > nlamira 1526 0.0 0.1 1368 492 pts/1 S 17:40 0:00 grep postmaster
i don't really understand why my new user nlamirault can't create database In the file /etc/postgresql/pg_hba.conf i have change nothing I have at the end : # Put your actual configuration here # ---------------------------------- # This default configuration allows any local user to connect as himself # without a password, either through a Unix socket or through TCP/IP; users # on other machines are denied access. local all peer sameuser host all 127.0.0.1 255.0.0.0 ident sameuser host all 0.0.0.0 0.0.0.0 reject and the file /etc/postgresql/postgresql.conf: debug_level = 0 log_connections = on log_pid = on log_timestamp = on syslog = 2 # if syslog is 0, turn silent_mode off! silent_mode = off syslog_facility = LOCAL0 trace_notify = off max_connections = 64 # shared_buffers must be at least twice max_connections, and not less than 16 shared_buffers = 128 # TCP/IP access is allowed by default, but the default access given in # pg_hba.conf will permit it only from localhost, not other machines. tcpip_socket = 1 could you help me ? -- Nicolas Lamirault CVF Bordeaux 22 quai de Bacalan 33000 BORDEAUX
