[postgis-users] PostGIS/PostGres Configuration

[Mike Toews]

Another tool that I've used is ogr2ogr:
http://www.gdal.org/ogr2ogr.html
http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet

This transfers vector data from one database/file/etc to another.
There is a large list of supported database and file formats:
http://www.gdal.org/ogr/ogr_formats.html

It has tricky syntax, so often a few attempts are needed to get it
right. Also, there is an alternative to command-line:
http://www.ogr2gui.ca/

-Mike

On 18 March 2010 11:05, Steffan Chmuryk <schmuryk at icisociety.ca> wrote:
> Back again...
>
> I have attempted to run the shp2pgsql command, without success. So I decided to test some other datasets, and see what happens.
>
> Two polygon datasets, 300mb and 950mb, and one point dataset, 18mb, all loaded successfully. The civic address point dataset of 500mb, still does not load.
>
> Any suggestions?
>
> Also, when will PostGIS be able to load data that is larger than 2gb? And, is there any other intermediate format, other than shapefile, that I should consider using?
>
> Steffan Chmuryk
> Technical Services Coordinator, ICIS
> www.icisociety.ca