Thread: RE: handling of database size exceeding physical disk space

RE: handling of database size exceeding physical disk space

From
"Diehl, Jeffrey"
Date:
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@sandia.gov


> -----Original Message-----
> From: Rini Dutta [mailto:rinid@rocketmail.com]
> Sent: February 20, 2001 9:35 AM
> To: pgsql-general@postgresql.org; pgsql-sql@postgresql.org
> Cc: pgsql-hackers@postgresql.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/
>


RE: handling of database size exceeding physical disk space

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

Rini

--- "Diehl, Jeffrey" <jdiehl@sandia.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@sandia.gov
>
>
> > -----Original Message-----
> > From: Rini Dutta [mailto:rinid@rocketmail.com]
> > Sent: February 20, 2001 9:35 AM
> > To: pgsql-general@postgresql.org;
> pgsql-sql@postgresql.org
> > Cc: pgsql-hackers@postgresql.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/