| Lists: | pgsql-es-ayuda |
|---|
| From: | Luis José Ballesteros Toro <ljballesterostoro(at)gmail(dot)com> |
|---|---|
| To: | majordomo-owner(at)postgresql(dot)org |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | help postgreSql |
| Date: | 2007-11-17 15:18:35 |
| Message-ID: | 6ba9f3230711170718s1712b189t96ae21fa4eda1b1b@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-es-ayuda |
I have installed postgresql 8.2 on windows 2000 server.
i have Error no buffer available pqgetcopydata.
I am driving data that measured around 80 mb since tif images stored, but
when the sack backup or restore with I (pg_dump, pg_restore), I sample error
and aborts.
I changed the parameters of the file postgresql.conf (shared buffers), but
does not work for me, Thank you if I can help with this situation
--
Luis José Ballesteros Toro
| From: | Rodriguez Fernando <rodriguez(at)ort(dot)edu(dot)uy> |
|---|---|
| To: | Luis José Ballesteros Toro <ljballesterostoro(at)gmail(dot)com> |
| Cc: | majordomo-owner(at)postgresql(dot)org, pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: help postgreSql |
| Date: | 2007-11-19 11:28:29 |
| Message-ID: | 4741735D.5060107@ort.edu.uy |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-es-ayuda |
Hola, podrias probar:
vacuumlo -v -n <database>, en teoria esto te informa de los objetos "grandes" "huerfanos",
de esta manera podrias achicar tu base.
Cuando dices "restore with I", te refieres a index_name o i que es ignore version (notese la diferencia
de mayúscula y minúscula)
Saludos Fernando
Luis José Ballesteros Toro wrote:
>
> I have installed postgresql 8.2 on windows 2000 server.
>
> i have Error no buffer available pqgetcopydata.
>
>
> I am driving data that measured around 80 mb since tif images stored,
> but when the sack backup or restore with I (pg_dump, pg_restore), I
> sample error and aborts.
>
> I changed the parameters of the file postgresql.conf (shared buffers),
> but does not work for me,
> Thank you if I can help with this situation
>
>
> --
> Luis José Ballesteros Toro
| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Luis José Ballesteros Toro <ljballesterostoro(at)gmail(dot)com> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: help postgreSql |
| Date: | 2007-11-19 14:23:11 |
| Message-ID: | 20071119142311.GH13505@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-es-ayuda |
Luis José Ballesteros Toro escribió:
> I have installed postgresql 8.2 on windows 2000 server.
>
> i have Error no buffer available pqgetcopydata.
Hola, podrias explicar mas detalladamente lo que estas haciendo cuando
te aparece este error? ¿Quien te envia el error, el programa cliente o
el servidor?
--
Alvaro Herrera http://www.flickr.com/photos/alvherre/
"La conclusión que podemos sacar de esos estudios es que
no podemos sacar ninguna conclusión de ellos" (Tanenbaum)