I was able to solve the problem by remming out these lines:

comment on function @[EMAIL PROTECTED] (text, text) is
'Equivalent to 8.1+ ALTER FUNCTION ... STRICT';

Hopefully that is all I have to do.

What is this SEARCH_PATH? I did a search for it in the postgresql docs 
but the search didn't come up with anything.

Melvin Davidson wrote:
>> ERROR: no admin conninfo for node 160096504
>  
> Check that your replication user has a default schema.
> I've found that if the default schema is not set, your
> will get that error. It's misleading because it makes
> you think your connection info may be wrong, but 
> actually it's slony getting confused as to default 
> schema.
> 
> Also check that your pg_hba,conf on both master and slave
> allows connections from each other.
> 
> connect on both the master and slave(s) as the replication user
> and then
>  ALTER USER <replication user> SET SEARCH_PATH TO
> <some_existing_schema>; 
> 
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to