This assumes you will have pgAgent running on the same machine as your database.
- Install pgAgent via package manager
sudo apt update
#!/usr/bin/env bash | |
set -e | |
# Examples of call: | |
# git-clone-bare-for-worktrees git@github.com:name/repo.git | |
# => Clones to a /repo directory | |
# | |
# git-clone-bare-for-worktrees git@github.com:name/repo.git my-repo | |
# => Clones to a /my-repo directory |
$Dictionary = @{ | |
"key1" = "value1"; | |
"key2" = "value2"; | |
} | |
$sourceFilename = "template.txt" | |
$destinationFilename = "output.txt" | |
$delimStart = "<" | |
$delimEnd = ">" | |
$templateContent = Get-Content $sourceFilename |
Import-Module PSReadLine | |
Import-Module Posh-Git | |
oh-my-posh init pwsh --config '$env:UserProfile\jandedobbeleer.omp.json' | Invoke-Expression | |
# AWS CLI | |
Register-ArgumentCompleter -Native -CommandName aws -ScriptBlock { | |
param($commandName, $wordToComplete, $cursorPosition) | |
$env:COMP_LINE = $wordToComplete | |
if ($env:COMP_LINE.Length -lt $cursorPosition) { |
[merge] | |
tool = kdiff3 | |
[mergetool "kdiff3"] | |
path = C:/Program Files/KDiff3/kdiff3.exe | |
trustExitCode = false | |
[diff] | |
guitool = kdiff3 | |
[difftool "kdiff3"] | |
path = C:/Program Files/KDiff3/kdiff3.exe | |
trustExitCode = false |
{ | |
"blocks": [{ | |
"type": "prompt", | |
"alignment": "left", | |
"segments": [{ | |
"type": "session", | |
"style": "diamond", | |
"foreground": "#ffffff", | |
"background": "#c386f1", | |
"leading_diamond": "", |
# There is no facility to replace passwords in RDCMan once they are stored. The only way is to create a new custom credential. | |
# If you open your *.rdg file in a text editor, locate the stored <password>, you can then decrypt it using this script. | |
# This script can also encrypt a plain text password in rdg format which can be used to overwrite an existing one in the xml. | |
Add-Type -AssemblyName System.Security; | |
Function EncryptPassword { | |
[CmdletBinding()] | |
param([String]$PlainText = $null) | |
# convert to RDCMan format: (null terminated chars) |
adddate() { | |
while IFS= read -r line; do | |
printf "%s %s\n" "[$(date +"%F %H:%M:%S")]" "$line" | |
done | |
} | |
$1 | adddate |
#!/usr/bin/env bash | |
> allowed_ranges | |
#Bamboo Triggers | |
echo '18.205.93.0/25' >> allowed_ranges | |
echo '18.234.32.128/25' >> allowed_ranges | |
echo '13.52.5.0/25' >> allowed_ranges | |
#Atlassian IP Addresses | |
curl -s https://ip-ranges.atlassian.com/ | jq -r '.items[] | .cidr' >> allowed_ranges | |
echo Allowed Ranges file generated |
#Add to /etc/postgresql/10/main/conf.d/logging.conf and reload config | |
log_statement = 'none' | |
log_duration = off | |
log_min_duration_statement = 10000 | |
log_lock_waits = on |