Advertisement
Guest User

Untitled

a guest
Jul 30th, 2015
279
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.33 KB | None | 0 0
  1. apple@ubuntu:/usr/local/pgsql/bin$ ./psql postgres -p 7777 -h localhost
  2. psql (PGXL 9.2.0, based on PG 9.2.4 (Postgres-XL 9.2.0))
  3. Type "help" for help.
  4.  
  5. postgres=# SELECT pgxc_pool_reload();
  6. pgxc_pool_reload
  7. ------------------
  8. t
  9. (1 row)
  10.  
  11. postgres=# INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27');
  12. INSERT 0 0
  13.  
  14. apple@ubuntu:/usr/local/pgsql/bin$ ./psql postgres -c "select * from pgxc_node" -p 7777 -h localhost
  15. node_name | node_type | node_port | node_host | nodeis_primary | nodeis_preferr
  16. ed | node_id
  17. -----------+-----------+-----------+-----------+----------------+---------------
  18. ---+------------
  19. coord1 | C | 5432 | localhost | f | f
  20. | 1885696643
  21. datanode1 | D | 8888 | localhost | f | f
  22. | 888802358
  23. (2 rows)
  24.  
  25. # - Connection Settings -
  26.  
  27. #listen_addresses = 'localhost'
  28.  
  29. port = 7777
  30. max_connections = 10
  31.  
  32. pooler_port = 9999
  33.  
  34. max_pool_size = 10
  35. #pool_conn_keepalive = 600
  36.  
  37. #pool_maintenance_timeout = 30
  38.  
  39. #persistent_datanode_connections = off
  40.  
  41. max_coordinators = 2
  42.  
  43. max_datanodes = 2
  44.  
  45.  
  46. #gtm_host = '*'
  47.  
  48. gtm_port = 6666
  49.  
  50. pgxc_node_name = 'coord1'
  51.  
  52. # - Connection Settings -
  53.  
  54. #listen_addresses = 'localhost'
  55.  
  56. port = 8888
  57. max_connections = 10
  58.  
  59. pooler_port = 1010
  60.  
  61. max_pool_size = 10
  62. #pool_conn_keepalive = 600
  63.  
  64. #pool_maintenance_timeout = 30
  65.  
  66. #persistent_datanode_connections = off
  67.  
  68. max_coordinators = 2
  69.  
  70. max_datanodes = 2
  71.  
  72.  
  73. #gtm_host = '*'
  74.  
  75. gtm_port = 6666
  76.  
  77. pgxc_node_name = 'datanode1'
  78.  
  79. # TYPE DATABASE USER ADDRESS METHOD
  80.  
  81. # "local" is for Unix domain socket connections only
  82. local all all trust
  83. # IPv4 local connections:
  84. host all all 127.0.0.1/32 trust
  85. # IPv6 local connections:
  86. host all all ::1/128 trust
  87. # Allow replication connections from localhost, by a user with the
  88. # replication privilege.
  89. #local replication apple trust
  90. #host replication apple 127.0.0.1/32 trust
  91. #host replication apple ::1/128 trust
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement