Menu ▾ ▴

#5 Configure use_xa parameter of dblink_plus as GUC parameter.

Unstable (example)
closed
Sachin Kotwal
dblink_plus (6)
5
2014-06-02
2014-05-30
Sachin Kotwal
No

This patch enables user to configure use_xa parameter of dblink_plus as GUC parameter in postgresql.conf . If user set this parameter to "false" it disables two phase commit for all dblink_plus related sqls except user explicitly specify different value in dblink.connect() function for use_xa parameter.
Making this parameter value "false" it allows to execute dblink_plus sqls on standby servers.

1 Attachments
use_xa_as_guc_parameter.patch

Discussion

  • Sachin Kotwal

    Sachin Kotwal - 2014-05-30

    How to specify GUC parameter for dblibk_plus in postgresql.conf:
    1. For 9.1 and Old versions of PostgreSQL:
    custom_variable_classes = 'dblink_plus'
    dblink_plus.use_xa = false

    1. For 9.2 and Latest versions of PostgreSQL:
      dblink_plus.use_xa = true
     

    Last edit: Sachin Kotwal 2014-06-02

  • Takashi Ohnishi

    Takashi Ohnishi - 2014-05-30
    • status: open --> accepted
     

  • Sachin Kotwal

    Sachin Kotwal - 2014-06-02
    • summary: Configure use_pgxa parameter of dblink_plus as GUC parameter. --> Configure use_xa parameter of dblink_plus as GUC parameter.
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1,2 +1,2 @@
-This patch enables user to configure use_pgxa parameter of dblink_plus as GUC parameter in postgresql.conf . If user set this parameter to "false" it disables two phase commit for all dblink_plus related sqls except user explicitly specify different value in dblink.connect() function for use_pgxa parameter.
+This patch enables user to configure use_xa parameter of dblink_plus as GUC parameter in postgresql.conf . If user set this parameter to "false" it disables two phase commit for all dblink_plus related sqls except user explicitly specify different value in dblink.connect() function for use_xa parameter.
 Making this parameter value "false" it allows to execute dblink_plus sqls on standby servers.
     

  • Takashi Ohnishi

    Takashi Ohnishi - 2014-06-02
    • status: accepted --> closed