Re: [PERFORM] help me problems with pg_clog file

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Gourish Singbal <gourish(at)gmail(dot)com>
Cc: Joao <joao(dot)junior(at)conab(dot)gov(dot)br>, pgsql-performance(at)postgresql(dot)org, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [PERFORM] help me problems with pg_clog file
Date: 2006-06-05 14:48:41
Message-ID: 20060605144841.GR53487@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

On Fri, Jun 02, 2006 at 01:11:27PM +0530, Gourish Singbal wrote:
> This Error came since the 0002 file from the pg_clog folder was missing.
> Since the logs are missing from pg_clog folder can perfom pg_resetxlogs to
> reset the logs and bring up the database.

Understand that this will almost certainly lose some of your data.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2006-06-05 16:03:09 Re: restoring data tree from old 7.3 database
Previous Message Averbukh Stella 2006-06-05 13:13:02 Re: Problem building initdb on sparc10

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-06-05 15:04:25 Re: Bulk loading/merging
Previous Message Jim C. Nasby 2006-06-05 14:43:49 Re: vacuuming problems continued