Skip site navigation (1) Skip section navigation (2)

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

From: "ITS ONT Alcazar, Jose Aguedo C" <jacalcazar(at)exportbank(dot)com(dot)ph>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "ITS ONT Alcazar, Jose Aguedo C" <jacalcazar(at)exportbank(dot)com(dot)ph>
Cc: Tim Allen <tim(at)proximity(dot)com(dot)au>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Major Problem, need help! Can't run our website!
Date: 2005-11-15 05:53:27
Message-ID: 227C7FFACEA9D9118BD600096BA5A7CA011E1B43@EIBPOST (view raw or flat)
Thread:
Lists: pgsql-admin
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


Responses

pgsql-admin by date

Next:From: Jonah H. HarrisDate: 2005-11-15 06:28:12
Subject: Re: [HACKERS] Major Problem, need help! Can't run our
Previous:From: Tom LaneDate: 2005-11-15 05:19:13
Subject: Re: Major Problem, need help! Can't run our website!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group