huaweigu

git clean -xfd
git submodule foreach --recursive git clean -xfd
git reset --hard
git submodule foreach --recursive git reset --hard
git submodule update --init --recursive

huaweigu

Steps to generate self-signed PKCS#12 SSL certificate and export its keys:

1- Create PKCS#12 keystore (.p12 or .pfx file)

keytool -genkeypair -keystore myKeystore.p12 -storetype PKCS12 -storepass MY_PASSWORD -alias KEYSTORE_ENTRY -keyalg RSA -keysize 2048 -validity 99999 -dname "CN=My SSL Certificate, OU=My Team, O=My Company, L=My City, ST=My State, C=SA" -ext san=dns:mydomain.com,dns:localhost,ip:127.0.0.1

• myKeystore.p12 = keystore filename. It can with .pfx extension as well.
• MY_PASSWORD = password used for the keystore and the private key as well.
• CN = commonName, it will be shown as certiciate name in certificates list.
• OU = organizationUnit, department name for example.

huaweigu

Safe Operations For High Volume PostgreSQL

Safe

• Add a new column
• Drop a column
• Rename a column
• Add an index concurrently (Example), Note: it will still take a long time to run the migration, but it won't write-lock the table.
• Drop a constraint (for example, non-nullable)
• Add a default value to an existing column

huaweigu

DO $$
  DECLARE updated_rows INT;
  BEGIN

    UPDATE some_table
    SET some_column = 'new'
    WHERE some_column = 'old';

    GET DIAGNOSTICS updated_rows = ROW_COUNT;