ISO_8859_8 encoding

"Sim Zacks" <sim@nospam.com> writes:

Error: Could not access file "$libdir/utf8_and_iso8859": No such file or
directory. The file utf8_and_iso8859.so is in the /usr/local/pgsql/lib
directory. Is there somewhere I have to assign the $libdir variable or is
this something else completely?

It may be complaining about another shlib that that one depends on.
What does "ldd" say when you run it on utf8_and_iso8859.so?

Also, check "pg_config --pkglibdir" which is the definitive answer
as to what $libdir means.

regards, tom lane

Here are the results of pgconfig and ldd. They both look correct. Do I need
a link to libc.so.6 in my pglib/lib directory? It isn't there on my other
machine and that is working fine.

[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

[root@bkupsrvr] locate libc.so.6
/var/ftp/lib/libc.so.6
/lib/i686/libc.so.6
/lib/libc.so.6

[root@bkupsrvr] locate ld-linux.so.2
/var/ftp/lib/ld-linux.so.2
/lib/ld-linux.so.2

"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:7946.1103898819@sss.pgh.pa.us...

"Sim Zacks" <sim@nospam.com> writes:

Error: Could not access file "$libdir/utf8_and_iso8859": No such file or
directory. The file utf8_and_iso8859.so is in the /usr/local/pgsql/lib
directory. Is there somewhere I have to assign the $libdir variable or

is

"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

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...