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

pgAdminIII and the LogFile - useless for debugging

From: Scott Chapman <chappie(at)mischko(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdminIII and the LogFile - useless for debugging
Date: 2005-03-02 01:57:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
pgAdminIII 1.2.0 PostgreSQL 8.0

I moved over from Linux to do some work with Pg on Windows.  Windows 
doesn't have a "tail" command unless you use cygwin tail it from there.

So, I was quite happy to see the Tools->Server Status->LogFile option in 

The first thing I noticed is that it doesn't "tail".  The scroll bar 
stays where it was an you move it manually.  That's something I can live 
with but I'd love to see it able to put the latest queries on top or 
scroll the bar and allow you to scroll back to get into the history buffer.

Anyway, I turned my logging level to LOG and my log_statement to all so 
I can see what is actually being SELECTED.  This is a great way to debug 
your web application in my experience.  Imagine my disappointment when 
the log file started filling up with this junk:

2005-03-01 17:39:04 LOG:  statement: SELECT pg_file_length('C:/Program 
Files/PostgreSQL/8.0/data/pg_log/postgresql-2005-03-01_173622.log') AS len
2005-03-01 17:39:04 LOG:  statement: SELECT len FROM pg_file_stat($1) AS 
s(len int8, c timestamp, a timestamp, m timestamp, i bool)
2005-03-01 17:39:04 CONTEXT:  SQL function "pg_file_length" during inlining

...making it virtually completely useless.

PgAdmin needs to find another way to get the log file length besides a 
SQL query to the database!  I'm off to deal with cygwin now.  :(

Is this the place to put in enhancement requests/bug notices?



pgadmin-support by date

Next:From: Miha RadejDate: 2005-03-02 07:14:24
Subject: Re: pgAdminIII and the LogFile - useless for debugging
Previous:From: Dave PageDate: 2005-03-01 08:07:18
Subject: Re: Question for using PGADMIN

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