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/
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 spaceHi,
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/
Import Notes
Resolved by subject fallback
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 exceedingphysical 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 thatrelevant
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/