On 1/6/2005 2:20 PM, Christopher Browne wrote:
> Brad Nicholson wrote:
> 
>> Vivek Khera wrote:
>>
>>>
>>> On Jan 5, 2005, at 1:03 PM, sarlav kumar wrote:
>>>
>>>> I do the following things:
>>>>
>>>> pg_dump -s -h $MASTERHOST -U $REPLICATIONUSER $MASTERDBNAME > dumpfile
>>>> I am attaching the dumpfile with this email. If you look at the 
>>>> dumpfile, it creates an operator "=" though I did not create the 
>>>> operator in the database.
>>>>
>>>
>>> you're dumping a schema that's been altered by slony already.  Jan 
>>> posted a script here the other day to get a "clean" dump from a 
>>> database that's already slony-fied.
>>>
>>>
>>
>> You could also import the dump, and then drop the slony schema with 
>> the CASACADE option to clean out the slony stuff.
> 
> I should point out one problem with the "drop schema" scenario; that 
> doesn't cope with tables where Slony-I added in a column to provide a 
> primary key.  Those columns are not in the Slony-I namespace, so they 
> don't get dropped.
> 
> And they reference a sequence that gets dropped, so that things wind up 
> not quite totally clean :-(.

Which is the reason for that script, which can be found in the CVS tree 
under tools.


Jan


> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #