From: ITS ONT Alcazar, Jose Aguedo C <jacalcazar@exportbank.com.ph>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: ITS ONT Alcazar, Jose Aguedo C <jacalcazar@exportbank.com.ph>
Cc: Tim Allen <tim@proximity.com.au>
Cc: pgsql-admin@postgresql.org
Subject: Re: Major Problem, need help! Can't run our website!
Date: Tue, 15 Nov 2005 13:53:27 +0800
Message-ID: <227C7FFACEA9D9118BD600096BA5A7CA011E1B43@EIBPOST> (raw)
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" <jacalcazar@exportbank.com.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jacalcazar@exportbank.com.ph, tgl@sss.pgh.pa.us, tim@proximity.com.au
Subject: Re: Major Problem, need help! Can't run our website!
In-Reply-To: <227C7FFACEA9D9118BD600096BA5A7CA011E1B43@EIBPOST>
References: <227C7FFACEA9D9118BD600096BA5A7CA011E1B43@EIBPOST>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox