X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 59F32DB4C8; Mon, 14 Nov 2005 23:49:20 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50159-02; Tue, 15 Nov 2005 11:53:04 +0000 (GMT) X-Greylist: delayed 00:08:24.930145 by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from gw.proximity.com.au (147-68-185-210.rev.techex.net.au [210.185.68.147]) by svr1.postgresql.org (Postfix) with ESMTP id 19504D6D16; Mon, 14 Nov 2005 23:48:38 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by gw.proximity.com.au (Postfix) with ESMTP id 589651DF2C3; Tue, 15 Nov 2005 14:48:43 +1100 (EST) Received: from gw.proximity.com.au ([127.0.0.1]) by localhost (gw [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14207-10; Tue, 15 Nov 2005 14:48:42 +1100 (EST) Received: from [192.168.128.103] (bee.proximity.com.au [192.168.128.103]) by gw.proximity.com.au (Postfix) with ESMTP id 624E81DEDE4; Tue, 15 Nov 2005 14:48:42 +1100 (EST) Message-ID: <43795A96.9070500@proximity.com.au> Date: Tue, 15 Nov 2005 14:48:38 +1100 From: Tim Allen User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Hackers Cc: pgsql-admin@postgresql.org Subject: Re: Major Problem, need help! Can't run our website! References: <227C7FFACEA9D9118BD600096BA5A7CA011E188B@EIBPOST> In-Reply-To: <227C7FFACEA9D9118BD600096BA5A7CA011E188B@EIBPOST> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at proximity.com.au X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[MANY_EXCLAMATIONS=0] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/166 X-Sequence-Number: 19539 ITS ONT Alcazar, Jose Aguedo C wrote: > Anyone! > > Before anything else, I have no background in PostgreSQL. But I have a > little knowledge in Linux. We used postgreSQL to run one of our website. It > runs in Redhat Linux 7.3. Our System Administrator, who used to maintain > this server, had resigned and didn't have a proper documentation on how to > maintain this server. Right now, our NEW System Administrator is clearing > some logs in /var/lib/pgsql/data/pg_xlog in able to free some space in the > /var file system. It used to work before, but now, its not working anymore. > Information below is the message we are encountering when we are trying to > connect to the website. Please, ANYONE, help us! We've seen reports of people firing this particular foot-gun before, haven't we? Would it make sense to rename pg_xlog to something that doesn't sound like it's "just" full of log files? Eg pg_wal - something where the half-educated will have no idea what it is, and therefore not think they know what they can do with it. Tim -- ----------------------------------------------- Tim Allen tim@proximity.com.au Proximity Pty Ltd http://www.proximity.com.au/