My basic idea was to move one directory to a bigger disk. I used this page to do that: http://embraceubuntu.com/2006/01/29/move-home-to-its-own-partition/ And here are the steps what were proceeded:
mkdir /mnt/newpostgresql
sudo mount -t ext4 /dev/sdb1 /mnt/newpostgresql
cd /var/lib/postgresql
$find . -depth -print0 | cpio --null --sparse -pvd /mnt/newpostgresql
umount /mnt/newpostgresql
mv /var/lib/postgresql /var/lib/old_postgresql
mkdir /var/lib/postgresql
mount /dev/sdb1 /var/lib/postgresql
/etc/fstab ->
/dev/sdb1 /var/lib/postgresql ext4 nodev,nosuid 0 2
restart
rm -r /var/lib/old_postgresql
After rebooting I had the following error: "Serious error where found while checking the disk drive for ..."
There is an option to skip this error, but it's quite to inconvient to do this every boot.
I searched for solution at many places, but I couldn't find what could cause the problem. Previously I also moved my home directory to the same disk. Now I also have the home directory in the /var/lib/postgresql Here is my /etc/fstab:
# /etc/fstab: static file system information.
#
# Use 'blkid -o value -s UUID' to print the universally unique identifier
# for a device; this may be used with UUID= as a more robust way to name
# devices that works even if disks are added and removed. See fstab(5).
#
# <file system> <mount point> <type> <options> <dump> <pass>
proc /proc proc nodev,noexec,nosuid 0 0
# / was on /dev/sda1 during installation
UUID=2c5347a2-b829-4e4d-b82b-c4d7b3ea0dd5 / ext4 errors=remount-ro 0 1
# swap was on /dev/sda5 during installation
UUID=022af060-e909-4d12-a532-8834b319e75c none swap sw 0 0
/dev/fd0 /media/floppy0 auto rw,user,noauto,exec,utf8 0 0
/dev/sdb1 /home ext4 nodev,nosuid 0 2
/dev/sdb1 /var/lib/postgresql ext4 nodev,nosuid 0 2
Any help or suggestions is appreciated.
