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

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 (view raw or flat)
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

pgsql-es-ayuda by date

Next:From: jlcamberoDate: 2007-11-19 12:16:41
Subject: Re: duda con función
Previous:From: Rodriguez FernandoDate: 2007-11-19 11:17:39
Subject: Re: Preocupacion con PostgreSQL

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