I deleted everything under /library/pgsql-xs/ but '<span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; ">service pgsql-xs initdb' failed. Ended up with an initdb.log file that was the same as running 'service postgresql initdb.' When I installed the XS, I checkbox'd pretty much everything that was offered (editors, db, web server, etc.) ... would that make a difference?</span><div>
<font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><br></span></font></div><div><span class="Apple-style-span" style="font-size: 13px; "></span><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">I already checked for inodes usage yesterday. That's not a problem.</span></font></div>
<div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><br></span></font></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">-Ben</span></font></div>
<div><br><div class="gmail_quote">On Wed, Dec 2, 2009 at 2:22 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 Wed, Dec 2, 2009 at 1:42 AM, Ben T <<a href="mailto:benjtran@gmail.com">benjtran@gmail.com</a>> wrote:<br>
> Attempting to start pgsql-xs resulted in it asking me to run initdb for<br>
> postgresql to initialize the cluster (was this supposed to be done<br>
> automatically as part of the installation?). I did that and it said OK.<br>
<br>
</div>Yes, it does it automatically. But there is a bit of confusion - the<br>
'postgresql' service will initdb in a different location to the<br>
'pgsql-xs' service.<br>
<br>
So don't initdb postgresql. Instead, do<br>
<br>
service pgsql-xs initdb<br>
<div class="im"><br>
> It says device out of space<br>
> but I'm sure I have plenty of space.<br>
<br>
</div>Clearly, that's what we have to address.<br>
<div class="im"><br>
> - attempting to execute 'service postgresql initdb' again --> "Data<br>
> directory is not empty!"<br>
> [root@schoolserver ~]# cd /library/pgsql-xs/data-8.3<br>
> [root@schoolserver data-8.3]# ll<br>
> total 2<br>
> drwx------ 2 postgres postgres 1024 2009-11-22 13:43 pg_log<br>
> -rw------- 1 postgres postgres 0 2009-11-22 13:49 pgstartup-8.3.log<br>
<br>
</div>That is not mornal. You should see quite a few more files&dirs in there.<br>
<div class="im"><br>
> copying template1 to postgres ... FATAL: could not write to file<br>
> "base/11511/2689": No space left on device<br>
> STATEMENT: CREATE DATABASE postgres;<br>
> child process exited with exit code 1<br>
> initdb: removing contents of data directory "/library/pgsql-xs/data-8.3"<br>
<br>
</div>that is completely bizarre. How about<br>
<br>
rm -fr /library/pgsql-xs/*<br>
service pgsql-xs initdb<br>
service pgsql-xs start<br>
<br>
does it succeed?<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></div>