Mark Steben msteben at autorevenue.com
Mon Aug 4 12:39:55 PDT 2008
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.
****************************************************************



More information about the Slony1-general mailing list