Re: [Postgres-xc-developers] Postgresxc SET TRANSACTION READ WRITE

[Nikhil S. <ni...@st...>]

Hi Afonso,


> Afonso,
> Is this newly created device? My wild guess is, the server was not fully
> recovered (after some crash may be), and thus put in read only mode.
>
> OR
> for some reason, default transaction mode is read-only.
>
> We need more context.
>
>
>
Please check if the coordinator was started as a datanode by mistake!

Regards,
Nikhils



> On Fri, Jul 26, 2013 at 8:20 PM, Afonso Bione <aag...@gm...> wrote:
>
>> Dear Friend,
>> I installed the newest version of postgres xc and when I create a
>> database I get the error message "-bash-4.1 $ createdb moodle4
>> ERROR: CREATE DATABASE can not run in a read-only transaction
>> STATEMENT: CREATE DATABASE moodle4;
>>
>> *createdb*: database creation failed: ERROR: CREATE DATABASE can not run in
>> a read-only transaction "
>> My settings are:
>> 13567? Ps 12:22 GTM-D / var / lib / pgsql / data_gtm
>> 22159 pts / 0 S + 0:00 grep gtm
>> 28265? Ps 00:00 / var / lib / pgsql / bin / gtm_proxy-D / var / lib /
>> pgsql / gtm_proxy-l logfile
>>
>> the* gtm.conf*
>> nodename = 'one' # Specifies the node name.
>>                                          # (Changes requires restart)
>> listen_addresses = '*' # Listen addresses of this GTM.
>>                                          # (Changes requires restart)
>> port = 6666 # Port number of this GTM.
>>                                          # (Changes requires restart)
>>
>> ACT = # startup # Start mode. ACT / STANDBY.
>>
>> my *gtm_proxy.conf*
>>
>> nodename = 'one'                                        # Specifies the
>> node name.
>>                                                                 #
>> (changes requires restart)
>> listen_addresses = '*'                  # Listen addresses of this GTM.
>>                                                                 #
>> (changes requires restart)
>> port = 20008                            # Port number of this GTM.
>>                                                                 #
>> (changes requires restart)
>>
>>
>>
>> the *datanode*:
>> postgres --datanode -i -D /var/lib/pgsql/data
>>
>> the *postgresql.conf*
>> gtm_host = 'localhost'                  # Host name or address of GTM
>>                                         # (change requires restart)
>> gtm_port = 6666                 # Port of GTM
>>                                         # (change requires restart)
>> pgxc_node_name = 'one'                  # Coordinator or Datanode name
>>                                         # (change requires restart)
>>
>> Best regards
>>
>> thanks
>> Afonso Bione
>>
>>
>
>
> --
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Postgres Database Company
>
>
> ------------------------------------------------------------------------------
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>


-- 
StormDB - http://www.stormdb.com
The Database Cloud