Re: [GENERAL] Ownership/Permissions Problem

2010-12-24 Thread Rich Shepard
On Fri, 24 Dec 2010, Joshua D. Drake wrote: You will want to make sure you didn't do that to /usr/local/pgsql/data . /usr/local/pgsql/data should be 700. Thanks, Josh. Fixed. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: ht

Re: [GENERAL] Ownership/Permissions Problem

2010-12-24 Thread Joshua D. Drake
On Fri, 2010-12-24 at 14:09 -0800, Rich Shepard wrote: > On Fri, 24 Dec 2010, John R Pierce wrote: > > > I'd check the permisisons on /usr/local/pgsql and /usr/local/pgsql/lib > > too. > > if that directory is not o+r, you'll have problems too. > > John, > >Bingo! The subdirectories in /u

Re: [GENERAL] Ownership/Permissions Problem

2010-12-24 Thread Rich Shepard
On Fri, 24 Dec 2010, John R Pierce wrote: I'd check the permisisons on /usr/local/pgsql and /usr/local/pgsql/lib too. if that directory is not o+r, you'll have problems too. John, Bingo! The subdirectories in /usr/local/pgsql were 700. Changing them to 755 fixed everything. _Very_ much

Re: [GENERAL] Ownership/Permissions Problem

2010-12-24 Thread John R Pierce
On 12/24/10 1:37 PM, Rich Shepard wrote: On Fri, 24 Dec 2010, John R Pierce wrote: wild guess says, libpq.so.5 or whatever its linked to. John, That was my original thought, too. on this system... $ ls -l /usr/lib/libpq* lrwxrwxrwx 1 root root 12 Dec 23 2009 /usr/lib/libpq.so.5 ->

Re: [GENERAL] Ownership/Permissions Problem

2010-12-24 Thread Rich Shepard
On Fri, 24 Dec 2010, John R Pierce wrote: wild guess says, libpq.so.5 or whatever its linked to. John, That was my original thought, too. 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 138

Re: [GENERAL] Ownership/Permissions Problem

2010-12-24 Thread John R Pierce
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: [rshep...@salmo ~]$ psql aesi psql: error while loading shared libraries: libpq

[GENERAL] Ownership/Permissions Problem

2010-12-24 Thread Rich Shepard
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: [rshep...@salmo ~]$ psql aesi psql: error while loading shared libraries: libpq.so.5: cannot open shared object file: Per