Category: Administration

Everything related to system administration.

How to use psexec to remotely update machines time (from domain)?

In my previous posts you can find info how to install psexec. When you’re already done with this process, you can start updating clock settings on remote machines.

Set time

psexec64 -s /user:domain\user -i \\remote_ip net time \\domain_controller /set /y

Will output:

Bieżąca godzina na \\domain_controller to 2018-08-28 09:55:00.

At least in polish Windows 😀

Check time

psexec64 -s /user:domain\user -i \\remote_ip cmd /c time /t

Will output:

11:18

And remember good IT specialist is lazy specialist! Do not go anywhere! Eat ya buritos.

Znalezione obrazy dla zapytania fat guy computer

How to change priority on Windows scheduled task using Powershell?

By default Windows setups task priority in scheduler to 7 (which is kinda low). The side effect of this is that for eg. backups are taking very long to take. In my case all databases were backed up in about 40-50 minutes…

Continue reading How to change priority on Windows scheduled task using Powershell?

Backup script for PostgreSQL with zip support (Windows)

Simplest solution for backing up PostgreSQL databases. With this bat file you can dump one database to a file and compress it using 7-zip.

PS. If you want a date in your filename simply add %date% var to it’s string.
PS2. Of course check your paths before complaining it does not work 😛

@echo off
:: Global config
SET PG_BIN="C:\Program Files\PostgreSQL\9.6\bin\pg_dump.exe"
SET PG_HOST=localhost
SET PG_PORT=5432
SET PG_PATH="C:\inetpub\temporary_backups"
SET ZIP_BIN="C:\Program Files\7-Zip\7z.exe"

:: Database config for 
SET PG_DATABASE=your_database_name
SET PG_USER=your_database_user
SET PGPASSWORD=youe_database_password

SET PG_FILENAME=%PG_PATH%\%PG_DATABASE%_postgres.sql
%PG_BIN% -h %PG_HOST% -p %PG_PORT% -U %PG_USER% %PG_DATABASE% > "%PG_FILENAME%"
%ZIP_BIN% a "%PG_FILENAME:~0,-4%.zip" "%PG_FILENAME%" &DEL "%PG_FILENAME%"

@echo Backup Taken Complete %PG_PATH%%PG_FILENAME%