createlang

postgres(at)abigail ~/data $ createdb test1
Password:
CREATE DATABASE

postgres(at)abigail ~/data $ createlang --dbname=test1 --pglib=/usr/lib/pgsql
'plpgsql'
Password: Password: Password:
Password:

postgres(at)abigail ~/data $ createlang --list --dbname=test1
Password:
Procedural languages
Name | Trusted? | Compiler
---------+----------+----------
plpgsql | t | PL/pgSQL
(1 row)

postgres(at)abigail ~/data $ dropdb test1
Password:
DROP DATABASE

----------------------------------------------------------------------------
-
----------------------------------------------------------------------------
-

The createlang does not accept my password correctly. Also, should it not
give a confirmation such as "CREATE" when it executes? One can see from the
above output that I had to enter it 4 times. Note that it does not behave
this way when I enter the incorrect password (see below).

I'm on RedHat 7.1 and using the default Postgres RPM from my initial
install.

template1=# SELECT version()
template1-# ;
version
-------------------------------------------------------------
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
(1 row)

postgres(at)abigail ~/data $ cat /proc/meminfo
total: used: free: shared: buffers: cached:
Mem: 393175040 219648000 173527040 1470464 32092160 80633856
Swap: 271392768 0 271392768

----------------------------------------------------------------------------
-
----------------------------------------------------------------------------
-

postgres(at)abigail ~/data $ createdb test1
Password:
CREATE DATABASE

postgres(at)abigail ~/data $ createlang --dbname=test1 --pglib=/usr/lib/pgsql
'plpgsql'
Password: psql: Password authentication failed for user 'postgres'
createlang: external error

postgres(at)abigail ~/data $ createlang --list --dbname=test1
Password:
Procedural languages
Name | Trusted? | Compiler
------+----------+----------
(0 rows)

postgres(at)abigail ~/data $ dropdb test1
Password:
DROP DATABASE