05 2022 档案

PostGIS 扩展创建失败原因调查
摘要：Issue 升级 PostgreSQL 9.1 的一个集群，由于该集群用到了 PostGIS，在升级 PostgreSQL 时也需要升级一下 PostGIS。PostGIS 相关软件安装好后，在 PostgreSQL 11 中创建 postgis extension 时失败，如下： alvindb= 阅读全文
posted @ 2022-05-21 00:28 DBADaily 阅读(1843) 评论(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 阅读(186) 评论(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 阅读(201) 评论(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 阅读(117) 评论(0) 推荐(0) 编辑
写了一个简单易用的 shell 框架
摘要：Easy Bash - a simple bash library to make scripting easier 阅读全文
posted @ 2022-05-06 08:01 DBADaily 阅读(110) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示