I’ve long had issues with PostgreSQL 8.3 and now 8.4 refusing to start on my laptop which is really a pain for live demonstrations of ERDAS Apollo. I’m not sure if anyone else has similar problems, but I believe (or rather have a hunch) that it is something to do with “ungraceful” shutdowns of the db when you may lose power or consistently go to sleep. Its only ever occured on my laptop, so luckily postgres on a server is still stable as hell.
If you are getting something like the following in postgresql.log on Windows or are just tearing your hair out wondering why the service that was working before is no longer starting …
2009-12-04 09:05:37 WSTLOG: database system is ready to accept connections
FATAL: could not reattach to shared memory (key=240, addr=02690000): 487
2009-12-04 09:05:38 WSTLOG: autovacuum launcher started
2009-12-04 09:05:38 WSTLOG: background writer process (PID 9712) exited with exit code 1
2009-12-04 09:05:38 WSTLOG: terminating any other active server processes
2009-12-04 09:05:38 WSTLOG: all server processes terminated; reinitializing
2009-12-04 09:05:48 WSTFATAL: pre-existing shared memory block is still in use
2009-12-04 09:05:48 WSTHINT: Check if there are any old server processes still running, and terminate them.
To reliably fix things for me anyway,
- Delete postmaster.opts or postmaster.pid (if they exist) in your postgres data dir
- Kill the pg_ctl.exe process (if running)
- Start the postgres service
Success!
Ok. I am kinda pre-empting the fallout of the FOSS4G Benchmarking list here. But for everyone interested, this is a cross post from the Tilecache list where Bruce Foster has, I believe, drawn a very long bow.
This offer also extends to anyone else at Foss4g who may draw similar conclusions for ERDAS not participating in the event. I’m easy to spot in a crowd 
I have never been fond of this mythical Opensource vs Commercial divide in the spatial industry; even when I was exclusively using opensource software. Mapserver is no different from a commercially competitive point of view than ESRI products.
Bruce,
Lets set the record straight here. We were invited, but declined. There is nothing more to it.
I will be at FOSS4G on Thursday and Friday on the CCIP booth. Swing by and I will sit down and show you whatever you seem to think we are hiding?
The FOSS4G benchmarks are a great starting point and I would like to think we can be involved next year. I really hope customers do much more by way of due diligence in selecting enterprise software than just some benchmark results.
Lets not forget that we are not the only ones not competing in the event. Mapguide, Deegree, Mapnik, Cubewerx, Mapinfo, Oracle, Cadcorp, Manifold … the list goes on (notice, there is no delineation between OS vs Commercial here). There is no conspiracy here mate and I’d be happy to show you.
Look forward to seeing you next week.
Regards,
Chris Tweedie
ERDAS Australia
Now, where did that unicorn go and my car with that rocket booster …
Its been a long time between posts lately but there is a lot of things I’d like to report. Thanks to everyone who has reminded me how lazy i have become at every industry event i seem to attend
First up, I have resigned from my position at Landgate starting December 1. Its been a great four years working with all sorts of industry and government personnel around Australia but its time to go. Landgate really is an innovative land information provider so if you are interested in a “bleeding edge” position specialising in spatial web service delivery, the job has now been advertised on Seek.com.au. I’m not aware of anything else in the government sector like this in Australia so get writing as it would be great to know a solid candidate will fill my rather large shoes
It is with no surprise then that i have accepted a new position at ERDAS to be based in Brisbane in the new year. ERDAS’ recent aquisitions and alignment towards strong OGC support has provided sufficent interest for me to join the team to dabble, tweak, prod and spread their internet solutions around Asia/Pacific. Watch this space!
Many will know much of my time over the years has been spent on the SLIP spatial data infrastructure in Western Australia. Its kinda sad to walk away from it, but its at a state now that I am confident the system will continue to grow as demand keeps increasing. Its time to hand over the reigns, so to speak. If you have no idea about the project, please check it out. Its very much a world leading project, not because its a new idea, but because we’ve actually deployed a system across a wide range of sectors. Its with great pleasure to announce then that in the last week we have been awarded both the WA Premiers award and the Asia Pacific Spatial Excellence Award for Spatially Enabled Government which is great to be formally recognised in the community. While I wasn’t successful in the Young Professional category, i’ve still got a few more years to apply before i hit 35 Kudos to my offsider, Patrick Fitzgerald for picking up the Student of the year for two years running
In less exciting news, I am currently transitioning domains (again). It became clear this year that an address like http://chris.narx.net simply caused people to think i was American (a little too often for my liking). The current webmapper.com.au will be updated soon to yet another domain but the move will be transparent but the old address will still redirect automatically. So just to confirm, no I do not do consulting in the US, but thanks for the emails!
It certainly won’t be the end of me and this blog. It appears i might have even more time to write more frequently at ERDAS with would be great. Change is a good thing, and I look forward to see where we end up in the next 12 months
Chris
Jeff Harrison’s mass email caught my eye today with the free trial of CarbonArc. I had the pleasure of taking an early release of CarbonArc for a spin last year and while it was a good start there were a few key things missing from my point of view. Having pushed and prodded Mapinfo 9.5 support for use with our SDI, why not run the new CarbonArc 1.6 through its paces …
From the press release,
CarbonArc PRO 1.6 eliminates barriers to SDI usability through advanced SOA-based discovery, analysis, exploitation, transaction management and security tools for OGC SDI – directly from the ESRI ArcGIS desktop.
Instead of just regurgitating the release, the key question that always gets asked is … doesn’t ESRI ArcGIS already do all this?
Its a tricky question to answer because while on paper i could say, “Yes it does!”, in reality there are just so many annoying quirks and missing features, it quickly becomes a nightmare integrating SDI features into your normal ArcGIS workflow (which is what this is all about, right?). So with fingers crossed, lets dive right in and see what i can find in 5 minutes flat …
The Good
- Well laid out and robust tool set which delivers fully functional WMS/WFS/WFST/WCS capabilities … with no mucking about required!. The thing just works.
- Very easy export to Shapefile tool
- Full featured filter encoding support … no black magic, user has full control
- Full access to the query string for all service types
- Caching of features / images when saving to project files
The Bad
- GML Integration will always be difficult given its a completely new ArcGIS feature source, but its still not up to the average users expectations I dont think. There is no attribute table, the features are independant of pretty much all other ArcGIS functionality so you are really left with GAIA functionality squished into an ArcGIS window.
- Web services request headers are devoid of any accept-encoding headers. I’m still pondering the choice of Expect: 100 requests … but i’m sure there’s a good reason in the depths of HTTP …
- The exclusive tool for CubeWerx “Identity Management Service” seems a bit strange as i’m not aware of any services that use this technology? Shoot me a link if i missed something!
- Lack of support for any WMS LegendGraphics. Users can choose from multiple Styles, but theres no way to actually view legend information which is a bit disappointing
- In the full minute spent trying, i wasnt able to get the WFST support working … i could get as far as the schema but as soon as i’d try to insert a feature the thing would just bail out.
I’m beginning to think the best suggestion would be to somehow merge CarbonArc WFS functionality with an automated export to shape on each filter response. This would allow excellent SDI WFS support, while still giving full ESRI ArcGIS functionality to users without having to reinvent the wheel (for things like the edit system). With the WMS/WCS support pretty solid, i think getting the balance of WFS right could mean the difference between a very promising product and one I would recommend to everyone using our platform.
Thoughts?
So i’ve been a bit late taking a look at the new Mapinfo Professional v9.5. With the consistent dissapointment towards the consumption of OGC standards in commercial apps I wasn’t holding my breath … but wait a sec, it did work and it worked damn well. I mean, it worked flawlessly; updates, inserts, deletes, lock support and it also comes complete with a semi-intelligent conflict manager.
A few more suggestions to improve things further (for anyone listening~) …
- Add HTTP compression handling. Huge performance gains with the transfer of features and its really a no brainer to enable in any http library.
- I am by no means a “Mapinfo Master” ™, but it would be great to enable an automated WFS Table refresh especially if you are retrieving features based on CURRENT_MAPPER. I guess the CTRL+F5 shortcut makes it easy-ish … but i certainly found myself wondering whether i had retrieved the features or not and ended up just sending unnecessary requests.
- If a transaction is successful, give me some kind of alert. Alerting only when it fails does not instill much confidence whether my long edit session went through or not (even after refreshing)
- It would be fantastic to add helpful warning messages when performance drops. I’d imagine most users would skim over the maxfeatures and column / row filters and just add the layer.
If the first request takes 5 minutes and Mapinfo tells me i just retrieved 4000 poly features totalling 10mb and it kindly directed me to the WFS how-to, i’d be more inclined to see what the filtering options were all about
So there’s no WFS1.1 support … but i’m still trying to get my head around handling the axis order issue and are more than happy to let sleeping dogs lie … at least for the moment. I only had time to test against our Geoserver installs, but it certainly seems tested against many other apps including Cadcorp, Ionic & Mapinfo. Geoserver specific here, but the advanced security in 1.6.x works very well with the bundled support for basic authentication.
Finally…
Recent Comments