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 AF9B0D6D16 for ; Tue, 15 Nov 2005 01:52:17 -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 74757-08 for ; Tue, 15 Nov 2005 05:52:16 +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 4BEB0D6D04 for ; Tue, 15 Nov 2005 01:52:13 -0400 (AST) X-eSCM-MailFrom: Received: from EIBPOST (192.9.1.179) by scm (192.9.1.37); Tue, 15 November 2005 13:50:17 +0800 Received: by EIBPOST with Internet Mail Service (5.5.2657.72) id ; Tue, 15 Nov 2005 13:53:29 +0800 Message-ID: <227C7FFACEA9D9118BD600096BA5A7CA011E1B43@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 13:53:27 +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/180 X-Sequence-Number: 19553 Thanks Tom! I think we did it. Below are the thing's i've inputed. Also, i have change the attributes and ownership of the xlog file as to the same with the previous file. Probably, they (sysadmins) have restored the backup xlog file to the original folder. That's why it was changed the attributes and ownership. Do you think this will resolve the issue? BTW, can you suggest on the clean-up thing? I think I wont recommend the one they are doing right now, deleting the files in pxlog. whats the best way they can do the clean-up? which one do they need to be "deleted"? Please advise. Thanks! # sudo /sbin/service postgresql start Starting postgresql service: [FAILED] # su - postgre -c postmaster DEBUG: database system was shut down at 2005-11-13 22:14:02 PHT DEBUG: checkpoint record is at 0/51C059A4 DEBUG: redo record is at 0/51C059A4; undo record is at 0/0; shutdown TRUE DEBUG: next transaction id: 7517511; next oid: 492827 FATAL 2: open of /var/lib/pgsql/data/pg_xlog/0000000000000052 (logfile 0, segment 82) failed: Permission denied DEBUG: startup process (pid 2502) exited with exit code 2 DEBUG: aborting startup due to startup process failure # chmod 600 0000000000000052 # chown postgres:postgres 0000000000000052 # sudo /sbin/service postgresql start Starting postgresql service: [OK] -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, November 15, 2005 1:19 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: > 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! On typical Linux systems, "sudo /sbin/service postgresql start" would probably do it, but this assumes that there isn't any problem that requires manual intervention. If you do that, does it work? If not, what do you get from "su - postgres -c postmaster" ? regards, tom lane