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
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 |