[SMS]

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

My postgres database is randomly shutting down. 'var/log/postgresql' gives this:

OG: database system was shut down at 2010-07-12 10:38:47 PDT
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2010-07-14 20:45:46 PDT
LOG: database system is ready to accept connections
LOG: autovacuum launcher started

this is only happening on my SMS64 test box. On server I don't have this problem. Both are configured the same. I am not sure how to debug this, so any pointers to what I should look at would be appreciated. Smile

gerasimos_h · Posted: Thu Jul 15, 2010 7:34 pm Post subject:

I 'll need more info to do some testings myself.
Have you started your installation with

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

I used your script in extras/openbravo. I was not using the db at any time this occurred. It has happened several times yesterday.

gerasimos_h · Posted: Fri Jul 16, 2010 6:33 am Post subject:

I have a machine running 12 hours and nothing happened.
Did it happened to you again?
have you installed an app?

gerasimos_h

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

Has not happened again since last occurrence. I have not installed any apps. Well, I will let it run and we will see what happens. Its on a test box. One thing about SMS64 is that it definitely runs faster.