Pessoal
Estou tentanto instalar o slony, so q ocorre o seguinte erro
%/usr/local/etc/slonu.sh
<stdin>:4: PGRES_FATAL_ERROR load '$libdir/xxid'; - ERROR: must be
superuser to do LOAD
<stdin>:4: Error: the extension for the xxid data type cannot be loaded
in database 'dbname=slonytmaster host=fileserver user=slonyt'
<stdin>:4: ERROR: no admin conninfo for node 134590976
%
meu script
#!/bin/sh
CLUSTER=sql_cluster
DB1=slonytmaster
DB2=slonytslave
H1=fileserver
H2=freebsd
U=slonyt
slonik <<_EOF_
cluster name = $CLUSTER;
node 1 admin conninfo = 'dbname=$DB1 host=$H1 user=$U';
node 2 admin conninfo = 'dbname=$DB2 host=$H2 user=$U';
init cluster (id = 1, comment = 'Node 1');
create set (id = 1, origin = 1,
comment = 'contact table');
set add table (set id = 1, origin = 1, id = 1,
full qualified name = 'public.contact',
comment = 'Table contact');
set add sequence (set id = 1, origin = 1, id = 2,
full qualified name = 'public.contact_seq',
comment = 'Sequence contact_seq');
store node (id = 2, comment = 'Node 2');
store path (server = 1, client = 2,
conninfo = 'dbname=$DB1 host=$H1 user=$U');
store path (server = 2, client = 1,
conninfo = 'dbname=$DB2 host=$H2 user=$U');
store listen (origin = 1, provider = 1, receiver = 2);
store listen (origin = 2, provider = 2, receiver = 1);
Estou rodando freebsd/Pg 8
Prometo q se me ajudarem escrevo um artigo pro slony..risos
Att Giancarlo
_______________________________________________
Grupo de Usuários do PostgreSQL no Brasil
http://www.postgresql.org.br
