LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 08-05-2011, 12:58 AM   #1
beparas
Member
 
Registered: Nov 2006
Location: Pune
Posts: 33

Rep: Reputation: 0
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.
 
Old 08-06-2011, 08:06 AM   #2
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643
Quote:
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.
 
1 members found this post helpful.
Old 08-07-2011, 11:39 PM   #3
beparas
Member
 
Registered: Nov 2006
Location: Pune
Posts: 33

Original Poster
Rep: Reputation: 0
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.
 
Old 08-07-2011, 11:43 PM   #4
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643
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
 
1 members found this post helpful.
Old 08-08-2011, 12:21 AM   #5
beparas
Member
 
Registered: Nov 2006
Location: Pune
Posts: 33

Original Poster
Rep: Reputation: 0
Smile [Solved] postgresql error

Quote:
Originally Posted by kbp View Post
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.

Last edited by beparas; 08-08-2011 at 12:24 AM. Reason: spl mistake.
 
Old 08-08-2011, 05:47 AM   #6
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643
Just remove the matching entry from /etc/fstab
 
1 members found this post helpful.
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] PostgreSql error after db dump warrenscorgie Linux - General 1 12-09-2010 09:59 PM
encoding mismatch error in postgresql dinakumar12 Linux - Server 1 07-12-2010 07:20 AM
postgresql jdbc connection error dsids Programming 3 12-29-2006 06:27 AM
PostgreSql Error coolrock Slackware 15 10-02-2006 12:51 AM
PostgreSQL trigger dropping error nazdrowie Programming 3 08-03-2005 12:03 AM


All times are GMT -5. The time now is 05:37 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration