[postgis-users] Loading Data / Refreshing every 5 minutes

chris brisendine ki4gyw at gmail.com
Mon May 2 15:40:26 PDT 2011

I am loading NWS Radar data every 5 minutes from two different sites.
What is the most effective way to load them?
right now I'm doing this to load them:

"shp2pgsql -D -a -s 4269 comp.shp compbase05 > compbase05.sql
psql -c "TRUNCATE TABLE compbase05" -d wxgis
psql -d wxgis -f compbase05.sql "

Would I be better to load them into a temp table remove the old table
and copy the temp table to replace the old?
The GIS viewer is missing the radar data sometimes so I'm looking for
the most effective and fastest way to load and refresh the data.


More information about the postgis-users mailing list