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

From: Rini Dutta <rinid(at)rocketmail(dot)com>
To: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>, 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 19:11:34
Message-ID: 20010220191134.18832.qmail@web2906.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

Thanks ! I'm using JDBC to insert into the tables.
Would it throw an SQLException in such a situation ?

Rini

--- "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov> wrote:
> 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/
> >
>

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-20 19:17:51 Re: vacuum analyze again...
Previous Message Dan Lyke 2001-02-20 19:06:06 Re: Re: A How-To: PostgreSQL from Tcl via ODBC

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-02-20 20:10:47 Re: Re: beta5 ...
Previous Message Tom Lane 2001-02-20 19:07:35 Re: About the FAQ_HPUX updates

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Czeyka 2001-02-21 03:30:51 two tables - foreign keys referring to each other...
Previous Message Josh Berkus 2001-02-20 17:58:09 Re: Huh? Mysterious Function Error