PostGreSQL
Reclaim some disk space by managing your postgresql database
I got an alarm that one of my virtual machines was low on space and after a quick analysis the file system was showing that the PostgreSQL folder was the culprit, so I realized its was time to shrink the drupal DB down a bit.
first I did
sudo su postgresnext I ran psql on the database that was very large
psql drupal7Next I did a full vaccum
vacuum full verbose; then I did a full reindex
reindex database drupal7;Things are running much smoother.
How do I know what version of PostGreSQL I am running?
Run this simple query on any database in the server:
SELECT version();you should see a result something like:
"PostgreSQL 8.3.9 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.2-1ubuntu11) 4.3.2"The next question will logically be, how do I determine the version of PostGIS running on PostGreSQL?
query any DB with this code:
select postgis_full_version();will give a result like:
"POSTGIS="1.5.1" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.5" USE_STATS"