Is this your first time deploying Airbyte yes OS V...
# troubleshooting
u
Is this your first time deploying Airbyte yes OS Version / Instance Mac Memory / Disk 32G/1T Deployment docker Airbyte Version v0.35.28-alpha Source name/version Postgres 9.6.13 Destination name/version Postgres 13 Step Setting up the connection Description Hi all - i’m trying to setup connection between one postgres and another and my source postgres only has views (no tables - it’s long story) im reading the postgres docs and it says it supports replicating views but under the “Select the data you want to sync” there are no rows so doesnt seem to be picking anything up even though it can successfully connect to the database and when i connect as well in a different program I can see the views / query them. Any idea what might be up?
o
Hi @Ross Nordeen, I confirm that our connector can read views. Could you double check the postgres user you're using with the connector has read permissions on these views? The connector does not list table/views it can't read.
v
Yep 100% can read the views, I am reading them with same user in different sql editor tool
Is there some kind of debugging can put on to see where it's getting stuck?
c
There is a bug reading views from Postgres connector, see issue: https://github.com/airbytehq/airbyte/issues/10389
j
ah got it - that def looks like it!
although not sure best way to confirm