05 2022 档案
摘要:Issue 升级 PostgreSQL 9.1 的一个集群,由于该集群用到了 PostGIS,在升级 PostgreSQL 时也需要升级一下 PostGIS。PostGIS 相关软件安装好后,在 PostgreSQL 11 中创建 postgis extension 时失败,如下: alvindb=
阅读全文
摘要:Background In many cases applications need to get current Unix timestamp (seconds since 1970-01-01 00:00:00 UTC, also called Unix epoch or Unix time o
阅读全文
摘要:Steinar H. Gunderson Leaving MySQL About one month ago, Steinar H. Gunderson wrote a blog rubbishing MySQL and recommending PostgreSQL. Here is the or
阅读全文
摘要:Easy Dump While you are upgrading from PostgreSQL earlier releases like PostgreSQL 9.1 to later releases like PostgreSQL 11, pg_dump and pg_upgrade pr
阅读全文
摘要:Easy Bash - a simple bash library to make scripting easier
阅读全文