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 32A47DB7B5 for ; Tue, 15 Nov 2005 00:47:45 -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 54772-10 for ; Tue, 15 Nov 2005 04:47:05 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from scm.exportbank.com.ph (unknown [202.73.175.197]) by svr1.postgresql.org (Postfix) with ESMTP id CFB3FDB7A1 for ; Tue, 15 Nov 2005 00:47:03 -0400 (AST) X-eSCM-MailFrom: Received: from EIBPOST (192.9.1.179) by scm (192.9.1.37); Tue, 15 November 2005 12:45:05 +0800 Received: by EIBPOST with Internet Mail Service (5.5.2657.72) id ; Tue, 15 Nov 2005 12:48:17 +0800 Message-ID: <227C7FFACEA9D9118BD600096BA5A7CA011E1A3E@EIBPOST> From: "ITS ONT Alcazar, Jose Aguedo C" To: Tom Lane , "ITS ONT Alcazar, Jose Aguedo C" Cc: Tim Allen , pgsql-admin@postgresql.org Subject: Re: Major Problem, need help! Can't run our website! Date: Tue, 15 Nov 2005 12:48:17 +0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="iso-8859-1" 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/173 X-Sequence-Number: 19546 Hi Tom! The hard disk space right now is 96%, according to them (sysadmins) it should work now. But, its not displaying anything in the website. They have cleared the said pg_xlog after making backups. They issued mv *filename* /directory (for backup) and cat null > *filename* (for creating file). Please help. Need to work on this ASAP. Thanks! -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, November 15, 2005 12:36 PM To: ITS ONT Alcazar, Jose Aguedo C Cc: Tim Allen; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Major Problem, need help! Can't run our website! "ITS ONT Alcazar, Jose Aguedo C" writes: > Can anyone help me on how to create this? Before you do anything else, it would help to figure out why your postmaster stopped running in the first place. Removing xlog files wasn't a very bright recovery measure, but that didn't cause the postmaster to stop. What did? Were you completely out of disk space? regards, tom lane