Postgresql 7.1.3
I'm having a problem with createlang.
Commands:
[postgres@boxy postgres]$ createdb test1
Password: <----- Correct
password
CREATE DATABASE
[postgres@boxy postgres]$ createlang plpgsql test1
Password: <----- Correct
password (does not say it was incorrect, the first character is upper
case)
Password: <-----
Incorrect password "something"
psql: Password authentication failed for user 'postgres'
Password: <-----
Incorrect password "something"
psql: Password authentication failed for user 'postgres'
createlang: language installation failed
[postgres@boxy postgres]$
Logs corresponding to those commands:
2001-10-22 15:15:22 [13115] DEBUG: connection: host=[local]
user=postgres database=template1
2001-10-22 15:15:33 [13125] DEBUG: connection: host=[local]
user=postgres database=test1
Password authentication failed for user 'postgres'
Password authentication failed for user 'postgres'
pg_hba.conf entry:
local all crypt
Now again have a look at this (quite interesting):
[postgres@boxy postgres]$ dropdb test1
Password:
DROP DATABASE
[postgres@boxy postgres]$ createdb test1
Password:
CREATE DATABASE
[postgres@boxy postgres]$ createlang -l test1
Password: Procedural languagesName | Trusted? | Compiler
------+----------+----------
(0 rows)
[postgres@boxy postgres]$ createlang plpgsql test1
Password:
Password:
Password:
Password:
[postgres@boxy postgres]$ createlang -l test1
Password: Procedural languages Name | Trusted? | Compiler
---------+----------+----------plpgsql | t | PL/pgSQL
(1 row)
[postgres@boxy postgres]$
I had to enter the password 4 times for it to create the language.
Thanks.