Re: Unable to run createlang (or psql for that matter)

Fascinatingly, to me at least, as follows (I threw in "which bash"):

JohnGage:~ johngage$ which createlang
JohnGage:~ johngage$ which psql
JohnGage:~ johngage$ which bash
/bin/bash

i.e. zilch

Here's what I am able to do:

JohnGage:~ johngage$ su postgres
Password:
su: Sorry
JohnGage:~ johngage$ sudo su postgres
bash-3.2$ which createlang
bash-3.2$ which psql
bash-3.2$ cd /Library/PostgreSQL/8.4/bin
bash-3.2$ ./createlang -l
Password:
Procedural Languages
  Name | Trusted?
------+----------


In the "su:Sorry" after my attempt at a password for user "postgres" I
am only showing that all the possible and the true password for
postgres don't work.  No password works, i.e., you can't get there
from here.

However, when I su as superuser (using not the root password but my
"administrator" password on the Mac) I get to postgres.  Postgres too
is unable to get any response for "which" but postgres can run
createlang from the bin directory.

A very key difficulty is that if I attempt to add postgres as a user
to my system, my system tells me postgres already is a user.  But,
unfortunately, postgres as a user on my system has no password.  His
postgresql password does not work on the system.

John



On Apr 26, 2010, at 9:36 AM, Jorge Arevalo wrote:

> On Sun, Apr 25, 2010 at 11:08 AM, John Gage <jsmgage@numericable.fr>
> wrote:
>> If I open a bash terminal and type createlang -l, I get:
>>
>> JohnGage:~ johngage$ createlang -l
>> -bash: createlang: command not found
>> JohnGage:~ johngage$ psql
>> -bash: psql: command not found
>>
>> as one can see, the same thing happens with psql.
>>
>> The way I have been using psql is by pulling down the plugins menu in
>> pgAdmin3 and selecting (the only selection) psql.
>>
>> My $PATH variable includes the path to both createlang and psql.
>>
>> What am I doing wrong?
>>
>> John
>>
>
> What's your output for these commands?
>
> which createlang
> which psql
>
>
>>
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>