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@xxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
