Re: FW: [ADMIN] Out of disk space- error code - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: FW: [ADMIN] Out of disk space- error code
Date
Msg-id 20030515123822.GC23812@libertyrms.info
Whole thread Raw
In response to FW: [ADMIN] Out of disk space- error code  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
List pgsql-performance
On Thu, May 15, 2003 at 04:09:44PM +0530, Anagha Joshi wrote:
> The snapshot of the Postgres log is like this:
> ERROR:  cannot extend trap: No space left on device.
>             Check free disk space.

[. . .]

>
> That was clear from the logs that disk is full. But is there anyway that
> I can check this programatically? i.e. when I call 'PgDatabase::Exec()'
> to execute query from C++ API, I get error code reflecting 'low on the
> disk'? I know I can get corresponding error message in C++ from Postgres
> by
> 'errorMessage()' method. I want specific error code for this.

Postgres relies on your filesystem and OS.  It doesn't know you're
low on disk until it gets the error from the OS.  Use your OS to warn
you if you're going to run out of space.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-performance by date:

Previous
From: SZUCS Gábor
Date:
Subject: Re: nested select query failing
Next
From: Stephan Szabo
Date:
Subject: Re: nested select query failing