Re: Major Problem, need help! Can't run our website!

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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, November 15, 2005 1:19 PM
To: ITS ONT Alcazar, Jose Aguedo C
Cc: Tim Allen; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Major Problem, need help! Can't run our website!

"ITS ONT Alcazar, Jose Aguedo C" <jacalcazar(at)exportbank(dot)com(dot)ph> 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