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@xxxxxxxxxxxxx] Sent: Tuesday, November 15, 2005 1:19 PM To: ITS ONT Alcazar, Jose Aguedo C Cc: Tim Allen; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Major Problem, need help! Can't run our website! "ITS ONT Alcazar, Jose Aguedo C" <jacalcazar@xxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
