On 12/24/10 1:23 PM, Rich Shepard wrote:
I cannot run my accounting software and have, I believe, isolated the
problem by running 'psql' at the command line.
When I run psql logged in as myself I get this error:
[rshepard@salmo ~]$ psql aesi
psql: error while loading shared libraries: libpq.so.5: cannot open
shared
object file: Permission denied
Yet, when I su to user postgres and run the command it loads the shell:
postgres@salmo:/home/rshepard$ psql aesi
psql (9.0.1)
Type "help" for help.
aesi=#
What directory or file has the incorrect ownership and/or
permissions, and
what should they be?
wild guess says, libpq.so.5 or whatever its linked to.
on this system...
$ ls -l /usr/lib/libpq*
lrwxrwxrwx 1 root root 12 Dec 23 2009 /usr/lib/libpq.so.5 ->
libpq.so.5.1
-rwxr-xr-x 1 root root 138316 Dec 10 2009 /usr/lib/libpq.so.5.1
it doesn't really matter who owns it, what matters is the symlinked
actual file has +rx (755 or whatever)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general