(20210316已解决)postgresql cannot execute CREATE TABLE in a read-only transation

Overview如题，在一个postgresql 的docker container里创建数据库出现上述错误。SolutionNormally the most plausible reasons for this kinde of error are:trying create statements on a read-only replica (the entire instance is r

quantLearner

4669人浏览 · 2021-03-27 10:39:51

quantLearner · 2021-03-27 10:39:51 发布

Overview

如题，在一个postgresql 的docker container里创建数据库出现上述错误。
Solution

Normally the most plausible reasons for this kinde of error are:
1. trying create statements on a read-only replica (the entire instance is read-only)
2. <username> has default_transaction_read_only set to NO
3. the database has default_transaction_read_only set to NO
My situation is the first one. So, create a new container.
Reference