Viewing Running Postgres Queries (and what if they are too long??)

There can be many times when knowing what queries are currently running on a Postgres server can be helpful to know.  It is pretty well known that the system pg_stat_activity table can get you this information.  Just run the following query: SELECT * FROM pg_stat_activity; The resulting record set contains a bunch of information but …

Our Application Server Stack

With a new year coming up I thought I would give a quick run down of our OS server stack.  From the beginning SpatialKey has been built on a number of great community/company open source platforms, here is what we currently use: Apache/Tomcat We are currently evaluating moving our application servers to pure Tomcat vs. …

Running a command line executable in Java with redirected output???

First off there are some awesome new features coming very soon to SpatialKey!  I can’t let the cat completely out of the bag, but by reading this article you may get some idea of what is coming… One of the requirements for SpatialKey that has come up is the necessity to execute a command line …