Creating a New CA (SHA-512, 4096-bit) with PKCS #11 Smart Card Storage and Subordinate CA

<p class="wp-block-paragraph">Today, I will walk through the process of creating a new Certificate Authority (CA) using a 4096-bit RSA key and SHA-512 as the signature hash algorithm. I will also store the private key securely on a PKCS #11–compatible smart card, and then create a subordinate (sub) CA using the root CA. Throughout this guide, … Read more

PostgreSQL Notes

<p class="wp-block-paragraph">How to drop all tables sharing the same prefix in PostgreSQL?</p> <ul class="wp-block-list"> <li>Non-Cascade version:</li> </ul> <p class="wp-block-paragraph">How to drop all functions in PostgreSQL?</p> <p class="wp-block-paragraph"> How to drop all tables sharing the same prefix in PostgreSQL? Non-Cascade version: How to drop all functions in PostgreSQL?

Running PostgreSQL in Docker on my Mac

<p class="wp-block-paragraph">It’s extremely convenient to run your local tools, like RDMS, development environments and so on on Docker containers on Mac. To be honest with you, I hate installing a bunch of software on my Mac, and that’s the main reason why do I use containers for my local development.</p> <p class="wp-block-paragraph">Before doing that manual, … Read more

ElementaryOS: Resolution fix for 2560×1440

<p class="wp-block-paragraph">Edit <strong>/usr/share/X11/xorg.conf.d/10-monitor.conf</strong> and paste the following:</p> <p class="wp-block-paragraph">And reboot system with <strong>sudo reboot</strong></p> <p class="wp-block-paragraph">Thanks!</p> Edit /usr/share/X11/xorg.conf.d/10-monitor.conf and paste the following: And reboot system with sudo reboot Thanks!