pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
handling of database size exceeding physical disk space
3+ messages / 2 participants
[nested] [flat]

* handling of database size exceeding physical disk space
@ 2001-02-20 16:34  Rini Dutta <rinid@rocketmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Rini Dutta @ 2001-02-20 16:34 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-sql; +Cc: pgsql-hackers@postgresql.org

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/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: [SQL] handling of database size exceeding physical disk space
@ 2001-02-20 16:53  Diehl, Jeffrey <jdiehl@sandia.gov>
  0 siblings, 1 reply; 3+ messages in thread

From: Diehl, Jeffrey @ 2001-02-20 16:53 UTC (permalink / raw)
  To: 'Rini Dutta' <rinid@rocketmail.com>; pgsql-general@postgresql.org; pgsql-sql; +Cc: pgsql-hackers@postgresql.org

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/
> 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: [SQL] handling of database size exceeding physical disk space
@ 2001-02-20 19:11  Rini Dutta <rinid@rocketmail.com>
  parent: Diehl, Jeffrey <jdiehl@sandia.gov>
  0 siblings, 0 replies; 3+ messages in thread

From: Rini Dutta @ 2001-02-20 19:11 UTC (permalink / raw)
  To: Diehl, Jeffrey <jdiehl@sandia.gov>; pgsql-general@postgresql.org; pgsql-sql; +Cc: pgsql-hackers@postgresql.org

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/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-02-20 19:11 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-20 16:34 handling of database size exceeding physical disk space Rini Dutta <rinid@rocketmail.com>
2001-02-20 16:53 RE: [SQL] handling of database size exceeding physical disk space Diehl, Jeffrey <jdiehl@sandia.gov>
2001-02-20 19:11 ` Rini Dutta <rinid@rocketmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox