Hola lista, tengo el siguiente problema estoy configurando pyreplica con
maestro-esclavo mi esclavo lo tengo en mi localhost y el maestro en otro
servidor, ya ejecute en mi maestro el scrip sql master-install.sql y mi
somedb.conf con los parametros que indica el archivo de instalacion, ahora
cuando ejecuto:
r...@servidor-desktop:/usr/local/pyreplica# python pyreplica.py
"dbname=db_control_seguimiento user=postgres host=172.16.1.208"
"dbname=db_control_seguimiento user=postgres host=localhost"
me genera este error:
Thu Dec 17 14:41:22 2009 Opening origin (master) connection
Thu Dec 17 14:41:22 2009 connect(): FATAL ERROR: fe_sendauth: no password
supplied
Traceback (most recent call last):
File "pyreplica.py", line 221, in <module>
main_loop(DSN0,DSN1,is_killed=lambda:False, skip_user='',
slave_field=FIELD, keepalive = True)
File "pyreplica.py", line 153, in main_loop
con0, con1 = connect(dsn0, dsn1, debug)
File "pyreplica.py", line 133, in connect
con0 =
psycopg2.connect(dsn0,connection_factory=tpc.TwoPhaseCommitConnection)
File "/usr/local/pyreplica/tpc.py", line 27, in __init__
connection.__init__(self,*args,**kwargs)
psycopg2.OperationalError: fe_sendauth: no password supplied
y si ejecuto:
/etc/usr/local/pyreplica.py star en mi log se genera lo siguiente:
controlseguimiento Thu Dec 17 14:34:11 2009 Opening origin (master) connection
controlseguimiento Thu Dec 17 14:34:11 2009 Opening replica (slave) connection
controlseguimiento Thu Dec 17 14:34:46 2009 Opening origin (master) connection
controlseguimiento Thu Dec 17 14:34:46 2009 Opening replica (slave) connection
mi somedb.conf esta asi
[MAIN]
# name of replica set (first field of log file entries)
NAME=controlseguimiento
# master database connection string:
DSN0=dbname=db_control_seguimiento user=postgres password=123456
host=172.16.1.208
# slave database connection string:
DSN1=dbname=db_control_seguimiento user=postgres password=123456 host=
localhost
# in multimaster setup, set the replication postgres user
SKIP_USER=pyreplica
# in multi-slave setup, set the slave column to mark data as replicated
SLAVE_FIELD=replicated
# send a trivial query to keep alive the connection (optional)
KEEPALIVE=true
# optional debug level (0: none, 1: normal, 2: verbose, 3: very verbose)
DEBUG_LEVEL=1
lo siguiente esta comentado porque todavia no tengo el correo
# email notification config (optional):
#[SMTP]
#SERVER=somehost.somewhere.com
# login is optional:
#[email protected]
#PASSWORD=secret
#START_SUBJECT=[PyReplica] Starting db_control_seguimiento replication
#START_SUBJECT=[PyReplica] Starting db_control_seguimiento replication
#STOP_SUBJECT=[PyReplica] Stopping db_control_segumiento replication
#ERROR_SUBJECT=[PyReplica] Starting db_control_seguimiento replication (ERROR)
#WARNING_SUBJECT=[Replica] WARNING on db_control_seguimiento replication
#[email protected]
#[email protected];[email protected]
si alguien me puede ayudar por favor....
_________________________________________________________________
