sys admin notes...

 Recently i had a problem while updating Ubuntu via Ubuntu Software app. The problem was that it cannot update it because the snap-store is running. After some searching the solution was simple: sudo kill snap sudo snap refresh After that everything is back to normal :)

 Hi, Recently we have bough a new Dell PowerEdge R640 server for my current company, where we have got Windows 2019 Server ROK key. Since I wanted to use as primary OS Proxmox VE and then virtualize everything I just installed on VM Windows Server 2019 Evaluation Standard on it. After some test with our company software, I was ready to activate the Windows Licence Key on that machine. The Windows activation procedure via GUI cannot use that key, so from the terminal I have done this: C:\Windows\System32\DISM /online /Set-Edition:ServerStandard /ProductKey:XXXXX-XXXXX-XXXXX-XXXXX-XXXXX /AcceptEula  Deployment Image Servicing and Management Tool Version: 10.0.17763.1790 Image Version: 10.0.17763.1790 Starting to update components... Starting to install product key... Finished installing product key. Removing package Microsoft-Windows-ServerStandardEvaluation~31bff3856ad364e35~amd64~~10.0.17763.1 [--------------------------100%---------------------------] Finished updating components. St

 A few days ago I had to create a backup script for my PostgreSQL server running on Windows. After few minutes the script looks like this: @echo off SET DBHOST=localhost set DBNAME=YOUR_DB_NAME set DBUSER=YOUR_DB_USERNAME set PGPASSWORD=YOUR_DB_PASSWORD :: Path to PostgreSQL pg_dump.exe set PGDUMP="C:\Program Files\PostgreSQL\14\bin\pg_dump.exe" :: Get date in YYYY-MM-DD format set CURRENTDATE=%date:~6,4%%date:~3,2%%date:~0,2% set BACKUPDIR=BACKUP_DIRECTORY %PGDUMP% --host %DBHOST% --port 5432 --format custom --blobs --username %DBUSER% -f "%BACKUPDIR%\%CURRENTDATE%-%DBNAME%.backup" %DBNAME%   And it is working now like a charm :)

 Today I want to show you how to install Microsoft Windows Server 2019 on Proxmox VE. First we need to setup a new environment for our Microsoft Windows Server 2019 by clicking "Create VM" button Now we need to give ID of the VM and name for it Here we have to choose the guest OS Type, storage and ISO image Now it's time to choose SCSI adapter for our VM It is recommended to choose SCSI Controller like this: VirtIO SCSI In this step we have to choose the SCSI options. Once again it is recommended to choose Bus/Device: SCSI , and Cache: Write back . Here we can also choose our Storage place and Disk size. Here we have to setup CPU setting for our VM Memory settings Network settings Since I have here two NIC's - one for administration (1GBit), second one for VM machines (10GBit) - I choosed the vmbr1 interface bridge to get 10GBit on that. To achieve this I had to choose VirtIO (paravirtualized) which offers 10GBit Lan. Confirmation If you use VirtIO devices such as N