Is there any way to increase the size of pgsql/data? I believe that my database is crashing because I have run out of space.
A:
Buy bigger hard drive.
Or if you have free space on another disk/partition - read about tablespaces.
depesz
2009-09-26 18:53:52
A:
It is easy to confirm your theory -- check how much free space you have on the volume used by postgres. On *NIX systems, you'll want to use the df ("disk free") command. This will show all the mounted volumes, and the used and free space on each, and will look something like this (from my OS X laptop):
$ df
Filesystem 512-blocks Used Available Capacity Mounted on
/dev/disk0s2 624208520 564315416 59381104 91% /
devfs 215 215 0 100% /dev
...
You want to find the line where "Mounted on" has the longest path which is a parent of your pgsql/data folder. Check the "Available" column for amount of space remaining on the device.
dcrosta
2009-09-27 01:39:03