[OT] Slony + Alter table using pgadmin

Started by Ow Mun Hengabout 18 years ago2 messagesgeneral
Jump to latest
#1Ow Mun Heng
Ow.Mun.Heng@wdc.com

This is OT for this list and I don't have access to I-net (only email)
and I'm not subscribed to the Slony list.

I need to add a few additional columns to an existing replicated
set/table. I know that I can't just add the columns normally but have to
go through slonik's EXECUTE SCRIPT (/usr/bin/slonik_execute_script), but
I've never done this before.

Additionally, there's an option in Pgadmin, which I _think_ also does
this automatically using built-in slonik_execute-script equivalent.

Has anyone done this before? (it outputs this in the SQL. Can I add more
than 1 column per instance?)

-- Execute replicated using cluster "_my_cluster", set 4
ALTER TABLE xmms.d_product_e
ADD COLUMN aaaa integer;

PS : I can't test this out since my test_db virtual machine is at home.

many thanks..

#2Michael Glaesemann
grzm@seespotcode.net
In reply to: Ow Mun Heng (#1)
Re: [OT] Slony + Alter table using pgadmin

On Jan 29, 2008, at 23:42 , Ow Mun Heng wrote:

This is OT for this list and I don't have access to I-net (only email)
and I'm not subscribed to the Slony list.

To see your options for the slony1-general mailing list by email,
send a message to:

Slony1-general-request@lists.slony.info

with the word `help' in the subject or body (don't include the
quotes), and you will get back a message with instructions.

Michael Glaesemann
grzm seespotcode net