Olá,
Vc está dando o restore entre versão distindas do PostGIS? da 1.3.2 pra 1.3.3? algumas funções são alteradas, vc deve rodar antes o arquivo lwpostgis_upgrade.sql. vc deu o dump do bando com -Fc? []'s 2008/8/18 Ribamar Sousa <[EMAIL PROTECTED]> > > > 2008/8/18 Lucas Mocellin <[EMAIL PROTECTED]> > >> isso ja está feito. >> >> pode ver que a primeira notificacao eh que a linguagem "ja esta >> instalada". >> > > Tens razaão. Desculpe, foi a pressa. É isso, ao tentar criar a linguagem > que já está criada dispara o erro. > >> >> >> Em 18/08/08, Ribamar Sousa <[EMAIL PROTECTED]> escreveu: >>> >>> 2008/8/18 Lucas Mocellin <[EMAIL PROTECTED]> >>> >>>> Desculpe mais uma vez, nem olhei a fundo a documentacao. >>>> >>>> dei uma lida e vi o procedimento de atualização, porém agora acontece o >>>> seguinte, eu consigo migrar tudo certinho, as tabelas são criadas >>>> corretamente, porém o script envia algumas mensagens de erro: >>>> >>>> could not access file "$libdir/liblwgeom.dll": No such file or directory >>>> >>>> Porém estou em um linux, no mínimo deveria dar o erro do ".so", estou >>>> migrando de um windows para um linux, será que no banco antigo há algum >>>> "resquício" dessa dll? >>>> >>>> ls -l /usr/lib/postgresql/8.1/lib/liblwgeom.so >>>> lrwxrwxrwx 1 root root 16 2008-08-15 08:51 >>>> /usr/lib/postgresql/8.1/lib/liblwgeom.so -> liblwgeom.so.1.1 >>>> >>>> está ai o modulo. >>>> >>>> entao fiz o seguinte, exportei a variavel "libdir" e criei um link do >>>> .dll para o .so: >>>> ln -s liblwgeom.so.1.1 liblwgeom.dll >>>> >>>> executei e agora os erros nao ocorreram, porém vieram os avisos/erros: >>>> >>>> createlang: language "plpgsql" is already installed in database "web" >>>> NOTICE: type "histogram2d" is not yet defined >>>> DETAIL: Creating a shell type definition. >>>> NOTICE: argument type histogram2d is only a shell >>>> NOTICE: type "spheroid" is not yet defined >>>> DETAIL: Creating a shell type definition. >>>> NOTICE: argument type spheroid is only a shell >>>> NOTICE: type "geometry" is not yet defined >>>> DETAIL: Creating a shell type definition. >>>> NOTICE: argument type geometry is only a shell >>>> NOTICE: return type geometry is only a shell >>>> NOTICE: argument type geometry is only a shell >>>> NOTICE: type "box3d" is not yet defined >>>> DETAIL: Creating a shell type definition. >>>> NOTICE: argument type box3d is only a shell >>>> NOTICE: type "chip" is not yet defined >>>> DETAIL: Creating a shell type definition. >>>> NOTICE: argument type chip is only a shell >>>> NOTICE: type "box2d" is not yet defined >>>> DETAIL: Creating a shell type definition. >>>> NOTICE: argument type box2d is only a shell >>>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>>> "spatial_ref_sys_pkey" for table "spatial_ref_sys" >>>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index >>>> "geometry_columns_pk" for table "geometry_columns" >>>> ERROR: language "plpgsql" already exists >>>> ERROR: function "lockrow" already exists with same argument types >>>> ERROR: function "lockrow" already exists with same argument types >>>> >>>> >>> >>> Erro mesmo, deve ser apenas um. >>> Crie a linguagem antes de iniciar a importação: >>> >>> create language plpgsql; >>> >>> >>> -- >>> Ribamar FS - [EMAIL PROTECTED] >>> http://ribafs.net >>> >>> >>> _______________________________________________ >>> pgbr-geral mailing list >>> [email protected] >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> >>> >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > > -- > Ribamar FS - [EMAIL PROTECTED] > http://ribafs.net > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- Luigi Castro Cardeles
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
