No.. it was originally installed with /home
on this brand spanking new box and /usr/local
directory does not exist before
The thing is that my two web servers are run
under two other user ids and only under
web server environment these scripts were dying.
I cooked up a test script which runs fine
from the command line run under the id of
the owner of pgsql. The same test
script failed under web servers. It
was working before... but I was messing around
with permission on the home directories and
somewhere along the line things got too restrict
Only later in the day when I check logs I
realise that things were wrong.
BTW I wish later distributions will come
with better start and stop scripts.
pg_ctl is completely not working for me. I do
$ pg_ctl -o "-F -S 2048" start
and it keeps telling me I'm not doing it right.
On Wed, Feb 21, 2001 at 06:53:33PM -0500, John Madden wrote:
> > The problem mysteriously disappeared after I
> > reinstalled postgres under /usr/local/pgsql
> > instead of /home/newsreader/pgsql
>
> Was DBD::Pg installed with POSTGRES_INCLUDE and POSTGRES_LIB under
> usr/local/pgsql? Perhaps that's the problem?
>
>
> John
>
>
>
>
> --
> # John Madden weez@freelists.org ICQ: 2EB9EA
> # FreeLists, Free mailing lists for all: http://www.freelists.org
> # UNIX Systems Engineer, Ivy Tech State College: http://www.ivy.tec.in.us
> # Linux, Apache, Perl and C: All the best things in life are free!