Re: Missing pg_clog files

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.