Skip site navigation (1) Skip section navigation (2)

error al tratar de instalar funciones de dblink

From: Diego Ayala <netdiego81(at)gmail(dot)com>
To: Postgres Ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: error al tratar de instalar funciones de dblink
Date: 2011-05-30 21:02:24
Message-ID: BANLkTi=W0UJ5gmRHA83_X1afV3vC65r3MA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
buenas tardes, estoy tratando de correr por consola el script para crear las
funciones del dblink, pero al correr me genera el siguiente error..

 psql -f /usr/share/pgsql/contrib/dblink.sql -p 9999 db_prueba

SET
psql:/usr/share/pgsql/contrib/dblink.sql:11: ERROR:  kind mismatch among
backends. Possible last query was: "CREATE OR REPLACE FUNCTION
dblink_connect (text)
RETURNS text
AS '$libdir/dblink','dblink_connect'
LANGUAGE C STRICT;" kind details are: 0[C] 1[E: no se pudo acceder al
archivo «$libdir/dblink»: No
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
psql:/usr/share/pgsql/contrib/dblink.sql:11: connection to server was lost,
 es un servidor postgresql 8.4.8, de 64 bits, y conectado a un esclavo
mediante pgpool... como podria solucionarlo..?

Responses

pgsql-es-ayuda by date

Next:From: Jaime CasanovaDate: 2011-05-30 21:14:55
Subject: Re: Tablas no modificables
Previous:From: Marcos OrtizDate: 2011-05-30 20:42:43
Subject: Re: Tablas no modificables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group