Then it's finally done validating and it took about 40 hours.
[local] postgres@sl=# select * from ValidateTopology('topo_ar5_sysdata');
error | id1 | id2
---+-+-
(0 rows)
Time: 145477755.129 ms
Lars
Fra: Sandro Santilli
Hey first copy has a couple of options that you should check.
Secondly find one correct tin as text, and check that you can use
st_geomfromtext on this tin, to be sure it is correct.
Then
create a test file with only the found tin with correct encoding and end of
line.
You should be ok .
Chers
I forgot to include the full version info.
SELECT Postgis_Full_Version();
Old Server:
POSTGIS=1.3.6 GEOS=3.2.2-CAPI-1.6.2 PROJ=Rel. 4.7.1, 23 September
2009 USE_STATS
New Server
POSTGIS=2.1.1 r12113 GEOS=3.4.2-CAPI-1.8.2 r3921 PROJ=Rel. 4.8.0, 6
March 2012 GDAL=GDAL 1.9.2, released 2012/10/08
We are finally able to retire one of our older servers running an old
version of PostGIS and we are migrating everything over to a new install.
One thing that I am noticing is that I am getting different behavior
between the two versions when transforming some values from 4267 to 4326.
The Old
You're going from NAD27 to NAD83. Do you have the nad27 and nad83 datum
files installed in /usr/share/proj?
Rich
On Fri, Jun 5, 2015 at 10:19 AM, David Fawcett david.fawc...@gmail.com
wrote:
I forgot to include the full version info.
SELECT Postgis_Full_Version();
Old Server: