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 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] on behalf of Carol Walter Sent: Tue 9/23/2008 8:35 PM To: Scott Marlowe Cc: [email protected] 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 > <[EMAIL PROTECTED]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
