BUG #13492: drop database does not release disk space

Started by Nonamealmost 11 years ago2 messagesbugs
Jump to latest
#1Noname
ismaelbezerra@gmail.com

The following bug has been logged on the website:

Bug reference: 13492
Logged by: Ismael Bezerra
Email address: ismaelbezerra@gmail.com
PostgreSQL version: 9.4.4
Operating system: Linux CentOS 6
Description:

I'm having problem to drop a database. When performing the drop database
command postgresql does not release the disk space. The directory with oid
database remains on disk. This database has been updated from version 9.3.4
to 9.4.4 with the -k option pg_upgrade. What can it be?

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: BUG #13492: drop database does not release disk space

ismaelbezerra@gmail.com writes:

I'm having problem to drop a database. When performing the drop database
command postgresql does not release the disk space. The directory with oid
database remains on disk. This database has been updated from version 9.3.4
to 9.4.4 with the -k option pg_upgrade. What can it be?

If you forgot to rm -rf the 9.3 database directory after you were finished
upgrading, then all those files are still hard-linked into the 9.3 tree,
so they wouldn't disappear after being dropped from the 9.4 tree.

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs