From: | John Gage <jsmgage(at)numericable(dot)fr> |
---|---|
To: | Jorge Arevalo <jorgearevalo(at)gis4free(dot)org> |
Cc: | PostgreSQL - General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Unable to run createlang (or psql for that matter) |
Date: | 2010-04-26 07:55:54 |
Message-ID: | 31C9A180-633E-4636-8C57-84D8CD0B1056@numericable.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)numericable(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Kenichiro Tanaka | 2010-04-26 08:10:27 | Re: Problem with pg_prepare |
Previous Message | Vincenzo Romano | 2010-04-26 07:39:39 | Inheritance efficiency |