Two Plus Two Newer Archives

Two Plus Two Newer Archives (http://archives1.twoplustwo.com/index.php)
-   Software (http://archives1.twoplustwo.com/forumdisplay.php?f=47)
-   -   How to find the disk usage with PT PostgreSQL database? (http://archives1.twoplustwo.com/showthread.php?t=552262)

Sean Fraley 11-22-2007 02:16 PM

How to find the disk usage with PT PostgreSQL database?
 
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?

Brocken 11-22-2007 05:31 PM

Re: How to find the disk usage with PT PostgreSQL database?
 
Check how big the Data directory is in the Postgres dir?

notreallymyname 11-22-2007 07:13 PM

Re: How to find the disk usage with PT PostgreSQL database?
 
There are functions for this in contrib/dbsize.sql


All times are GMT -4. The time now is 07:20 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.