Hello Guillaume,

ok, that was my mistake. but now I altered the psql command accordingly and
this is the output:

fquest-b1:~ # psql -U $PGBENCHUSER -h localhost -d $MASTERDBNAME -c "begin;
alter table pgbench_history add column id serial; update pgbench_history set
id =
nextval('history_id_seq'); alter table pgbench_history add primary key(id);
commit";
NOTICE:  ALTER TABLE will create implicit sequence "pgbench_history_id_seq"
for serial column "pgbench_history.id"
ERROR:  relation "history_id_seq" does not exist
LINE 2: nextval('history_id_seq'); alter table pgbench_history add p...
                ^
fquest-b1:~ # psql -U $PGBENCHUSER -h localhost -d $MASTERDBNAME -c
"begin;update pgbench_history set id = nextval('pgbench_history_id_seq');
alter table pgbench_history add primary key(id); commit";
ERROR:  relation "pgbench_history_id_seq" does not exist
LINE 1: begin;update pgbench_history set id = nextval('pgbench_histo...

I really don't get it. Where should the relation "pgbench_history_id_seq"
come from, do I have to create everything manually? Slony is kind of a pain
in the ass for novices like me, excuse my language.
My colleage says, "but when it is finally running, it is solid as a rock and
amazingly fast". I'd like to experience that soon :)

Thanks for your time.

Have a great weekend,
Marcus


Guillaume Lelarge-3 wrote:
> 
> On Thu, 2011-07-21 at 04:52 -0700, marmu wrote:
>> Hello Guys,
>> 
>> at first, thanks Stéphane for your input. But after getting some more
>> errors
>> and not finding any suitable solutions, I already started from scratch. I
>> dropped both databases and did the following acording to the slony
>> documentation:
>> http://pastebin.com/RTJ5c4kY
>> 
>> The problem now is as follows (extract from the pastebin above): 
>> ...
>> fquest-b1:/etc/slony-I # pgbench -i -s 1 -U $PGBENCHUSER -h $MASTERHOST
>> $MASTERDBNAME
>> NOTICE:  table "pgbench_branches" does not exist, skipping
>> NOTICE:  table "pgbench_tellers" does not exist, skipping
>> NOTICE:  table "pgbench_accounts" does not exist, skipping
>> NOTICE:  table "pgbench_history" does not exist, skipping
>> ...
>> fquest-b1:/etc/slony-I # psql -U $PGBENCHUSER -h localhost -d
>> $MASTERDBNAME
>> -c "begin; alter table
>> history add column id serial; update history set id =
>> nextval('history_id_seq'); alter table history add primary key(id);
>> commit"
>> ERROR:  relation "history" does not exist
>> 
>> Why isn't the relation "history" created? Any ideas? I am really stuck
>> here.
>> Thanks again in advance.
>> 
> 
> Because its name is not history but pgbench_history. And ditto for the
> sequence.
> 
> 
> -- 
> Guillaume
>   http://blog.guillaume.lelarge.info
>   http://www.dalibo.com
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 

-- 
View this message in context: http://old.nabble.com/Is-it-possible-to-add-slony-to-an-existing-DB-%28imported-from-old-slony-server%29--tp32092506p32116280.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.