Unfortuneatly the partition that has the Postgres DB has filled up beause of files in the Postgres directory. this partition is 85GB
I tried using Table space to point it at a new partition so I did exampledb=# CREATE TABLESPACE fastspace LOCATION '/var/example/postgres';
which didn't work so I did
example=# SET default_tablespace = fastspace;
but that still didn't work
I also tried VACUUM FULL; last night but this hasn't freed up any space, the offending files are under /var/databases/8.1/main/base/2832253#
and the files inside the directory look like
2833195 2836410 2912054 2937747 3463991 2832506
and there a awful lot of them (85G to be precise) This database server serves our legacy web infrstructure to put things into perspective our current production database (Mysql) is 4.7G so I can't imagine our old database would be 85G!, I presume it just requires a bit of a clean up but im not sure where to start apart from the VACUUM,
As you probaly can tell I haven't got much experiene with Postgres so any help would be great