- lms - lists.lms.org.pl

migracja mysql to postres
by Marcin 19 Maj '13

19 Maj '13

Witam chcę sobie przetestować migrację z mysql do tak zachwalanego posgresa. do konwersji mysql -> posgres używam zalecanego https://github.com/philipsoutham/py-mysql2pgsql ale niestety mam problemy a to z konwersją albo ze wrzuceniem danych do bazy. Jak to powinienem prawidłowo zrobić by bez problemu zadziałało? czy dane przerzucić z mysql bezpośrednio do posgresa? - w tym przypadku też są problemy. oto scenariusz zrzucania tylko danych. Jako backum mam z Dira, to też na tej wersji robię migrację. 1. robię strukturę bazy #v+ postgres@pgsql:~$ psql -d lms -U lms -f /var/www/lms/doc/lms.pgsql psql:/var/www/lms/doc/lms.pgsql:6: ERROR: sequence "users_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:8: ERROR: table "users" does not exist psql:/var/www/lms/doc/lms.pgsql:27: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users" psql:/var/www/lms/doc/lms.pgsql:27: NOTICE: CREATE TABLE / UNIQUE will create implicit index "users_login_key" for table "users" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:32: ERROR: sequence "customers_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:34: ERROR: table "customers" does not exist psql:/var/www/lms/doc/lms.pgsql:74: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customers_pkey" for table "customers" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:82: ERROR: sequence "numberplans_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:84: ERROR: table "numberplans" does not exist psql:/var/www/lms/doc/lms.pgsql:92: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "numberplans_pkey" for table "numberplans" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:97: ERROR: sequence "assignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:99: ERROR: table "assignments" does not exist psql:/var/www/lms/doc/lms.pgsql:118: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "assignments_pkey" for table "assignments" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:126: ERROR: sequence "cash_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:128: ERROR: table "cash" does not exist psql:/var/www/lms/doc/lms.pgsql:143: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cash_pkey" for table "cash" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:153: ERROR: sequence "networks_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:155: ERROR: table "networks" does not exist psql:/var/www/lms/doc/lms.pgsql:174: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "networks_pkey" for table "networks" psql:/var/www/lms/doc/lms.pgsql:174: NOTICE: CREATE TABLE / UNIQUE will create implicit index "networks_name_key" for table "networks" psql:/var/www/lms/doc/lms.pgsql:174: NOTICE: CREATE TABLE / UNIQUE will create implicit index "networks_address_key" for table "networks" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:179: ERROR: sequence "nodes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:181: ERROR: table "nodes" does not exist psql:/var/www/lms/doc/lms.pgsql:209: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nodes_pkey" for table "nodes" psql:/var/www/lms/doc/lms.pgsql:209: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nodes_name_key" for table "nodes" psql:/var/www/lms/doc/lms.pgsql:209: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nodes_ipaddr_key" for table "nodes" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:217: ERROR: sequence "macs_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:219: ERROR: table "macs" does not exist psql:/var/www/lms/doc/lms.pgsql:227: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "macs_pkey" for table "macs" psql:/var/www/lms/doc/lms.pgsql:227: NOTICE: CREATE TABLE / UNIQUE will create implicit index "macs_mac_key" for table "macs" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:232: ERROR: sequence "nodegroups_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:234: ERROR: table "nodegroups" does not exist psql:/var/www/lms/doc/lms.pgsql:242: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nodegroups_pkey" for table "nodegroups" psql:/var/www/lms/doc/lms.pgsql:242: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nodegroups_name_key" for table "nodegroups" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:247: ERROR: sequence "nodegroupassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:249: ERROR: table "nodegroupassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:256: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nodegroupassignments_pkey" for table "nodegroupassignments" psql:/var/www/lms/doc/lms.pgsql:256: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nodegroupassignments_nodeid_key" for table "nodegroupassignments" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:261: ERROR: sequence "nodeassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:263: ERROR: table "nodeassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:272: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nodeassignments_pkey" for table "nodeassignments" psql:/var/www/lms/doc/lms.pgsql:272: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nodeassignments_nodeid_key" for table "nodeassignments" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:279: ERROR: sequence "tariffs_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:281: ERROR: table "tariffs" does not exist psql:/var/www/lms/doc/lms.pgsql:318: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "tariffs_pkey" for table "tariffs" psql:/var/www/lms/doc/lms.pgsql:318: NOTICE: CREATE TABLE / UNIQUE will create implicit index "tariffs_name_key" for table "tariffs" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:324: ERROR: sequence "promotions_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:334: ERROR: syntax error at or near "CREATE" LINE 2: CREATE TABLE promotions ( ^ psql:/var/www/lms/doc/lms.pgsql:339: ERROR: sequence "promotionschemas_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:341: ERROR: table "promotionschemas" does not exist psql:/var/www/lms/doc/lms.pgsql:355: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "promotionschemas_pkey" for table "promotionschemas" psql:/var/www/lms/doc/lms.pgsql:355: NOTICE: CREATE TABLE / UNIQUE will create implicit index "promotionschemas_promotionid_key" for table "promotionschemas" psql:/var/www/lms/doc/lms.pgsql:355: ERROR: relation "promotions" does not exist psql:/var/www/lms/doc/lms.pgsql:356: ERROR: relation "promotionschemas" does not exist psql:/var/www/lms/doc/lms.pgsql:361: ERROR: sequence "promotionassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:363: ERROR: table "promotionassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:373: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "promotionassignments_pkey" for table "promotionassignments" psql:/var/www/lms/doc/lms.pgsql:373: NOTICE: CREATE TABLE / UNIQUE will create implicit index "promotionassignments_promotionschemaid_key" for table "promotionassignments" psql:/var/www/lms/doc/lms.pgsql:373: ERROR: relation "promotionschemas" does not exist psql:/var/www/lms/doc/lms.pgsql:374: ERROR: relation "promotionassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:379: ERROR: sequence "liabilities_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:381: ERROR: table "liabilities" does not exist psql:/var/www/lms/doc/lms.pgsql:389: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "liabilities_pkey" for table "liabilities" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:394: ERROR: sequence "payments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:396: ERROR: table "payments" does not exist psql:/var/www/lms/doc/lms.pgsql:406: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "payments_pkey" for table "payments" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:411: ERROR: sequence "taxes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:413: ERROR: table "taxes" does not exist psql:/var/www/lms/doc/lms.pgsql:422: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "taxes_pkey" for table "taxes" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:427: ERROR: sequence "documents_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:429: ERROR: table "documents" does not exist psql:/var/www/lms/doc/lms.pgsql:454: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "documents_pkey" for table "documents" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:463: ERROR: table "documentcontents" does not exist psql:/var/www/lms/doc/lms.pgsql:474: NOTICE: CREATE TABLE / UNIQUE will create implicit index "documentcontents_docid_key" for table "documentcontents" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:483: ERROR: table "receiptcontents" does not exist CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:497: ERROR: table "invoicecontents" does not exist CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:515: ERROR: table "debitnotecontents" does not exist psql:/var/www/lms/doc/lms.pgsql:516: ERROR: sequence "debitnotecontents_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:526: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "debitnotecontents_pkey" for table "debitnotecontents" psql:/var/www/lms/doc/lms.pgsql:526: NOTICE: CREATE TABLE / UNIQUE will create implicit index "debitnotecontents_docid_key" for table "debitnotecontents" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:530: ERROR: sequence "numberplanassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:532: ERROR: table "numberplanassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:539: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "numberplanassignments_pkey" for table "numberplanassignments" psql:/var/www/lms/doc/lms.pgsql:539: NOTICE: CREATE TABLE / UNIQUE will create implicit index "numberplanassignments_planid_key" for table "numberplanassignments" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:545: ERROR: sequence "customergroups_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:547: ERROR: table "customergroups" does not exist psql:/var/www/lms/doc/lms.pgsql:554: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customergroups_pkey" for table "customergroups" psql:/var/www/lms/doc/lms.pgsql:554: NOTICE: CREATE TABLE / UNIQUE will create implicit index "customergroups_name_key" for table "customergroups" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:559: ERROR: sequence "customerassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:561: ERROR: table "customerassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:570: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customerassignments_pkey" for table "customerassignments" psql:/var/www/lms/doc/lms.pgsql:570: NOTICE: CREATE TABLE / UNIQUE will create implicit index "customerassignments_customergroupid_key" for table "customerassignments" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:577: ERROR: table "stats" does not exist psql:/var/www/lms/doc/lms.pgsql:584: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "stats_pkey" for table "stats" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:590: ERROR: sequence "netlinks_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:592: ERROR: table "netlinks" does not exist psql:/var/www/lms/doc/lms.pgsql:602: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "netlinks_pkey" for table "netlinks" psql:/var/www/lms/doc/lms.pgsql:602: NOTICE: CREATE TABLE / UNIQUE will create implicit index "netlinks_src_key" for table "netlinks" CREATE TABLE CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION psql:/var/www/lms/doc/lms.pgsql:639: ERROR: table "rtattachments" does not exist psql:/var/www/lms/doc/lms.pgsql:645: ERROR: relation "rtmessages" does not exist psql:/var/www/lms/doc/lms.pgsql:647: ERROR: relation "rtattachments" does not exist psql:/var/www/lms/doc/lms.pgsql:649: ERROR: sequence "rtqueues_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:651: ERROR: table "rtqueues" does not exist psql:/var/www/lms/doc/lms.pgsql:659: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rtqueues_pkey" for table "rtqueues" psql:/var/www/lms/doc/lms.pgsql:659: NOTICE: CREATE TABLE / UNIQUE will create implicit index "rtqueues_name_key" for table "rtqueues" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:661: ERROR: sequence "rttickets_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:663: ERROR: table "rttickets" does not exist psql:/var/www/lms/doc/lms.pgsql:678: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rttickets_pkey" for table "rttickets" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:685: ERROR: sequence "rtmessages_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:687: ERROR: table "rtmessages" does not exist psql:/var/www/lms/doc/lms.pgsql:703: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rtmessages_pkey" for table "rtmessages" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:707: ERROR: sequence "rtnotes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:709: ERROR: table "rtnotes" does not exist psql:/var/www/lms/doc/lms.pgsql:719: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rtnotes_pkey" for table "rtnotes" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:724: ERROR: sequence "rtrights_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:726: ERROR: table "rtrights" does not exist psql:/var/www/lms/doc/lms.pgsql:736: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rtrights_pkey" for table "rtrights" psql:/var/www/lms/doc/lms.pgsql:736: NOTICE: CREATE TABLE / UNIQUE will create implicit index "rtrights_userid_key" for table "rtrights" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:741: ERROR: sequence "passwd_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:743: ERROR: table "passwd" does not exist psql:/var/www/lms/doc/lms.pgsql:767: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "passwd_pkey" for table "passwd" psql:/var/www/lms/doc/lms.pgsql:767: NOTICE: CREATE TABLE / UNIQUE will create implicit index "passwd_login_key" for table "passwd" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:773: ERROR: sequence "domains_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:775: ERROR: table "domains" does not exist psql:/var/www/lms/doc/lms.pgsql:788: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "domains_pkey" for table "domains" psql:/var/www/lms/doc/lms.pgsql:788: NOTICE: CREATE TABLE / UNIQUE will create implicit index "domains_name_key" for table "domains" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:794: ERROR: sequence "records_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:796: ERROR: table "records" does not exist psql:/var/www/lms/doc/lms.pgsql:808: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "records_pkey" for table "records" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:816: ERROR: sequence "supermasters_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:818: ERROR: table "supermasters" does not exist psql:/var/www/lms/doc/lms.pgsql:825: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "supermasters_pkey" for table "supermasters" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:830: ERROR: sequence "aliases_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:832: ERROR: table "aliases" does not exist psql:/var/www/lms/doc/lms.pgsql:839: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "aliases_pkey" for table "aliases" psql:/var/www/lms/doc/lms.pgsql:839: NOTICE: CREATE TABLE / UNIQUE will create implicit index "aliases_login_key" for table "aliases" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:844: ERROR: sequence "aliasassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:846: ERROR: table "aliasassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:854: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "aliasassignments_pkey" for table "aliasassignments" psql:/var/www/lms/doc/lms.pgsql:854: NOTICE: CREATE TABLE / UNIQUE will create implicit index "aliasassignments_aliasid_key" for table "aliasassignments" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:859: ERROR: sequence "uiconfig_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:861: ERROR: table "uiconfig" does not exist psql:/var/www/lms/doc/lms.pgsql:871: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "uiconfig_pkey" for table "uiconfig" psql:/var/www/lms/doc/lms.pgsql:871: NOTICE: CREATE TABLE / UNIQUE will create implicit index "uiconfig_section_key" for table "uiconfig" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:876: ERROR: sequence "events_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:878: ERROR: table "events" does not exist psql:/var/www/lms/doc/lms.pgsql:892: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "events_pkey" for table "events" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:898: ERROR: table "eventassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:903: NOTICE: CREATE TABLE / UNIQUE will create implicit index "eventassignments_eventid_key" for table "eventassignments" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:908: ERROR: table "sessions" does not exist psql:/var/www/lms/doc/lms.pgsql:917: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sessions_pkey" for table "sessions" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:922: ERROR: sequence "cashsources_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:924: ERROR: table "cashsources" does not exist psql:/var/www/lms/doc/lms.pgsql:931: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cashsources_pkey" for table "cashsources" psql:/var/www/lms/doc/lms.pgsql:931: NOTICE: CREATE TABLE / UNIQUE will create implicit index "cashsources_name_key" for table "cashsources" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:936: ERROR: sequence "sourcefiles_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:938: ERROR: table "sourcefiles" does not exist psql:/var/www/lms/doc/lms.pgsql:947: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sourcefiles_pkey" for table "sourcefiles" psql:/var/www/lms/doc/lms.pgsql:947: NOTICE: CREATE TABLE / UNIQUE will create implicit index "sourcefiles_idate_key" for table "sourcefiles" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:954: ERROR: sequence "cashimport_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:956: ERROR: table "cashimport" does not exist psql:/var/www/lms/doc/lms.pgsql:972: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cashimport_pkey" for table "cashimport" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:982: ERROR: sequence "hosts_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:984: ERROR: table "hosts" does not exist psql:/var/www/lms/doc/lms.pgsql:993: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "hosts_pkey" for table "hosts" psql:/var/www/lms/doc/lms.pgsql:993: NOTICE: CREATE TABLE / UNIQUE will create implicit index "hosts_name_key" for table "hosts" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:998: ERROR: sequence "daemoninstances_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1000: ERROR: table "daemoninstances" does not exist psql:/var/www/lms/doc/lms.pgsql:1011: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "daemoninstances_pkey" for table "daemoninstances" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1016: ERROR: sequence "daemonconfig_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1018: ERROR: table "daemonconfig" does not exist psql:/var/www/lms/doc/lms.pgsql:1028: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "daemonconfig_pkey" for table "daemonconfig" psql:/var/www/lms/doc/lms.pgsql:1028: NOTICE: CREATE TABLE / UNIQUE will create implicit index "daemonconfig_instanceid_key" for table "daemonconfig" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1033: ERROR: sequence "docrights_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1035: ERROR: table "docrights" does not exist psql:/var/www/lms/doc/lms.pgsql:1043: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docrights_pkey" for table "docrights" psql:/var/www/lms/doc/lms.pgsql:1043: NOTICE: CREATE TABLE / UNIQUE will create implicit index "docrights_userid_key" for table "docrights" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1048: ERROR: sequence "cashrights_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1050: ERROR: table "cashrights" does not exist psql:/var/www/lms/doc/lms.pgsql:1058: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cashrights_pkey" for table "cashrights" psql:/var/www/lms/doc/lms.pgsql:1058: NOTICE: CREATE TABLE / UNIQUE will create implicit index "cashrights_userid_key" for table "cashrights" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1063: ERROR: sequence "cashregs_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1065: ERROR: table "cashregs" does not exist psql:/var/www/lms/doc/lms.pgsql:1075: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cashregs_pkey" for table "cashregs" psql:/var/www/lms/doc/lms.pgsql:1075: NOTICE: CREATE TABLE / UNIQUE will create implicit index "cashregs_name_key" for table "cashregs" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1080: ERROR: sequence "cashreglog_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1082: ERROR: table "cashreglog" does not exist psql:/var/www/lms/doc/lms.pgsql:1093: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cashreglog_pkey" for table "cashreglog" psql:/var/www/lms/doc/lms.pgsql:1093: NOTICE: CREATE TABLE / UNIQUE will create implicit index "cashreglog_regid_key" for table "cashreglog" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1098: ERROR: sequence "ewx_pt_config_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1100: ERROR: table "ewx_pt_config" does not exist psql:/var/www/lms/doc/lms.pgsql:1110: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ewx_pt_config_pkey" for table "ewx_pt_config" psql:/var/www/lms/doc/lms.pgsql:1110: NOTICE: CREATE TABLE / UNIQUE will create implicit index "ewx_pt_config_nodeid_key" for table "ewx_pt_config" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1115: ERROR: sequence "ewx_stm_nodes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1117: ERROR: table "ewx_stm_nodes" does not exist psql:/var/www/lms/doc/lms.pgsql:1131: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ewx_stm_nodes_pkey" for table "ewx_stm_nodes" psql:/var/www/lms/doc/lms.pgsql:1131: NOTICE: CREATE TABLE / UNIQUE will create implicit index "ewx_stm_nodes_nodeid_key" for table "ewx_stm_nodes" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1136: ERROR: sequence "ewx_stm_channels_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1138: ERROR: table "ewx_stm_channels" does not exist psql:/var/www/lms/doc/lms.pgsql:1146: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ewx_stm_channels_pkey" for table "ewx_stm_channels" psql:/var/www/lms/doc/lms.pgsql:1146: NOTICE: CREATE TABLE / UNIQUE will create implicit index "ewx_stm_channels_cid_key" for table "ewx_stm_channels" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1151: ERROR: sequence "ewx_channels_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1153: ERROR: table "ewx_channels" does not exist psql:/var/www/lms/doc/lms.pgsql:1163: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ewx_channels_pkey" for table "ewx_channels" psql:/var/www/lms/doc/lms.pgsql:1163: NOTICE: CREATE TABLE / UNIQUE will create implicit index "ewx_channels_name_key" for table "ewx_channels" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1168: ERROR: sequence "netdevices_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1170: ERROR: table "netdevices" does not exist psql:/var/www/lms/doc/lms.pgsql:1190: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "netdevices_pkey" for table "netdevices" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1197: ERROR: table "dbinfo" does not exist psql:/var/www/lms/doc/lms.pgsql:1202: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dbinfo_pkey" for table "dbinfo" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1207: ERROR: sequence "imessengers_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1209: ERROR: table "imessengers" does not exist psql:/var/www/lms/doc/lms.pgsql:1217: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "imessengers_pkey" for table "imessengers" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1223: ERROR: sequence "customercontacts_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1225: ERROR: table "customercontacts" does not exist psql:/var/www/lms/doc/lms.pgsql:1234: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customercontacts_pkey" for table "customercontacts" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1241: ERROR: sequence "excludedgroups_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1243: ERROR: table "excludedgroups" does not exist psql:/var/www/lms/doc/lms.pgsql:1251: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "excludedgroups_pkey" for table "excludedgroups" psql:/var/www/lms/doc/lms.pgsql:1251: NOTICE: CREATE TABLE / UNIQUE will create implicit index "excludedgroups_userid_key" for table "excludedgroups" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1257: ERROR: sequence "states_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1259: ERROR: table "states" does not exist psql:/var/www/lms/doc/lms.pgsql:1266: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "states_pkey" for table "states" psql:/var/www/lms/doc/lms.pgsql:1266: NOTICE: CREATE TABLE / UNIQUE will create implicit index "states_name_key" for table "states" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1271: ERROR: sequence "countries_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1273: ERROR: table "countries" does not exist psql:/var/www/lms/doc/lms.pgsql:1279: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "countries_pkey" for table "countries" psql:/var/www/lms/doc/lms.pgsql:1279: NOTICE: CREATE TABLE / UNIQUE will create implicit index "countries_name_key" for table "countries" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1284: ERROR: sequence "zipcodes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1286: ERROR: table "zipcodes" does not exist psql:/var/www/lms/doc/lms.pgsql:1293: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "zipcodes_pkey" for table "zipcodes" psql:/var/www/lms/doc/lms.pgsql:1293: NOTICE: CREATE TABLE / UNIQUE will create implicit index "zipcodes_zip_key" for table "zipcodes" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1299: ERROR: sequence "divisions_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1301: ERROR: table "divisions" does not exist psql:/var/www/lms/doc/lms.pgsql:1323: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "divisions_pkey" for table "divisions" psql:/var/www/lms/doc/lms.pgsql:1323: NOTICE: CREATE TABLE / UNIQUE will create implicit index "divisions_shortname_key" for table "divisions" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1328: ERROR: sequence "voipaccounts_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1330: ERROR: table "voipaccounts" does not exist psql:/var/www/lms/doc/lms.pgsql:1342: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "voipaccounts_pkey" for table "voipaccounts" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1347: ERROR: sequence "messages_id_seq" does not exist psql:/var/www/lms/doc/lms.pgsql:1348: ERROR: table "messages" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1359: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1367: ERROR: sequence "messageitems_id_seq" does not exist psql:/var/www/lms/doc/lms.pgsql:1368: ERROR: table "messageitems" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1379: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messageitems_pkey" for table "messageitems" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1387: ERROR: sequence "nastypes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1389: ERROR: table "nastypes" does not exist psql:/var/www/lms/doc/lms.pgsql:1395: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nastypes_pkey" for table "nastypes" psql:/var/www/lms/doc/lms.pgsql:1395: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nastypes_name_key" for table "nastypes" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1400: ERROR: sequence "up_rights_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1402: ERROR: table "up_rights" does not exist psql:/var/www/lms/doc/lms.pgsql:1410: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "up_rights_pkey" for table "up_rights" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1415: ERROR: sequence "up_rights_assignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1417: ERROR: table "up_rights_assignments" does not exist psql:/var/www/lms/doc/lms.pgsql:1424: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "up_rights_assignments_pkey" for table "up_rights_assignments" psql:/var/www/lms/doc/lms.pgsql:1424: NOTICE: CREATE TABLE / UNIQUE will create implicit index "up_rights_assignments_customerid_key" for table "up_rights_assignments" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1429: ERROR: sequence "up_customers_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1431: ERROR: table "up_customers" does not exist psql:/var/www/lms/doc/lms.pgsql:1441: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "up_customers_pkey" for table "up_customers" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1446: ERROR: sequence "up_help_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1448: ERROR: table "up_help" does not exist psql:/var/www/lms/doc/lms.pgsql:1455: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "up_help_pkey" for table "up_help" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1460: ERROR: sequence "up_info_changes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1462: ERROR: table "up_info_changes" does not exist psql:/var/www/lms/doc/lms.pgsql:1469: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "up_info_changes_pkey" for table "up_info_changes" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1474: ERROR: must be owner of function array_agg CREATE AGGREGATE CREATE FUNCTION CREATE VIEW CREATE FUNCTION CREATE VIEW CREATE VIEW CREATE VIEW INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 postgres@pgsql:~$ #v- 2. teraz przygotowywuje dane do migracji. pobieram z mysql. #v+ root@pgsql:~# cat mysql2pgsql.yml # if a socket is specified we will use that # if tcp is chosen you can use compression mysql: hostname: localhost port: 3306 socket: /var/run/mysqld/mysqld.sock username: root password: toor database: lms compress: false destination: # if file is given, output goes to file, else postgres file: back.sql postgres: hostname: port: 5432 username: lms password: database: lms # if tables is given, only the listed tables will be converted. leave empty to convert all tables. #only_tables: #- table1 #- table2 # if exclude_tables is given, exclude the listed tables from the conversion. #exclude_tables: #- table3 #- table4 # if supress_data is true, only the schema definition will be exported/migrated, and not the data supress_data: false # if supress_ddl is true, only the data will be exported/imported, and not the schema #supress_ddl: false supress_ddl: true # if force_truncate is true, forces a table truncate before table loading #force_truncate: false force_truncate: true # if timezone is true, forces to append/convert to UTC tzinfo mysql data timezone: false root@pgsql:~# root@pgsql:~# py-mysql2pgsql -v -f mysql2pgsql.yml >>>>>>>>>> STARTING <<<<<<<<<< START TRUNCATING TABLES START - TRUNCATING TABLE aliasassignments FINISH - TRUNCATING TABLE aliasassignments START - TRUNCATING TABLE aliases FINISH - TRUNCATING TABLE aliases START - TRUNCATING TABLE assignments FINISH - TRUNCATING TABLE assignments START - TRUNCATING TABLE cash FINISH - TRUNCATING TABLE cash START - TRUNCATING TABLE cashimport FINISH - TRUNCATING TABLE cashimport START - TRUNCATING TABLE cashreglog FINISH - TRUNCATING TABLE cashreglog START - TRUNCATING TABLE cashregs FINISH - TRUNCATING TABLE cashregs START - TRUNCATING TABLE cashrights FINISH - TRUNCATING TABLE cashrights START - TRUNCATING TABLE cashsources FINISH - TRUNCATING TABLE cashsources START - TRUNCATING TABLE countries FINISH - TRUNCATING TABLE countries START - TRUNCATING TABLE customerassignments FINISH - TRUNCATING TABLE customerassignments START - TRUNCATING TABLE customercontacts FINISH - TRUNCATING TABLE customercontacts START - TRUNCATING TABLE customergroups FINISH - TRUNCATING TABLE customergroups START - TRUNCATING TABLE customers FINISH - TRUNCATING TABLE customers START - TRUNCATING TABLE customersview FINISH - TRUNCATING TABLE customersview START - TRUNCATING TABLE daemonconfig FINISH - TRUNCATING TABLE daemonconfig START - TRUNCATING TABLE daemoninstances FINISH - TRUNCATING TABLE daemoninstances START - TRUNCATING TABLE dbinfo FINISH - TRUNCATING TABLE dbinfo START - TRUNCATING TABLE debitnotecontents FINISH - TRUNCATING TABLE debitnotecontents START - TRUNCATING TABLE divisions FINISH - TRUNCATING TABLE divisions START - TRUNCATING TABLE docrights FINISH - TRUNCATING TABLE docrights START - TRUNCATING TABLE documentcontents FINISH - TRUNCATING TABLE documentcontents START - TRUNCATING TABLE documents FINISH - TRUNCATING TABLE documents START - TRUNCATING TABLE domains FINISH - TRUNCATING TABLE domains START - TRUNCATING TABLE eventassignments FINISH - TRUNCATING TABLE eventassignments START - TRUNCATING TABLE events FINISH - TRUNCATING TABLE events START - TRUNCATING TABLE ewx_channels FINISH - TRUNCATING TABLE ewx_channels START - TRUNCATING TABLE ewx_pt_config FINISH - TRUNCATING TABLE ewx_pt_config START - TRUNCATING TABLE ewx_stm_channels FINISH - TRUNCATING TABLE ewx_stm_channels START - TRUNCATING TABLE ewx_stm_nodes FINISH - TRUNCATING TABLE ewx_stm_nodes START - TRUNCATING TABLE excludedgroups FINISH - TRUNCATING TABLE excludedgroups START - TRUNCATING TABLE hosts FINISH - TRUNCATING TABLE hosts START - TRUNCATING TABLE imessengers FINISH - TRUNCATING TABLE imessengers START - TRUNCATING TABLE invoicecontents FINISH - TRUNCATING TABLE invoicecontents START - TRUNCATING TABLE liabilities FINISH - TRUNCATING TABLE liabilities START - TRUNCATING TABLE macs FINISH - TRUNCATING TABLE macs START - TRUNCATING TABLE messageitems FINISH - TRUNCATING TABLE messageitems START - TRUNCATING TABLE messages FINISH - TRUNCATING TABLE messages START - TRUNCATING TABLE nastypes FINISH - TRUNCATING TABLE nastypes START - TRUNCATING TABLE netdevices FINISH - TRUNCATING TABLE netdevices START - TRUNCATING TABLE netlinks FINISH - TRUNCATING TABLE netlinks START - TRUNCATING TABLE networks FINISH - TRUNCATING TABLE networks START - TRUNCATING TABLE nodeassignments FINISH - TRUNCATING TABLE nodeassignments START - TRUNCATING TABLE nodegroupassignments FINISH - TRUNCATING TABLE nodegroupassignments START - TRUNCATING TABLE nodegroups FINISH - TRUNCATING TABLE nodegroups START - TRUNCATING TABLE nodes FINISH - TRUNCATING TABLE nodes START - TRUNCATING TABLE numberplanassignments FINISH - TRUNCATING TABLE numberplanassignments START - TRUNCATING TABLE numberplans FINISH - TRUNCATING TABLE numberplans START - TRUNCATING TABLE passwd FINISH - TRUNCATING TABLE passwd START - TRUNCATING TABLE payments FINISH - TRUNCATING TABLE payments START - TRUNCATING TABLE promotionassignments FINISH - TRUNCATING TABLE promotionassignments START - TRUNCATING TABLE promotions FINISH - TRUNCATING TABLE promotions START - TRUNCATING TABLE promotionschemas FINISH - TRUNCATING TABLE promotionschemas START - TRUNCATING TABLE receiptcontents FINISH - TRUNCATING TABLE receiptcontents START - TRUNCATING TABLE records FINISH - TRUNCATING TABLE records START - TRUNCATING TABLE rtattachments FINISH - TRUNCATING TABLE rtattachments START - TRUNCATING TABLE rtmessages FINISH - TRUNCATING TABLE rtmessages START - TRUNCATING TABLE rtnotes FINISH - TRUNCATING TABLE rtnotes START - TRUNCATING TABLE rtqueues FINISH - TRUNCATING TABLE rtqueues START - TRUNCATING TABLE rtrights FINISH - TRUNCATING TABLE rtrights START - TRUNCATING TABLE rttickets FINISH - TRUNCATING TABLE rttickets START - TRUNCATING TABLE sessions FINISH - TRUNCATING TABLE sessions START - TRUNCATING TABLE sourcefiles FINISH - TRUNCATING TABLE sourcefiles START - TRUNCATING TABLE states FINISH - TRUNCATING TABLE states START - TRUNCATING TABLE stats FINISH - TRUNCATING TABLE stats START - TRUNCATING TABLE supermasters FINISH - TRUNCATING TABLE supermasters START - TRUNCATING TABLE tariffs FINISH - TRUNCATING TABLE tariffs START - TRUNCATING TABLE taxes FINISH - TRUNCATING TABLE taxes START - TRUNCATING TABLE uiconfig FINISH - TRUNCATING TABLE uiconfig START - TRUNCATING TABLE up_customers FINISH - TRUNCATING TABLE up_customers START - TRUNCATING TABLE up_help FINISH - TRUNCATING TABLE up_help START - TRUNCATING TABLE up_info_changes FINISH - TRUNCATING TABLE up_info_changes START - TRUNCATING TABLE up_rights FINISH - TRUNCATING TABLE up_rights START - TRUNCATING TABLE up_rights_assignments FINISH - TRUNCATING TABLE up_rights_assignments START - TRUNCATING TABLE users FINISH - TRUNCATING TABLE users START - TRUNCATING TABLE vmacs FINISH - TRUNCATING TABLE vmacs START - TRUNCATING TABLE vnodes FINISH - TRUNCATING TABLE vnodes START - TRUNCATING TABLE vnodes_mac FINISH - TRUNCATING TABLE vnodes_mac START - TRUNCATING TABLE voipaccounts FINISH - TRUNCATING TABLE voipaccounts START - TRUNCATING TABLE zipcodes FINISH - TRUNCATING TABLE zipcodes DONE TRUNCATING TABLES START WRITING TABLE DATA START - WRITING DATA TO aliasassignments FINISH - WRITING DATA TO aliasassignments START - WRITING DATA TO aliases FINISH - WRITING DATA TO aliases START - WRITING DATA TO assignments FINISH - WRITING DATA TO assignments START - WRITING DATA TO cash 11608.32 rows/sec [180000] FINISH - WRITING DATA TO cash START - WRITING DATA TO cashimport FINISH - WRITING DATA TO cashimport START - WRITING DATA TO cashreglog FINISH - WRITING DATA TO cashreglog START - WRITING DATA TO cashregs FINISH - WRITING DATA TO cashregs START - WRITING DATA TO cashrights FINISH - WRITING DATA TO cashrights START - WRITING DATA TO cashsources FINISH - WRITING DATA TO cashsources START - WRITING DATA TO countries FINISH - WRITING DATA TO countries START - WRITING DATA TO customerassignments FINISH - WRITING DATA TO customerassignments START - WRITING DATA TO customercontacts FINISH - WRITING DATA TO customercontacts START - WRITING DATA TO customergroups FINISH - WRITING DATA TO customergroups START - WRITING DATA TO customers FINISH - WRITING DATA TO customers START - WRITING DATA TO customersview FINISH - WRITING DATA TO customersview START - WRITING DATA TO daemonconfig FINISH - WRITING DATA TO daemonconfig START - WRITING DATA TO daemoninstances FINISH - WRITING DATA TO daemoninstances START - WRITING DATA TO dbinfo FINISH - WRITING DATA TO dbinfo START - WRITING DATA TO debitnotecontents FINISH - WRITING DATA TO debitnotecontents START - WRITING DATA TO divisions FINISH - WRITING DATA TO divisions START - WRITING DATA TO docrights FINISH - WRITING DATA TO docrights START - WRITING DATA TO documentcontents FINISH - WRITING DATA TO documentcontents START - WRITING DATA TO documents 7051.36 rows/sec [120000] FINISH - WRITING DATA TO documents START - WRITING DATA TO domains FINISH - WRITING DATA TO domains START - WRITING DATA TO eventassignments FINISH - WRITING DATA TO eventassignments START - WRITING DATA TO events FINISH - WRITING DATA TO events START - WRITING DATA TO ewx_channels FINISH - WRITING DATA TO ewx_channels START - WRITING DATA TO ewx_pt_config FINISH - WRITING DATA TO ewx_pt_config START - WRITING DATA TO ewx_stm_channels FINISH - WRITING DATA TO ewx_stm_channels START - WRITING DATA TO ewx_stm_nodes FINISH - WRITING DATA TO ewx_stm_nodes START - WRITING DATA TO excludedgroups FINISH - WRITING DATA TO excludedgroups START - WRITING DATA TO hosts FINISH - WRITING DATA TO hosts START - WRITING DATA TO imessengers FINISH - WRITING DATA TO imessengers START - WRITING DATA TO invoicecontents 8598.63 rows/sec [100000] FINISH - WRITING DATA TO invoicecontents START - WRITING DATA TO liabilities FINISH - WRITING DATA TO liabilities START - WRITING DATA TO macs FINISH - WRITING DATA TO macs START - WRITING DATA TO messageitems FINISH - WRITING DATA TO messageitems START - WRITING DATA TO messages FINISH - WRITING DATA TO messages START - WRITING DATA TO nastypes FINISH - WRITING DATA TO nastypes START - WRITING DATA TO netdevices FINISH - WRITING DATA TO netdevices START - WRITING DATA TO netlinks FINISH - WRITING DATA TO netlinks START - WRITING DATA TO networks FINISH - WRITING DATA TO networks START - WRITING DATA TO nodeassignments FINISH - WRITING DATA TO nodeassignments START - WRITING DATA TO nodegroupassignments FINISH - WRITING DATA TO nodegroupassignments START - WRITING DATA TO nodegroups FINISH - WRITING DATA TO nodegroups START - WRITING DATA TO nodes FINISH - WRITING DATA TO nodes START - WRITING DATA TO numberplanassignments FINISH - WRITING DATA TO numberplanassignments START - WRITING DATA TO numberplans FINISH - WRITING DATA TO numberplans START - WRITING DATA TO passwd FINISH - WRITING DATA TO passwd START - WRITING DATA TO payments FINISH - WRITING DATA TO payments START - WRITING DATA TO promotionassignments FINISH - WRITING DATA TO promotionassignments START - WRITING DATA TO promotions FINISH - WRITING DATA TO promotions START - WRITING DATA TO promotionschemas FINISH - WRITING DATA TO promotionschemas START - WRITING DATA TO receiptcontents 15751.60 rows/sec [40000] FINISH - WRITING DATA TO receiptcontents START - WRITING DATA TO records FINISH - WRITING DATA TO records START - WRITING DATA TO rtattachments FINISH - WRITING DATA TO rtattachments START - WRITING DATA TO rtmessages FINISH - WRITING DATA TO rtmessages START - WRITING DATA TO rtnotes FINISH - WRITING DATA TO rtnotes START - WRITING DATA TO rtqueues FINISH - WRITING DATA TO rtqueues START - WRITING DATA TO rtrights FINISH - WRITING DATA TO rtrights START - WRITING DATA TO rttickets FINISH - WRITING DATA TO rttickets START - WRITING DATA TO sessions FINISH - WRITING DATA TO sessions START - WRITING DATA TO sourcefiles FINISH - WRITING DATA TO sourcefiles START - WRITING DATA TO states FINISH - WRITING DATA TO states START - WRITING DATA TO stats FINISH - WRITING DATA TO stats START - WRITING DATA TO supermasters FINISH - WRITING DATA TO supermasters START - WRITING DATA TO tariffs FINISH - WRITING DATA TO tariffs START - WRITING DATA TO taxes FINISH - WRITING DATA TO taxes START - WRITING DATA TO uiconfig FINISH - WRITING DATA TO uiconfig START - WRITING DATA TO up_customers FINISH - WRITING DATA TO up_customers START - WRITING DATA TO up_help FINISH - WRITING DATA TO up_help START - WRITING DATA TO up_info_changes FINISH - WRITING DATA TO up_info_changes START - WRITING DATA TO up_rights FINISH - WRITING DATA TO up_rights START - WRITING DATA TO up_rights_assignments FINISH - WRITING DATA TO up_rights_assignments START - WRITING DATA TO users FINISH - WRITING DATA TO users START - WRITING DATA TO vmacs FINISH - WRITING DATA TO vmacs START - WRITING DATA TO vnodes FINISH - WRITING DATA TO vnodes START - WRITING DATA TO vnodes_mac FINISH - WRITING DATA TO vnodes_mac START - WRITING DATA TO voipaccounts FINISH - WRITING DATA TO voipaccounts START - WRITING DATA TO zipcodes FINISH - WRITING DATA TO zipcodes DONE WRITING TABLE DATA >>>>>>>>>> FINISHED <<<<<<<<<< #v- 3. tak przygotowany plik sql wrzucam do postgresa ale niestety sa errory #v+ postgres@pgsql:~$ psql -d lms -U lms -f /root/back.sql SET SET SET SET TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) psql:/root/back.sql:80: ERROR: "customersview" is not a table TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) psql:/root/back.sql:250: ERROR: relation "promotionassignments" does not exist psql:/root/back.sql:252: ERROR: relation "promotionassignments" does not exist psql:/root/back.sql:255: ERROR: relation "promotions" does not exist psql:/root/back.sql:257: ERROR: relation "promotions" does not exist psql:/root/back.sql:260: ERROR: relation "promotionschemas" does not exist psql:/root/back.sql:262: ERROR: relation "promotionschemas" does not exist TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) psql:/root/back.sql:273: ERROR: relation "rtattachments" does not exist TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) psql:/root/back.sql:367: ERROR: "vmacs" is not a table psql:/root/back.sql:370: ERROR: "vnodes" is not a table psql:/root/back.sql:373: ERROR: relation "vnodes_mac" does not exist TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) psql:/root/back.sql:2847: ERROR: invalid input syntax for integer: "t" CONTEXT: COPY assignments, line 1, column invoice: "t" psql:/root/back.sql:199444: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY cashregs, line 1, column disabled: "f" psql:/root/back.sql:201097: ERROR: insert or update on table "customerassignments" violates foreign key constraint "customerassignments_customergroupid_fkey" DETAIL: Key (customergroupid)=(1) is not present in table "customergroups". psql:/root/back.sql:203940: ERROR: insert or update on table "customercontacts" violates foreign key constraint "customercontacts_customerid_fkey" DETAIL: Key (customerid)=(888) is not present in table "customers". psql:/root/back.sql:206249: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY customers, line 1, column deleted: "f" psql:/root/back.sql:208542: ERROR: cannot copy to view "customersview" psql:/root/back.sql:208609: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY daemonconfig, line 1, column disabled: "f" psql:/root/back.sql:208641: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY daemoninstances, line 1, column disabled: "f" psql:/root/back.sql:208782: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY divisions, line 1, column status: "f" psql:/root/back.sql:347784: ERROR: invalid input syntax for integer: "t" CONTEXT: COPY documents, line 1, column closed: "t" psql:/root/back.sql:348188: ERROR: invalid input syntax for integer: "t" CONTEXT: COPY events, line 1, column private: "t" psql:/root/back.sql:348239: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY hosts, line 1, column reload: "f" psql:/root/back.sql:348270: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY imessengers, line 1, column type: "f" psql:/root/back.sql:452699: ERROR: insert or update on table "macs" violates foreign key constraint "macs_nodeid_fkey" DETAIL: Key (nodeid)=(1780) is not present in table "nodes". psql:/root/back.sql:456685: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY netlinks, line 1, column type: "f" psql:/root/back.sql:456746: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY networks, line 1, column disabled: "f" psql:/root/back.sql:459332: ERROR: insert or update on table "nodeassignments" violates foreign key constraint "nodeassignments_nodeid_fkey" DETAIL: Key (nodeid)=(2) is not present in table "nodes". psql:/root/back.sql:463324: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY nodes, line 1, column linktype: "f" psql:/root/back.sql:463348: ERROR: invalid input syntax for integer: "t" CONTEXT: COPY numberplans, line 1, column isdefault: "t" psql:/root/back.sql:463373: ERROR: relation "promotionassignments" does not exist psql:/root/back.sql:463374: ERROR: syntax error at or near "1" LINE 1: 1 1 202 199; ^ psql:/root/back.sql:463374: ERROR: syntax error at or near "25" LINE 1: 25:3; ^ psql:/root/back.sql:463375: ERROR: syntax error at or near "49" LINE 1: 49:3 ^ psql:/root/back.sql:463375: ERROR: syntax error at or near "25" LINE 1: 25:3; ^ psql:/root/back.sql:463376: invalid command \. psql:/root/back.sql:463383: ERROR: syntax error at or near "49" LINE 1: 49:3 ^ psql:/root/back.sql:463384: invalid command \. psql:/root/back.sql:463391: ERROR: relation "promotionschemas" does not exist psql:/root/back.sql:463392: ERROR: syntax error at or near "1" LINE 1: 1 z aktywacją 12; ^ psql:/root/back.sql:463392: invalid command \N psql:/root/back.sql:463393: ERROR: syntax error at or near "24" LINE 1: 24 1 f ^ psql:/root/back.sql:463393: invalid command \N psql:/root/back.sql:463394: invalid command \. psql:/root/back.sql:463401: ERROR: syntax error at or near "24" LINE 1: 24 1 f ^ psql:/root/back.sql:484687: ERROR: syntax error at or near "3297" LINE 1: 3297 1 191.80 Faktura VAT Nr 642/2006 1 ^ psql:/root/back.sql:493540: ERROR: syntax error at or near ")" LINE 1: )))) 2 ^ psql:/root/back.sql:493969: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:498413: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:498432: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:498443: ERROR: syntax error at or near "wnanie" LINE 1: wnanie 2 ^ psql:/root/back.sql:498538: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:498678: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:498679: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:499232: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:500217: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:500450: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:500575: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:500576: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:501024: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:515732: invalid command \n> psql:/root/back.sql:515733: invalid command \nPowinno Query buffer reset (cleared). psql:/root/back.sql:515734: invalid command \nJakby Query buffer reset (cleared). psql:/root/back.sql:515735: invalid command \nod psql:/root/back.sql:515736: invalid command \n Query buffer reset (cleared). psql:/root/back.sql:515737: invalid command \n psql:/root/back.sql:515738: invalid command \nFrom: psql:/root/back.sql:515740: invalid command \nFrom: psql:/root/back.sql:515743: invalid command \n> Query buffer reset (cleared). psql:/root/back.sql:515745: invalid command \n psql:/root/back.sql:515746: invalid command \nWłączenie psql:/root/back.sql:515747: invalid command \n Query buffer reset (cleared). psql:/root/back.sql:515748: invalid command \n Query buffer reset (cleared). psql:/root/back.sql:515749: invalid command \n psql:/root/back.sql:515750: invalid command \nPrzetestowałem Query buffer reset (cleared). psql:/root/back.sql:515751: invalid command \n Query buffer reset (cleared). psql:/root/back.sql:515752: invalid command \nUprzejmie Query buffer reset (cleared). psql:/root/back.sql:515753: invalid command \nSerwer psql:/root/back.sql:515754: invalid command \nFrom: psql:/root/back.sql:515755: invalid command \nFrom: psql:/root/back.sql:515757: invalid command \nFrom: psql:/root/back.sql:515759: invalid command \nW Query buffer reset (cleared). psql:/root/back.sql:515760: invalid command \n psql:/root/back.sql:515762: invalid command \nFrom: psql:/root/back.sql:515765: invalid command \n> psql:/root/back.sql:515766: invalid command \nUmówiony Query buffer reset (cleared). psql:/root/back.sql:515767: invalid command \nCzy psql:/root/back.sql:515768: invalid command \n psql:/root/back.sql:515770: invalid command \nFrom: Query buffer reset (cleared). psql:/root/back.sql:515771: invalid command \nPłatności psql:/root/back.sql:515772: invalid command \nFrom: psql:/root/back.sql:515774: invalid command \nFrom: Query buffer reset (cleared). psql:/root/back.sql:515775: invalid command \nUsługa psql:/root/back.sql:515776: invalid command \nFrom: Query buffer reset (cleared). psql:/root/back.sql:515778: invalid command \nczy psql:/root/back.sql:515779: invalid command \n> psql:/root/back.sql:515781: invalid command \nFrom: psql:/root/back.sql:515782: invalid command \. psql:/root/back.sql:515789: ERROR: syntax error at or near "97" LINE 1: 97 53 1 0 Re: Router Edimax BR-6226n - konfiguracja [RT#000... ^ Query buffer reset (cleared). psql:/root/back.sql:515790: invalid command \nPaweł Query buffer reset (cleared). psql:/root/back.sql:515792: invalid command \nCo Query buffer reset (cleared). psql:/root/back.sql:515795: invalid command \nna Query buffer reset (cleared). psql:/root/back.sql:515796: invalid command \nPotwierdzone Query buffer reset (cleared). psql:/root/back.sql:515798: invalid command \nUmówić Query buffer reset (cleared). psql:/root/back.sql:515800: invalid command \nDane psql:/root/back.sql:515802: invalid command \. psql:/root/back.sql:515809: ERROR: syntax error at or near "16" LINE 1: 16 43 1 Wymiana MT 1356343553 ^ psql:/root/back.sql:515814: invalid command \. psql:/root/back.sql:515821: ERROR: syntax error at or near "1" LINE 1: 1 zgloszenia biuro(a)interdom.net.pl zgloszenia klientów ^ psql:/root/back.sql:515849: invalid command \. psql:/root/back.sql:515856: ERROR: syntax error at or near "53" LINE 1: 53 1 1 15 ^ psql:/root/back.sql:515862: ERROR: syntax error at or near "8" LINE 1: 8 1 Problem z zalogowaniem na http://biling.interdom.net.pl... ^ psql:/root/back.sql:515896: invalid command \. psql:/root/back.sql:515903: ERROR: syntax error at or near ")" LINE 1: )) 2 11 1965 1329297577 1329298273 2 11 ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "78" LINE 1: 78dad9c4ff0dae1eddb4a96133acdf26051966eeb08786b0 1368813291 ... ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:12:"193.59.33.10"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:15:"HTTP_USER_AGENT"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:101:"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTM... ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:11:"SERVER_NAME"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:19:"lms.interdom.net.pl"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:11:"SERVER_PORT"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:2:"88"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "}" LINE 1: } a:9:{s:10:"session_id"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:1:"7"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:13:"session_login"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:4:"rych"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:15:"session_logname"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:14:"Ryszard Rauzer"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:12:"session_last"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:10:"1368727020"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:14:"session_lastip"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:12:"193.59.33.10"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:10:"lastmodule"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:10:"netdevinfo"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:4:"ndlo"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "N" LINE 1: N; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:4:"ndlp"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "i" LINE 1: i:1; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:6:"backto"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:28:"m=netdevinfo&id=1841&ip=4359"; ^ psql:/root/back.sql:515905: invalid command \. psql:/root/back.sql:515912: ERROR: syntax error at or near "}" LINE 1: } ^ psql:/root/back.sql:515913: invalid command \. psql:/root/back.sql:516302: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY uiconfig, line 1, column disabled: "f" psql:/root/back.sql:516560: ERROR: invalid input syntax for integer: "t" CONTEXT: COPY up_rights, line 1, column setdefault: "t" psql:/root/back.sql:516592: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY users, line 1, column deleted: "f" psql:/root/back.sql:520513: ERROR: cannot copy to view "vmacs" psql:/root/back.sql:524481: ERROR: cannot copy to view "vnodes" psql:/root/back.sql:524488: ERROR: relation "vnodes_mac" does not exist psql:/root/back.sql:528402: invalid command \. psql:/root/back.sql:528409: ERROR: syntax error at or near "2" LINE 1: 2 00:10:5A:3B:FC:A8 ^ psql:/root/back.sql:528526: invalid command \. psql:/root/back.sql:528533: ERROR: syntax error at or near "1" LINE 1: 1 3 468807001 ClD68qJ7jqF0ntA7BvD0 48468807001 1320406614 13... ^ psql:/root/back.sql:528652: invalid command \. psql:/root/back.sql:528653: ERROR: syntax error at or near "1" LINE 1: 1 0 ^ postgres@pgsql:~$ #v- niestety po tym zabiegu wiele danych nie ląduje do bazy :/ ma ktoś jakiś pomysł by to ruszyło? ============== Drugi scenariusz ======= dane brane z mysql wrzucane bezpośrednio do postgres. w posgtgresie czysta baza ze schamatami. próba zrzucenia samych danych: #v+ root@pgsql:~# cat mysql2pgsql.yml # if a socket is specified we will use that # if tcp is chosen you can use compression mysql: hostname: localhost port: 3306 socket: /var/run/mysqld/mysqld.sock username: root password: toor database: lms compress: false destination: # if file is given, output goes to file, else postgres file: postgres: hostname: localhost port: 5432 username: lms password: pass database: lms # if tables is given, only the listed tables will be converted. leave empty to convert all tables. #only_tables: #- table1 #- table2 # if exclude_tables is given, exclude the listed tables from the conversion. #exclude_tables: #- table3 #- table4 # if supress_data is true, only the schema definition will be exported/migrated, and not the data supress_data: false # if supress_ddl is true, only the data will be exported/imported, and not the schema #supress_ddl: false supress_ddl: true # if force_truncate is true, forces a table truncate before table loading force_truncate: false #force_truncate: true # if timezone is true, forces to append/convert to UTC tzinfo mysql data timezone: false root@pgsql:~# py-mysql2pgsql -v -f mysql2pgsql.yml >>>>>>>>>> STARTING <<<<<<<<<< START WRITING TABLE DATA START - WRITING DATA TO aliasassignments FINISH - WRITING DATA TO aliasassignments START - WRITING DATA TO aliases FINISH - WRITING DATA TO aliases START - WRITING DATA TO assignments Traceback (most recent call last): File "/usr/local/bin/py-mysql2pgsql", line 5, in <module> pkg_resources.run_script('py-mysql2pgsql==0.1.6', 'py-mysql2pgsql') File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 499, in run_script self.require(requires)[0].run_script(script_name, ns) File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 1235, in run_script execfile(script_filename, namespace, namespace) File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/EGG-INFO/scripts/py-mysql2pgsql", line 38, in <module> mysql2pgsql.Mysql2Pgsql(options).convert() File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/mysql2pgsql/mysql2pgsql.py", line 31, in convert Converter(reader, writer, self.file_options, self.run_options.verbose).convert() File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/mysql2pgsql/lib/converter.py", line 51, in convert self.writer.write_contents(table, self.reader) File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/mysql2pgsql/lib/__init__.py", line 86, in decorated_function ret = f(*args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/mysql2pgsql/lib/postgres_db_writer.py", line 193, in write_contents self.copy_from(f, '"%s"' % table.name, ['"%s"' % c['name'] for c in table.columns]) File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/mysql2pgsql/lib/postgres_db_writer.py", line 116, in copy_from columns=columns psycopg2.DataError: invalid input syntax for integer: "t" CONTEXT: COPY assignments, line 1, column invoice: "t" root@pgsql:~# #v- teraz zrzut całości z mysql do postgres: #v+ root@pgsql:~# cat mysql2pgsql.yml # if a socket is specified we will use that # if tcp is chosen you can use compression mysql: hostname: localhost port: 3306 socket: /var/run/mysqld/mysqld.sock username: root password: toor database: lms compress: false destination: # if file is given, output goes to file, else postgres file: postgres: hostname: localhost port: 5432 username: lms password: pass database: lms # if tables is given, only the listed tables will be converted. leave empty to convert all tables. #only_tables: #- table1 #- table2 # if exclude_tables is given, exclude the listed tables from the conversion. #exclude_tables: #- table3 #- table4 # if supress_data is true, only the schema definition will be exported/migrated, and not the data supress_data: false # if supress_ddl is true, only the data will be exported/imported, and not the schema supress_ddl: false #supress_ddl: true # if force_truncate is true, forces a table truncate before table loading force_truncate: false #force_truncate: true # if timezone is true, forces to append/convert to UTC tzinfo mysql data timezone: false root@pgsql:~# py-mysql2pgsql -v -f mysql2pgsql.yml >>>>>>>>>> STARTING <<<<<<<<<< START CREATING TABLES START - CREATING TABLE aliasassignments FINISH - CREATING TABLE aliasassignments START - CREATING TABLE aliases FINISH - CREATING TABLE aliases START - CREATING TABLE assignments FINISH - CREATING TABLE assignments START - CREATING TABLE cash FINISH - CREATING TABLE cash START - CREATING TABLE cashimport FINISH - CREATING TABLE cashimport START - CREATING TABLE cashreglog FINISH - CREATING TABLE cashreglog START - CREATING TABLE cashregs FINISH - CREATING TABLE cashregs START - CREATING TABLE cashrights FINISH - CREATING TABLE cashrights START - CREATING TABLE cashsources FINISH - CREATING TABLE cashsources START - CREATING TABLE countries FINISH - CREATING TABLE countries START - CREATING TABLE customerassignments FINISH - CREATING TABLE customerassignments START - CREATING TABLE customercontacts FINISH - CREATING TABLE customercontacts START - CREATING TABLE customergroups FINISH - CREATING TABLE customergroups START - CREATING TABLE customers FINISH - CREATING TABLE customers START - CREATING TABLE customersview FINISH - CREATING TABLE customersview START - CREATING TABLE daemonconfig FINISH - CREATING TABLE daemonconfig START - CREATING TABLE daemoninstances FINISH - CREATING TABLE daemoninstances START - CREATING TABLE dbinfo FINISH - CREATING TABLE dbinfo START - CREATING TABLE debitnotecontents FINISH - CREATING TABLE debitnotecontents START - CREATING TABLE divisions FINISH - CREATING TABLE divisions START - CREATING TABLE docrights FINISH - CREATING TABLE docrights START - CREATING TABLE documentcontents FINISH - CREATING TABLE documentcontents START - CREATING TABLE documents FINISH - CREATING TABLE documents START - CREATING TABLE domains FINISH - CREATING TABLE domains START - CREATING TABLE eventassignments FINISH - CREATING TABLE eventassignments START - CREATING TABLE events FINISH - CREATING TABLE events START - CREATING TABLE ewx_channels FINISH - CREATING TABLE ewx_channels START - CREATING TABLE ewx_pt_config FINISH - CREATING TABLE ewx_pt_config START - CREATING TABLE ewx_stm_channels FINISH - CREATING TABLE ewx_stm_channels START - CREATING TABLE ewx_stm_nodes FINISH - CREATING TABLE ewx_stm_nodes START - CREATING TABLE excludedgroups FINISH - CREATING TABLE excludedgroups START - CREATING TABLE hosts FINISH - CREATING TABLE hosts START - CREATING TABLE imessengers FINISH - CREATING TABLE imessengers START - CREATING TABLE invoicecontents FINISH - CREATING TABLE invoicecontents START - CREATING TABLE liabilities FINISH - CREATING TABLE liabilities START - CREATING TABLE macs FINISH - CREATING TABLE macs START - CREATING TABLE messageitems FINISH - CREATING TABLE messageitems START - CREATING TABLE messages FINISH - CREATING TABLE messages START - CREATING TABLE nastypes FINISH - CREATING TABLE nastypes START - CREATING TABLE netdevices FINISH - CREATING TABLE netdevices START - CREATING TABLE netlinks FINISH - CREATING TABLE netlinks START - CREATING TABLE networks FINISH - CREATING TABLE networks START - CREATING TABLE nodeassignments FINISH - CREATING TABLE nodeassignments START - CREATING TABLE nodegroupassignments FINISH - CREATING TABLE nodegroupassignments START - CREATING TABLE nodegroups FINISH - CREATING TABLE nodegroups START - CREATING TABLE nodes FINISH - CREATING TABLE nodes START - CREATING TABLE numberplanassignments FINISH - CREATING TABLE numberplanassignments START - CREATING TABLE numberplans FINISH - CREATING TABLE numberplans START - CREATING TABLE passwd FINISH - CREATING TABLE passwd START - CREATING TABLE payments FINISH - CREATING TABLE payments START - CREATING TABLE promotionassignments FINISH - CREATING TABLE promotionassignments START - CREATING TABLE promotions FINISH - CREATING TABLE promotions START - CREATING TABLE promotionschemas FINISH - CREATING TABLE promotionschemas START - CREATING TABLE receiptcontents FINISH - CREATING TABLE receiptcontents START - CREATING TABLE records FINISH - CREATING TABLE records START - CREATING TABLE rtattachments FINISH - CREATING TABLE rtattachments START - CREATING TABLE rtmessages FINISH - CREATING TABLE rtmessages START - CREATING TABLE rtnotes FINISH - CREATING TABLE rtnotes START - CREATING TABLE rtqueues FINISH - CREATING TABLE rtqueues START - CREATING TABLE rtrights FINISH - CREATING TABLE rtrights START - CREATING TABLE rttickets FINISH - CREATING TABLE rttickets START - CREATING TABLE sessions FINISH - CREATING TABLE sessions START - CREATING TABLE sourcefiles FINISH - CREATING TABLE sourcefiles START - CREATING TABLE states FINISH - CREATING TABLE states START - CREATING TABLE stats FINISH - CREATING TABLE stats START - CREATING TABLE supermasters FINISH - CREATING TABLE supermasters START - CREATING TABLE tariffs FINISH - CREATING TABLE tariffs START - CREATING TABLE taxes FINISH - CREATING TABLE taxes START - CREATING TABLE uiconfig FINISH - CREATING TABLE uiconfig START - CREATING TABLE up_customers FINISH - CREATING TABLE up_customers START - CREATING TABLE up_help FINISH - CREATING TABLE up_help START - CREATING TABLE up_info_changes FINISH - CREATING TABLE up_info_changes START - CREATING TABLE up_rights FINISH - CREATING TABLE up_rights START - CREATING TABLE up_rights_assignments FINISH - CREATING TABLE up_rights_assignments START - CREATING TABLE users FINISH - CREATING TABLE users START - CREATING TABLE vmacs FINISH - CREATING TABLE vmacs START - CREATING TABLE vnodes FINISH - CREATING TABLE vnodes START - CREATING TABLE vnodes_mac FINISH - CREATING TABLE vnodes_mac START - CREATING TABLE voipaccounts FINISH - CREATING TABLE voipaccounts START - CREATING TABLE zipcodes FINISH - CREATING TABLE zipcodes DONE CREATING TABLES START WRITING TABLE DATA START - WRITING DATA TO aliasassignments FINISH - WRITING DATA TO aliasassignments START - WRITING DATA TO aliases FINISH - WRITING DATA TO aliases START - WRITING DATA TO assignments FINISH - WRITING DATA TO assignments START - WRITING DATA TO cash 11045.66 rows/sec [180000] FINISH - WRITING DATA TO cash START - WRITING DATA TO cashimport FINISH - WRITING DATA TO cashimport START - WRITING DATA TO cashreglog FINISH - WRITING DATA TO cashreglog START - WRITING DATA TO cashregs FINISH - WRITING DATA TO cashregs START - WRITING DATA TO cashrights FINISH - WRITING DATA TO cashrights START - WRITING DATA TO cashsources FINISH - WRITING DATA TO cashsources START - WRITING DATA TO countries FINISH - WRITING DATA TO countries START - WRITING DATA TO customerassignments FINISH - WRITING DATA TO customerassignments START - WRITING DATA TO customercontacts FINISH - WRITING DATA TO customercontacts START - WRITING DATA TO customergroups FINISH - WRITING DATA TO customergroups START - WRITING DATA TO customers FINISH - WRITING DATA TO customers START - WRITING DATA TO customersview FINISH - WRITING DATA TO customersview START - WRITING DATA TO daemonconfig FINISH - WRITING DATA TO daemonconfig START - WRITING DATA TO daemoninstances FINISH - WRITING DATA TO daemoninstances START - WRITING DATA TO dbinfo FINISH - WRITING DATA TO dbinfo START - WRITING DATA TO debitnotecontents FINISH - WRITING DATA TO debitnotecontents START - WRITING DATA TO divisions FINISH - WRITING DATA TO divisions START - WRITING DATA TO docrights FINISH - WRITING DATA TO docrights START - WRITING DATA TO documentcontents FINISH - WRITING DATA TO documentcontents START - WRITING DATA TO documents 7084.47 rows/sec [120000] FINISH - WRITING DATA TO documents START - WRITING DATA TO domains FINISH - WRITING DATA TO domains START - WRITING DATA TO eventassignments FINISH - WRITING DATA TO eventassignments START - WRITING DATA TO events FINISH - WRITING DATA TO events START - WRITING DATA TO ewx_channels FINISH - WRITING DATA TO ewx_channels START - WRITING DATA TO ewx_pt_config FINISH - WRITING DATA TO ewx_pt_config START - WRITING DATA TO ewx_stm_channels FINISH - WRITING DATA TO ewx_stm_channels START - WRITING DATA TO ewx_stm_nodes FINISH - WRITING DATA TO ewx_stm_nodes START - WRITING DATA TO excludedgroups FINISH - WRITING DATA TO excludedgroups START - WRITING DATA TO hosts FINISH - WRITING DATA TO hosts START - WRITING DATA TO imessengers FINISH - WRITING DATA TO imessengers START - WRITING DATA TO invoicecontents 8713.26 rows/sec [100000] FINISH - WRITING DATA TO invoicecontents START - WRITING DATA TO liabilities FINISH - WRITING DATA TO liabilities START - WRITING DATA TO macs FINISH - WRITING DATA TO macs START - WRITING DATA TO messageitems FINISH - WRITING DATA TO messageitems START - WRITING DATA TO messages FINISH - WRITING DATA TO messages START - WRITING DATA TO nastypes FINISH - WRITING DATA TO nastypes START - WRITING DATA TO netdevices FINISH - WRITING DATA TO netdevices START - WRITING DATA TO netlinks FINISH - WRITING DATA TO netlinks START - WRITING DATA TO networks FINISH - WRITING DATA TO networks START - WRITING DATA TO nodeassignments FINISH - WRITING DATA TO nodeassignments START - WRITING DATA TO nodegroupassignments FINISH - WRITING DATA TO nodegroupassignments START - WRITING DATA TO nodegroups FINISH - WRITING DATA TO nodegroups START - WRITING DATA TO nodes FINISH - WRITING DATA TO nodes START - WRITING DATA TO numberplanassignments FINISH - WRITING DATA TO numberplanassignments START - WRITING DATA TO numberplans FINISH - WRITING DATA TO numberplans START - WRITING DATA TO passwd FINISH - WRITING DATA TO passwd START - WRITING DATA TO payments FINISH - WRITING DATA TO payments START - WRITING DATA TO promotionassignments FINISH - WRITING DATA TO promotionassignments START - WRITING DATA TO promotions FINISH - WRITING DATA TO promotions START - WRITING DATA TO promotionschemas FINISH - WRITING DATA TO promotionschemas START - WRITING DATA TO receiptcontents 16936.79 rows/sec [40000] FINISH - WRITING DATA TO receiptcontents START - WRITING DATA TO records FINISH - WRITING DATA TO records START - WRITING DATA TO rtattachments FINISH - WRITING DATA TO rtattachments START - WRITING DATA TO rtmessages FINISH - WRITING DATA TO rtmessages START - WRITING DATA TO rtnotes FINISH - WRITING DATA TO rtnotes START - WRITING DATA TO rtqueues FINISH - WRITING DATA TO rtqueues START - WRITING DATA TO rtrights FINISH - WRITING DATA TO rtrights START - WRITING DATA TO rttickets FINISH - WRITING DATA TO rttickets START - WRITING DATA TO sessions FINISH - WRITING DATA TO sessions START - WRITING DATA TO sourcefiles FINISH - WRITING DATA TO sourcefiles START - WRITING DATA TO states FINISH - WRITING DATA TO states START - WRITING DATA TO stats FINISH - WRITING DATA TO stats START - WRITING DATA TO supermasters FINISH - WRITING DATA TO supermasters START - WRITING DATA TO tariffs FINISH - WRITING DATA TO tariffs START - WRITING DATA TO taxes FINISH - WRITING DATA TO taxes START - WRITING DATA TO uiconfig FINISH - WRITING DATA TO uiconfig START - WRITING DATA TO up_customers FINISH - WRITING DATA TO up_customers START - WRITING DATA TO up_help FINISH - WRITING DATA TO up_help START - WRITING DATA TO up_info_changes FINISH - WRITING DATA TO up_info_changes START - WRITING DATA TO up_rights FINISH - WRITING DATA TO up_rights START - WRITING DATA TO up_rights_assignments FINISH - WRITING DATA TO up_rights_assignments START - WRITING DATA TO users FINISH - WRITING DATA TO users START - WRITING DATA TO vmacs FINISH - WRITING DATA TO vmacs START - WRITING DATA TO vnodes FINISH - WRITING DATA TO vnodes START - WRITING DATA TO vnodes_mac FINISH - WRITING DATA TO vnodes_mac START - WRITING DATA TO voipaccounts FINISH - WRITING DATA TO voipaccounts START - WRITING DATA TO zipcodes FINISH - WRITING DATA TO zipcodes DONE WRITING TABLE DATA START CREATING INDEXES AND CONSTRAINTS START - ADDING INDEXES TO aliasassignments FINISH - ADDING INDEXES TO aliasassignments START - ADDING INDEXES TO aliases FINISH - ADDING INDEXES TO aliases START - ADDING INDEXES TO assignments FINISH - ADDING INDEXES TO assignments START - ADDING INDEXES TO cash FINISH - ADDING INDEXES TO cash START - ADDING INDEXES TO cashimport FINISH - ADDING INDEXES TO cashimport START - ADDING INDEXES TO cashreglog FINISH - ADDING INDEXES TO cashreglog START - ADDING INDEXES TO cashregs FINISH - ADDING INDEXES TO cashregs START - ADDING INDEXES TO cashrights FINISH - ADDING INDEXES TO cashrights START - ADDING INDEXES TO cashsources FINISH - ADDING INDEXES TO cashsources START - ADDING INDEXES TO countries FINISH - ADDING INDEXES TO countries START - ADDING INDEXES TO customerassignments FINISH - ADDING INDEXES TO customerassignments START - ADDING INDEXES TO customercontacts FINISH - ADDING INDEXES TO customercontacts START - ADDING INDEXES TO customergroups FINISH - ADDING INDEXES TO customergroups START - ADDING INDEXES TO customers FINISH - ADDING INDEXES TO customers START - ADDING INDEXES TO customersview FINISH - ADDING INDEXES TO customersview START - ADDING INDEXES TO daemonconfig FINISH - ADDING INDEXES TO daemonconfig START - ADDING INDEXES TO daemoninstances FINISH - ADDING INDEXES TO daemoninstances START - ADDING INDEXES TO dbinfo FINISH - ADDING INDEXES TO dbinfo START - ADDING INDEXES TO debitnotecontents FINISH - ADDING INDEXES TO debitnotecontents START - ADDING INDEXES TO divisions FINISH - ADDING INDEXES TO divisions START - ADDING INDEXES TO docrights FINISH - ADDING INDEXES TO docrights START - ADDING INDEXES TO documentcontents FINISH - ADDING INDEXES TO documentcontents START - ADDING INDEXES TO documents FINISH - ADDING INDEXES TO documents START - ADDING INDEXES TO domains FINISH - ADDING INDEXES TO domains START - ADDING INDEXES TO eventassignments FINISH - ADDING INDEXES TO eventassignments START - ADDING INDEXES TO events FINISH - ADDING INDEXES TO events START - ADDING INDEXES TO ewx_channels FINISH - ADDING INDEXES TO ewx_channels START - ADDING INDEXES TO ewx_pt_config FINISH - ADDING INDEXES TO ewx_pt_config START - ADDING INDEXES TO ewx_stm_channels FINISH - ADDING INDEXES TO ewx_stm_channels START - ADDING INDEXES TO ewx_stm_nodes FINISH - ADDING INDEXES TO ewx_stm_nodes START - ADDING INDEXES TO excludedgroups FINISH - ADDING INDEXES TO excludedgroups START - ADDING INDEXES TO hosts FINISH - ADDING INDEXES TO hosts START - ADDING INDEXES TO imessengers FINISH - ADDING INDEXES TO imessengers START - ADDING INDEXES TO invoicecontents FINISH - ADDING INDEXES TO invoicecontents START - ADDING INDEXES TO liabilities FINISH - ADDING INDEXES TO liabilities START - ADDING INDEXES TO macs FINISH - ADDING INDEXES TO macs START - ADDING INDEXES TO messageitems FINISH - ADDING INDEXES TO messageitems START - ADDING INDEXES TO messages FINISH - ADDING INDEXES TO messages START - ADDING INDEXES TO nastypes FINISH - ADDING INDEXES TO nastypes START - ADDING INDEXES TO netdevices FINISH - ADDING INDEXES TO netdevices START - ADDING INDEXES TO netlinks FINISH - ADDING INDEXES TO netlinks START - ADDING INDEXES TO networks FINISH - ADDING INDEXES TO networks START - ADDING INDEXES TO nodeassignments FINISH - ADDING INDEXES TO nodeassignments START - ADDING INDEXES TO nodegroupassignments FINISH - ADDING INDEXES TO nodegroupassignments START - ADDING INDEXES TO nodegroups FINISH - ADDING INDEXES TO nodegroups START - ADDING INDEXES TO nodes FINISH - ADDING INDEXES TO nodes START - ADDING INDEXES TO numberplanassignments FINISH - ADDING INDEXES TO numberplanassignments START - ADDING INDEXES TO numberplans FINISH - ADDING INDEXES TO numberplans START - ADDING INDEXES TO passwd FINISH - ADDING INDEXES TO passwd START - ADDING INDEXES TO payments FINISH - ADDING INDEXES TO payments START - ADDING INDEXES TO promotionassignments FINISH - ADDING INDEXES TO promotionassignments START - ADDING INDEXES TO promotions FINISH - ADDING INDEXES TO promotions START - ADDING INDEXES TO promotionschemas FINISH - ADDING INDEXES TO promotionschemas START - ADDING INDEXES TO receiptcontents FINISH - ADDING INDEXES TO receiptcontents START - ADDING INDEXES TO records FINISH - ADDING INDEXES TO records START - ADDING INDEXES TO rtattachments FINISH - ADDING INDEXES TO rtattachments START - ADDING INDEXES TO rtmessages FINISH - ADDING INDEXES TO rtmessages START - ADDING INDEXES TO rtnotes FINISH - ADDING INDEXES TO rtnotes START - ADDING INDEXES TO rtqueues FINISH - ADDING INDEXES TO rtqueues START - ADDING INDEXES TO rtrights FINISH - ADDING INDEXES TO rtrights START - ADDING INDEXES TO rttickets FINISH - ADDING INDEXES TO rttickets START - ADDING INDEXES TO sessions FINISH - ADDING INDEXES TO sessions START - ADDING INDEXES TO sourcefiles FINISH - ADDING INDEXES TO sourcefiles START - ADDING INDEXES TO states FINISH - ADDING INDEXES TO states START - ADDING INDEXES TO stats FINISH - ADDING INDEXES TO stats START - ADDING INDEXES TO supermasters FINISH - ADDING INDEXES TO supermasters START - ADDING INDEXES TO tariffs FINISH - ADDING INDEXES TO tariffs START - ADDING INDEXES TO taxes FINISH - ADDING INDEXES TO taxes START - ADDING INDEXES TO uiconfig FINISH - ADDING INDEXES TO uiconfig START - ADDING INDEXES TO up_customers FINISH - ADDING INDEXES TO up_customers START - ADDING INDEXES TO up_help FINISH - ADDING INDEXES TO up_help START - ADDING INDEXES TO up_info_changes FINISH - ADDING INDEXES TO up_info_changes START - ADDING INDEXES TO up_rights FINISH - ADDING INDEXES TO up_rights START - ADDING INDEXES TO up_rights_assignments FINISH - ADDING INDEXES TO up_rights_assignments START - ADDING INDEXES TO users FINISH - ADDING INDEXES TO users START - ADDING INDEXES TO vmacs FINISH - ADDING INDEXES TO vmacs START - ADDING INDEXES TO vnodes FINISH - ADDING INDEXES TO vnodes START - ADDING INDEXES TO vnodes_mac FINISH - ADDING INDEXES TO vnodes_mac START - ADDING INDEXES TO voipaccounts FINISH - ADDING INDEXES TO voipaccounts START - ADDING INDEXES TO zipcodes FINISH - ADDING INDEXES TO zipcodes START - ADDING CONSTRAINTS ON aliasassignments FINISH - ADDING CONSTRAINTS ON aliasassignments START - ADDING CONSTRAINTS ON aliases FINISH - ADDING CONSTRAINTS ON aliases START - ADDING CONSTRAINTS ON assignments FINISH - ADDING CONSTRAINTS ON assignments START - ADDING CONSTRAINTS ON cash FINISH - ADDING CONSTRAINTS ON cash START - ADDING CONSTRAINTS ON cashimport FINISH - ADDING CONSTRAINTS ON cashimport START - ADDING CONSTRAINTS ON cashreglog FINISH - ADDING CONSTRAINTS ON cashreglog START - ADDING CONSTRAINTS ON cashregs FINISH - ADDING CONSTRAINTS ON cashregs START - ADDING CONSTRAINTS ON cashrights FINISH - ADDING CONSTRAINTS ON cashrights START - ADDING CONSTRAINTS ON cashsources FINISH - ADDING CONSTRAINTS ON cashsources START - ADDING CONSTRAINTS ON countries FINISH - ADDING CONSTRAINTS ON countries START - ADDING CONSTRAINTS ON customerassignments FINISH - ADDING CONSTRAINTS ON customerassignments START - ADDING CONSTRAINTS ON customercontacts FINISH - ADDING CONSTRAINTS ON customercontacts START - ADDING CONSTRAINTS ON customergroups FINISH - ADDING CONSTRAINTS ON customergroups START - ADDING CONSTRAINTS ON customers FINISH - ADDING CONSTRAINTS ON customers START - ADDING CONSTRAINTS ON customersview FINISH - ADDING CONSTRAINTS ON customersview START - ADDING CONSTRAINTS ON daemonconfig FINISH - ADDING CONSTRAINTS ON daemonconfig START - ADDING CONSTRAINTS ON daemoninstances FINISH - ADDING CONSTRAINTS ON daemoninstances START - ADDING CONSTRAINTS ON dbinfo FINISH - ADDING CONSTRAINTS ON dbinfo START - ADDING CONSTRAINTS ON debitnotecontents FINISH - ADDING CONSTRAINTS ON debitnotecontents START - ADDING CONSTRAINTS ON divisions FINISH - ADDING CONSTRAINTS ON divisions START - ADDING CONSTRAINTS ON docrights FINISH - ADDING CONSTRAINTS ON docrights START - ADDING CONSTRAINTS ON documentcontents FINISH - ADDING CONSTRAINTS ON documentcontents START - ADDING CONSTRAINTS ON documents FINISH - ADDING CONSTRAINTS ON documents START - ADDING CONSTRAINTS ON domains FINISH - ADDING CONSTRAINTS ON domains START - ADDING CONSTRAINTS ON eventassignments FINISH - ADDING CONSTRAINTS ON eventassignments START - ADDING CONSTRAINTS ON events FINISH - ADDING CONSTRAINTS ON events START - ADDING CONSTRAINTS ON ewx_channels FINISH - ADDING CONSTRAINTS ON ewx_channels START - ADDING CONSTRAINTS ON ewx_pt_config FINISH - ADDING CONSTRAINTS ON ewx_pt_config START - ADDING CONSTRAINTS ON ewx_stm_channels FINISH - ADDING CONSTRAINTS ON ewx_stm_channels START - ADDING CONSTRAINTS ON ewx_stm_nodes FINISH - ADDING CONSTRAINTS ON ewx_stm_nodes START - ADDING CONSTRAINTS ON excludedgroups FINISH - ADDING CONSTRAINTS ON excludedgroups START - ADDING CONSTRAINTS ON hosts FINISH - ADDING CONSTRAINTS ON hosts START - ADDING CONSTRAINTS ON imessengers FINISH - ADDING CONSTRAINTS ON imessengers START - ADDING CONSTRAINTS ON invoicecontents FINISH - ADDING CONSTRAINTS ON invoicecontents START - ADDING CONSTRAINTS ON liabilities FINISH - ADDING CONSTRAINTS ON liabilities START - ADDING CONSTRAINTS ON macs FINISH - ADDING CONSTRAINTS ON macs START - ADDING CONSTRAINTS ON messageitems FINISH - ADDING CONSTRAINTS ON messageitems START - ADDING CONSTRAINTS ON messages FINISH - ADDING CONSTRAINTS ON messages START - ADDING CONSTRAINTS ON nastypes FINISH - ADDING CONSTRAINTS ON nastypes START - ADDING CONSTRAINTS ON netdevices FINISH - ADDING CONSTRAINTS ON netdevices START - ADDING CONSTRAINTS ON netlinks FINISH - ADDING CONSTRAINTS ON netlinks START - ADDING CONSTRAINTS ON networks FINISH - ADDING CONSTRAINTS ON networks START - ADDING CONSTRAINTS ON nodeassignments FINISH - ADDING CONSTRAINTS ON nodeassignments START - ADDING CONSTRAINTS ON nodegroupassignments FINISH - ADDING CONSTRAINTS ON nodegroupassignments START - ADDING CONSTRAINTS ON nodegroups FINISH - ADDING CONSTRAINTS ON nodegroups START - ADDING CONSTRAINTS ON nodes FINISH - ADDING CONSTRAINTS ON nodes START - ADDING CONSTRAINTS ON numberplanassignments FINISH - ADDING CONSTRAINTS ON numberplanassignments START - ADDING CONSTRAINTS ON numberplans FINISH - ADDING CONSTRAINTS ON numberplans START - ADDING CONSTRAINTS ON passwd FINISH - ADDING CONSTRAINTS ON passwd START - ADDING CONSTRAINTS ON payments FINISH - ADDING CONSTRAINTS ON payments START - ADDING CONSTRAINTS ON promotionassignments FINISH - ADDING CONSTRAINTS ON promotionassignments START - ADDING CONSTRAINTS ON promotions FINISH - ADDING CONSTRAINTS ON promotions START - ADDING CONSTRAINTS ON promotionschemas FINISH - ADDING CONSTRAINTS ON promotionschemas START - ADDING CONSTRAINTS ON receiptcontents FINISH - ADDING CONSTRAINTS ON receiptcontents START - ADDING CONSTRAINTS ON records FINISH - ADDING CONSTRAINTS ON records START - ADDING CONSTRAINTS ON rtattachments FINISH - ADDING CONSTRAINTS ON rtattachments START - ADDING CONSTRAINTS ON rtmessages FINISH - ADDING CONSTRAINTS ON rtmessages START - ADDING CONSTRAINTS ON rtnotes FINISH - ADDING CONSTRAINTS ON rtnotes START - ADDING CONSTRAINTS ON rtqueues FINISH - ADDING CONSTRAINTS ON rtqueues START - ADDING CONSTRAINTS ON rtrights FINISH - ADDING CONSTRAINTS ON rtrights START - ADDING CONSTRAINTS ON rttickets FINISH - ADDING CONSTRAINTS ON rttickets START - ADDING CONSTRAINTS ON sessions FINISH - ADDING CONSTRAINTS ON sessions START - ADDING CONSTRAINTS ON sourcefiles FINISH - ADDING CONSTRAINTS ON sourcefiles START - ADDING CONSTRAINTS ON states FINISH - ADDING CONSTRAINTS ON states START - ADDING CONSTRAINTS ON stats FINISH - ADDING CONSTRAINTS ON stats START - ADDING CONSTRAINTS ON supermasters FINISH - ADDING CONSTRAINTS ON supermasters START - ADDING CONSTRAINTS ON tariffs FINISH - ADDING CONSTRAINTS ON tariffs START - ADDING CONSTRAINTS ON taxes FINISH - ADDING CONSTRAINTS ON taxes START - ADDING CONSTRAINTS ON uiconfig FINISH - ADDING CONSTRAINTS ON uiconfig START - ADDING CONSTRAINTS ON up_customers FINISH - ADDING CONSTRAINTS ON up_customers START - ADDING CONSTRAINTS ON up_help FINISH - ADDING CONSTRAINTS ON up_help START - ADDING CONSTRAINTS ON up_info_changes FINISH - ADDING CONSTRAINTS ON up_info_changes START - ADDING CONSTRAINTS ON up_rights FINISH - ADDING CONSTRAINTS ON up_rights START - ADDING CONSTRAINTS ON up_rights_assignments FINISH - ADDING CONSTRAINTS ON up_rights_assignments START - ADDING CONSTRAINTS ON users FINISH - ADDING CONSTRAINTS ON users START - ADDING CONSTRAINTS ON vmacs FINISH - ADDING CONSTRAINTS ON vmacs START - ADDING CONSTRAINTS ON vnodes FINISH - ADDING CONSTRAINTS ON vnodes START - ADDING CONSTRAINTS ON vnodes_mac FINISH - ADDING CONSTRAINTS ON vnodes_mac START - ADDING CONSTRAINTS ON voipaccounts FINISH - ADDING CONSTRAINTS ON voipaccounts START - ADDING CONSTRAINTS ON zipcodes FINISH - ADDING CONSTRAINTS ON zipcodes DONE CREATING INDEXES AND CONSTRAINTS >>>>>>>>>> FINISHED <<<<<<<<<< #v- Zadowolony, że nie było błędów odpalam przeglądarke z lms a tu na dole widzę błąd: #v+ Napotkano błędy w bazie danych! Zapytanie: SELECT section, var, value FROM uiconfig WHERE disabled=0 Błąd: ERROR: operator does not exist: boolean = integer LINE 1: SELECT section, var, value FROM uiconfig WHERE disabled=0 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. #v- który powoduje, że nie mogę się nawet zalogować #v+ Napotkano błędy w bazie danych! Zapytanie: SELECT section, var, value FROM uiconfig WHERE disabled=0 Błąd: ERROR: operator does not exist: boolean = integer LINE 1: SELECT section, var, value FROM uiconfig WHERE disabled=0 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. Zapytanie: SELECT id, name, passwd, hosts, lastlogindate, lastloginip FROM users WHERE login='marceli' AND deleted=0 Błąd: ERROR: operator does not exist: boolean = integer LINE 2: FROM users WHERE login='marceli' AND deleted=0 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. #v- jak przeglądam bazę z phppgadmina (niestety jesze nie znam dobrze interfesju postgresa) to widzę, iż zniknęły widoki. może będzie ktoś tak dobry i podpowie step by step jak bezboleśnie przebrnąć przez migracje? -- Pozdrawiam Marcin / nicraM

3 5

coś co można uznać na nową wersję LMS-a numerowaną jako 1.11.14
by Tomasz Chiliński 17 Maj '13

17 Maj '13

Witam, Dziś oznaczyłem wersję z 24 kwietnia 2013 w github.com jako wersję 1.11.14: https://github.com/lmsgit/lms/tree/LMS_011114 Jako, że późniejsze zmiany w LMS są bardzo inwazyjne uznałem, że będzie najlepiej jak da się trochę odetchnąć użytkownikom LMS-a korzystając z tego w miarę stabilnej migawki. Jest to wyłącznie znacznik (tag) w repozytorium git, a bieżące poprawki będą nanoszone wyłącznie w bieżącej gałęzi master. Zapraszam to testów wersji bieżących z gałęzi master, a kto nie ma na to czasu, może pozostać przy wersji dzisiaj oznakowanej właśnie jako LMS_011114. -- Pozdrawiam Tomasz Chiliński, Chilan

10 25

Re: [lms] szablon faktury z druczkiem wpłaty
by Sławomir Paszkiewicz 17 Maj '13

17 Maj '13

W dniu 17.05.2013 14:48, Michał Bochniak pisze: > > Witam > > Poratuje ktoś działającym szablonem faktury z druczkiem wpłaty > pod dirę? > > Potrzebuję aby na fakturze wyświetlał się numer indywidualny > konta każdego klienta. > > No to wywalasz ze stopki/opisu numer konta i w szablonie masz > bankaccount > > Dokładniej, to w Konfiguracja>Firmy (Oddziały) > Firma > "Stopka > faktury" dodałem %bankaccount jako informację, ale same numery konta w > druczku pojawiają się automatycznie. > > Ok tylko przy standardowym szablonie nie mam ani druczka wpłaty a > dodając samo %bankaccount w stopce na fakturze mam %bankaccount > > > > _______________________________________________ > lms mailing list > lms(a)lists.lms.org.pl > http://lists.lms.org.pl/mailman/listinfo/lms Konfiguracja>Interfejs uzytkownika>template_file: FT-0100 i będzie ten druczek. Co do %bankaccount to musiałbyś sprawdzić czy to nie weszło w wersji GIT. Jeśli tak - upgraduj lub tylko tę zmianę przeportuj :)

2 1

Re: [lms] szablon faktury z druczkiem wpłaty
by Sławomir Paszkiewicz 17 Maj '13

17 Maj '13

W dniu 17.05.2013 13:54, Michał Bochniak pisze: > > Witam > > Poratuje ktoś działającym szablonem faktury z druczkiem wpłaty pod dirę? > > Potrzebuję aby na fakturze wyświetlał się numer indywidualny konta > każdego klienta. > > .................. > pozdrawiam > Bochniak Michał > cid:image001.jpg@01CD1E7D.65413550 > *Zapnet Spółka Jawna* > ul. Leśna 1 > 63-430 Odolanów > tel.: +48 62 597 70 83 > fax: +48 62 597 70 93 > kom.: +48 502 531 940 > email: michal.bochniak(a)zapnet.pl <mailto:michal.bochniak@zapnet.pl> > www.zapnet.pl <http://www.zapnet.pl/> > > > > _______________________________________________ > lms mailing list > lms(a)lists.lms.org.pl > http://lists.lms.org.pl/mailman/listinfo/lms No to wywalasz ze stopki/opisu numer konta i w szablonie masz bankaccount

2 2

szablon faktury z druczkiem wpłaty
by Michał Bochniak 17 Maj '13

17 Maj '13

Witam Poratuje ktoś działającym szablonem faktury z druczkiem wpłaty pod dirę? Potrzebuję aby na fakturze wyświetlał się numer indywidualny konta każdego klienta. bochniak.malpa.onet.eu

1 0

szablon faktury z druczkiem wpłaty
by Michał Bochniak 17 Maj '13

17 Maj '13

Witam Poratuje ktoś działającym szablonem faktury z druczkiem wpłaty pod dirę? Potrzebuję aby na fakturze wyświetlał się numer indywidualny konta każdego klienta. .................. pozdrawiam Bochniak Michał cid:image001.jpg@01CD1E7D.65413550 Zapnet Spółka Jawna ul. Leśna 1 63-430 Odolanów tel.: +48 62 597 70 83 fax: +48 62 597 70 93 kom.: +48 502 531 940 email: <mailto:michal.bochniak@zapnet.pl> michal.bochniak(a)zapnet.pl <http://www.zapnet.pl/> www.zapnet.pl

1 0

Odp: Problem z bazą lms
by mis misiowy 16 Maj '13

16 Maj '13

7 9

Problem z bazą lms
by Sliw.net 14 Maj '13

14 Maj '13

Witam, mam prośbe, wczoraj w rannych godzinach wpolnik chciał dostać się standardowo do lmsa, a ten powitał go kominikatem o błedzie bazy danych ( niestety nie mam tego komunikatu ) natomiast teraz skrypt wpuszcza bez hasła i brak w nim danych . Czy możecie coś pomóc ?

2 1

Usunięcie klienta-usuniete komputery i zobowiązania
by LoLe 13 Maj '13

13 Maj '13

Czy mógby ktoś uzasadnić dlaczego usunięcie klienta powoduje usunięcie również komputerów i zobowiązań? Przypuszczam że z komputerami to pewnei kwestia mac i ip, które były by zajęte, ale to można było by jakoś obsłużyć komunikatami.

5 7

integracja PNA z LMS (kontynuacja)
by Tomasz Chiliński 11 Maj '13

11 Maj '13

Witam, co Wy na to, żeby w końcu dalej to ruszyć? http://www.poczta-polska.pl/spis-pna/ W sumie za 122 zł rocznie można mieć ten spis w sensownej postaci txt i wtedy pewnie mój skrypt lms-pna.php lepiej z tym sobie poradzi. Są chętni na zrzutkę na roczny abonament PNA w PP? ;-) -- Pozdrawiam Tomasz Chiliński, Chilan

5 7