RE: [SQL] handling of database size exceeding physical disk space

From: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>
To: "'Rini Dutta'" <rinid(at)rocketmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: RE: [SQL] handling of database size exceeding physical disk space
Date: 2001-02-20 16:53:14
Message-ID: B51F0C636E578A4E832D3958690CD73E0130BE0F@es04snlnt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

I happen to know this very well... It handles things very gracefully as far
as I can tell. I complains that it can't extend the table and bails out of
the transaction. I just wish it didn't happen so often... <grin>

Mike Diehl,
Network Monitoring Tool Devl.
284-3137
jdiehl(at)sandia(dot)gov

> -----Original Message-----
> From: Rini Dutta [mailto:rinid(at)rocketmail(dot)com]
> Sent: February 20, 2001 9:35 AM
> To: pgsql-general(at)postgresql(dot)org; pgsql-sql(at)postgresql(dot)org
> Cc: pgsql-hackers(at)postgresql(dot)org
> Subject: [SQL] handling of database size exceeding physical disk space
>
>
> Hi,
>
> Does anyone know how postgres/ postmaster handles the
> situation where the physical hard disk space is full ?
> Does it crash / corrupt the database, or does it
> cleanly exit with appopriate message so that relevant
> tables can be pruned (by the user) to free up disk
> space and get it working again ?
>
> Thanks,
> Rini
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year! http://personal.mail.yahoo.com/
>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emmanuel Pierre 2001-02-20 16:57:27 number of pgsql childrens
Previous Message Paulo Parola 2001-02-20 16:52:30 unions on views (workaround?)

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2001-02-20 16:57:14 Re: Re: beta5 ...
Previous Message Tom Lane 2001-02-20 16:47:16 Re: Turkish locale bug

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-02-20 16:54:54 Huh? Mysterious Function Error
Previous Message Rini Dutta 2001-02-20 16:34:39 handling of database size exceeding physical disk space