Click here to Skip to main content
15,886,026 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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

HTML
#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:

SQL
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.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900