Search Postgresql Archives

Re: Reclaiming space for dropped database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Alban Hertroys <alban.hertroys@xxxxxxxxxxxxxxxxxxxx> writes:
> Our current development database server is running a bit low on diskspace, 
> so I dropped an old but rather large database with the intention of 
> claiming back some space. However, the space remains claimed.
> This server was upgraded from PG10 to PG11 using pg_upgrade's --link 
> option.

If you used --link, then all the files would remain hard-linked from both
the old and new database directories.  You've got to remove them from the
old DB directory as well.

There's not really any point in keeping around the source DB directory
once you've completed a --link migration.  Starting the postmaster in
the old DB directory would be disastrous because the files are
inconsistent from its standpoint once the new postmaster has modified
them at all.  (In fact, I think pg_upgrade intentionally makes the old
directory non-runnable to prevent that error.)  So you might as well
just "rm -rf ./10", not only its biggest subdirectory.

			regards, tom lane




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux