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