Re: VACUUM ANALYZE

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: "Stephan Szabo" <acroyear_07030(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: VACUUM ANALYZE
Date: 2001-07-18 12:43:38
Message-ID: 00b601c10f87$44ed79a0$aa5796d4@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I use 7.1.2 compiled with locale set to the he_IL

Last day I re initdb the whole data dir and dumped the data back to the
server.
Then I tried VACUM ANALYZE which worked :)
but next day it stopped working returning the next lines in the log (link)

http://www.canaan.co.il/users/miki/pg_errors.txt

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------

----- Original Message -----
From: "Stephan Szabo" <acroyear_07030(at)yahoo(dot)com>
To: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>; <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, July 17, 2001 8:25 PM
Subject: Re: [GENERAL] VACUUM ANALYZE

> What version are you using, and what does your postgres
> log show? There's probably more information there.
>
> ----- Original Message -----
> From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
> To: <pgsql-general(at)postgresql(dot)org>
> Sent: Tuesday, July 17, 2001 5:02 AM
> Subject: [GENERAL] VACUUM ANALYZE
>
>
> > Hi All
> >
> > VACUUM ANALYZE;
> >
> > return me the next error:
> >
> > pqReadData() -- backend closed the channel unexpectedly.
> > This probably means the backend terminated abnormally
> > before or while processing the request.
> > The connection to the server was lost. Attempting reset: Failed.
> >
> > Any ideas ?
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Werby 2001-07-18 13:02:37 Program to convert from PostgreSQL to Access or view table relationships
Previous Message Raymond Chui 2001-07-18 12:18:31 What is the syntax turn off auto commit?