Package: postgresql-client-common
Version: 113
Severity: normal
I expected createuser -W to create user with password. Here is what I get.
~$ createuser -W test
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n
Password:
~$ createdb -O test test
~$ psql
psql (8.4.7)
Type "help" for help.
postgres=# select * from pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil
| useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
postgres | 10 | t | t | t | ******** |
|
test | 16384 | f | f | f | ******** |
|
(2 rows)
postgres=# select * from pg_shadow;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil |
useconfig
----------+----------+-------------+----------+-----------+--------+----------+-----------
postgres | 10 | t | t | t | | |
test | 16384 | f | f | f | | |
(2 rows)
~$ psql -h 127.0.0.1 -U test test
Password for user test:
psql: FATAL: password authentication failed for user "test"
FATAL: password authentication failed for user "test"
~$ psql
postgres=# alter user test with password 'testtest';
ALTER ROLE
postgres=# select * from pg_shadow;
usename | usesysid | usecreatedb | usesuper | usecatupd |
passwd | valuntil | useconfig
----------+----------+-------------+----------+-----------+-------------------------------------+----------+-----------
postgres | 10 | t | t | t |
| |
test | 16384 | f | f | f |
md51fb0e331c05a52d5eb847d6fc018320d | |
(2 rows)
~$ psql -h 127.0.0.1 -U test test
Password for user test:
psql (8.4.7)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.
test=>
-- System Information:
Debian Release: 6.0.1
APT prefers stable
APT policy: (700, 'stable'), (500, 'oldstable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.26-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
postgresql-client-common depends on no packages.
Versions of packages postgresql-client-common recommends:
ii lsb-release 3.2-23.2squeeze1 Linux Standard Base version report
postgresql-client-common suggests no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
