Return-Path: postman 
Delivery-Date: Wed, 27 Oct 93 08:48:31 PDT
Return-Path: postman
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA07300; Wed, 27 Oct 93 08:42:21 -0700
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9310271542.AA07300@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: postgres@st.nepean.uws.edu.au
Received: from lancelot.st.nepean.uws.EDU.AU by postgres.Berkeley.EDU (5.61/1.29)
	id AA07280; Wed, 27 Oct 93 08:42:09 -0700
Received: from guinevere.st.nepean.uws.edu.au (guinevere) by lancelot.st.nepean.uws.edu.au with SMTP id AA22784
  (5.65c/IDA-1.4.4 for <postgres@postgres.berkeley.edu>); Thu, 28 Oct 1993 01:48:46 +1000
Received: by guinevere.st.nepean.uws.edu.au id AA28762
  (5.65c/IDA-1.4.4 for postgres@postgres.berkeley.edu); Thu, 28 Oct 1993 01:46:58 +1000
From: PostGres <postgres@st.nepean.uws.edu.au>
Message-Id: <199310271546.AA28762@guinevere.st.nepean.uws.edu.au>
Subject: Expanding pg_time table
To: postgres@postgres.berkeley.edu (PostGres Mail Group)
Date: Thu, 28 Oct 1993 01:46:54 +1000 (EST)
X-Mailer: ELM [version 2.4 PL6]
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 1763      
Resent-To: postgres-dist
Resent-Date: Wed, 27 Oct 93 08:42:20 PDT

To The More Knowledgable,

I have a few of questions for you :

1st :  how do I reduce the size of the pg_time table
       in the ~/data directory .. this file is now
       approaching 2megs and since I dont really know
       what its used for I thought it best to ask. This
       also goes for the pg_log file.

2nd :  The system occasionally produces temp files in
       the ~/data/base/user database directories. What
       are these files for and is it ok to delete them.

3rd :  My system does not allow me to purge any of the
       classes. It also falls over with the error 
       mentioned in the man entry. Has this been fixed
       or is it something Im doing wrong.

To close .. a few words of praise. I am currently 
developing a system for keeping track of all the allocated
IP numbers across our distributed campuses. I needed a
relatively small, (no cost :) product that could run on
both the dec and the sun environments. Even with the locking
problems with postgres I have found the product to be most
useful in this application. To ensure data integrity it
was necessary to use a dummy lock table .. but that aside
it was worth the effort to create this postgres based
application. My thanx to the authors.

Glen Darby
-- 
--------------------------------------------------------
| University Of Western Sydney                         |
| Postgres Database Aministration                      |
|                                                      |
| Administrator :  Glen Darby                          |
|                                                      |
|                                                      |
| Return Mail : postgres@st.nepean.uws.edu.au          |
========================================================