Latest LQ Deal: Linux Power User Bundle
Go Back > Forums > Linux Forums > Linux - Networking
User Name
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.


  Search this Thread
Old 10-19-2006, 05:02 PM   #1
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.



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 12:17 AM
LXer: Running Linux for ARM processors under QEMU LXer Syndicated Linux News 0 06-29-2006 02:54 AM
Embedded ARM + debian + sound + wi-fi Jehuty Linux - Hardware 1 05-01-2005 08:43 PM
Embedded SQL -Unable to connect to PostgreSQL database vikram_cvk Linux - Software 1 05-30-2004 06:14 AM
installing and running postgresql or MySql Whatshisface Linux - Software 3 02-22-2004 11:29 PM > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 01:55 PM.

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