Ok, I think I'm getting closer on this .. found an error message in a log file .. please see below.<div>Attempting to start pgsql-xs resulted in it asking me to run initdb for postgresql to initialize the cluster (was this supposed to be done automatically as part of the installation?). I did that and it said OK. However, looking at the initdb.log file, it ran into an error trying to create the database. With the database not being there, pgsql-xs couldn't start? leading to Moodle not being enabled? It says device out of space but I'm sure I have plenty of space. Any ideas how to take care of this error?</div>
<div><br></div><div>thanks!</div><div>-Ben<br><div><br></div><div><div>[root@schoolserver ~]# service pgsql-xs start</div><div>/library/pgsql-xs/data-8.3 is missing. Use "service postgresql initdb" to initialize the cluster first.<span class="Apple-tab-span" style="white-space:pre"> </span>[FAILED]</div>
<div><br></div><div>[root@schoolserver ~]# service postgresql initdb</div><div>Initializing database: <span class="Apple-tab-span" style="white-space:pre"> </span>[OK]</div><div><br></div><div>[root@schoolserver ~]# service pgsql-xs start</div>
<div>/library/pgsql-xs/data-8.3 is missing. Use "service postgresql initdb" to initialize the cluster first.<span class="Apple-tab-span" style="white-space:pre"> </span>[FAILED]</div><div><br></div><div>[root@schoolserver ~]# shutdown -r now</div>
<div><br></div><div>- same error trying to pgsql-xs</div><div>- attempting to execute 'service postgresql initdb' again --> "Data directory is not empty!"</div><div><br></div><div>[root@schoolserver ~]# cd /library/pgsql-xs/data-8.3</div>
<div>[root@schoolserver data-8.3]# ll</div><div>total 2</div><div>drwx------ 2 postgres postgres 1024 2009-11-22 13:43 pg_log</div><div>-rw------- 1 postgres postgres 0 2009-11-22 13:49 pgstartup-8.3.log</div><div>[root@schoolserver data-8.3]# cd pg_log</div>
<div>[root@schoolserver pg_log]# ll</div><div>total 3</div><div>-rw------- 1 root root 1240 2009-11-22 13:43 initdb.log</div><div><br></div><div>initdb.log</div><div>==========</div><div>The files belonging to this database system will be owned by user "postgres".</div>
<div>This user must also own the server process.</div><div><br></div><div>The database cluster will be initialized with locale C.</div><div>The default database encoding has accordingly been set to SQL_ASCII.</div><div>The default text search configuration will be set to "english".</div>
<div><br></div><div>fixing permissions on existing directory /library/pgsql-xs/data-8.3 ... ok</div><div>creating subdirectories ... ok</div><div>(goes on to perform more tasks and they're all 'ok')</div><div>
copying template1 to template0 ... ok</div><div>copying template1 to postgres ... FATAL: could not write to file "base/11511/2689": No space left on device</div><div>STATEMENT: CREATE DATABASE postgres;</div><div>
<br></div><div>child process exited with exit code 1</div><div>initdb: removing contents of data directory "/library/pgsql-xs/data-8.3"</div></div><div><br></div><div><br></div><div><br><br><div class="gmail_quote">
On Mon, Nov 30, 2009 at 8:15 PM, Ben T <span dir="ltr"><<a href="mailto:benjtran@gmail.com">benjtran@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi Martin,<div><br></div><div>Thanks for checking in .. I took a break from this for a few days .. Will give it another attempt sometime tomorrow and update.</div><div><br></div><div><font color="#888888">-Ben</font><div>
<div></div><div class="h5"><br><br><div class="gmail_quote">On Fri, Nov 27, 2009 at 3:34 AM, Martin Langhoff <span dir="ltr"><<a href="mailto:martin.langhoff@gmail.com" target="_blank">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">On Tue, Nov 24, 2009 at 4:17 PM, Martin Langhoff<br>
<div><<a href="mailto:martin.langhoff@gmail.com" target="_blank">martin.langhoff@gmail.com</a>> wrote:<br>
</div><div>>> drwx------ 3 postgres postgres 1024 2009-11-22 13:49 data-8.3<br>
><br>
> So it exists... and is mounted correctly! What happens if you try to<br>
> start pgsql-xs service? Does it still complain?<br>
><br>
> With this, and your logs looking normal, I can only think of a timing<br>
> thing -- PostgreSQL startup might be slow and Moodle is starting right<br>
> after and not finding it?<br>
<br>
</div>Bump! Did you retry? Is it working?<br>
<div><div></div><div><br>
<br>
<br>
m<br>
--<br>
<a href="mailto:martin.langhoff@gmail.com" target="_blank">martin.langhoff@gmail.com</a><br>
<a href="mailto:martin@laptop.org" target="_blank">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></div></div>
</blockquote></div><br></div></div>