Quoting Tom Lane <[EMAIL PROTECTED]>: > Network Administrator <[EMAIL PROTECTED]> writes: > > ..if I using the psql client, and issue a "select * from <corrupt table > name> > > limit 5" if get this... > > > PANIC: read of clog file 5, offset 16384 failed: Success > > Hm, not good :-(. What files actually exist in $PGDATA/pg_clog/ (names > and sizes)?
Here you go... -rw------- 1 postgres users 262144 Jul 20 15:53 0000 -rw------- 1 postgres users 262144 Jul 31 12:57 0001 -rw------- 1 postgres users 262144 Aug 12 17:32 0002 -rw------- 1 postgres users 262144 Aug 26 00:15 0003 -rw------- 1 postgres users 262144 Sep 9 23:44 0004 -rw------- 1 postgres users 16384 Sep 10 21:21 0005 > > So back to my original question. What are the recover procedures (if > > any) that should be tried before I grab my PGDATA path from tape? > > You may be up against having to do that, but some investigation first > seems called for. Yep, its ready to go. When and if nothing surgical can be done. > regards, tom lane > -- Keith C. Perry Director of Networks & Applications VCSN, Inc. http://vcsn.com ____________________________________ This email account is being host by: VCSN, Inc : http://vcsn.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
