[GENERAL] Postgres with daemontools or similar

2008-02-04 Thread Chuck D.
Greetings everyone. I would like to know what the correct position is on the use of Postgres with DJB's daemontools or other monitoring prgrams? I tried to set it up the other day and was successful in getting it to start and log, and even refresh the config files, but I could not get it to sh

Re: [GENERAL] Geographic data sources, queries and questions

2007-10-26 Thread Chuck D.
On May 24, 2007 01:02:42 pm John D. Burger wrote: > Tilmann Singer wrote: > > We are using this data which seems to be fairly extensive and > > accurate, and is free: > > > > http://earth-info.nga.mil/gns/html/gis_countryfiles.htm > > We use that, but it is only non-US, so we combine it with this:

Re: [GENERAL] Geographic data sources, queries and questions

2007-05-27 Thread Chuck D.
On Thursday 24 May 2007 13:02, John D. Burger wrote: > > We also have a hodge-podge of other sources, but those are the main > ones. (By the way, we have found USGS to very amenable to dumping > their data in arbitrary ways. Those state files essentially try to > fit everything into a single CSV

Re: [GENERAL] Geographic data sources, queries and questions

2007-05-23 Thread Chuck D.
On Wednesday 23 May 2007 18:59, you wrote: > > I don't believe this is good design. You'll have to have a trigger or > something to verify that the country_id+state_id on the city table are > exactly equal to the country_id+state_id on the state table. If you > don't, you might have something li

Re: [GENERAL] Geographic data sources, queries and questions

2007-05-23 Thread Chuck D.
which, if you are using a similar database what source did you use for geographic data? I'm having troubles with a reliable set. > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Chuck D. > > Sent: Wednesday, May 23, 2

[GENERAL] Geographic data sources, queries and questions

2007-05-23 Thread Chuck D.
Greetings all, I have a couple issues regarding geographic names databases. 1) The first is this. I have 3 tables. Country, state and city. Country has a country_id to identify a country, state has a state_id and country_id to identify a state, and city has a city_id, state_id and country_id