{"id":1533,"date":"2024-10-16T05:51:17","date_gmt":"2024-10-16T05:51:17","guid":{"rendered":"https:\/\/craftcookcode.com\/?p=1533"},"modified":"2024-10-16T05:51:17","modified_gmt":"2024-10-16T05:51:17","slug":"docker-qlik-replicate-and-postres-stitching-them-together","status":"publish","type":"post","link":"https:\/\/craftcookcode.com\/?p=1533","title":{"rendered":"Docker, Qlik Replicate and Postres – stitching them together"},"content":{"rendered":"\n

So far – what do we have?<\/p>\n\n\n\n

We have:<\/p>\n\n\n\n

    \n
  1. Postges working in a docker container<\/a><\/li>\n\n\n\n
  2. Qlik Replicate working in a docker container<\/a><\/li>\n<\/ol>\n\n\n\n

    Let’s see if we can get them talking to each other<\/p>\n\n\n\n

    Working on Postgres Config files<\/h2>\n\n\n\n

    First modification is needed is to the postgresql.conf for the postgres docker image. If you were following the docker-compose.yml in my previous post; you can find the file under:<\/p>\n\n\n

    \n~\/apps\/postgres-plv8\/postgresql.conf\n<\/pre><\/div>\n\n\n
    The following changes need to be made in postgresql.conf as found in the Qlik documentation<\/a><\/p>\n\n\n
    \nwal_level = logical\nmax_replication_slots = 3       # max number of replication slots\n<\/pre><\/div>\n\n\n
    Now to added the following lines to <\/p>\n\n\n
    \n~\/apps\/postgres-plv8\/pg_hba.conf\n<\/pre><\/div>\n\n
    \n# Allow replication connections from localhost, by a user with the\n# replication privilege.\nlocal   replication     all                                     trust\nhost    replication     all             127.0.0.1\/32            trust\nhost    replication     all             ::1\/128                 trust\n<\/pre><\/div>\n\n\n
    Once done – the docker container needs to be restarted for the changes to take effect.<\/p>\n\n\n\n
    Setting up QR<\/h2>\n\n\n\n
    Log into QR using the address:<\/p>\n\n\n\n
    https://127.0.0.1:3552\/attunityreplicate<\/code><\/pre>\n\n\n\n
    Create a new postgres connection<\/p>\n\n\n\n
    Fill out the following fields:<\/p>\n\n\n\n
    Field <\/strong><\/td>Value<\/strong><\/td><\/tr>
    Server<\/td>host.docker.internal<\/td><\/tr>
    Port<\/td>9432<\/td><\/tr>
    Username<\/td>Username from the docker-compose.yml file for postgres<\/td><\/tr>
    Password<\/td>Password from the docker-compose.yml for postgres<\/td><\/tr>
    Database<\/td>Database from docker-compose.yml for postgres<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    From here a QR task can be built to read from the postgres database<\/p>\n\n\n\n
    \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
    So far – what do we have? We have: Let’s see if we can get them talking to each other Working on Postgres Config files First...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[68,64,16],"tags":[],"class_list":["post-1533","post","type-post","status-publish","format-standard","hentry","category-docker","category-postgres","category-qlik-replicate"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/posts\/1533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1533"}],"version-history":[{"count":6,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/posts\/1533\/revisions"}],"predecessor-version":[{"id":1548,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=\/wp\/v2\/posts\/1533\/revisions\/1548"}],"wp:attachment":[{"href":"https:\/\/craftcookcode.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftcookcode.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}