[postgis-users] About Hard Upgrade

[Sandro Santilli]

On Thu, Oct 03, 2013 at 07:34:25AM +0200, Anne Quesnel wrote:
> Dear all,
> About hard upgrade from old to new environment.
> 
> I followed process from this link:
> http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade
> 
> The new environment os is windows 7 "64 bits", pgSQL 9.3 & postgis 2.1.0-2
> 
> 
> The old environment(oracle vm virtual box: 4.1.12r77218, ubuntu 12.04 LTS,
> pg SQL 9.1, postgis 1.5.3.
> 
> 
> 
> I have made two hard upgrades on windows with a file.backup "tar" and a
> file.dump "custom format".
> 
> My both files "error.txt" are empty.
> 
> Knowing that "the geometry_column table" is no longer a table in the new
> postgis version, I' ve got 7 on 8 tables, but it's normal.
> 
> But If we make  comparaison between the remaining tables : I' ve got
> missing values in the "the_geom geometry" attribute  of three tables.
> 
> my database is from a "postgis workshop" and it's called "nyc"
> the tables with missing values are:
> 
> public.nyc_census_blocks
> public.nyc_neighborhoods
> public.queens
> 
> Could you help me for this problem?

Are you missing values or full records ?

  SELECT count(*) from public.nyc_census_blocks;
  SELECT count(*) from public.nyc_census_blocks WHERE the_geom IS NULL;

--strk;