PROBLEMA SLONY

From: "Fabio Arias" <fharias(at)gmail(dot)com>
To: PostgreSQL Español Ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: PROBLEMA SLONY
Date: 2008-11-06 21:44:16
Message-ID: c1d7f0f90811061344o5629eeaara33e495ee281ea24@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola listeros tengo problemas con una nueva replicacion con Slony, y m esta
dando mucha lata no he podido empezar a llenar los sets para la replicacion
por que sale un error de permisos y no se que pueda ser. Les pido su ayuda.
Muchas Gracias,

An error has occurred:

ERROR: permission denied for relation pg_class
CONTEXT: SQL statement "select T.tab_reloid, T.tab_set, T.tab_idxname,
T.tab_altered, S.set_origin, PGX.indexrelid,
"_cluster_replicacion_cbctso".slon_quote_brute(PGN.nspname)
|| '.' || "_cluster_replicacion_cbctso".slon_quote_brute(PGC.relname) as
tab_fqname from "_cluster_replicacion_cbctso".sl_table T,
"_cluster_replicacion_cbctso".sl_set S, "pg_catalog".pg_class PGC,
"pg_catalog".pg_namespace PGN, "pg_catalog".pg_index PGX,
"pg_catalog".pg_class PGXC where T.tab_id = $1 and T.tab_set = S.set_id
and T.tab_reloid = PGC.oid and PGC.relnamespace = PGN.oid and PGX.indrelid =
T.tab_reloid and PGX.indexrelid = PGXC.oid and PGXC.relname = T.tab_idxname
for update"
PL/pgSQL function "altertableforreplication" line 25 at SQL statement
SQL statement "SELECT
"_cluster_replicacion_cbctso".alterTableForReplication( $1 )"
PL/pgSQL function "setaddtable_int" line 109 at perform
SQL statement "SELECT "_cluster_replicacion_cbctso".setAddTable_int( $1 ,
$2 , $3 , $4 , $5 )"
PL/pgSQL function "setaddtable" line 37 at perform

--
Fabio Hernando Arias Vera
Cel. 314 411 7776

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2008-11-06 21:49:03 Re: PROBLEMA SLONY
Previous Message Alvaro Herrera 2008-11-06 20:49:56 Re: Mantenimiento