[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