Out of disk space- error code - Mailing list pgsql-admin

From Anagha Joshi
Subject Out of disk space- error code
Date
Msg-id FF851C7EEB75954F9BCFB5CA117AB1EC011435@delta.nulinkinc.com
Whole thread Raw
List pgsql-admin
Hello,
I�m using PostgreSQL 7.1.2 on Sun Solaries 8.
 
One day when EMS server was kept for overnight test machine ran out of disk space. This tied up the postgres process and stoped normal use of the EMS. The postgres logs have useful info explaining the situation but it looks as if this information is not passed to the client. 
I want to display client warning to the user when the server/db hostmachine is running low on disk space. The warning could be displayed to any open clients as well as any new clients who attempt to log into the server.
 
Please see the server logs and the postgres logs attached.
 
Here is the scenario:
 
On the EMS server hostmachine I could not su 'postgres' to see the postgres pid.
It looked as if the postgres process was tied up some how. 
 
The EMS server pids were available but postgress was not. This looks like a potential DB crash although there are no postgres core files or logs that give us clues as to what may have happned 
The zipped server logs display lots of error trying to locate the postgres PID.
 

The snapshot of the Postgres log is like this:

ERROR:cannot extend trap: No space left on device.

����������� Check free disk space.

ERROR:cannot extend trap: No space left on device.

����������� Check free disk space.

ERROR:cannot extend trap: No space left on device.

����������� Check free disk space.

ERROR:cannot extend trap: No space left on device.

 

"root" execution of the PostgreSQL server is not permitted.

 

DEBUG:database system shutdown was interrupted at 2003-02-10 06:32:20 PST

DEBUG:CheckPoint record at (0, 98945120)

DEBUG:Redo record at (0, 98945120); Undo record at (0, 0); Shutdown FALSE

DEBUG:NextTransactionId: 221802; NextOid: 239904

DEBUG:database system was not properly shut down; automatic recovery in progress...

DEBUG:redo starts at (0, 98945184)

DEBUG:ReadRecord: record with zero len at (0, 98962280)

DEBUG:redo done at (0, 98962240)

DEBUG:database system is in production state

DEBUG:MoveOfflineLogs: remove 0000000000000005

 

Is there anyway, that Postgres returns error code (apart from error message) when disk space is full ?

Pls. help ASAP.

 

Thanks in advance,

Anagha

 

pgsql-admin by date:

Previous
From: Daniel Rubio
Date:
Subject: Re: Can't connect to my postgresql
Next
From: "A.Bhuvaneswaran"
Date:
Subject: Re: About changing type af a column