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

[chris brisendine]

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.

Thanks,
Chris