Buenas tardes, al correr el SQL me arrojo el siguiente error:
Password for user postgres:
ERROR: could not open extension control file "/usr/share/postgresql/9.4/extension/pgcrypto.control": No such file or directory
ERROR: relation "parametro_instalacion" does not exist
LINE 1: update parametro_instalacion set valor = encrypt(valor::byt...
^
SET
SET
SET
SET
SET
SET
SET
CREATE SCHEMA
ALTER SCHEMA
....
En el 2.sql, el error es:
psql -h 192.168.1.38 -U postgres -W < 2.sql
Password for user postgres:
ERROR: relation "public.version" does not exist
LINE 1: INSERT INTO public.version ("version",descripcion,fechacarga...
^
root@wichi:/opt/pentaho/etl/migraciones_base_datos/610_620# psql -h 192.168.1.38 -U postgres -W -d siu_wichi < 1.sql
Password for user postgres:
CREATE EXTENSION
UPDATE 2
SET
SET
SET
SET
SET
SET
SET
ERROR: schema "querandies" already exists
ALTER SCHEMA
SET
SET
SET
ERROR: relation "d_anio" already exists
ALTER TABLE
ERROR: relation "d_construcciones" already exists
ALTER TABLE
ERROR: relation "d_cumplimiento" already exists
ALTER TABLE
ERROR: relation "d_estado_conservacion" already exists
ALTER TABLE
ERROR: relation "d_estado_construccion" already exists
ALTER TABLE
ERROR: relation "d_inmuebles" already exists
ALTER TABLE
ERROR: relation "d_localidad" already exists
ALTER TABLE
ERROR: relation "d_periodo" already exists
ALTER TABLE
ERROR: relation "d_sino" already exists
ALTER TABLE
ERROR: relation "d_situacion_dominio" already exists
ALTER TABLE
ERROR: relation "d_sub_tipo_uso" already exists
ALTER TABLE
ERROR: relation "d_tipo_construccion" already exists
ALTER TABLE
ERROR: relation "d_tipo_planta" already exists
ALTER TABLE
ERROR: relation "d_tipo_uso" already exists
ALTER TABLE
ERROR: relation "d_ubicacion" already exists
ALTER TABLE
ERROR: relation "d_unidad_academica" already exists
ALTER TABLE
ERROR: relation "d_uso" already exists
ALTER TABLE
ERROR: relation "ft_construcciones_plantas" already exists
ALTER TABLE
ERROR: relation "ft_construcciones_tipo_de_uso" already exists
ALTER TABLE
ERROR: relation "ft_inmuebles" already exists
ALTER TABLE
ERROR: multiple primary keys for table "d_anio" are not allowed
ERROR: multiple primary keys for table "d_cumplimiento" are not allowed
ERROR: multiple primary keys for table "d_periodo" are not allowed
ERROR: multiple primary keys for table "d_localidad" are not allowed
ERROR: multiple primary keys for table "d_unidad_academica" are not allowed
ERROR: multiple primary keys for table "d_construcciones" are not allowed
ERROR: multiple primary keys for table "d_estado_conservacion" are not allowed
ERROR: multiple primary keys for table "d_inmuebles" are not allowed
ERROR: multiple primary keys for table "d_sino" are not allowed
ERROR: multiple primary keys for table "d_situacion_dominio" are not allowed
ERROR: multiple primary keys for table "d_sub_tipo_uso" are not allowed
ERROR: multiple primary keys for table "d_tipo_construccion" are not allowed
ERROR: multiple primary keys for table "d_tipo_planta" are not allowed
ERROR: multiple primary keys for table "d_tipo_uso" are not allowed
ERROR: multiple primary keys for table "d_ubicacion" are not allowed
ERROR: multiple primary keys for table "d_uso" are not allowed
ERROR: multiple primary keys for table "d_estado_construccion" are not allowed
root@wichi:/opt/pentaho/etl/migraciones_base_datos/610_620# psql -h 192.168.1.38 -U postgres -W -d siu_wichi < 2.sql
Password for user postgres:
INSERT 0 1
Más allá de los errores normales por duplicación, pasa algo malo al volver a correrlo o debería instalar todo de nuevo?