Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- apple@ubuntu:/usr/local/pgsql/bin$ ./psql postgres -p 7777 -h localhost
- psql (PGXL 9.2.0, based on PG 9.2.4 (Postgres-XL 9.2.0))
- Type "help" for help.
- postgres=# SELECT pgxc_pool_reload();
- pgxc_pool_reload
- ------------------
- t
- (1 row)
- postgres=# INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27');
- INSERT 0 0
- apple@ubuntu:/usr/local/pgsql/bin$ ./psql postgres -c "select * from pgxc_node" -p 7777 -h localhost
- node_name | node_type | node_port | node_host | nodeis_primary | nodeis_preferr
- ed | node_id
- -----------+-----------+-----------+-----------+----------------+---------------
- ---+------------
- coord1 | C | 5432 | localhost | f | f
- | 1885696643
- datanode1 | D | 8888 | localhost | f | f
- | 888802358
- (2 rows)
- # - Connection Settings -
- #listen_addresses = 'localhost'
- port = 7777
- max_connections = 10
- pooler_port = 9999
- max_pool_size = 10
- #pool_conn_keepalive = 600
- #pool_maintenance_timeout = 30
- #persistent_datanode_connections = off
- max_coordinators = 2
- max_datanodes = 2
- #gtm_host = '*'
- gtm_port = 6666
- pgxc_node_name = 'coord1'
- # - Connection Settings -
- #listen_addresses = 'localhost'
- port = 8888
- max_connections = 10
- pooler_port = 1010
- max_pool_size = 10
- #pool_conn_keepalive = 600
- #pool_maintenance_timeout = 30
- #persistent_datanode_connections = off
- max_coordinators = 2
- max_datanodes = 2
- #gtm_host = '*'
- gtm_port = 6666
- pgxc_node_name = 'datanode1'
- # TYPE DATABASE USER ADDRESS METHOD
- # "local" is for Unix domain socket connections only
- local all all trust
- # IPv4 local connections:
- host all all 127.0.0.1/32 trust
- # IPv6 local connections:
- host all all ::1/128 trust
- # Allow replication connections from localhost, by a user with the
- # replication privilege.
- #local replication apple trust
- #host replication apple 127.0.0.1/32 trust
- #host replication apple ::1/128 trust
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement