| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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..?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2011-05-30 21:14:55 | Re: Tablas no modificables |
| Previous Message | Marcos Ortiz | 2011-05-30 20:42:43 | Re: Tablas no modificables |