Skip site navigation (1) Skip section navigation (2)

Re: Function Hangs

From: "Rob Arnold" <rob(at)cabrion(dot)com>
To: <ingram(at)samsix(dot)com>, "Patrick Hatcher" <PHatcher(at)macys(dot)com>
Cc: "Josh Berkus" <josh(at)agliodbs(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Function Hangs
Date: 2002-02-15 03:44:06
Message-ID: 001e01c1b5d3$0f4cc1a0$4901010a@canrion.net (view raw or flat)
Thread:
Lists: pgsql-novice
Josh,

Yes, it goes where /dev/null is.  The only thing is that the log can't/wont
rotate that way.  It just keeps growing until postgres is restarted.  (It
can't because there is no way to SIG HUP the postmaster into releasing the
log file, it just stays "in use" until a restart) That may or may not be an
issue.  The other way to handle logging is to enable syslog logging in the
startup config file.  You will have to dig in the manual for the specifics
on that.

--rob

----- Original Message -----
From: "Stephen Ingram" <ingram(at)samsix(dot)com>
To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
Cc: "Josh Berkus" <josh(at)agliodbs(dot)com>; <pgsql-novice(at)postgresql(dot)org>
Sent: Wednesday, February 13, 2002 3:11 PM
Subject: Re: Function Hangs


> On Wednesday 13 February 2002 02:48 pm, Patrick Hatcher wrote:
> > I found the Postmaster startup file.  Here is the start params:
> >
> > 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?
> >
>
> Hi,
>
> Josh will answer anyway ( :) ), but this tripped me up too when I started.
>
> 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.
>
> It would be kind of nice if the startup scripts came as
>
> POSTMASTER_LOG=${POSTMASTER_LOG:-"/tmp/postmaster.log"}
> export POSTMASTER_LOG
>
> su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o
"-i"
>     start >${POSTMASTER_LOG} 2>&1"
>
> or some such.
>
> Just waffling on...
>
> Steve
>
>
> > Thanks again for the help
> >
> > Patrick Hatcher
> > Macys.Com
> > Legacy Integration Developer
> > 415-932-0610 office
> >
> >
> >
> >
> >
> >                     Patrick
> >                     Hatcher              To:     "Josh Berkus"
> > <josh(at)agliodbs(dot)com>@FDS-NOTES cc:     pgsql-novice(at)postgresql(dot)org
> > 02/13/2002           Subject:     Re: [NOVICE] Function Hangs(Document
> > link: Patrick Hatcher) 11:33 AM
> >
> >
> >
> >
> >
> > It was a Mandrake install, so it auto-starts during system start up.
> >
> > Patrick Hatcher
> > Macys.Com
> > Legacy Integration Developer
> > 415-932-0610 office
> >
> >
> >
> >
> >
> >                     "Josh Berkus"
> >                     <josh(at)agliodbs       To:     "Patrick Hatcher"
> > <PHatcher(at)macys(dot)com> .com>                cc:
> > pgsql-novice(at)postgresql(dot)org Subject:     Re: [NOVICE] Function Hangs
> > 02/13/2002
> >                     11:30 AM
> >
> >
> >
> >
> >
> >
> > Patrick,
> >
> > > Thanks.  Stupid question:  Where would I find the database log?
> >
> > Wherever you put it in your startup options for Postmaster.  I usually
> >  put mine in /var/log/postgresql.  How do you start postmaster?
> >
> > -Josh
> >
> > ______AGLIO DATABASE SOLUTIONS___________________________
> >                                        Josh Berkus
> >   Complete information technology      josh(at)agliodbs(dot)com
> >    and data management solutions       (415) 565-7293
> >   for law firms, small businesses        fax 621-2533
> >     and non-profit organizations.      San Francisco
> >
> >
> >
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>


In response to

pgsql-novice by date

Next:From: Ivan HorvathDate: 2002-02-15 09:44:26
Subject: problem in executing a function
Previous:From: Josh BerkusDate: 2002-02-14 21:31:48
Subject: Re: New ID

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group