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@gallo.ucsf.edu



-----Original Message-----
From: pgsql-admin-owner@postgresql.org on behalf of Carol Walter
Sent: Tue 9/23/2008 8:35 PM
To: Scott Marlowe
Cc: pgsql-admin@postgresql.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@indiana.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.


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin