handling of database size exceeding physical disk space

Started by Rini Duttaalmost 25 years ago3 messages
#1Rini Dutta
rinid@rocketmail.com

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/

#2Diehl, Jeffrey
jdiehl@sandia.gov
In reply to: Rini Dutta (#1)
RE: [SQL] handling of database size exceeding physical disk space

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

Show quoted text

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

#3Rini Dutta
rinid@rocketmail.com
In reply to: Diehl, Jeffrey (#2)
RE: [SQL] handling of database size exceeding physical disk space

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/