Re: help postgreSql

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

In response to

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message jlcambero 2007-11-19 12:16:41 Re: duda con función
Previous Message Rodriguez Fernando 2007-11-19 11:17:39 Re: Preocupacion con PostgreSQL