You may want to increase your shared_buffer to 25% of your system's available memory.
You really should tile your raster. -bborie On 10/25/2012 02:19 AM, Mahavir Trivedi wrote: > i have 4 GB RAM WINDOWS XP 64-bit > > shared_buffer:512 MB checkpoint_segment 32 > > work_mem;5MB > > i wish to import 540 MB tif image into database postgis 2.0 . without tile . > > i got success test.sql file. but error occured when psql -d dbname -f test.sql > > error : String is 978678801 byte too long for encoding conversion > > pls give any suitable solution > > with thanks > mahavir > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
