Re: createlang

I have noticed that some of the command line tools do not work nicely
when the local auth is not set to trust, but trust is dangerous. Have
you tried creating the language from psql rather than from the command line?

jason(at)matchingmoms(dot)com wrote:

>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
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>