[Postgres-xl-general] About read-only transaction

Arthur Chan arthur1977.chan at gmail.com
Sun Jun 28 01:52:34 PDT 2015


Hello, my PostgresXL version 9.2.0

(1)
After I started the GTM, DataNode, Coordinator, as well as the coordinator
of each datanode postgresql.conf archive

#default_read_only_transaction = "off" modified
default_read_only_transaction = "off"

(2)
Use the following instructions to connect information nodes:

psql -h 192.168.20.138 -p 25431 -U postgres

192.168.20.138 is the first data node ip location.

25431 is the first data node postgresql.conf set port settings.

postgres is installed PostgresXL system account, also a super manager of
this PostgresXL.

(3)
Establish a database using the following command:

create database "MyTest";

The following error message has appeared:

can not execute CREATE DATABASE "MyTest" in a read-only transaction.


How can I be able to cancel the read-only transaction of this restriction?


THX.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20150628/7ef7dc65/attachment.htm>


More information about the postgres-xl-general mailing list