[Postgres-xc-developers] Read-only mode in Postgresxc

[Timur A. <tim...@gm...>]

Good day,

I have recently switched to postgresxc v1.2.1, and I find it great. In my
test scenario, I have created GTM, GTM Proxy, Coordinator and Datanode all
running on one server. I then created a new database:

# create database test_db encoding='UFT8';

+several simple tables. All works like a charm.

However, what I discovered is that for some reason when I re-booted my
server several times (trying to imitate some abnormal conditions) all my
tables in that particular database (test_db) had become read-only.

Initially I though - may be postgres is in the recovery mode, so I ran:

postgres=# SELECT pg_is_in_recovery();
pg_is_in_recovery
-------------------
f
(1 row)

I then executed 'SET transaction_read_only = off' and it didn't help
either.

Any idea what could cause that problem? What will be the solution to fix it
should I face with that issue again?
Thank you.

-Timur