lesovsky

PostgreSQL 13

• 2020-09-24: Release notes

Major features:

• Оптимизация хранения и производительности за счет дедупликации в B-tree индексах.
• Улучшение производительности запросов с использованием агрегатов или работающих с партицонированными таблицами.
• Улучшенное планирование запросов с использованием расширенной статистики.
• Параллельное вакуумирование индексов.
• Инкрементальная сортировка.

checco

--
-- Change database owner
--

ALTER DATABASE "db_name" OWNER TO user;

--
-- List schemas
--

beevee

Summary

Опиши в 3-4 предложениях что происходило и почему. Это информативное представление о факапе с высоты птичьего полета, оно должно быть понятно любому человеку без контекста.

Ущерб

Качественная оценка Какая функциональность не работала, насколько долго, у кого. Была ли потеря или порча данных. Выбери поле справа.

Количественная оценка

abhirockzz

#------------ bootstrap the cluster nodes --------------------

start_cmd='redis-server --port 6379 --cluster-enabled yes --cluster-config-file nodes.conf --cluster-node-timeout 5000 --appendonly yes'
redis_image='redis:5.0-rc'
network_name='redis_cluster_net'

docker network create $network_name
echo $network_name " created"

#---------- create the cluster ------------------------

djraw

Use Java keytool to convert from JKS to P12...

Export from keytool's proprietary format (called "JKS") to standardized format PKCS #12:

keytool -importkeystore -srckeystore keystore.jks -destkeystore keystore.p12 -deststoretype PKCS12 -srcalias <jkskeyalias> -deststorepass <password> -destkeypass <password>

...then use openssl to export from P12 to PEM

Export certificate using openssl:

monodot

Java, do you trust me? 🤔

Using openssl to test an SSL connection to google.com, using a CA file that's been pulled out from a Java keystore. For those days when you want to verify that you've got the right certificate in the store:

1. Download the Equifax root certificate (which is the root CA for Google)
2. Import the certificate into a new Java keystore
3. Export the certificate back out again
4. Convert the certificate to PEM
5. Use openssl to test an SSL connection to Google with that cert

wesm

import gc
import os
import time

import numpy as np
import pandas as pd
from pyarrow.compat import guid
import pyarrow as pa
import pyarrow.parquet as pq
import snappy

houtianze

Let's say you have a SysV Init Script named foo

1. Copy the file to /etc/init.d/foo

2. Enable the SysV service: chkconfig --add foo

3. Enable the SysV service: chkconfig foo on

4. Start the service: service foo start. After this, systemd-sysv-generator will generate this file /run/systemd/generator.late/foo.service, copy this file to /etc/systemd/system by running: cp /run/systemd/generator.late/foo.service /etc/systemd/system/foo.service

5. Edit /etc/systemd/system/foo.service by running systemctl edit foo.service, add in the following line to foo.servie (this makes the service installable)

[Install]

dreikanter

Symmetic encryption

For symmetic encryption, you can use the following:

To encrypt:

openssl aes-256-cbc -salt -a -e -in plaintext.txt -out encrypted.txt

To decrypt:

zhujunsan

What / Why

Deploy key is a SSH key set in your repo to grant client read-only (as well as r/w, if you want) access to your repo.

As the name says, its primary function is to be used in the deploy process in replace of username/password, where only read access is needed. Therefore keep the repo safe from the attack, in case the server side is fallen.

How to

1. Generate a ssh key