<div class="gmail_quote">So tonight I installed the XS 0.6 all over again but this time I didn't checkbox anything. The end result was the exact same thing. Moodle is disabled. Please see results inline. Thanks!</div>
<div class="gmail_quote"><br></div><div class="gmail_quote"><div class="gmail_quote">[root@schoolserver ~]# service pgsql-xs initdb</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>[FAILED]</div>
<div class="gmail_quote"><br></div><div class="gmail_quote">[root@schoolserver ~]# cat /library/pgsql-xs/data-8.3/pg_log/initdb.log</div><div class="gmail_quote">initdb: directory "/library/pgsql-xs/data-8.3" exists but is not empty</div>
<div class="gmail_quote">If you want to create a new database system, either remove or empty</div><div class="gmail_quote">the directory "/library/pgsql-xs/data-8.3" or run initdb</div><div class="gmail_quote">with an argument other than "/library/pgsql-xs/data-8.3".</div>
<div class="gmail_quote">The files belonging to this database system will be owned by user "postgres".</div><div class="gmail_quote">This user must also own the server process.</div><div class="gmail_quote"><br>
</div><div class="gmail_quote">The database cluster will be initialized with locale en_US.UTF-8.</div><div class="gmail_quote">The default database encoding has accordingly been set to UTF8.</div><div class="gmail_quote">
The default text search configuration will be set to "english".</div><div class="gmail_quote"><br></div><div class="gmail_quote">[root@schoolserver ~]# rm -rf /library/pgsql-xs/data-8.3/*</div><div class="gmail_quote">
<br></div><div class="gmail_quote">[root@schoolserver ~]# service pgsql-xs initdb</div><div class="gmail_quote"><span class="Apple-tab-span" style="white-space:pre"> </span>[FAILED]</div><div class="gmail_quote">[root@schoolserver ~]# cat /library/pgsql-xs/data-8.3/pg_log/initdb.log</div>
<div class="gmail_quote">(same as previously)</div><div class="gmail_quote">copying template1 to template0 ... ok</div><div class="gmail_quote">copying template1 to postgres ... FATAL: could not write to file "base/11511/2838": No space left on device</div>
<div class="gmail_quote">STATEMENT: CREATE DATABASE postgres;</div><div class="gmail_quote"><br></div><div class="gmail_quote">child process exited with exit code 1</div><div class="gmail_quote">initdb: removing contents of data directory "/library/pgsql-xs/data-8.3"</div>
</div><div class="gmail_quote"><br></div><div class="gmail_quote">On Thu, Dec 3, 2009 at 4:20 AM, Martin Langhoff <span dir="ltr"><<a href="mailto:martin.langhoff@gmail.com">martin.langhoff@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Thu, Dec 3, 2009 at 1:15 AM, Ben T <<a href="mailto:benjtran@gmail.com">benjtran@gmail.com</a>> wrote:<br>
> I deleted everything under /library/pgsql-xs/ but 'service pgsql-xs initdb'<br>
> failed. Ended up with an initdb.log file that was the same as running<br>
> 'service postgresql initdb.'<br>
<br>
</div>That is completely bizarre. I assume that /library/pgsql-xs exists,<br>
and that you can create files there normally if you su to 'postgres',<br>
even large files.<br>
<div class="im"><br>
> I already checked for inodes usage yesterday. That's not a problem.<br>
<br>
</div>Thanks.<br>
<div class="im"><br>
> When I installed the XS, I checkbox'd pretty<br>
> much everything that was offered (editors, db, web server, etc.) ... would<br>
> that make a difference?<br>
<br>
</div>That may have confused the installer -- all those things are not on<br>
the CD -- but it seems like you got your XS installed -- to<br>
confirm:are xs-pkgs and xs-config reported as installed by rpm?<br></blockquote><div><br></div><div>[root@schoolserver ~]# rpm -qi xs-pkgs</div><div>Name<span class="Apple-tab-span" style="white-space:pre"> </span>: xs-pkgs</div>
<div>Version<span class="Apple-tab-span" style="white-space:pre"> </span>: 0.10.1.g2a97d89</div><div>Release<span class="Apple-tab-span" style="white-space:pre"> </span>: 1</div><div>(...and a lot more info)</div><div><br>
</div><div>[root@schoolserver ~]# rpm -qi xs-config</div><div>Name<span class="Apple-tab-span" style="white-space:pre"> </span>: xs-config</div><div>Version<span class="Apple-tab-span" style="white-space:pre"> </span>: 0.6.0.16.g3c1e949</div>
<div>Release<span class="Apple-tab-span" style="white-space:pre"> </span>: 1</div><div>(...and a lot more info)</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
Further debugging steps...<br>
<br>
- Is selinux enabled perhaps?<br>
selinuxenabled && echo I am SELinux, son of HAL, you cannot open<br>
the pod bay doors or start Pg...<br></blockquote><div><br></div><div><div>[root@schoolserver ~]# cat /etc/sysconfig/selinux</div><div>SELINUX=disabled</div><div>SELINUXTYPE=targeted</div></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
- Re-run initdb, looking at what it does:<br>
<div class="im"> rm -fr /library/pgsql-xs<br>
</div> ( bash -x /etc/init.d/pgsql-xs initdb 2>&1 ) | tee initdb.log<br></blockquote><div><br></div><div><div>[root@schoolserver ~]# rm -rf /library/pgsql-xs</div><div>[root@schoolserver ~]# ( bash -x /etc/init.d/pgsql-xs initdb 2>&1 ) | tee initdb.log</div>
<div>(it ended with the following:)</div><div>......</div><div>[+ '[' color = color ']'</div><div>+ echo -en '\033[0;31m'</div><div>+ echo -n FAILED</div><div>FAILED+ '[' color = color ']'</div>
<div>+ echo -en '\033[0;39m'</div><div>+ echo -n ']'</div><div>]+ echo -ne '\r'</div><div>+ return 1</div><div>+ script_result=1</div><div>+ exit 1</div></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
</blockquote><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
- Run the init under strace - install strace and then change the line<br>
that actually starts Pg to run it under strace. It will get logged to<br>
the same pgstartup.log we are getting now. Look for the line that<br>
talks about<br>
<br>
$SU -l postgres -c "$PGENGINE/postmarter -p ...<br>
<br>
and add in there strace, like:<br>
<br>
$SU -l postgres -c "/usr/bin/strace $PGENGINE/postmarter -p ...<br>
<br>
and then try to do /etc/init.d/pgsql-xs start<br></blockquote><div><br></div><div>I'm not familiar with network settings so my XS running on a virtual machine doesn't seem to be connected to the internet for 'yum install strace' to work. And I don't know how to transfer the strace tar file even if I have it downloaded on the host machine where the vm is running. When you said "look for the line that talks about..." ... which file were you referring to?</div>
<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
I am rather curious as to what the problem is and would like to find<br>
the root cause. If it's all too much, and you'd rather reinstall and<br>
see if it's better, it's also a valid approach.<br></blockquote><div><br></div><div>Unfortunately, the reinstall didn't help =(</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
cheers,<br>
<div><div></div><div class="h5"><br>
<br>
m<br>
--<br>
<a href="mailto:martin.langhoff@gmail.com">martin.langhoff@gmail.com</a><br>
<a href="mailto:martin@laptop.org">martin@laptop.org</a> -- School Server Architect<br>
- ask interesting questions<br>
- don't get distracted with shiny stuff - working code first<br>
- <a href="http://wiki.laptop.org/go/User:Martinlanghoff" target="_blank">http://wiki.laptop.org/go/User:Martinlanghoff</a><br>
</div></div></blockquote></div><br>