postgresql docker: FATAL: role "root" does not exist

The Problem

When you use docker to run postgresql (ex, postgres:14.5-bullseye) and enabled healthcheck, you might get health status from docker compose ps, but you might see error messages in your docker log.

Sample docker-compose.yml:

Nginx 1.25.0 開始支援 HTTP/3 (QUIC)


不過正式釋出是昨天的事,不到 24 小時前。

Changes with nginx 1.25.0                                        23 May 2023

    *) Feature: experimental HTTP/3 support.


記得寫研究所論文時就爬過 QUIC 程式碼、翻過 spec,找過缺陷問題,然後心心念念期待普及。直至今日。

使用 GCP 和 AWS 建立 TON 算力挖礦 (PoW) 及驗證節點 (PoS)

TON (The Open Network) 或 TONcoin,前身是 Telegram (通訊軟體)發起的 Telegram Open Network.

Miner 算力挖礦 - PoW

支援 GPU 加速挖礦。

AWS g4ad

AMD EPYC CPU + AMD Radeon Pro V520 GPU. - 較便宜、TON 挖礦效能好、CP 值高。 - ETH (ethash) hashrate 算力很低,不適合雙幣挖礦。

建立 instance 時,請確定選擇了用 Ubuntu 18.04,因為 AWS 只提供給 Ubuntu 18.04 的 GPU 驅動程式。

TON miner (PoW) and validator (PoS) on AWS and GCP

TON (The Open Network), or TONcoin, former Telegram Open Network founded by the instant messaging app Telegram.

Miner - PoW

We can use GPU for mining.

AWS g4ad

AMD EPYC CPU + AMD Radeon Pro V520 GPU.

  • Lower price, better TON mining performance, better C/P value.
  • ETH (ethash) hash rate is low, so not for dual mining.

Make sure to use Ubuntu 18.04, as AWS doesn't provide Ubuntu 20.04 drivers.

Backport an Ubuntu package in 5 minutes.

Packaging software might sound scary, but backporting Ubuntu package is actually easy.
When you need some features or bugfix in a newer version of software, which exists in latest Ubuntu release, but need it to be running in your older release of Ubuntu, what you need to do is to port the software from latest Ubuntu to the version you want. And in this HowTo I'll guide you through.

  1. Install tools: sudo apt install ubuntu-dev-tools
  2. Set developer (YOU) info: export UBUMAIL="Your Name <[email protected]>"
  3. Use tool to backport backportpackage -w . the-package-name

在 Docker 中使用 Linux 版微軟 Microsoft SQL Server

最近向我尋求顧問諮詢的組織單位中,其中一個再也受不了微軟的天價授權費勒索,打算用 Linux (Ubuntu) 替換掉所有 Windows Server。用 PHP、Java 以及其他跨平台語言撰寫的服務要轉移很容易。但是其中一些系統使用 MicroSoft SQL Server 作為資料庫。
治本的方法是轉移到 MySQL、MariaDB 或其他 OpenSource 資料庫系統,但那需要時間來處理所有 schema 以及 query 的轉換。
另一個方法是在 Docker 中使用 Linux 版微軟 Microsoft SQL Server 作為暫時性的過渡時期解法。

Running Microsoft SQL Server on Linux in Docker

One of the organizations that recently consulted me for advice, no longer willing to be extortion by Microsoft's high licensing fees, and plans to replace all Windows Server with Linux (Ubuntu). No big deal for services written in PHP, Java, and other cross platform languages. But some of the systems use MicroSoft SQL Server as their Database. The permanent cure is to migrate to MySQL, MariaDB, or other OpenSource Databases. But it takes time to translate all schema and queries. The other solution is to use Microsoft SQL Server on Linux in Docker as a temporary workaround.

Secure Web Connection with Lighttpd + Let’s Encrypt = A+ score on ssllabs (HTTPS + HSTS)

Lighttpd + Let’s Encrypt + This HOWTO = A+ score on ssllabs (HTTPS + HSTS)
My A+ report:
ssllabs A+ rating for

Subscribe to RSS - linux