- 论坛徽章:
- 0
|
应该只用在一台机器上配置就可以了。
你需要修改这几个参数:
backend_host_name
backend_port
secondary_backend_host_name
secondary_backend_port
比如:192.168.1.1的5432端口是一个服务器
192.168.1.2的5432端口是另一个postgres服务器
你需要配置成:
backend_host_name='192.168.1.1'
backend_port=5432
secondary_backend_host_name='192.168.1.2'
secondary_backend_port=5432
我刚才用pgpool连接了一下postgresql8.1和postgres8.2是可以的
我在一台计算机上,修改后为:
backend_host_name = '127.0.0.1'
backend_port = 5432
secondary_backend_host_name = '127.0.0.1'
secondary_backend_port = 5434
连接情况:
postgres@myhome:/home/cg$ psql -p 5433
口令:
Welcome to psql 8.1.6, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# |
|