pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-admin@postgresql.org
Subject: Re: Major Problem, need help! Can't run our website!
Date: Tue, 15 Nov 2005 08:32:02 -0500
Message-ID: <20051115133202.GD19079@phlogiston.dyndns.org> (raw)
In-Reply-To: <227C7FFACEA9D9118BD600096BA5A7CA011E1B43@EIBPOST>
References: <227C7FFACEA9D9118BD600096BA5A7CA011E1B43@EIBPOST>

On Tue, Nov 15, 2005 at 01:53:27PM +0800, ITS ONT Alcazar, Jose Aguedo C wrote:
> 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!

Actually, given that you are nearly full on that disk, you probably
need more disk.  You ought to be able to trim some things out of
/var/log.  But you can't delete anything from the PostgreSQL area
(/var/lib/pgsql/*, it looks like).  There's no "clean up" you can do
there -- your data is there.

You _may_ need a vacuum full -- if you have a lot of dead tuples, you
might be able to recover some disk space.  It'll lock all the tables,
so you'll need to be able to take an outage to do this.  In the psql
command monitor (psql -U postgres [yourdbname]) you can issue a
VACUUM FULL VERBOSE and recover available space (and find out how
much you're recovering -- that's what the VERBOSE does).  Note that
this may take a _long_ time to complete (depending how big oyur
database is), and (as I noted) it will cause your application not to
work while it's going on.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
		--H.W. Fowler



view thread (18+ messages)  latest in thread

Message-ID: <20051115133202.GD19079@phlogiston.dyndns.org>
Permalink:  ../20051115133202.GD19079@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20051115133202.GD19079@phlogiston.dyndns.org

 · 

reply

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: ajs@crankycanuck.ca
  Subject: Re: Major Problem, need help! Can't run our website!
  In-Reply-To: <20051115133202.GD19079@phlogiston.dyndns.org>
  References: <227C7FFACEA9D9118BD600096BA5A7CA011E1B43@EIBPOST> <20051115133202.GD19079@phlogiston.dyndns.org>

* 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