Re: device full ---> postgres will not start

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