Hi Deepak, Another related question. If I enable the wal archive on many machine, is it ok to have the WAL location be the same for all of my machine? Or should thay be saved at different location.
Currently my archive_command is like this: 'rsync -e "ssh -o StrictHostKeyChecking=no -i /opt/PostgreSQL/8.3/data/id_dsa -l harold" %p har...@xxxx:~/exchange/wal/%f < /dev/null' Will that cause conflicts, since all of my machines have har...@xxxx:~/exchange/wal/%f Thanks, Harold --- On Tue, 4/7/09, DM <[email protected]> wrote: > From: DM <[email protected]> > Subject: Re: [Pgpool-general] Question about Online Recovery > To: [email protected], [email protected] > Date: Tuesday, April 7, 2009, 12:07 PM > Harold, > > WAL archives can be enabled on one machine or many machines > it depends on > how you want. > Assuming you have 2 systems one primary and another > standby, in real time > scenario any system can go down. Its better to enable WAL > on both system so > that if one fails you could recover from other. > > For your issue with recovery make sure that you have added > both of your > system ip address or host name in pgpool_hba.conf file and > try executing > your scripts one by one you should be able to debug it. > > Also copy the scripts to recover the database on both > machines. > > I can send you my steps to recovery if you want. Its same > as Gerd's but > little modification. > > - Deepak > ----------------------------------------------------------- > > > Message: 2 > > Date: Mon, 6 Apr 2009 15:32:34 -0700 (PDT) > > From: Harold Lim <[email protected]> > > Subject: [Pgpool-general] Question about Online > Recovery > > To: [email protected] > > Message-ID: > <[email protected]> > > Content-Type: text/plain; charset=us-ascii > > > > > > Hi All, > > > > I'm trying to setup the online recovery. I'm > following the > > tutorial/beginners guide written by Gerd. > > > > I am getting an error for 2nd stage. Any idea what the > problem might be? > > > > > > Below is the log file: > > > > 2009-04-06 18:28:14 DEBUG: pid 25867: pcp_child: > authentication OK > > 2009-04-06 18:28:14 DEBUG: pid 25867: pcp_child: > received PCP packet type > > of service 'O' > > 2009-04-06 18:28:14 DEBUG: pid 25867: pcp_child: start > online recovery > > 2009-04-06 18:28:14 LOG: pid 25867: starting > recovering node 1 > > 2009-04-06 18:28:14 DEBUG: pid 25867: exec_checkpoint: > start checkpoint > > 2009-04-06 18:28:14 DEBUG: pid 25867: exec_checkpoint: > finish checkpoint > > 2009-04-06 18:28:14 LOG: pid 25867: CHECKPOINT in > the 1st stage done > > 2009-04-06 18:28:14 LOG: pid 25867: starting > recovery command: "SELECT > > pgpool_recovery('copy_base_backup', > '172.16.63.10', > > '/opt/PostgreSQL/8.3/data')" > > 2009-04-06 18:28:14 DEBUG: pid 25867: exec_recovery: > start recovery > > 2009-04-06 18:28:22 DEBUG: pid 25834: starting health > checking > > 2009-04-06 18:28:22 DEBUG: pid 25834: health_check: 0 > th DB node status: 1 > > 2009-04-06 18:28:22 DEBUG: pid 25834: health_check: 1 > th DB node status: 3 > > 2009-04-06 18:28:33 DEBUG: pid 25867: exec_recovery: > finish recovery > > 2009-04-06 18:28:33 LOG: pid 25867: 1st stage is > done > > 2009-04-06 18:28:33 LOG: pid 25867: starting 2nd > stage > > 2009-04-06 18:28:33 LOG: pid 25867: all connections > from clients have > > been closed > > 2009-04-06 18:28:33 DEBUG: pid 25867: exec_checkpoint: > start checkpoint > > 2009-04-06 18:28:33 DEBUG: pid 25867: exec_checkpoint: > finish checkpoint > > 2009-04-06 18:28:33 LOG: pid 25867: CHECKPOINT in > the 2nd stage done > > 2009-04-06 18:28:33 LOG: pid 25867: starting > recovery command: "SELECT > > pgpool_recovery('pgpool_recovery_pitr', > '172.16.63.10', > > '/opt/PostgreSQL/8.3/data')" > > 2009-04-06 18:28:33 DEBUG: pid 25867: exec_recovery: > start recovery > > 2009-04-06 18:28:33 ERROR: pid 25867: exec_recovery: > pgpool_recovery_pitr > > command failed at 2nd stage > > 2009-04-06 18:28:33 DEBUG: pid 25867: exec_recovery: > finish recovery > > 2009-04-06 18:28:33 DEBUG: pid 25867: pcp_child: > received PCP packet type > > of service 'X' > > 2009-04-06 18:28:33 DEBUG: pid 25867: pcp_child: > client disconnecting. > > close connection > > > > Thanks! > > Harold > > > > > > > > > > > > > > ------------------------------ > > > > Message: 3 > > Date: Mon, 6 Apr 2009 16:42:20 -0700 (PDT) > > From: Harold Lim <[email protected]> > > Subject: [Pgpool-general] Online recovery + WAL > archiving > > To: [email protected] > > Message-ID: > <[email protected]> > > Content-Type: text/plain; charset=us-ascii > > > > > > Hi, > > > > I'm currently looking at the pgpool-ii > beginner's guide. > > I'm mainly interested in online recovery (e.g, > dynamically adding a new > > postgresql node). > > > > Do I have to enable wal archiving for all of my node? > or just for my first > > node? > > > > > > > > Thanks!, > > Harold > > > > > > > > > > > > > > ------------------------------ > > > > _______________________________________________ > > Pgpool-general mailing list > > [email protected] > > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > > > > End of Pgpool-general Digest, Vol 53, Issue 5 > > ********************************************* > > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
