Re: device full ---> postgres will not start - Mailing list pgsql-admin

From kevin07@optonline.net (kbd)
Subject Re: device full ---> postgres will not start
Date
Msg-id f5454a7d.0310270524.305c863b@posting.google.com
Whole thread Raw
In response to device full ---> postgres will not start  (Duffy House <kevin07@optonline.net>)
List pgsql-admin
Thanks for your reply to my posting.
Hope you would be willing to provide some additional assistance.
What can I says, I really do not have enough experience to bail, myself
out of this one.

i did cd /var/lib/pgsql/data then du-sh   this reported    3.6gig
This means I really have a 3.6 gig postgesql database?

**********
Var contain also all log file of your box
where would they be? can I dump old ones?  well how do I dump them?
*********
 we run vacume everyday against the database.

 thanks in advance

kd




mendola@bigfoot.com (Gaetano Mendola) wrote in message news:<3F9C5B92.4060800@bigfoot.com>...
> Duffy House wrote:
>
> > Hello:
> >
> > It looks like I got caught sleeping.
> >
> > I am running Postgresql 7.2 under Red Hat 7.3.
> > Postgresql failed today.  When I tried to restart it, I got a message
> > stating that the device is full.
> > I used df to confirm that /var where postgres reside is full.  /var is
> > on a 4 Gig device.
> > Postgresql is the only application on this machine.
> >
> > Please note, the backup of the database from the prior day, is 45 Meg
> > zipped.
> > I do not know how the database could be soaking up a 4 Gig device.
> >
> > Questions:
> >
> > How can I recover from this situation?
>
> Var contain also all log file of your box I guess.
> Go on your directory data  ( on RH is on /var/lib/pgsql/data )
> and do :
>
> du -sh
>
> if is really 4GB move your data directory in another big partition,
> make a simbolink link with your old location, start postgres and
> do a vacuum full of your database.
>
> if is not really 4GB  do a log rotate of your logs.
>
>
>
>
> Regards
> Gaetano Mendola
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html

pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Starting postgresql service FAILED
Next
From: "scott.marlowe"
Date:
Subject: Re: device full ---> postgres will not start