[SOLVED] postgresql error

Hi,

I download “postgresql-9.0.4″ and cross-compile for my embedded board.

I followed this link for installation,

http://www.thegeekstuff.com/2009/04/...e-from-source/


When I try to start my postgreSQL database its gives me following error:
“FATAL: could not write lock file “/tmp/.s.PGSQL.5432.lock”: No space left on device”

The output of df -h is
$df -h
Filesystem Size Used Available Use% Mounted on
/dev/root 3.6G 650.4M 2.8G 18% /
tmpfs 424.0M 40.0K 424.0M 0% /dev
shm 424.0M 0 424.0M 0% /dev/shm
rwfs 512.0K 512.0K 0 100% /mnt/rwfs
rwfs 512.0K 512.0K 0 100% /tmp
rwfs 512.0K 512.0K 0 100% /var

It shows that ‘/tmp’ is full, but ‘/’ is 2.8G free.
I install filesystem on 4GB SD card.

Please help me to solve this problem.
Thanks in advance.

rwfs 512.0K 512.0K 0 100% /tmp

.. seems pretty clear there is no space left on /tmp - therefore the lock file cannot be created. I suggest you rearrange your partitioning or use tmpfs for /tmp which will map it into ram.

Thank you kbp,
Can you please guide me, I don't know how to create a tmpfs ?
On my MMC/SD card I have two partitions,

root@embd ~$ cat /proc/partitions
major minor #blocks name

179 0 3872256 mmcblk0
179 1 3868160 mmcblk0p1

I copied U-boot and uImage on first partition (mmcblk0),
and copied the rootFS on second partition (mmcblk0p1).

So please help me how to create a tmpfs partition and what is the size of it.

Thanks.

You don't need to create it, just add it to /etc/fstab - the size is equal to the amount of memory present in the machine

Originally Posted by kbp You don't need to create it, just add it to /etc/fstab - the size is equal to the amount of memory present in the machine

I added following entry into /etc/fstab,

root@embd $cat /etc/fstab
#
# /etc/fstab: static file system information.
#
# file system mount type options dump pass
#/dev/root / ext2 rw,noauto 0 1
proc /proc proc defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
usbfs /proc/bus/usb usbfs defaults 0 0
tmpfs /tmp tmpfs defaults 0 0

And after rebooting the output of df is

root@embd ~$ df -h
Filesystem Size Used Available Use% Mounted on
/dev/root 3.6G 613.3M 2.8G 17% /
tmpfs 424.0M 40.0K 424.0M 0% /dev
shm 424.0M 0 424.0M 0% /dev/shm
rwfs 512.0K 512.0K 0 100% /mnt/rwfs
rwfs 424.0M 0 424.0M 0% /tmp
rwfs 512.0K 512.0K 0 100% /var
tmpfs 424.0M 0 424.0M 0% /tmp

Thank you very much, the problem gets solved, postgresql is running now
I have one question,
In df output, it shows the /tmp is mounted twice, How do I remove the first entry.

Just remove the matching entry from /etc/fstab