[pgbr-geral] Upgrade Postgis

2015-04-02 Thread Leandro 
Pessoal, alguem que manja bem de postgis poderia me dar um help ...
 efetuei upgrade do meu postgis da versão 1.5 para 2.1 e conforme
instruções do site do postigs efetuei o hard_upgrade da base ...perl utils/
postgis_restore.pl "/somepath/olddb.backup" | psql -h localhost -p 5432 -U
postgres newdb 2> errors.txt

acontece que me retornou varios erros de funções que não existem... Como
minha base é antiga utilizei tambem o legacy.sql , os erros dimuinuiram mas
ainda sim parece que varias funções não existem ... a ajuda que preciso é
como fazer para não ocorrer esses varios erros de conversão?


Erros:
ERROR:  function box3d_extent_in(cstring) does not exist
ERROR:  function box3d_extent_in(cstring) does not exist
ERROR:  function box3d_extent_in(cstring) does not exist
ERROR:  function box3d_extent_in(cstring) does not exist
ERROR:  function box3d_extent_in(cstring) does not exist
ERROR:  type "box3d_extent" does not exist
ERROR:  type "box3d_extent" does not exist
ERROR:  type "box3d_extent" does not exist
ERROR:  type "box3d_extent" does not exist
ERROR:  type "box3d_extent" does not exist
ERROR:  function chip_in(cstring) does not exist
ERROR:  function chip_in(cstring) does not exist
ERROR:  function chip_in(cstring) does not exist
ERROR:  function chip_in(cstring) does not exist
ERROR:  function chip_in(cstring) does not exist
ERROR:  type "chip" does not exist
ERROR:  type "chip" does not exist
ERROR:  type "chip" does not exist
ERROR:  type "chip" does not exist
ERROR:  type "chip" does not exist
ERROR:  function _st_asgml(integer, geometry, integer, integer) does not
exist
ERROR:  function _st_asgml(integer, geometry, integer, integer) does not
exist
ERROR:  function _st_asgml(integer, geometry, integer, integer) does not
exist
ERROR:  function _st_asgml(integer, geometry, integer, integer) does not
exist
ERROR:  function _st_asgml(integer, geometry, integer, integer) does not
exist
ERROR:  function _st_asgml(integer, geography, integer, integer) does not
exist
ERROR:  function _st_asgml(integer, geography, integer, integer) does not
exist
ERROR:  function _st_asgml(integer, geography, integer, integer) does not
exist
ERROR:  function _st_asgml(integer, geography, integer, integer) does not
exist
ERROR:  function _st_asgml(integer, geography, integer, integer) does not
exist
ERROR:  function _st_askml(integer, geometry, integer) does not exist
ERROR:  function _st_askml(integer, geometry, integer) does not exist
ERROR:  function _st_askml(integer, geometry, integer) does not exist
ERROR:  function _st_askml(integer, geometry, integer) does not exist
ERROR:  function _st_askml(integer, geometry, integer) does not exist
ERROR:  function _st_askml(integer, geography, integer) does not exist
ERROR:  function _st_askml(integer, geography, integer) does not exist
ERROR:  function _st_askml(integer, geography, integer) does not exist
ERROR:  function _st_askml(integer, geography, integer) does not exist
ERROR:  function _st_askml(integer, geography, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
integer, character varying, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
integer, character varying, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
integer, character varying, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
integer, character varying, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
integer, character varying, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
character varying, integer, character varying, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
character varying, integer, character varying, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
character varying, integer, character varying, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
character varying, integer, character varying, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
character varying, integer, character varying, integer) does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
character varying, character varying, integer, character varying, integer)
does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
character varying, character varying, integer, character varying, integer)
does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
character varying, character varying, integer, character varying, integer)
does not exist
ERROR:  function addgeometrycolumn(character varying, character varying,
character varying, character varying, integer, character varying

Re: [pgbr-geral] Upgrade Postgis

2015-04-02 Thread Eloi 

On 2015-04-02 16:43, Leandro wrote:

Pessoal, alguem que manja bem de postgis poderia me dar um help ...
efetuei upgrade do meu postgis da versão 1.5 para 2.1 e conforme
instruções do site do postigs efetuei o hard_upgrade da base ...perl
utils/postgis_restore.pl [1] "/somepath/olddb.backup" | psql -h
localhost -p 5432 -U postgres newdb 2> errors.txt

acontece que me retornou varios erros de funções que não existem...
Como minha base é antiga utilizei tambem o legacy.sql , os erros
dimuinuiram mas ainda sim parece que varias funções não existem ...
a ajuda que preciso é como fazer para não ocorrer esses varios erros
de conversão?


O que eu fiz quando tive de atualizar PostGIS de 1.5 para 2.x, foi:
1. passar a geometria para Well-Known Text (WKT), função ST_AsEWKT()
2. fazer um Dump sem o public schema (todas as minhas tabelas já estavam 
noutro schema)

3. criar uma base de dados com a nova versão de PostGIS
4. fazer o Restore do Dump na nova base
5. recriar a geometria e eliminar o Well-Known Text

Boa sorte.

Cumprimentos,

--
Eloi
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Re: [pgbr-geral] Upgrade Postgis

2015-04-02 Thread Guimarães Faria Corcete DUTRA , Leandro 
2015-04-02 11:43 GMT-03:00 Leandro :
> Pessoal, alguem que manja bem de postgis poderia me dar um help ...

Por favor, se possível, texto simples, não HTML.  Está ruim de ler.


-- 
skype:leandro.gfc.dutra?chat  Yahoo!: ymsgr:sendIM?lgcdutra
+55 (61) 3546 7191  gTalk: xmpp:leand...@jabber.org
+55 (61) 9302 2691ICQ/AIM: aim:GoIM?screenname=61287803
BRAZIL GMT−3  MSN: msnim:chat?contact=lean...@dutra.fastmail.fm
___
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral