2022年5月21日
PostGIS 扩展创建失败原因调查
摘要： Issue 升级 PostgreSQL 9.1 的一个集群，由于该集群用到了 PostGIS，在升级 PostgreSQL 时也需要升级一下 PostGIS。PostGIS 相关软件安装好后，在 PostgreSQL 11 中创建 postgis extension 时失败，如下： alvindb= 阅读全文
posted @ 2022-05-21 00:28 DBADaily 阅读(1964) 评论(0) 推荐(0)
[PG Upgrade Series] Extract Epoch Trap
摘要： 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 阅读全文
posted @ 2022-05-21 00:26 DBADaily 阅读(210) 评论(0) 推荐(0)
MySQL or PostgreSQL?
摘要： Steinar H. Gunderson Leaving MySQL About one month ago, Steinar H. Gunderson wrote a blog rubbishing MySQL and recommending PostgreSQL. Here is the or 阅读全文
posted @ 2022-05-21 00:25 DBADaily 阅读(227) 评论(0) 推荐(0)
pg_dump 的十六般变化
摘要： 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 阅读全文
posted @ 2022-05-21 00:22 DBADaily 阅读(148) 评论(0) 推荐(0)