https://forum.postgresql.org.pl/viewtopic.php?id=1428 Wed, 05 Dec 2012 13:30:17 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=3825#p3825 /home/postgres/zabbix.dump.`date +%Y%m%d`.gz Natomiast próbowałem wgrać za pomocą komendy psql -U zabbix < zabbix.dump.20121203 -L text1.log Problem jest w tym że gdy wykonuje polecenie - na starej bazie -bash-4.1$ psql -U zabbix zabbix -W Password for user zabbix: psql (8.4.13) Type "help" for help. zabbix=> SELECT pg_size_pretty(pg_database_size('zabbix')) As fulldbsize; fulldbsize ------------ 54 GB (1 row) natomiast gdy wykonuję to samo na nowej bazie bash-4.1$ psql -U zabbix zabbix -W Password for user zabbix: psql (9.1.6) Type "help" for help. zabbix=> SELECT pg_size_pretty(pg_database_size('zabbix')) As fulldbsize; fulldbsize ------------ 34 GB (1 row) 20gb to spora rozbieżność. W logach można znaleźć kilka errorów - czy powinienem się nimi przejmować? cat text1.log | grep error error character varying(128) DEFAULT ''::character varying NOT NULL, error character varying(128) DEFAULT ''::character varying NOT NULL, errors_from integer DEFAULT 0 NOT NULL, ipmi_errors_from integer DEFAULT 0 NOT NULL, snmp_errors_from integer DEFAULT 0 NOT NULL, ipmi_error character varying(128) DEFAULT ''::character varying NOT NULL, snmp_error character varying(128) DEFAULT ''::character varying NOT NULL, jmx_errors_from integer DEFAULT 0 NOT NULL, jmx_error character varying(128) DEFAULT ''::character varying NOT NULL, error character varying(128) DEFAULT ''::character varying NOT NULL, error character varying(128) DEFAULT ''::character varying NOT NULL, COPY alerts (alertid, actionid, eventid, userid, clock, mediatypeid, sendto, subject, message, status, retries, error, nextcheck, esc_step, alerttype) FROM stdin; COPY hosts (hostid, proxy_hostid, host, status, disable_until, error, available, errors_from, lastaccess, ipmi_authtype, ipmi_privilege, ipmi_username, ipmi_password, ipmi_disable_until, ipmi_available, snmp_disable_until, snmp_available, maintenanceid, maintenance_status, maintenance_type, maintenance_from, ipmi_errors_from, snmp_errors_from, ipmi_error, snmp_error, jmx_disable_until, jmx_available, jmx_errors_from, jmx_error, name) FROM stdin; COPY items (itemid, type, snmp_community, snmp_oid, hostid, name, key_, delay, history, trends, lastvalue, lastclock, prevvalue, status, value_type, trapper_hosts, units, multiplier, delta, prevorgvalue, snmpv3_securityname, snmpv3_securitylevel, snmpv3_authpassphrase, snmpv3_privpassphrase, formula, error, lastlogsize, logtimefmt, templateid, valuemapid, delay_flex, params, ipmi_sensor, data_type, authtype, username, password, publickey, privatekey, mtime, lastns, flags, filter, interfaceid, port, description, inventory_link, lifetime) FROM stdin; COPY triggers (triggerid, expression, description, url, status, value, priority, lastchange, comments, error, templateid, type, value_flags, flags) FROM stdin; Proszę o pomoc, bo sam nie potrafię zinterpretować tych błędów. Dodam że na pierwszy rzut oka wygląda na to że import się powiódł, zabbix działa poprawnie.]]> Wed, 05 Dec 2012 13:30:17 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=3825#p3825