abc icon indicating copy to clipboard operation
abc copied to clipboard

Not able to import View as table from PostgreSQL

Open manjunathkadrolli opened this issue 3 years ago • 1 comments

Version Version: 1.0.0-beta.1 Variant: !oss Go version: go1.12.5 OS: linux

I am trying to import a view as table, upon which i am not seeing any warning/message on the CLI Below are the logs with log enabled.

@* ~ % abc import --src_type=postgres --src_uri="postgresql://:@.:5442/” --src_filter="v_ETLOffer" "https://:-[email protected]" --log.level="info" time="2020-08-10T12:26:28Z" level=info msg="Created temp file pipeline_1597062388589677100.js" time="2020-08-10T12:26:28Z" level=info msg="postgres uri: postgresql://:@..com:5442/?sslmode=disable" time="2020-08-10T12:26:29Z" level=info msg="ES Version: 7.7.1" time="2020-08-10T12:26:30Z" level=info msg="starting with metadata map[]" name=source path=source type=postgres time="2020-08-10T12:26:30Z" level=info msg="adaptor Starting..." name=source path=source type=postgres time="2020-08-10T12:26:30Z" level=info msg="boot map[sink:elasticsearch source:postgres]" ts=1597062390301761900 time="2020-08-10T12:26:30Z" level=info msg="adaptor Listening..." name=sink path=source/sink type=elasticsearch time="2020-08-10T12:26:31Z" level=info msg="starting Read func" db= time="2020-08-10T12:26:32Z" level=info msg="done iterating collections" db=***** time="2020-08-10T12:26:32Z" level=info msg="Read completed" db=***** time="2020-08-10T12:26:32Z" level=info msg="adaptor Start finished..." name=source path=source type=postgres time="2020-08-10T12:26:32Z" level=info msg="adaptor Stopping..." name=source path=source type=postgres time="2020-08-10T12:26:32Z" level=info msg="adaptor Stopped" name=source path=source type=postgres time="2020-08-10T12:26:32Z" level=info msg="closing connection..." name=source path=source type=postgres time="2020-08-10T12:26:32Z" level=info msg="connection closed..." name=source path=source type=postgres time="2020-08-10T12:26:32Z" level=info msg="adaptor Stopping..." name=sink path=source/sink type=elasticsearch time="2020-08-10T12:26:32Z" level=info msg="received stop, message buffer is empty, closing..." time="2020-08-10T12:26:32Z" level=info msg="adaptor Listen closed..." name=sink path=source/sink type=elasticsearch time="2020-08-10T12:26:32Z" level=info msg="adaptor Stopped" name=sink path=source/sink type=elasticsearch time="2020-08-10T12:26:32Z" level=info msg="closing connection..." name=sink path=source/sink type=elasticsearch time="2020-08-10T12:26:32Z" level=info msg="connection closed..." name=sink path=source/sink type=elasticsearch time="2020-08-10T12:26:32Z" level=info msg="closing writer..." name=sink path=source/sink type=elasticsearch time="2020-08-10T12:26:32Z" level=info msg="closing BulkService" version=7 writer=elasticsearch time="2020-08-10T12:26:32Z" level=info msg="writer closed..." name=sink path=source/sink type=elasticsearch time="2020-08-10T12:26:32Z" level=info msg="metrics source records: 0" path=source ts=1597062392087403600 time="2020-08-10T12:26:32Z" level=info msg="metrics source/sink records: 0" path=source/sink ts=1597062392087442400 time="2020-08-10T12:26:32Z" level=info msg="exit map[sink:elasticsearch source:postgres]" ts=1597062392087475600

manjunathkadrolli avatar Aug 10 '20 13:08 manjunathkadrolli

@manjunathkadrolli did you ever find a workaround for this?

machty avatar Nov 15 '22 16:11 machty