X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A8A979FA19B for ; Mon, 15 May 2006 17:17:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49060-02 for ; Mon, 15 May 2006 17:16:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 51B3F9FA15C for ; Mon, 15 May 2006 17:16:57 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.sprint-hsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.6/8.13.4) with ESMTP id k4FKGrfJ022753; Mon, 15 May 2006 13:16:54 -0700 Message-ID: <4468E1B2.60708@commandprompt.com> Date: Mon, 15 May 2006 13:16:50 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mail/News 1.5 (X11/20060309) MIME-Version: 1.0 To: "Jim C. Nasby" CC: "Xu, Xiaoyi (Rocky) FSM" , andy.shellam@mailnetwork.co.uk, pgsql-admin@postgresql.org Subject: Re: Error in MS Access References: <20060515194228.GH26212@pervasive.com> In-Reply-To: <20060515194228.GH26212@pervasive.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.2, clamav-milter version 0.88.2 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Mon, 15 May 2006 13:16:54 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/200 X-Sequence-Number: 21732 Jim C. Nasby wrote: > On Mon, May 15, 2006 at 12:56:16PM -0500, Xu, Xiaoyi (Rocky) FSM wrote: >> Thank you Andy. >> >> The server is SunOS 5.8 Generic_117350-29 ultra-250. The db is version 7. > > 7.what? > >> I checked disk (df -k) telling me /home0 is full 100% that has DB on. Former DBA has notes to delete large log files (server.log). But this time I didn't find same file. I saw pg_log file 4.6 MB timestamped May 9. > > Be *VERY* careful about deleting anything in $PGDATA. A file called > pg_log is probably safe, but you never know... Well pg_log is the default logging location of PostgreSQL as of 8.1 (if it is not logging to syslog), thus anything within there *should* be safe. However, Jim is correct... be very, very careful in that directory. > > 4.6MB certainly isn't going to get you very far. How large is /home0? > How large is the database? How often have you been vacuuming? Joshua D. drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/