Hello,
We use PostgreSQL 14 under Windows operating system and when we try to take a sample it raises the following error:
take_sample (local,"could not establish connection
SQL-оператор: ""SELECT dblink_connect('server_connection', server_properties #>> '{properties,server_connstr}')""
функция PL/pgSQL init_sample(integer), строка 86, оператор PERFORM
функция PL/pgSQL take_sample(integer,boolean), строка 32, оператор присваивание
функция PL/pgSQL take_sample_subset(integer,integer), строка 27, оператор присваивание
SQL-функция ""take_sample"", оператор 1
connection to server at ""localhost"" (127.0.0.1), port 5433 failed: fe_sendauth: no password supplied",00:00:00.09)
We have added a new line to pg_hba.conf, but the error still exists, however typical dblink check works fine:
local all all trust
SELECT dblink_connect('test_conn', 'host=localhost port=5432 dbname=postgres user=postgres password=mypwd');
SELECT * FROM dblink('test_conn', 'SELECT 1') AS t(res int);
How to update the database configs to use pg_profile under Windows env?
Hello,
We use PostgreSQL 14 under Windows operating system and when we try to take a sample it raises the following error:
take_sample (local,"could not establish connection
SQL-оператор: ""SELECT dblink_connect('server_connection', server_properties #>> '{properties,server_connstr}')""
функция PL/pgSQL init_sample(integer), строка 86, оператор PERFORM
функция PL/pgSQL take_sample(integer,boolean), строка 32, оператор присваивание
функция PL/pgSQL take_sample_subset(integer,integer), строка 27, оператор присваивание
SQL-функция ""take_sample"", оператор 1
connection to server at ""localhost"" (127.0.0.1), port 5433 failed: fe_sendauth: no password supplied",00:00:00.09)
We have added a new line to pg_hba.conf, but the error still exists, however typical dblink check works fine:
local all all trust
SELECT dblink_connect('test_conn', 'host=localhost port=5432 dbname=postgres user=postgres password=mypwd');
SELECT * FROM dblink('test_conn', 'SELECT 1') AS t(res int);
How to update the database configs to use pg_profile under Windows env?