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

Re: Function Hangs

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
Subject: Re: Function Hangs
Date: 2002-02-13 20:11:16
Message-ID: 20020213201618.ZXAH13094.femail46.sdc1.sfba.home.com@there (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-02-13 21:08:00
Subject: Re: Pooled Connections
Previous:From: Peter MuhlbergerDate: 2002-02-13 20:09:11
Subject: Pooled Connections

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