Hi, Recovery mode uses rsync command in order to sync DB data from other cluster DB. 'rsync' command uses some key files under '$HOME/.ssh' directory. According to your debug log, $HOME=/root. This is the cause of the error.
Regards, -- At.Mitani On Thu, 07 Jan 2010 16:22:11 +0000 avelino <[email protected]> wrote: > Hi, all. > > I have configured a pgcluster with 1 load balancer, 1 replication server > and 2 cluster DBs (a very simple configuration) and the pgcluster runs > fine (pgcluster-1.9.0rc7 with the "dollar quoting" patch, > http://pgfoundry.org/pipermail/pgcluster-general/2006-May/000718.html). > The load balancer and the cluster #1 runs both on a machine and the > replication server and the cluster #2 runs both on another machine. I > want to add another cluster #3 from a third machine, but when I want to > do this I get the following error > > [r...@altisidora ~]# sudo -u dbadmin /opt/pgcluster-cluster3/bin/pg_ctl > -D /opt/pgcluster-cluster3/data start -o "-R" > could not change directory to "/root" > server starting > [r...@altisidora ~]# DEBUG: 00000: postgres: PostmasterMain: initial > environ dump: > LOCATION: PostmasterMain, postmaster.c:819 > DEBUG: 00000: ----------------------------------------- > LOCATION: PostmasterMain, postmaster.c:821 > DEBUG: 00000: HOSTNAME=altisidora.mhp-interno.com > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: SHELL=/bin/bash > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: TERM=xterm > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: HISTSIZE=1000 > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: QTDIR=/usr/lib/qt-3.3 > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: USER=dbadmin > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: > > LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:do=00;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=00;32:*.tar=00;31:*.tgz=00;31:*.svgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.dz=00;31:*.gz=00;31:*.bz2=00;31:*.tbz2=00;31:*.bz=00;31:*.tz=00;31:*.deb=00;31:*.rpm=00;31:*.jar=00;31:*.rar=00;31:*.ace=00;31:*.zoo=00;31:*.cpio=00;31:*.7z=00;31:*.rz=00;31:*.jpg=00;35:*.jpeg=00;35:*.gif=00;35:*.bmp=00;35:*.pbm=00;35:*.pgm=00;35:*.ppm=00;35:*.tga=00;35:*.xbm=00;35:*.xpm=00;35:*.tif=00;35:*.tiff=00;35:*.png=00;35:*.mng=00;35:*.pcx=00;35:*.mov=00;35:*.mpg=00;35:*.mpeg=00;35:*.m2v=00;35:*.mkv=00;35:*.ogm=00;35:*.mp4=00;35:*.m4v=00;35:*.mp4v=00;35:*.vob=00;35:*.qt=00;35:*.nuv=00;35:*.wmv=00;35:*.asf=00;35:*.rm=00;35:*.rmvb=00;35:*.flc=00;35:*.avi=00;35:*.fli=00;35:*.gl=00;35:*.dl=00;35:*.xcf=00;35:*.xwd=00;35:*.yuv=00;35:*.svg=00;35:*.aac=00;36:*.au=00;36:*.flac=0 0; > > 36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36: > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: SUDO_USER=root > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: SUDO_UID=0 > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: USERNAME=dbadmin > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: PATH=/sbin:/bin:/usr/sbin:/usr/bin > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: MAIL=/var/spool/mail/root > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: PWD=/opt/pgcluster-cluster3/bin > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: INPUTRC=/etc/inputrc > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: lang=es...@euro > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: SHLVL=1 > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: SUDO_COMMAND=/opt/pgcluster-cluster3/bin/pg_ctl -D > /opt/pgcluster-cluster3/data start -o -R > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: HOME=/root > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: LOGNAME=dbadmin > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: PGDATA=/opt/pgcluster-cluster3/data > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: SUDO_GID=0 > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: _=/opt/pgcluster-cluster3/bin/postgres > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: PGSYSCONFDIR=/opt/pgcluster-cluster3/etc/postgresql > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: lc_collate=es...@euro > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: lc_ctype=es...@euro > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: lc_messages=es...@euro > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: LC_MONETARY=C > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: LC_NUMERIC=C > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: LC_TIME=C > LOCATION: PostmasterMain, postmaster.c:824 > DEBUG: 00000: ----------------------------------------- > LOCATION: PostmasterMain, postmaster.c:826 > ipc_fname[/opt/pgcluster-cluster3/data/cluster.ipc] > Start in recovery mode! > Please wait until a data synchronization finishes from Master DB... > DEBUG: 00000: no = 102 > LOCATION: show_recovery_packet, recovery.c:1086 > DEBUG: 00000: max_connect = 0 > LOCATION: show_recovery_packet, recovery.c:1087 > DEBUG: 00000: port = 0 > LOCATION: show_recovery_packet, recovery.c:1088 > DEBUG: 00000: recoveryPort = 0 > LOCATION: show_recovery_packet, recovery.c:1089 > DEBUG: 00000: hostName = > LOCATION: show_recovery_packet, recovery.c:1091 > DEBUG: 00000: pg_data = > LOCATION: show_recovery_packet, recovery.c:1093 > unknown packet[102] received > PGR_Recovery_Main() failed with cold recovery > DEBUG: 00000: proc_exit(0) > LOCATION: proc_exit, ipc.c:98 > DEBUG: 00000: shmem_exit(0) > LOCATION: shmem_exit, ipc.c:164 > DEBUG: 00000: exit(0) > LOCATION: proc_exit, ipc.c:116 > > I have put the log level to "debug5" and all the 4 servers (load > balancer, replication server and both two clusters) are up and running. > I cannot read the replication server log because "pgreplicate" is not > writing any log (?) (although it's configured to generate it). Thanks in > advance. > > _______________________________________________ > Pgcluster-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgcluster-general -- mitani <[email protected]> _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
