yjhjstz commented on issue #1747:
URL: https://github.com/apache/cloudberry/issues/1747#issuecomment-4464181576

   The actual cause is that your password contains special characters (such as 
spaces, =, @, \, etc.), which causes the      
   connection string parser (PQconninfoParse) to fail silently. When parsing 
fails, the host check is never reached — so even though host= is present, the 
error still fires.             
                                                                                
                                                                                
                              
    Quote the password value in keyword=value format                            
                                                                                
                     
                                                                                
                                                                                
                              
    Wrap the password in single quotes, and escape any single quote inside the 
password as '':                                                                 
                              
                                                                                
                                                                                
                            
    SELECT dblink_connect('myconn', 'host=10.x.x.x port=5434 dbname=afiniti 
user=postgres password=''your_password'''); 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to