LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices



Reply
 
Search this Thread
Old 10-19-2006, 06:02 PM   #1
billygotee
LQ Newbie
 
Registered: Nov 2003
Posts: 21

Rep: Reputation: 15
Question Error-triggering on Embedded (ARM) running PostgreSQL


Hi, thanks for reading -- the system in question is unique but the question is probably a generic one, so I'm sure any input at all from someone would be helpful.

I've been developing a PostgreSQL data-logging service which runs on several embedded systems running linux on a compact flash card and connecting to the internet via ppp using a Verizon cellular modem card. Instead of getting the expensive batch of static IPs from Verizon, I'm using DYNDNS to be able to access the SQL database from a central (Windows) server and it works great, until something unexpected happens (like windows crashing while a connection is open) and the inetd (I think) service or something related on the embedded system crashes, making it impossible to pull data from it without going to the site and rebooting the system. This is not to say that linux itself crashes -- in fact, I can still ping it through its dyndns address, but the connection will be refused for any ssh, psql, etc. service.

There are a couple of things I'd like to implement that would solve this problem for me in a big way:

1.) Automatically reboot when it isn't working. I could probably get crond to automatically reboot it once a night fairly easily, but it'd be even better if I could get this to happen as soon as an issue presents itself. Something along the lines of detecting when the last time a PSQL connection was made and rebooting when that has been longer than the normal interval.

2.) NOT Linux related, but maybe someone can direct me toward something helpful. It could be useful to have a low-hardware, fool-proof UPS. . .thingy which automatically shuts the power off once a night for a second and turns itself back on. This is in case linux itself actually crashes (I know, when does that ever happen) and can't reboot itself.

Thanks in advance! The real meat of what I need is the first part there.

-Brandon
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to check whether Postgresql is running? coolrock Slackware 6 10-03-2006 01:17 AM
LXer: Running Linux for ARM processors under QEMU LXer Syndicated Linux News 0 06-29-2006 03:54 AM
Embedded ARM + debian + sound + wi-fi Jehuty Linux - Hardware 1 05-01-2005 09:43 PM
Embedded SQL -Unable to connect to PostgreSQL database vikram_cvk Linux - Software 1 05-30-2004 07:14 AM
installing and running postgresql or MySql Whatshisface Linux - Software 3 02-23-2004 12:29 AM


All times are GMT -5. The time now is 10:20 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration