No, that wasn't the entire script. From the error message it appears
that something is wrong in the
/usr/local/pgsql/share//slony1_funcs.v80.sql file.
The script up to that point was:
cluster name = d1clust;
node 1 admin conninfo = 'dbname=XXX host=localhost user=postgres';
node 2 admin conninfo = 'dbname=XXX host=p2i user=postgres';
#--
# init the first node. Its id MUST be 1. This creates the schema
# _d1clust containing all replication system specific database
# objects.
#--
init cluster ( id=1, comment = 'Master Node');
Andrew Hammond wrote:
> If that was your entire slonik script, then I'm not surprised it
> failed. If that was just a snippet, then how do you expect us to help
> you troubleshoot it?
>
> Andrew
>
>
> On 3/9/07, Joseph S <[email protected]> wrote:
>> When I try to init cluster, as per the example in the docs, I get:
>>
>> init cluster ( id=1, comment = 'Master Node');
>>
>>
>> <stdin>:21: loading of file
>> /usr/local/pgsql/share//slony1_funcs.v80.sql: PGRES_FATAL_ERROR ERROR:
>> function _d1clust.make_table_strict(text, text) does not exist
>> ERROR: function _d1clust.make_table_strict(text, text) does not exist
>> <stdin>:21: ERROR: no admin conninfo for node 160096504
>> _______________________________________________
>> Slony1-general mailing list
>> [email protected]
>> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>>
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
