s
user
10/01/2020, 11:44 PMuser
10/01/2020, 11:44 PM➜ ~ /usr/local/lib/singer/tap-postgres/bin/tap-postgres -c ~/Desktop/config.json --properties catalog.json
INFO User postgres connected with SSL = False
INFO Selected streams: ['postgres-public-id_and_name', 'postgres-public-id_and_name2']
INFO No currently_syncing found
INFO Beginning sync of stream(postgres-public-id_and_name) with sync method(full)
INFO Stream postgres-public-id_and_name is using full_table replication
{"type": "SCHEMA", "stream": "id_and_name", "schema": {"type": "object", "properties": {"id": {"type": ["null", "integer"], "minimum": -2147483648, "maximum": 2147483647}, "name": {"type": ["null", "string"], "maxLength": 200}}, "definitions": {"sdc_recursive_integer_array": {"type": ["null", "integer", "array"], "items": {"$ref": "#/definitions/sdc_recursive_integer_array"}}, "sdc_recursive_number_array": {"type": ["null", "number", "array"], "items": {"$ref": "#/definitions/sdc_recursive_number_array"}}, "sdc_recursive_string_array": {"type": ["null", "string", "array"], "items": {"$ref": "#/definitions/sdc_recursive_string_array"}}, "sdc_recursive_boolean_array": {"type": ["null", "boolean", "array"], "items": {"$ref": "#/definitions/sdc_recursive_boolean_array"}}, "sdc_recursive_timestamp_array": {"type": ["null", "string", "array"], "format": "date-time", "items": {"$ref": "#/definitions/sdc_recursive_timestamp_array"}}, "sdc_recursive_object_array": {"type": ["null", "object", "array"], "items": {"$ref": "#/definitions/sdc_recursive_object_array"}}}}, "key_properties": [], "bookmark_properties": []}
{"type": "STATE", "value": {"bookmarks": {"postgres-public-id_and_name": {"last_replication_method": "FULL_TABLE", "version": 1601595489854}, "postgres-public-id_and_name2": {"last_replication_method": "FULL_TABLE"}}, "currently_syncing": "postgres-public-id_and_name"}}
{"type": "ACTIVATE_VERSION", "stream": "id_and_name", "version": 1601595489854}
INFO Current Server Encoding: UTF8
INFO Current Client Encoding: UTF8
INFO hstore is UNavailable
INFO Beginning new Full Table replication 1601595489854
INFO select SELECT "id" , "name" , xmin::text::bigint
FROM "public"."id_and_name"
ORDER BY xmin::text::bigint ASC with itersize 20000
{"type": "RECORD", "stream": "id_and_name", "record": {"id": 1, "name": "2013"}, "version": 1601595489854, "time_extracted": "2020-10-01T23:38:09.854558Z"}
{"type": "RECORD", "stream": "id_and_name", "record": {"id": 1, "name": "2013"}, "version": 1601595489854, "time_extracted": "2020-10-01T23:38:09.854558Z"}
INFO METRIC: {"type": "counter", "metric": "record_count", "value": 2, "tags": {}}
{"type": "ACTIVATE_VERSION", "stream": "id_and_name", "version": 1601595489854}
{"type": "STATE", "value": {"bookmarks": {"postgres-public-id_and_name": {"last_replication_method": "FULL_TABLE", "version": 1601595489854, "xmin": null}, "postgres-public-id_and_name2": {"last_replication_method": "FULL_TABLE"}}, "currently_syncing": null}}
INFO Beginning sync of stream(postgres-public-id_and_name2) with sync method(full)
INFO Stream postgres-public-id_and_name2 is using full_table replication
{"type": "SCHEMA", "stream": "id_and_name2", "schema": {"type": "object", "properties": {"id": {"type": ["null", "integer"], "minimum": -2147483648, "maximum": 2147483647}, "name": {"type": ["null", "string"], "maxLength": 200}}, "definitions": {"sdc_recursive_integer_array": {"type": ["null", "integer", "array"], "items": {"$ref": "#/definitions/sdc_recursive_integer_array"}}, "sdc_recursive_number_array": {"type": ["null", "number", "array"], "items": {"$ref": "#/definitions/sdc_recursive_number_array"}}, "sdc_recursive_string_array": {"type": ["null", "string", "array"], "items": {"$ref": "#/definitions/sdc_recursive_string_array"}}, "sdc_recursive_boolean_array": {"type": ["null", "boolean", "array"], "items": {"$ref": "#/definitions/sdc_recursive_boolean_array"}}, "sdc_recursive_timestamp_array": {"type": ["null", "string", "array"], "format": "date-time", "items": {"$ref": "#/definitions/sdc_recursive_timestamp_array"}}, "sdc_recursive_object_array": {"type": ["null", "object", "array"], "items": {"$ref": "#/definitions/sdc_recursive_object_array"}}}}, "key_properties": [], "bookmark_properties": []}
{"type": "STATE", "value": {"bookmarks": {"postgres-public-id_and_name": {"last_replication_method": "FULL_TABLE", "version": 1601595489854, "xmin": null}, "postgres-public-id_and_name2": {"last_replication_method": "FULL_TABLE", "version": 1601595489900}}, "currently_syncing": "postgres-public-id_and_name2"}}
{"type": "ACTIVATE_VERSION", "stream": "id_and_name2", "version": 1601595489900}
INFO Current Server Encoding: UTF8
INFO Current Client Encoding: UTF8
INFO hstore is UNavailable
INFO Beginning new Full Table replication 1601595489900
INFO select SELECT "id" , "name" , xmin::text::bigint
FROM "public"."id_and_name2"
ORDER BY xmin::text::bigint ASC with itersize 20000
INFO METRIC: {"type": "counter", "metric": "record_count", "value": 0, "tags": {}}
{"type": "ACTIVATE_VERSION", "stream": "id_and_name2", "version": 1601595489900}
{"type": "STATE", "value": {"bookmarks": {"postgres-public-id_and_name": {"last_replication_method": "FULL_TABLE", "version": 1601595489854, "xmin": null}, "postgres-public-id_and_name2": {"last_replication_method": "FULL_TABLE", "version": 1601595489900, "xmin": null}}, "currently_syncing": null}}
user
10/01/2020, 11:45 PM