I hereby claim:
- I am evkuzin on github.
- I am evk (https://keybase.io/evk) on keybase.
- I have a public key ASCfR3kw4YaKf4co4cU8-NHo2OYMiFN4orI65GgXcRAyAQo
To claim this, I am signing this object:
<?xml version="1.0" encoding="UTF-8"?> | |
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> | |
<plist version="1.0"> | |
<dict> | |
<key>Label</key> | |
<string>org.openssh.port-forwards</string> | |
<key>OnDemand</key> | |
<true/> | |
<key>ProgramArguments</key> | |
<array> |
I hereby claim:
To claim this, I am signing this object:
sudo -s | |
export APP=app # REPLACE WITH YOUR APP NAME | |
cat <<EOF > /srv/$APP/config/logback.xml | |
<?xml version="1.0" encoding="UTF-8"?> | |
<configuration> | |
<conversionRule conversionWord="maskedMessage" converterClass="com.revolut.common.infra.logging.MaskingConverter" /> | |
<property name="defaultPattern" value="%-5level [%d{dd/MM/yy HH:mm:ss.SSS}] [%thread] %logger [%X{Request-Id:-NonRequest}] %maskedMessage%n" /> | |
<appender name="default" class="ch.qos.logback.core.ConsoleAppender"> | |
<encoder> | |
<charset>utf-8</charset> |
# fix docker shell size | |
docker run -e COLUMNS=$COLUMNS -e LINES=$LINES -e TERM=$TERM -it postgres /bin/bash |
How to get an estimate of the impact of writing Postgres logs with log_min_duration_statement = 0
:
Do select pg_stat_statements_reset();
and wait N seconds (where N >> 60 – say 1-24 hours, covering typical busy hours). Remember when it was, and write down somewhere – this timestamp will be needed!
Check if select count(*) from pg_stat_statements
is lower than pg_stat_statements.max
. If it's equal to it, then raise pg_stat_statements.max
and restart with the step 1.
Get the estimate:
\set TS_PGSS_RESET 'XXXX-XX-XX XX:XX:XX';
cat << EOF > ~/.vimrc | |
set backupcopy=yes | |
EOF |
#!/bin/bash | |
# gist to add/modify your ssh key to the google cloud project | |
# run bash <(curl -s URL_TO_THIS_RAW_GIST) -p PROJECT | |
TEMP_KEYS="/tmp/ssh-keys" | |
jq_not_installed () { | |
printf "\nplease install 'jq' util:\nbrew install jq\n\n" && exit 1 | |
} |
#!/bin/bash | |
cd /home/postgres || exit | |
DATABASE=${1:-"postgres"} | |
cat <<EOF > /tmp/idx_targets.sql | |
with step1 as ( | |
select | |
i.nspname as schema_name, | |
i.tblname as table_name, |
# Github: | |
``` | |
git config --global url."git@github.com:".insteadOf "https://github.com/" | |
``` | |
# BitBucket: | |
``` |