Answer the question
In order to leave comments, you need to log in
How to resolve db_link?
On the test everything was created from the root, there were no problems. I don't understand how to set up data retrieval via db_link.
If you just make a request - SELECT * FROM dblink('dbname=tbl', '...');
then
18:20:34 Kernel error: ERROR: password is required
DETAIL: Non-superuser cannot connect if the server does not request a password.
SELECT * FROM dblink('dbname=db user=user password=pwd', '...')
- same error, strange. GRANT EXECUTE ON FUNCTION dblink_connect_u(TEXT, TEXT) TO user;
, and thenSELECT dblink_connect_u('c', 'dbname=db');
SELECT * FROM dblink('c', '...')
- the first time is fine. And then18:24:03 Kernel error: ERROR: duplicate connection name.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question