problem with postgreSQL
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
> 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
>
>
> $> 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
Reply to: