topic Re: Is it possible to backup the repository with Integrated Security ? in App Development

Is it possible to backup the repository with Integrated Security ?

EmmaC — Fri, 09 Mar 2018 12:40:14 GMT

Dear all,

Our client is not allowed to have the passwords clear text (for example in C:\users\qliksense_account\AppData\Roaming\pgpass.conf )

I read that Integrated Security is possible in Postgresql, editing the pg_hba.conf file and specifying the authentication mode sspi.

But, the services are connecting to the repository with a password!

How to do it? Is it somehow possible?

thanks in advance for your help!

nice regards,

Emma

Re: Is it possible to backup the repository with Integrated Security ?

reshma_km — Fri, 27 Jul 2018 20:45:03 GMT

I also can't save the password in plain text in pgpass for taking repository backup. Any solutions for this?

Re: Is it possible to backup the repository with Integrated Security ?

BalaBhaskar_Qlik — Sat, 28 Jul 2018 10:38:41 GMT

May be this:

https://stackingitblog.com/2017/09/03/qlik-sense-postgre-sql-pgpass-and-backups/

Re: Is it possible to backup the repository with Integrated Security ?

BalaBhaskar_Qlik — Sat, 28 Jul 2018 10:39:43 GMT

Try this:

So the .pgpass file needs to be in the user's profile doing the pg_dump command. Reference: https://www.postgresql.org/docs/9.6/static/libpq-pgpass.html

In PowerShell, this style of approach should work:

cd $env:userprofile\AppData\Roaming\postgresql\

if (Test-Path $env:userprofile\AppData\Roaming\postgresql\pgpass.conf) {

} else {

"localhost:4432:$([char]42):postgres:INSERTYOURSUPERUSERPASSWORD" | set-content pgpass.conf -Encoding Ascii

}

Refer this link:

Qlik Sense Repository Backup Automation

Re: Is it possible to backup the repository with Integrated Security ?

reshma_km — Mon, 30 Jul 2018 13:53:33 GMT

But, in pagpass, the password will be stored in plain text right? I have created a key file and an encrypted password file using powershell. Can I decrypt and use that password in pg_dump? Can I store the files in some other location other than the pgpass location?

Re: Is it possible to backup the repository with Integrated Security ?

BalaBhaskar_Qlik — Mon, 30 Jul 2018 14:37:02 GMT

May be it helps for encryption:

Remove $env:userprofile\AppData\Roaming\postgresql\pgpass.conf