To allow access from all IPv6 addresses: ::/0įor more detailed information about setting these parameters, see the PostgreSQL documentation.For a single host: ::1/128 (in this case the IPv6 loopback address).To allow access from all IPv4 addresses: 0.0.0.0/0 When specifying these settings, add one row for each node, using /32 as a suffix for each address, or add a sub net that covers all addresses using, for example, /24 as a suffix: At this point, the server is configured to allow connections from Active Directory users who have a corresponding PostgreSQL role and database. By default, your PostgreSQL install is likely configured to only allow connections from your local Linux server. Replace 127.0.0.1/32 with a sub net specification that covers all the IP addresses of the nodes in your site. Configure PostgreSQL to allow remote connections. The default address setting, 127.0.0.1/32, only allows local host to access the database. This line determines which servers can access the repository database server. Make the following configuration changes:.Open the file in a text editor as an administrator.Navigate to the nf file in C:\Program Files\PostgreSQL\\data of your PostgreSQL installation.Note: Make a backup copy of the nf and pg_hba.conf files before you start, so that you have the option to revert back to the original settings. So my next recommendation would be to edit the pga_hba.conf and nf configuration files of your DB to allow communication between your PostgreSQL database and external (Qlik) in this case If I got this correct since you are able to see these connections in data source don't think your license should be a issue ( I am not sure need to confirm) Supported MySQL Enterprise Edition versions From the create new connection you are testing PostgresSQL and MySQL enterprise edition.You have a an trail version of SaaS edition of Qlik Sense.Okay, Now I think I understood what you are trying to do
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |