[lms] migracja mysql to postres

18 Maj 2013


      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@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