https://community.qlik.com/t5/Data-Movement-Streaming/Rocky-8-PostgreSQL-Data-Movement-Gateway/m-p/2131930#M1515 <P>Hi, I have a PostgreSQL database in Rocky 8 running on an AWS EC2 instance.&nbsp; I was able to install the Qlik Data Movement rpm file and I've checked all the permissions on the EC2 instance but I still don't seem to be able to create a data connection in QDI.&nbsp; I keep getting the following error.</P> <LI-CODE lang="markup">SYS-E-HTTPFAIL, Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connect,RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib 'PostgreSQL Unicode(x64)' : file not found</LI-CODE> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="issue_screenshot.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118881iE7E3C06AA0A01C5E/image-size/large?v=v2&amp;px=999" role="button" title="issue_screenshot.png" alt="issue_screenshot.png" /></span></P> Wed, 19 Mar 2025 22:43:16 GMT jborthen 2025-03-19T22:43:16Z https://community.qlik.com/t5/Data-Movement-Streaming/Rocky-8-PostgreSQL-Data-Movement-Gateway/m-p/2131930#M1515 <P>Hi, I have a PostgreSQL database in Rocky 8 running on an AWS EC2 instance.&nbsp; I was able to install the Qlik Data Movement rpm file and I've checked all the permissions on the EC2 instance but I still don't seem to be able to create a data connection in QDI.&nbsp; I keep getting the following error.</P> <LI-CODE lang="markup">SYS-E-HTTPFAIL, Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connect,RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib 'PostgreSQL Unicode(x64)' : file not found</LI-CODE> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="issue_screenshot.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118881iE7E3C06AA0A01C5E/image-size/large?v=v2&amp;px=999" role="button" title="issue_screenshot.png" alt="issue_screenshot.png" /></span></P> Wed, 19 Mar 2025 22:43:16 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Rocky-8-PostgreSQL-Data-Movement-Gateway/m-p/2131930#M1515 jborthen 2025-03-19T22:43:16Z https://community.qlik.com/t5/Data-Movement-Streaming/Rocky-8-PostgreSQL-Data-Movement-Gateway/m-p/2131936#M1516 <P>Can you try installing the&nbsp;PostgreSQL ODBC Driver Package?</P> <P>You can use the below command on redhat based machines</P> <P><SPAN>sudo yum install postgresql-odbc</SPAN></P> Wed, 25 Oct 2023 20:54:40 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Rocky-8-PostgreSQL-Data-Movement-Gateway/m-p/2131936#M1516 vinodn1989 2023-10-25T20:54:40Z