From: | Brian <signal(at)shreve(dot)net> |
---|---|
To: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] postgres getting slow |
Date: | 1999-05-20 18:51:43 |
Message-ID: | Pine.LNX.4.10.9905201350180.11822-100000@mercury.shreve.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>
> I have something like this in my startup script appended to the invocation
> of the postmaster ( as we discussed yesterday):
>
> >> ${PGLOGFILE} 2>&1
>
> where $PGLOGFILE is a path to postgres.log.
>
What sort of things to do you catch with logging this? I haven't seen a
single thing goto this file since starting it:
export PGLOGFILE=/var/lib/pgsql/pg.log
su postgres -c '/usr/bin/postmaster -B 250 -i -S -D/var/lib/pgsql -o -S 1024 >> ${PGLOGFILE} 2>&1'
[signal(at)norad signal]$ ls -al /var/lib/pgsql/pg.log
-rw-rw-r-- 1 postgres postgres 0 May 14 11:31 /var/lib/pgsql/pg.log
> Brett W. McCoy
> http://www.lan2wan.com/~bmccoy/
> -----------------------------------------------------------------------
> "One basic notion underlying Usenet is that it is a cooperative."
>
> Having been on USENET for going on ten years, I disagree with this.
> The basic notion underlying USENET is the flame.
> -- Chuq Von Rospach
>
-----------------------------------------------------
Brian Feeny (BF304) signal(at)shreve(dot)net
318-222-2638 x 109 http://www.shreve.net/~signal
Network Administrator ShreveNet Inc. (ASN 11881)
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Burrows | 1999-05-20 22:03:27 | libgen on a Sparc |
Previous Message | Rudy Gireyev | 1999-05-20 18:46:15 | RE: [GENERAL] Relations between tables. |