Last night, we upgraded from 7.1.2 to 7.3.4 on our Sun E3500's, running
Solaris 6. Everything went well, except that we appear to have dodged a
bullet, and that mystifies me.
Somehow, nobody noticed that the data filesystem was at 100%, yet this
heavily used application that uses postgres continued to run without error.
df -k show about 20k blocks unused.
Had this been in the old instance, i'd assume new rows were added to holes
in the database, where data was deleted. Since we pg_dumpall'd from one
instance to another, i'm sure the tables were all rebuilt without holes and
are all nice and tidy now.
The pgsql.log showed a bunch of rows like the following:
2003-12-03 20:33:22 LOG: recycled transaction log file 0000000000000000
2003-12-03 20:33:22 LOG: recycled transaction log file 0000000000000001
2003-12-03 20:33:22 LOG: recycled transaction log file 0000000000000002
There were no messages about being out of space.
Does Postgres have some keen trick to trash log files when you are out of
space, or did something else save our behinds?
Happy but curious,
Naomi
-------------------------------------------------------------------------------------------------------------------------
Naomi Walker Chief Information Officer
Eldorado Computing, Inc.
[EMAIL PROTECTED] 602-604-3100
-------------------------------------------------------------------------------------------------------------------------
Never eat more than you can lift. - Miss Piggy
------------------------------------------------------------------------------------------------------------------------
-- CONFIDENTIALITY NOTICE --
This message is intended for the sole use of the individual and entity to whom it is
addressed, and may contain information that is privileged, confidential and exempt
from disclosure under applicable law. If you are not the intended addressee, nor
authorized to receive for the intended addressee, you are hereby notified that you may
not use, copy, disclose or distribute to anyone the message or any information
contained in the message. If you have received this message in error, please
immediately advise the sender by reply email, and delete the message. Thank you.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
