evkuzin

# Github:

```
git config --global url."git@github.com:".insteadOf "https://github.com/"
```

# BitBucket:

```

evkuzin

#!/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,

evkuzin

#!/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
}

evkuzin

cat << EOF > ~/.vimrc
set backupcopy=yes
EOF

evkuzin

How to get an estimate of the impact of writing Postgres logs with log_min_duration_statement = 0:

1. 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!

2. 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.

3. Get the estimate:

\set TS_PGSS_RESET 'XXXX-XX-XX XX:XX:XX';

evkuzin

# fix docker shell size
docker run -e COLUMNS=$COLUMNS -e LINES=$LINES -e TERM=$TERM -it postgres /bin/bash

evkuzin

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>

evkuzin

Keybase proof

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:

evkuzin

<?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>