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

Re: Missing pg_clog files

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: "Carol Walter" <walterc(at)indiana(dot)edu>,"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Missing pg_clog files
Date: 2008-09-24 04:16:27
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C0378F512@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Carol,

I detect in you some apprehension as to pg_dumpall
won't run or complete.  Why is that?  Have you already
done it and it didn't work?  If that's not the case,
why not run pg_dumpall at a quiet hour and see?

I think Scott is right as to install the latest
8.2 on top.  It won't be time consuming task.
Why not give it a wheel?  It would be good to
find out one way or the other.


Scott: Are files 0000 through 002F (which are
not there) absolutely necessary for recovering data?

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu



-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org on behalf of Carol Walter
Sent: Tue 9/23/2008 8:35 PM
To: Scott Marlowe
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Missing pg_clog files
 
Hello,

Here are the pg_clog files I still have.

-rw-------   1 postgres postgres  262144 Jun  4 18:43 0030
-rw-------   1 postgres postgres  262144 Jun  6 02:06 0031
-rw-------   1 postgres postgres  262144 Jun  7 01:26 0032
-rw-------   1 postgres postgres  262144 Jun  7 21:26 0033
-rw-------   1 postgres postgres  262144 Jun  8 23:16 0034
-rw-------   1 postgres postgres  262144 Jun  9 21:46 0035
-rw-------   1 postgres postgres  262144 Jun 11 06:33 0036
-rw-------   1 postgres postgres  262144 Jun 13 08:33 0037
-rw-------   1 postgres postgres  262144 Jun 16 04:20 0038
-rw-------   1 postgres postgres  262144 Jun 18 11:36 0039
-rw-------   1 postgres postgres  262144 Jun 21 17:06 003A
-rw-------   1 postgres postgres  262144 Jun 24 18:43 003B
-rw-------   1 postgres postgres  262144 Jun 26 05:26 003C
-rw-------   1 postgres postgres  262144 Jun 27 18:40 003D
-rw-------   1 postgres postgres  262144 Jun 28 19:06 003E
-rw-------   1 postgres postgres  262144 Jun 30 09:10 003F
-rw-------   1 postgres postgres  262144 Jul  2 23:40 0040
-rw-------   1 postgres postgres  262144 Jul  4 17:03 0041
-rw-------   1 postgres postgres  262144 Jul  6 03:30 0042
-rw-------   1 postgres postgres  262144 Jul  7 23:06 0043
-rw-------   1 postgres postgres  262144 Jul  9 12:53 0044
-rw-------   1 postgres postgres  262144 Jul 12 19:13 0045
-rw-------   1 postgres postgres  262144 Jul 17 08:06 0046
-rw-------   1 postgres postgres  262144 Jul 21 07:56 0047
-rw-------   1 postgres postgres  262144 Jul 26 22:06 0048
-rw-------   1 postgres postgres  262144 Aug  2 02:10 0049
-rw-------   1 postgres postgres  262144 Aug  5 21:50 004A
-rw-------   1 postgres postgres  262144 Aug  7 11:20 004B
-rw-------   1 postgres postgres  262144 Aug 10 04:58 004C
-rw-------   1 postgres postgres  262144 Aug 11 15:41 004D
-rw-------   1 postgres postgres  262144 Aug 12 22:31 004E
-rw-------   1 postgres postgres  262144 Aug 14 19:31 004F
-rw-------   1 postgres postgres  262144 Aug 23 15:11 0050
-rw-------   1 postgres postgres  262144 Sep  7 16:01 0051
-rw-------   1 postgres postgres  262144 Sep 18 03:41 0052
-rw-------   1 postgres postgres  262144 Sep 23 01:27 0053
-rw-------   1 postgres postgres   40960 Sep 23 23:22 0054

Carol

On Sep 23, 2008, at 11:05 PM, Scott Marlowe wrote:

> On Tue, Sep 23, 2008 at 7:59 PM, Walter,  Carol Williams
> <walterc(at)indiana(dot)edu> wrote:
>> Hi, Tena,
>>
>> I actually downloaded 8.3.3 last week.  The upgrade has been in  
>> the plan.  I
>> didn't realize the latest was 8.3.4. I am concerned though. We  
>> have so many
>> dependencies that they never go smoothly.
>
> The real priority is getting the latest bug fix release of 8.2
> installed.  that only takes a few minutes and is quite easy, just
> update the package for pgsql.
>
> Going to 8.3 requires dump restore and testing your app for
> compatibility, something you don't have to do going to 8.2.10 or
> whatever version is the latest 8.2 release.


In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-09-24 04:21:56
Subject: Re: Missing pg_clog files
Previous:From: Carol WalterDate: 2008-09-24 03:39:11
Subject: Re: error

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