How to find the disk usage with PT PostgreSQL database?
Join Date: Aug 2006
Posts: 1,816
I've been using a VMWare image to play poker for the past year or so due to the fact that I was shuffling between different computers in the house and simply running the same VMWare image on all of them and serving my PT database off one of them. Now that I am no longer doing this, I would like to transfer the database to the VM image but need to make sure that the disk size used by the image is large enough. Does anyone know how to find out how much server disk space is used by the database?
Join Date: Sep 2007
Posts: 211
Check how big the Data directory is in the Postgres dir?
Join Date: Dec 2006
Posts: 351
There are functions for this in contrib/dbsize.sql