Mon Aug 8 18:45:40 PDT 2005
- Previous message: [Slony1-general] Problem with Database Replication
- Next message: [Slony1-general] Authentication / Connection Problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi everyone,
I'm having connection problems when I try to run slon on my master
database. The master was configured with the following connection lines:
node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST
port=$MASTERPORT user=$MASTERDBA password=mypass';
node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST
port=$SLAVEPORT user=$SLAVEDBA password=mypass';
I invoke slon with the following confg value:
conn_info='dbname=$MASTERDBNAME user=$MASTERDBA password=mypass
host=$MASTERHOST port=$MASTERPORT'
I read in my slon logs:
2005-08-05 14:19:27 EDT WARN remoteListenThread_2: DB connection
failed - sleep 10 seconds
2005-08-05 14:19:29 EDT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 42
2005-08-05 14:19:29 EDT DEBUG2 localListenThread: Received event 1,42 SYNC
2005-08-05 14:19:37 EDT ERROR slon_connectdb:
PQconnectdb("dbname=$SLAVEDBNAME host=$SLAVEHOST port=$SLAVEPORT
user=$SLAVEDBA ") failed - fe_sendauth: no password supplied
It appears that I'm failing to submit a password, but that seems totally
contrary to my configuration values.
I'm sure that I'm missing something simple here; any suggestions are
greatly welcome.
Thanks,
Andrew Gold
- Previous message: [Slony1-general] Problem with Database Replication
- Next message: [Slony1-general] Authentication / Connection Problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list