[postgis-users] more effective way?

chris brisendine ki4gyw at gmail.com
Sun Jun 3 07:02:32 PDT 2012


I have a postgis table that contains radar. My problem is every 3
minutes I update the radar table and sometimes the end user has no
radar showing due to the new data loading
is there a more effective way than doing it like I am with the following code,

shp2pgsql -D -a -s 4269 last.shp base05 > base05.sql
psql -c "TRUNCATE TABLE base05" -d wxserver
psql -d wxserver -f base05.sql

I was dropping the table but that would cause my wms server to freakout.



More information about the postgis-users mailing list