I didn't pay attention when i installed postgresql with aptitude, but it installed the databases in the wrong partition.
Now my partitions look like this:
# df -h Filesystem Size Used Avail Use% Mounted on /dev/md1 10G 8.7G 793M 92% / tmpfs 2.0G 0 2.0G 0% /lib/init/rw udev 10M 176K 9.9M 2% /dev tmpfs 2.0G 0 2.0G 0% /dev/shm /dev/md2 683G 197M 649G 1% /home
I checked and postgresql data is installed on
This will be a problem in no time, and I would like to fix this. What is the best approach ? Can i simply move the postgresql directory and patch some configuration file ? Can I extend the size of the partition dev/md1 ?
I'm looking for a way to do any of this successfully.