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 6DF0FDB7FA for ; Tue, 15 Nov 2005 00:52:54 -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 56227-06 for ; Tue, 15 Nov 2005 04:52:14 +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 CD93EDB80E for ; Tue, 15 Nov 2005 00:52:12 -0400 (AST) X-eSCM-MailFrom: Received: from EIBPOST (192.9.1.179) by scm (192.9.1.37); Tue, 15 November 2005 12:50:16 +0800 Received: by EIBPOST with Internet Mail Service (5.5.2657.72) id ; Tue, 15 Nov 2005 12:53:28 +0800 Message-ID: <227C7FFACEA9D9118BD600096BA5A7CA011E1A51@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:53:24 +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/176 X-Sequence-Number: 19549 Tom, as i've said in my previous eMail, I have no background on postgresql. can you help me on how to restart this? my apologies for my zero knowledge, but i really need this to work. thanks! -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, November 15, 2005 12:50 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: > 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! Well, if they were smart enough to keep a copy, then just moving the copy back should make it possible to restart the postmaster. What happens exactly when you try to start the postmaster? regards, tom lane