Mon Aug 4 12:39:55 PDT 2008
- Previous message: [Slony1-general] provider I/P address has been changed
- Next message: [Slony1-general] How to add more slaves to an existing replication set
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Thanks Bill for your reply about store_path. With a little massaging it finally worked. Now I am going to show my total inexperience with this product. We are running slony 1.2.14 by the way. I am running it in development where I have the luxury of totally shutting down the provider machine and restarting if need be. This is what I had to do to restart the slons pointing to the new I/P address and now we are up again. Before I performed this 'last resort' I attempted to Restart the slons by simply reissuing the slon command: Slon slonypractice "dbname=whatever user=postgres host=newipaddress" And of course I got a 'slon already running - duplicate pk' type of error There must be a better way of restarting the slons short of killing and Restarting the machine. I tried 'DROP NODE' couldn't get that to work. I'd appreciate some insight on this. Is there a document within or without www.slony.info that has basic 'how to' administrative tasks that I can refer to? Thanks for your time. ______________________________ Mark Steben│Database Administrator│ @utoRevenueT 480 Pleasant Street, Suite B200, Lee, MA 01238 413-243-4800 x1512 (Phone) │ 413-243-4809 (Fax) A Division of Dominion Enterprises -----Original Message----- From: Bill Moran [mailto:wmoran at collaborativefusion.com] Sent: Monday, August 04, 2008 7:43 AM To: Mark Steben Cc: slony1-general at lists.slony.info Subject: Re: [Slony1-general] provider I/P address has been changed In response to "Mark Steben" <msteben at autorevenue.com>: > Hi, > Due to an I/P addressing conflict with our parent company our systems > administrator had to change the IP addresses of each of our desktop > machines. So, the provider of our working slonik configuration has been > Changed to 10.10.5.25, from 10.10.1.25. Do I have to run another 'store > path' and 'store listen' to point to the new I/P? You don't say what version of Slony you're running, but newer versions don't need the "store listen" at all. However, a new "store path" should take care of things. You may need to restart the slons to get them to notice. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ wmoran at collaborativefusion.com Phone: 412-422-3463x4023 **************************************************************** IMPORTANT: This message contains confidential information and is intended only for the individual named. If the reader of this message is not an intended recipient (or the individual responsible for the delivery of this message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this message is prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. ****************************************************************
- Previous message: [Slony1-general] provider I/P address has been changed
- Next message: [Slony1-general] How to add more slaves to an existing replication set
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list