Re: Function Hangs - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Function Hangs
Date
Msg-id web-693166@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Function Hangs  (Stephen Ingram <ingram@samsix.com>)
List pgsql-novice
Patrick,

> > su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p
>  /usr/bin/postmaster -o "
> > -i" start >/dev/null 2>&1"
> >
> > would the name of the log file go where the /dev/null is?

Nope.  Instead, right after the word "postmaster", insert:
 -l /var/log/postgresql
.. or wherever you want to store the log.  You should also make
 provisions in CRON to clear the log periodically, or it will continue
 to grow forever.

> Josh will answer anyway ( :) ), but this tripped me up too when I
>  started.

Postgres Novice Help Desk, at your service!  ;-)

> I know the idea is for it to be configured for ones own site,
> but it seems this is one of the first questions people who start
> with PG ask.

Yeah.  I don't know why most Postgres startup scripts ignore the log
 file.  Every time I do a Postgres install, I have to alter the startup
 script by hand.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Pooled Connections
Next
From: "Patrick Hatcher"
Date:
Subject: Re: Function Hangs