Skip to content

Instantly share code, notes, and snippets.

View nikitasius's full-sized avatar
💭
🍆

Nikita S. nikitasius

💭
🍆
62 followers · 4 following
  • toxId: 4339E5C156D4858940E20F82BE6625BC69B4167EAE1E9924EF79AA474E2A454BE4323FE37C61
  • public static void main (String[] args){}
View GitHub Profile
@nikitasius
nikitasius / postgres_queries_and_commands.sql
Created November 26, 2017 19:00 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@nikitasius
nikitasius / block'em ALL.txt
Created November 22, 2017 22:20
#======
0.0.0.0 statsfe2.update.microsoft.com.akadns.net
0.0.0.0 fe2.update.microsoft.com.akadns.net
0.0.0.0 s0.2mdn.net
0.0.0.0 survey.watson.microsoft.com
0.0.0.0 view.atdmt.com
0.0.0.0 watson.microsoft.com
0.0.0.0 watson.ppe.telemetry.microsoft.com
0.0.0.0 vortex.data.microsoft.com
0.0.0.0 vortex-win.data.microsoft.com
@nikitasius
nikitasius / pub.key
Last active May 1, 2018 21:36
ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAIE9SWE52Fg3d292pLIZddrJmAuQTe4QyDoUAmz1vGZjo nikitas@publickeycurveblablabla
||
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAAEAQC+9UKK+NYcz82xBMhy4GP3TnPw2TC+B1ylMF2rTLPZqzeaoTTCqno9ubhRL8szjHHptSXtj+iVoNpHs5iYNdUGI21O84nrlflH33NISxWupPmZyolgbEoczBj/5SMzqvOtEa2nnb5Op0VVWt8yZ7R6PMuu1tRqPGU18Cuil64mK47oP4PqcalOC+9uPeBQv65hiSjAs25qkAf4cycqfLpE16rW3gZNhTQsLjDDLvfmzjnXy7XR99RrCw62vtgyc1J1/9qOpBaLgeHmILMt34lMZknFqC+2r7r+67s2zg2WXREkabibPEsJn3Dy5UTf0U6PpZ/hFAckMU1EQ6lKcUXxAbCodd/VCVVok9DZFmlC2xRh5q53D9tMB4j5iUp/TaOzrJISfuYK9gVGdPhaGH+GqfjWLTaGV68zoQnFa/V47a/MqNrWhKZfzmVNZQXexKHrlFZrBS+8tCV2Q3y6i2lMWJl/A1i6VFhZnn3GogzuvyF9jG7r+cTLHm1qOKplbvJbtXK1BgPy3tEx9DdcXd0VZKRZox3P5+eLvxHBYIzh0xYjkjCpDr4GlisKtFiZZIzAz0RijKCROikryHF7BTyfVKq5rSd9WPAcG484T+lsvg3yReQTTdTfBe+AY9gYR2BCcXOMnucsT1I9Sa0oTUnBS4PY2oQ0gzeG8im2vayiBX9ZkLbkxoqo8sN6D9beudPCZpp/2tQlw1wn+bPrrmOq1jW9PfNmKESvFFqEvwl25PTkCm2mjk/cD9NRgGGR0jT7+3pfSqGiOZzXAe1wGZCIeNRsqI2b/cEaSs1VpW4GYw0oT2/pcokj003LQjZZ9evAQHIM37+4p1U2gO/fjrNmKBiGNpT3veLzL9
@nikitasius
nikitasius / ssh-1-click.sh
Created March 15, 2017 21:42
#!/bin/bash
xfce4-terminal -e "ssh -i /path/to/ssh-key login@servername -p22"
exit 0
@nikitasius
nikitasius / OVH - VPS SSD 1 (PC)
Created March 11, 2017 18:19
this from PublicCloud
=========================================================================================================
# 7z b
7-Zip [64] 9.20 Copyright (c) 1999-2010 Igor Pavlov 2010-11-18
p7zip Version 9.20 (locale=en_US.UTF-8,Utf16=on,HugeFiles=on,1 CPU)
RAM size: 1962 MB, # CPU hardware threads: 1
RAM usage: 419 MB, # Benchmark threads: 1
Dict Compressing | Decompressing
@nikitasius
nikitasius / byebye sweet server
Created March 10, 2017 21:36
root@minisrv ~ # echo "ByeBye sweet server :'-(".`uptime`|/usr/games/cowsay
_________________________________________
/ ByeBye sweet server :'-(. 21:36:17 up \
| 375 days, 13:33, 3 users, load average: |
\ 0.92, 0.98, 1.05 /
-----------------------------------------
\ ^__^
\ (oo)\_______
(__)\ )\/\
||----w |
@nikitasius
nikitasius / uptime
Created March 6, 2017 09:10
root@minisrv ~ # uptime|/usr/games/cowsay
______________________________________
/ 09:09:45 up 371 days, 1:06, 1 user, \
\ load average: 0.67, 1.07, 1.18 /
--------------------------------------
\ ^__^
\ (oo)\_______
(__)\ )\/\
||----w |
|| ||
@nikitasius
nikitasius / VPS tests.md
Last active March 31, 2017 10:49
@nikitasius
nikitasius / hosts - win file
Created December 16, 2016 07:05
127.0.0.1 localhost
::1 localhost
127.0.0.1 localhost.tld
#======
0.0.0.0 statsfe2.update.microsoft.com.akadns.net
0.0.0.0 fe2.update.microsoft.com.akadns.net
0.0.0.0 s0.2mdn.net
0.0.0.0 survey.watson.microsoft.com
0.0.0.0 view.atdmt.com
0.0.0.0 watson.microsoft.com
@nikitasius
nikitasius / null phpbb 3.1.9
Created August 9, 2016 13:40
./phpBB3/install/install_convert.php:151: $config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);
./phpBB3/install/install_convert.php:392: $config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);
./phpBB3/install/install_convert.php:636: $config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);
./phpBB3/install/install_install.php:1490: $config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);
./phpBB3/install/install_install.php:1906: $config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);
./phpBB3/install/install_install.php:1980: $config = new \phpbb\config\db($db, new \phpbb\cache\driver\null, CONFIG_TABLE);