Hola Lista
Estoy moviendo una informacion de un servidor a otro, ambos tiene instalado
la versión PostgreSQL 9.5.19, estoy exportando la informacion asi:
/opt/PostgreSQL/9.5/bin/pg_dump -U postgres -F c -f
/mnt/san/offline/phone.3oct2019.backup -j 3 -n phone -n phone_aud -v
callcenter
en la base origen tengo la siguiente tabla:
CREATE TABLE phone.cdr
(
calldate timestamp with time zone NOT NULL DEFAULT now(),
clid character varying(80) NOT NULL DEFAULT ''::character varying,
src character varying(80) NOT NULL DEFAULT ''::character varying,
dst character varying(80) NOT NULL DEFAULT ''::character varying,
dcontext character varying(80) NOT NULL DEFAULT ''::character varying,
channel character varying(80) NOT NULL DEFAULT ''::character varying,
dstchannel character varying(80) NOT NULL DEFAULT ''::character varying,
lastapp character varying(80) NOT NULL DEFAULT ''::character varying,
lastdata character varying(80) NOT NULL DEFAULT ''::character varying,
duration bigint NOT NULL DEFAULT (0)::bigint,
billsec bigint NOT NULL DEFAULT (0)::bigint,
disposition character varying(45) NOT NULL DEFAULT ''::character varying,
amaflags bigint NOT NULL DEFAULT (0)::bigint,
*accountcode character varying(20) NOT NULL DEFAULT ''::character varying*
,
uniqueid character varying(32) NOT NULL DEFAULT ''::character varying,
userfield character varying(255) NOT NULL DEFAULT ''::character varying,
temp_hora timestamp(0) without time zone DEFAULT now(),
id bigint NOT NULL DEFAULT nextval('phone.seq_cdr_ivr'::regclass),
CONSTRAINT cdr_ivr_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
utilizo esta linea para importar el backup que generé, en el servidor
destino en el cual no existe el schema phone:
/opt/PostgreSQL/9.5/bin/pg_restore -U postgres -j 2 -d offline -v
/mnt/san/offline/phone.3oct2019.backup
al cabo de un rato genera el siguiente error:
2019-10-04 13:49:44 -05@[local]@38929: ERROR: *value too long for type
character varying(20)*
2019-10-04 13:49:44 -05@@[local]@38929: CONTEXT: COPY cdr, line 4534809,
column accountcode: "isk/sounds/ivr-vali3.40696"
2019-10-04 13:49:44 -05@[local]@38929: STATEMENT: COPY cdr (calldate,
clid, src, dst, dcontext, channel, dstchannel, lastapp, lastdata, duration,
billsec, disposition, amaflags, accountcode, uniqueid, userfield,
temp_hora, id) FROM stdin;
2019-10-04 13:49:56 -05@[local]@38930: ERROR: canceling statement due to
user request
verifico en el servidor destino la definición de la tabla y es igual que
origen:
CREATE TABLE phone.cdr
(
calldate timestamp with time zone NOT NULL DEFAULT now(),
clid character varying(80) NOT NULL DEFAULT ''::character varying,
src character varying(80) NOT NULL DEFAULT ''::character varying,
dst character varying(80) NOT NULL DEFAULT ''::character varying,
dcontext character varying(80) NOT NULL DEFAULT ''::character varying,
channel character varying(80) NOT NULL DEFAULT ''::character varying,
dstchannel character varying(80) NOT NULL DEFAULT ''::character varying,
lastapp character varying(80) NOT NULL DEFAULT ''::character varying,
lastdata character varying(80) NOT NULL DEFAULT ''::character varying,
duration bigint NOT NULL DEFAULT (0)::bigint,
billsec bigint NOT NULL DEFAULT (0)::bigint,
disposition character varying(45) NOT NULL DEFAULT ''::character varying,
amaflags bigint NOT NULL DEFAULT (0)::bigint,
*accountcode character varying(20) NOT NULL DEFAULT ''::character
varying,*
uniqueid character varying(32) NOT NULL DEFAULT ''::character varying,
userfield character varying(255) NOT NULL DEFAULT ''::character varying,
temp_hora timestamp(0) without time zone DEFAULT now(),
id bigint NOT NULL DEFAULT nextval('phone.seq_cdr_ivr'::regclass)
)
WITH (
OIDS=FALSE
);
No entiendo, hago un dump y restore que cree el schema en el destino, se
supone que en el origen esta almacenado en un campo de tamaño igual!!! y el
mismo crea el schema en le destino!!
Les agradezco su colaboración
--
Cordialmente,
Ing. Hellmuth I. Vargas S.
Esp. Telemática y Negocios por Internet
