Home > mailing lists

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

From	Duffy House
Subject	device full ---> postgres will not start
Date	October 25, 2003 02:04:36
Msg-id	GGEMLFEGHEKNIPGEHJBEIEJFCHAA.kevin07@optonline.net Whole thread Raw
Responses	Re: device full ---> postgres will not start (Gaetano Mendola <mendola@bigfoot.com>) Re: device full ---> postgres will not start ("scott.marlowe" <scott.marlowe@ihs.com>)
List	pgsql-admin

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?

If postgres will not start how can I restore the database from the prior day?

When I run a backup does postgres truncate its logs?

please keep it simple, I have about 1 hours admin experience with postgres.

thanks in advance.

From: Robert Treat
Date: 24 October 2003, 18:15:20
Subject: Re: Access with a management tool

From: Laszlo Hornyak
Date: 25 October 2003, 09:22:03
Subject: lost permissions?