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

[Ashutosh B. <ash...@en...>]

Including hackers,

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.


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