Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » SMS User Support

Post new topic   Reply to topic
postgres shutting down on its own
View previous topic :: View next topic  
Author Message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Thu Jul 15, 2010 6:59 pm    Post subject: postgres shutting down on its own Reply with quote

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
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Thu Jul 15, 2010 7:34 pm    Post subject: Reply with quote

I 'll need more info to do some testings myself.
Have you started your installation with
Code:
su postgres -c "initdb -D /var/lib/pgsql/data"

Does it happened something with postgres user?
What the machine was doing at times of shutdown, accessing the database?

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Thu Jul 15, 2010 7:50 pm    Post subject: Reply with quote

I used your script in extras/openbravo. I was not using the db at any time this occurred. It has happened several times yesterday.
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Fri Jul 16, 2010 6:33 am    Post subject: Reply with quote

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

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Fri Jul 16, 2010 6:44 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional