topic Re: When installing PostgreSQL, when would a DbHost argument be anything other than localhost? in Connectivity & Data Prep

When installing PostgreSQL, when would a DbHost argument be anything other than localhost?

mbespartochnyy — Wed, 29 May 2024 15:06:16 GMT

I'm going through Silently installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer documentation which mentions a list of arguments that can be used to install a PostgreSQL database. One of the arguments is dbhost.

Does anyone know when the dbhost argument would be anything other than localhost?

Re: When installing PostgreSQL, when would a DbHost argument be anything other than localhost?

mpc — Thu, 30 May 2024 09:15:07 GMT

Hi,

dbhost argument is localhost when you use the PostgreSQL bundled with Qlik, or Standalone PostgreSQL on the Qlik Server.

When you use an external PostgreSQL database as the Repository, dbhost should be the fqdn or IP of the server which host the DB.

Kind regards

Re: When installing PostgreSQL, when would a DbHost argument be anything other than localhost?

mbespartochnyy — Thu, 30 May 2024 15:00:02 GMT

Isn't the Qlik PostgreSQL Installer (QPI) only applicable to Qlik Sense environments that have bundled PostgreSQL database?

In other words, it's impossible to install a bundled PostgreSQL database on a different server, right? If PostgreSQL and Qlik Sense are bundled, they both must live on the same server, right?

Re: When installing PostgreSQL, when would a DbHost argument be anything other than localhost?

mpc — Thu, 30 May 2024 15:06:58 GMT

You're goddamn right !

Re: When installing PostgreSQL, when would a DbHost argument be anything other than localhost?

mbespartochnyy — Thu, 30 May 2024 15:23:00 GMT

haha good to hear. I thought I was losing my mind.

So if QPI tool only works for bundled PostgreSQL, and bundled PostgreSQL must live on the same server as central Qlik Sense node, then the dbhost argument will never be anything other than localhost. At least when we're talking about using QPI tool to unbundle and upgrade PostgreSQL from Qlik Sense, is that right?

Re: When installing PostgreSQL, when would a DbHost argument be anything other than localhost?

mpc — Thu, 30 May 2024 15:27:57 GMT

You've said everything !