Buenos Dias, estoy teniendo inconvenientes para convertir la Base de datos 2.3.5 a 3.0.0.
Genere el archivo pilaga.dump del ambiente 2.3.5 y lo cargue en el ambiente 3.0.0. con esta sentencia
“postgres@server:~$ psql -U postgres -f /home/pablo-b/Pilaga235_2016.dump”
y por consola me mostro esto
ALTER TABLE
ALTER TABLE
ALTER TABLE
…
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
SET
ALTER TABLE
ALTER TABLE
ALTER TABLE
REVOKE
REVOKE
GRANT
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
a simple vista parece que todo esta bien, luego de esto voy a convertir esta base de datos Pilaga_2016
" psql -U postgres Pilaga_2016 < /home/pablo-b/SIU-Pilaga-3.0.0/sql/conversion/script_3.0.0.sql"
me devuelve:
n block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xed 0x27 0x0d
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xe1 0x6e 0x65
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xed 0x61 0x20
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xed 0x20 0x70
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xf3 0x6e 0x20 0x41
ERROR: invalid byte sequence for encoding “UTF8”: 0xf3 0x6e 0x2e 0x27
ERROR: invalid byte sequence for encoding “UTF8”: 0xfa
ERROR: invalid byte sequence for encoding “UTF8”: 0xe1 0x2e 0x27
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xf3 0x6e 0x20 0x41
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xf3 0x6e 0x27 0x0d
ERROR: invalid byte sequence for encoding “UTF8”: 0xf3 0x6e 0x27 0x0d
ERROR: invalid byte sequence for encoding “UTF8”: 0xf3 0x6e 0x27 0x0d
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xf3 0x6e 0x20 0x25
ERROR: invalid byte sequence for encoding “UTF8”: 0xf3 0x6e 0x20 0x65
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xf1 0x6f 0x73 0x20
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xf1 0x6f 0x20 0x64
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xfa
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xe1 0x20 0x69
ERROR: invalid byte sequence for encoding “UTF8”: 0xf3 0x64 0x75 0x6c
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xe1 0x6d 0x69
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xe1 0x6c 0x69
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xfa
ERROR: invalid byte sequence for encoding “UTF8”: 0xe1 0x6c 0x69
ERROR: invalid byte sequence for encoding “UTF8”: 0xf1 0x6f 0x20 0x64
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xd3 0x4e
ERROR: current transaction is aborted, commands ignored until end of transaction block
ERROR: invalid byte sequence for encoding “UTF8”: 0xd1 0x4f
…
ERROR: current transaction is aborted, commands ignored until end of transaction block
ROLLBACK
Agradeceria que me puedan ayudar
Saludos