postgres@abigail ~/data $ createdb test1
Password:
CREATE DATABASE
postgres@abigail ~/data $ createlang --dbname=test1 --pglib=/usr/lib/pgsql
'plpgsql'
Password: Password: Password:
Password:
postgres@abigail ~/data $ createlang --list --dbname=test1
Password:
Procedural languages
Name | Trusted? | Compiler
---------+----------+----------
plpgsql | t | PL/pgSQL
(1 row)
postgres@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@abigail ~/data $ cat /proc/meminfo
total: used: free: shared: buffers: cached:
Mem: 393175040 219648000 173527040 1470464 32092160 80633856
Swap: 271392768 0 271392768
----------------------------------------------------------------------------
-
----------------------------------------------------------------------------
-
postgres@abigail ~/data $ createdb test1
Password:
CREATE DATABASE
postgres@abigail ~/data $ createlang --dbname=test1 --pglib=/usr/lib/pgsql
'plpgsql'
Password: psql: Password authentication failed for user 'postgres'
createlang: external error
postgres@abigail ~/data $ createlang --list --dbname=test1
Password:
Procedural languages
Name | Trusted? | Compiler
------+----------+----------
(0 rows)
postgres@abigail ~/data $ dropdb test1
Password:
DROP DATABASE