pg_dump without/forgot password-Toy模板网

这篇具有很好参考价值的文章主要介绍了pg_dump without/forgot password。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

Background

I shared the "Qlik Sense Repository Back up and Restore" in the past , but somehow we don't know or forgor our repository password , and you don't know how to backup it . No worries , you can follow my step to add whitelist in pg_hba_conf to allow you backcup by pg_dump with any password .(154条消息) Qlik Sense Repository Back up and Restore_Moshow郑锴的博客-CSDN博客

pg_dump without/forgot password

Solution

first at all , we need to sort out some questions:

1.how to set whitelist ?

by setting the pgsql pg_hba.conf , in database level

2.where the pg_hba.conf in qlik sense ?

path is (TBC)

3.how to add trust connections in pg_hba.conf?

default the method should be md5 , change it from md5 to trust , which means you don't need to input the password in server local any more , but be care and remember to revert it back once done . also remember it only taken effect when you call the command or connect to repository database by the IP you confured in pg_hba.conf

# IPv4 local connections: host all all 127.0.0.1/32 trust

4.How to use pg_dump to backup repository/pgsql?

you can refer to offical document to study how it works .

pg_dump (postgres.com)http://www.postgres.com/docs/12/app-pgdump.html

If your deployment includes a local database on the central node that was installed using the Qlik Sense setup program, the location will be:
%ProgramFiles%\Qlik\Sense\Repository\PostgreSQL\<database version>\bin.
Note:If you installed PostgreSQL manually, the location will be:
%ProgramFiles%\PostgreSQL\<database version>\bin.

Run the following command:
pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "c:\QSR_backup.tar" QSR