数据库 主从备份

[llccluf]

关于postgres数据库的主从备份。有人实现过吗？
我用pgpool2实现。配置完成后，用psql已经可以登录postgres后台。

但是用OpenERP还是有错误，psycopg2还是会报错。不知是不是遗漏配置信息的关系。
先谢谢回复的人拉。


错误信息如下
2013-04-20 11:49:28,030 10199 ERROR trunk_demo openerp.sql_db: Connection to the database failed
Traceback (most recent call last):
  File "/home/scipsita/openerp/trunk/server/openerp/sql_db.py", line 428, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
  File "/usr/lib/python2.7/dist-packages/psycopg2/init.py", line 180, in connect
    connection_factory=connection_factory, async=async)
OperationalError
2013-04-20 11:49:28,031 10199 ERROR trunk_demo openerp.netsvc:
Traceback (most recent call last):
  File "/home/scipsita/openerp/trunk/server/openerp/netsvc.py", line 237, in dispatch_rpc
    result = dispatch(method, params)
  File "/home/scipsita/openerp/trunk/server/openerp/service/common.py", line 31, in dispatch
    return fn(*params)
  File "/home/scipsita/openerp/trunk/server/openerp/service/common.py", line 42, in exp_authenticate
    res_users = openerp.registry(db)['res.users']
  File "/home/scipsita/openerp/trunk/server/openerp/init.py", line 61, in registry
    return modules.registry.RegistryManager.get(database_name)
  File "/home/scipsita/openerp/trunk/server/openerp/modules/registry.py", line 192, in get
    update_module)
  File "/home/scipsita/openerp/trunk/server/openerp/modules/registry.py", line 204, in new
    registry = Registry(db_name)
  File "/home/scipsita/openerp/trunk/server/openerp/modules/registry.py", line 76, in init
    cr = self.db.cursor()
  File "/home/scipsita/openerp/trunk/server/openerp/sql_db.py", line 472, in cursor
    return Cursor(self._pool, self.dbname, serialized=serialized)
  File "/home/scipsita/openerp/trunk/server/openerp/sql_db.py", line 178, in init
    self._cnx = pool.borrow(dsn(dbname))
  File "/home/scipsita/openerp/trunk/server/openerp/sql_db.py", line 373, in _locked
    return fun(self, *args, **kwargs)
  File "/home/scipsita/openerp/trunk/server/openerp/sql_db.py", line 428, in borrow
    result = psycopg2.connect(dsn=dsn, connection_factory=PsycoConnection)
  File "/usr/lib/python2.7/dist-packages/psycopg2/init.py", line 180, in connect
    connection_factory=connection_factory, async=async)
OperationalError