Phillip,
As you can see it,
> Where did you install Postgres to? Did you install a binary package or
> compile from source?
Its from a binary source. The files are in various places but $PGDATA
will be in /usr/local/pgsql. Someone else did the installation.
>You may just need to sym link postmaster and psql into /usr/bin/ from
their
>actual location - probably something like /usr/local/postgres/bin/
[EMAIL PROTECTED] pgsql]$ ls -al /usr/bin/pg_ctl
-rwxr-xr-x 1 root root 10214 May 10 2005 /usr/bin/pg_ctl
[EMAIL PROTECTED] pgsql]$ ls -la /usr/bin/postmaster /usr/bin/psql
lrwxrwxrwx 1 root root 8 Jun 26 2006 /usr/bin/postmaster ->
postgres
-rwxr-xr-x 1 root root 165336 May 10 2005 /usr/bin/psql
Its actually in /usr/bin itself.
CONFIDENTIALITY
This e-mail message and any attachments thereto, is intended only for use by
the addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this e-mail
message, you are hereby notified that any dissemination, distribution or
copying of this e-mail message, and any attachments thereto, is strictly
prohibited. If you have received this e-mail message in error, please
immediately notify the sender and permanently delete the original and any
copies of this email and any prints thereof.
ABSENT AN EXPRESS STATEMENT TO THE CONTRARY HEREINABOVE, THIS E-MAIL IS NOT
INTENDED AS A SUBSTITUTE FOR A WRITING. Notwithstanding the Uniform Electronic
Transactions Act or the applicability of any other law of similar substance and
effect, absent an express statement to the contrary hereinabove, this e-mail
message its contents, and any attachments hereto are not intended to represent
an offer or acceptance to enter into a contract and are not otherwise intended
to bind the sender, Sanmina-SCI Corporation (or any of its subsidiaries), or
any other person or entity.
_____________________________________________________________________________
Scanned by Sanmina-SCI eShield
_____________________________________________________________________________
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match