Skip site navigation (1) Skip section navigation (2)

Re: createlang

From: Grant Johnson <grant(at)amadensor(dot)com>
To: jason(at)matchingmoms(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: createlang
Date: 2002-01-11 19:02:44
Message-ID: 3C3F36D4.2000500@amadensor.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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
>



In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-01-11 19:16:19
Subject: Re: Bad integer
Previous:From: Tom LaneDate: 2002-01-11 18:56:12
Subject: Re: ehm...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group