Thread: ISO_8859_8 encoding

PG 8.0 Beta 1

I created a new database with ISO_8859_8 encoding and I am getting an error
of:
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?

thanks
sim

"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
> > 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

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