Error When trying to Run Qliksenseutil for Backup.

[imrasyed]

Hi Experts,

I am getting the Error when iam executing the Qliksense util Backup Script below

C:\"Program Files"\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe -backup -databaseHostname="XXXXX" -databasePassword="XXXXXXX" -path="C:\Backup" -rootPath="XXXXX"

and the error i am getting is 

Exception in Thread Main, msg = 28000: no pg_hba_conf entry for host "XXXX"

Can anyone help me out in fixing this issue?

[lfetensini · Accepted solution]

Você precisa acrescentar seu endereço de rede ou faixa dele no arquivo de endereços permitidos.

O primeiro passo é você procurar a linha no postgresql.conf "listen_addresses = '*'" e retirar o sinal de # para descomentar a linha.

O segundo é você permitir no pg_hba.conf a sua faixa de endereço.

Se desejar saber melhor tecnicamente as situações, você pode ler este artigo:

https://support.qlik.com/articles/000044788

[imrasyed]

but iam not able to find pg_hba.cong file in the folder specified

[Levi_Turner · Accepted solution]

It's trying to connect to the underlying database (databaseHostname) and the connection attempt is not being allowed by the pg_hba.conf file that PostgreSQL uses to permit connectivity (https://support.qlik.com/articles/000051668).

If you are using the bundled PostgreSQL which comes with Qlik Sense Enterprise, then check in %ProgramData%\Qlik\Sense\Repository\PostgreSQL\9.6 on the Central node for the pg_hba.conf file and make the appropriate edits to allow connectivity.

[imrasyed]

Hi Levi,

I am not able to see that file at all in the folder specified.

I am able to see only pg_hba.conf.sample file and that to under 'share' folder.

Correction :

I am sorry I was looking at some other folder(Programfiles).

I am able to see the file.