"C:\Program Files\PostgreSQL\15\bin\pg_dump.exe" -U postgres -d pix_bi_keys > pix_bi_keys_backup.sql
"C:\Program Files\PostgreSQL\15\bin\pg_dump.exe" -U postgres -d pix_bi_test > pix_bi_test_backup.sql
"C:\Program Files\PostgreSQL\15\bin\pg_dump.exe" -U postgres -d pix_bi_dwh > pix_bi_dwh_backup.sql
"DataWarehouseConnectionStrings": {
"ClickhouseConnection": "Compression=True;CheckCompressedHash=False;Compressor=lz4;Protocol=http;UseSession=true;set_cancel_http_readonly_queries_on_client_close=1;Host=<SERVER_ADDRESS>;Port=8123;User=<LOGIN>;Password=<PASSWORD>"
},
sudo systemctl stop pixbi.service
cd /var/www
cp -r pixbi/ pixbi_old
pg_dump -U postgres -d pix_bi_test > pix_bi_test_backup.sql
pg_dump -U postgres -d pix_bi_keys > pix_bi_keys_backup.sql
pg_dump -U postgres -d pix_bi_dwh > pix_bi_dwh_backup.sql
unzip pix_bi_XXXXXX_main.nix.zip -d /var/www/pixbi
sudo systemctl start pixbi.service
sudo systemctl status pixbi.service