Vasily Safronov04/15/2021, 7:48 AM
but this message didn’t tell me anything about what specific query request was sent to the db when this error occurred. During debugged I saw that the problem is not in the wrong password or the connector is not working correctly, but in the following query:
2021-04-14 20:39:11 INFO (/tmp/workspace/8ea53a05-4867-4639-9f70-744cf07739ea/0) DefaultAirbyteStreamFactory(lambda$create$0):73 - org.postgresql.util.PSQLException: ERROR: permission denied for database test_db
during this method call. My db user just doesn’t have permissions to create a schema. So, if user will able to see specific queries logs he will have possibility to catching troubles like this with easy way and it will more friendly user experience.
CREATE SCHEMA IF NOT EXISTS public;
user04/15/2021, 2:47 PM
user04/15/2021, 2:48 PM