Yes; you're right. Sorry. Meanwhile, I also discovered, my RedHat may
originally have put a competing postgres onto the system from some RPM.
[EMAIL PROTECTED] root]# rpm -q postgresql
postgresql-7.2.1-5
So now I've done:
[EMAIL PROTECTED] root]# rpm --erase postgresql postgresql-server
postgresql-contrib php-pgsql
After having done the "rpm --erase" I cleaned the /data/postgres and
/opt/postgres-7.4.1 directories; re-created the postgres user, but initdb
still had the same fault. So I re-inserted the "absolute path"-hack;
createdb, and started psql to create function. The result from strace (when
running the CREATE FUNCTION) of the backend is:
"Q\0\0\0\237CREATE OR REPLACE FUNCTION "..., 8192, 0) = 160
gettimeofday({1075756990, 462661}, NULL) = 0
stat64("/usr/local/pgsql/lib/ascii_and_mic", 0xbfffca10) = -1 ENOENT (No
such file or directory)
stat64("/usr/local/pgsql/lib/ascii_and_mic.so", 0xbfffca10) = -1 ENOENT (No
such file or directory)
stat64("$libdir/ascii_and_mic", 0xbfffcad0) = -1 ENOENT (No such file or
directory)
write(2, "ERROR: could not access file \"$"..., 81) = 81
send(8, "E\0\0\0\202SERROR\0C58P01\0Mcould not ac"..., 131, 0) = 131
rt_sigprocmask(SIG_SETMASK, ~[QUIT ILL TRAP ABRT BUS FPE KILL SEGV CONT STOP
SYS], NULL, 8) = 0
time(NULL) = 1075756990
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
send(8, "Z\0\0\0\5I", 6, 0) = 6
recv(8,
It seems to search in /usr/local/pgsql -- but that directory does not exist
(at least not after the rpm --erase).
Does this give you a clue ?
Rgds
/Thomas.
-----Original Message-----
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 9:52 PM
To: Thomas Borg Salling
Cc: 'PostgreSQL Bugs List'
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory
"Thomas Borg Salling" <[EMAIL PROTECTED]> writes:
> Does this give you any clues ?
That's what I expected, but it doesn't tell me anything new. Could you
try strace-ing the backend while you execute the CREATE FUNCTION
command?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
