There is only one installation of PostGreSQL on this machine.
It is a 8.0 beta 1
This is running on a RedHat 8 box and the initial setup did not include any
database. I downloaded and installed PostGreSQL from source.
I noticed that all the directories under /usr/local/pgsql except "data" were
owned by root with a root group as well, so I changed them all to be owned
by postgres in the postgres group and that did not help.
As a side note, on my other machine where it is working fine, the directory
ownership is currently set up with root owning everything and being the root
group except the "data" directory, so I didn't think that was the issue, but
I tried anyways.
Any other thoughts or guidance are muchly appreciated.
Sim
"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:1534.1104466460@sss.pgh.pa.us...
> "Sim Zacks" <sim@nospam.com> writes:
> > Here are the results of pgconfig and ldd. They both look correct.
>
> > [root@bkupsrvr] /usr/local/pgsql/bin/pg_config --pkglibdir
> > /usr/local/pgsql/lib
>
> > [root@bkupsrvr] ldd /usr/local/pgsql/lib/utf8_and_iso8859.so
> > libc.so.6 -> /lib/i686/libc.so.6
> > /lib/ld-linux.so.2 -> /lib/ld-linux.so.2
>
> Hmph. Looks fine to me too. But are you certain that
> /usr/local/pgsql/bin/pg_config matches up with the postmaster you are
> actually talking to? I'm wondering if you have multiple PG
> installations on that machine...
>
> (It's probably a misfeature that you can't ask the backend directly
> what it thinks $libdir expands to.)
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>