search

Percona-Lab / clickhousedb_fdw

PostgreSQL's Foreign Data Wrapper For ClickHouse
Other
201 stars 24 forks source link

clickhousedb fdw does not support the options: user and password #12

Open chinaworld opened 5 years ago

chinaworld commented 5 years ago

clickhousedb fdw does not support the options: user and password.

postgres=# CREATE SERVER clickhouse_svr FOREIGN DATA WRAPPER clickhousedb_fdw OPTIONS(dbname 'test_database', driver '/usr/local/lib/odbc/libclickhouseodbc.so', host '127.0.0.1', user 'default', password 'clickhouse'); postgres=# error: invalid options - user postgres=# tips: options: host, hostaddr, port, dbname, driver

ibrarahmad commented 5 years ago

No, to sepecfy the user/password you need to create user mapping.

CREATE USER MAPPING FOR CURRENT_USER SERVER clickhouse_svr options(user 'default', password 'clickhouse');

On Sat, Apr 27, 2019 at 5:44 PM chinaworld notifications@github.com wrote:

clickhousedb fdw does not support the options: user and password.

postgres=# CREATE SERVER clickhouse_svr FOREIGN DATA WRAPPER clickhousedb_fdw OPTIONS(dbname 'test_database', driver '/usr/local/lib/odbc/libclickhouseodbc.so', host '127.0.0.1', user 'default', password 'clickhouse'); postgres=# error: invalid options - user postgres=# tips: options: host, hostaddr, port, dbname, driver

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Percona-Lab/clickhousedb_fdw/issues/12, or mute the thread https://github.com/notifications/unsubscribe-auth/AA3NF4WHSDEU2JHRKR6ABQLPSRDBTANCNFSM4HI4EO6Q .

-- Ibrar Ahmed