"%Programfiles%\Qlik\Sense\Repository\PostgreSQL\9.6\bin\dropdb. Pg_restore.exe -h localhost -p 4432 -U postgres -d QSR "c:\backup\QSR_backup.tar"â If the command fails because a database already exists, run the following command and then repeat the createdb command: dropdb -h localhost -p 4432 -U postgres QSR Run the following commands to restore the repository database (adjust the paths as needed): cd "%ProgramFiles%\Qlik\Sense\Repository\PostgreSQL\\bin"Note that reflects the version of your PostgreSQL install.Ĭreatedb -h localhost -p 4432 -U postgres -T template0 QSRâ Open a Command Prompt with administrator privileges in Microsoft Windows.Place the backed-up repository database on the machine targeted for the restore. To back up an existing PostgreSQL database on-premises or in a VM, run the following command: pgdump -Fc -v -host -username -dbname -f .T _deletedentitylog -f "E:\backup\QSR_Backup.tar" QSR âįor detailed information see Restoring a Qlik Sense site. Create a dump file that contains the data to be loaded.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |