Re: [GENERAL] Initdb fails on openwrt in "creating template1 database"

2012-01-08 Thread Clemens Eisserer
Hi, > Do you have more than one device mounted and if so are you sure you are > working > on the right one? As often, the problem turned out to be a simple one. With OpenWRT, /var is just a symlink to /tmp - which itself is located on a ramdisk. After moving the data-directory to /postgresql, e

Re: [GENERAL] Initdb fails on openwrt in "creating template1 database"

2011-12-23 Thread Ben Chobot
On Dec 23, 2011, at 1:58 AM, Clemens Eisserer wrote: >>> There are about 800mb free space on /, any idea what could be the problem >>> here? >> >> Could you be running out of file system nodes? > > Don't think so - its a standard ext4 filesystem on a flush drive, > nothing special. > Also I've

Re: [GENERAL] Initdb fails on openwrt in "creating template1 database"

2011-12-23 Thread Tom Lane
Clemens Eisserer writes: > Any idea what could be wrong here? Per-user disk space quota? And I wouldn't be so hasty to dismiss the out-of-inodes theory, either. There are not all that many ways to get an ENOSPC error. regards, tom lane -- Sent via pgsql-general mailing

Re: [GENERAL] Initdb fails on openwrt in "creating template1 database"

2011-12-23 Thread Adrian Klaver
On Friday, December 23, 2011 1:58:38 am Clemens Eisserer wrote: > Hi, > Don't think so - its a standard ext4 filesystem on a flush drive, > nothing special. > Also I've added about 128mb of swap space, so that shouldn't be an issue. > > Just tried the same with a 2GB usb drive and got the same re

Re: [GENERAL] Initdb fails on openwrt in "creating template1 database"

2011-12-23 Thread Clemens Eisserer
Hi, >> There are about 800mb free space on /, any idea what could be the problem >> here? > > Could you be running out of file system nodes? Don't think so - its a standard ext4 filesystem on a flush drive, nothing special. Also I've added about 128mb of swap space, so that shouldn't be an issue

Re: [GENERAL] Initdb fails on openwrt in "creating template1 database"

2011-12-22 Thread Scott Marlowe
On Thu, Dec 22, 2011 at 3:28 PM, Clemens Eisserer wrote: > Hi, > > I try to run postgresql on my mips based openwrt router. > Although openwrt provides precompiled packages, I have troubles > initializing postgresql's file system: > > # creating template1 database in /var/postgresql/data/base/1 ..

[GENERAL] Initdb fails on openwrt in "creating template1 database"

2011-12-22 Thread Clemens Eisserer
Hi, I try to run postgresql on my mips based openwrt router. Although openwrt provides precompiled packages, I have troubles initializing postgresql's file system: # creating template1 database in /var/postgresql/data/base/1 ... FATAL: could not write to file "pg_xlog/xlogtemp.1791": No space le